History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"troffer"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 417 | 2026-04-17 09:35:09 | troffer | 1 | 69583 | 3 | 3.516 | 19790.4 |
| 416 | 2026-04-15 16:11:15 | troffer | 3 | 134027 | 315 | 34.890 | 3841.4 |
| 415 | 2026-04-15 16:10:24 | troffer | 3 | 134027 | 315 | 31.173 | 4299.5 |
| 414 | 2026-04-15 16:10:18 | troffer | 3 | 134027 | 315 | 22.596 | 5931.4 |
| 413 | 2026-04-15 13:59:21 | troffer | 3 | 134027 | 315 | 18.500 | 7244.7 |
| 412 | 2026-04-15 11:39:45 | troffer | 1 | 69583 | 3 | 3.486 | 19960.7 |
| 411 | 2026-04-14 19:10:38 | troffer | 2 | 107671 | 27 | 4.813 | 22370.9 |
| 410 | 2026-04-14 10:32:33 | troffer | 2 | 107671 | 27 | 3.626 | 29694.2 |
| 409 | 2026-04-14 07:01:59 | troffer | 1 | 69583 | 3 | 3.063 | 22717.3 |
| 408 | 2026-04-13 05:56:18 | troffer | 3 | 134027 | 315 | 27.876 | 4808.0 |
| 407 | 2026-04-12 13:04:26 | troffer | 1 | 69583 | 3 | 2.483 | 28023.8 |
| 406 | 2026-04-10 20:27:15 | troffer | 1 | 69583 | 3 | 5.843 | 11908.8 |
| 405 | 2026-04-09 03:19:58 | troffer | 2 | 107671 | 27 | 12.373 | 8702.1 |
| 404 | 2026-04-08 13:14:10 | troffer | 3 | 134027 | 315 | 7.173 | 18684.9 |
| 403 | 2026-04-07 08:50:36 | troffer | 3 | 134027 | 315 | 27.580 | 4859.6 |
| 402 | 2026-04-06 15:56:55 | troffer | 3 | 134027 | 315 | 32.206 | 4161.6 |
| 401 | 2026-03-29 16:50:44 | troffer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 400 | 2026-03-29 09:58:13 | troffer | 1 | 69583 | 3 | 1.110 | 62687.4 |
| 399 | 2026-03-10 23:38:40 | troffer | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 398 | 2026-03-09 02:25:49 | troffer | 1 | 69583 | 3 | 1.203 | 57841.2 |
| 397 | 2026-03-08 16:31:39 | troffer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 396 | 2026-03-04 14:22:40 | troffer | 1 | 69583 | 3 | 1.096 | 63488.1 |
| 395 | 2026-02-26 22:09:18 | troffer | 1 | 69583 | 3 | 1.670 | 41666.5 |
| 394 | 2026-02-26 02:03:20 | troffer | 1 | 69583 | 3 | 1.216 | 57222.9 |
| 393 | 2026-02-25 22:07:55 | troffer | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 392 | 2026-02-25 00:56:24 | troffer | 2 | 107671 | 27 | 3.343 | 32207.9 |
| 391 | 2026-02-24 09:25:48 | troffer | 2 | 107671 | 27 | 3.343 | 32207.9 |
| 390 | 2026-02-20 10:22:57 | troffer | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 389 | 2026-02-11 04:28:50 | troffer | 1 | 69583 | 3 | 4.893 | 14220.9 |
| 388 | 2026-01-12 09:42:11 | troffer | 1 | 69583 | 3 | 1.266 | 54962.9 |
| 387 | 2026-01-12 09:33:07 | troffer | 1 | 69583 | 3 | 4.576 | 15206.1 |
| 386 | 2026-01-10 14:11:40 | troffer | 1 | 69583 | 3 | 1.940 | 35867.5 |
| 385 | 2026-01-10 08:55:13 | troffer | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 384 | 2026-01-07 01:54:30 | troffer | 2 | 107671 | 27 | 3.373 | 31921.4 |
| 383 | 2026-01-06 12:46:55 | troffer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 382 | 2026-01-04 23:59:36 | troffer | 1 | 69583 | 3 | 1.283 | 54234.6 |
| 381 | 2026-01-04 21:47:50 | troffer | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 380 | 2026-01-04 08:17:41 | troffer | 1 | 69583 | 3 | 1.360 | 51164.0 |
| 379 | 2026-01-03 10:41:42 | troffer | 1 | 69583 | 3 | 1.106 | 62914.1 |
| 378 | 2026-01-02 22:42:39 | troffer | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 377 | 2025-12-31 05:28:28 | troffer | 1 | 69583 | 3 | 5.720 | 12164.9 |
| 376 | 2025-12-31 05:27:12 | troffer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 375 | 2025-12-26 04:17:26 | troffer | 1 | 69583 | 3 | 2.296 | 30306.2 |
| 374 | 2025-12-25 03:17:12 | troffer | 1 | 69583 | 3 | 1.423 | 48898.8 |
| 373 | 2025-11-25 11:00:59 | troffer | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 372 | 2025-11-22 01:16:09 | troffer | 2 | 107671 | 27 | 5.920 | 18187.7 |
| 371 | 2025-11-16 23:12:23 | troffer | 1 | 69583 | 3 | 1.373 | 50679.5 |
| 370 | 2025-11-07 21:46:27 | troffer | 1 | 69583 | 3 | 1.170 | 59472.6 |
| 369 | 2025-11-06 01:18:47 | troffer | 1 | 69583 | 3 | 1.093 | 63662.4 |
| 368 | 2025-09-19 02:44:58 | troffer | 1 | 69583 | 3 | 1.280 | 54361.7 |
| 367 | 2025-09-12 17:24:35 | troffer | 2 | 107671 | 27 | 4.296 | 25063.1 |
| 366 | 2025-09-11 22:43:24 | troffer | 1 | 69583 | 3 | 1.080 | 64428.7 |
| 365 | 2025-08-27 15:29:35 | troffer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 364 | 2025-08-25 03:03:52 | troffer | 1 | 69583 | 3 | 5.736 | 12130.9 |
| 363 | 2025-08-24 23:13:24 | troffer | 1 | 69583 | 3 | 4.763 | 14609.1 |
| 362 | 2025-08-17 03:58:54 | troffer | 1 | 69583 | 3 | 3.296 | 21111.3 |
| 361 | 2025-08-10 02:43:16 | troffer | 3 | 134027 | 315 | 19.626 | 6829.1 |
| 360 | 2025-08-04 20:37:46 | troffer | 2 | 107671 | 27 | 8.330 | 12925.7 |
| 359 | 2025-08-03 11:32:14 | troffer | 2 | 107671 | 27 | 16.000 | 6729.4 |
| 358 | 2025-08-03 09:51:12 | troffer | 3 | 134027 | 315 | 39.160 | 3422.5 |
| 357 | 2025-08-01 21:31:41 | troffer | 3 | 134027 | 315 | 33.346 | 4019.3 |
| 356 | 2025-08-01 10:13:49 | troffer | 1 | 69583 | 3 | 5.626 | 12368.1 |
| 355 | 2025-07-31 05:09:59 | troffer | 1 | 69583 | 3 | 1.220 | 57035.2 |
| 354 | 2025-07-31 05:05:21 | troffer | 1 | 69583 | 3 | 1.233 | 56433.9 |
| 353 | 2025-07-28 14:15:05 | troffer | 3 | 134027 | 315 | 30.330 | 4419.0 |
| 352 | 2025-07-25 10:30:38 | troffer | 1 | 69583 | 3 | 3.296 | 21111.3 |
| 351 | 2025-07-25 05:55:22 | troffer | 1 | 69583 | 3 | 5.983 | 11630.1 |
| 350 | 2025-07-24 17:12:26 | troffer | 3 | 134027 | 315 | 38.780 | 3456.1 |
| 349 | 2025-07-24 05:35:41 | troffer | 1 | 69583 | 3 | 2.546 | 27330.3 |
| 348 | 2025-07-24 01:05:14 | troffer | 1 | 69583 | 3 | 5.016 | 13872.2 |
| 347 | 2025-07-23 12:11:38 | troffer | 1 | 69583 | 3 | 2.986 | 23303.1 |
| 346 | 2025-07-23 03:00:13 | troffer | 1 | 69583 | 3 | 3.486 | 19960.7 |
| 345 | 2025-07-22 16:39:01 | troffer | 3 | 134027 | 315 | 16.203 | 8271.7 |
| 344 | 2025-07-22 15:50:15 | troffer | 1 | 69583 | 3 | 3.220 | 21609.6 |
| 343 | 2025-07-18 03:23:16 | troffer | 2 | 107671 | 27 | 16.406 | 6562.9 |
| 342 | 2025-07-17 18:13:20 | troffer | 3 | 134027 | 315 | 33.313 | 4023.3 |
| 341 | 2025-07-16 08:35:01 | troffer | 2 | 107671 | 27 | 6.296 | 17101.5 |
| 340 | 2025-07-15 22:33:34 | troffer | 3 | 134027 | 315 | 9.626 | 13923.4 |
| 339 | 2025-07-15 21:45:29 | troffer | 1 | 69583 | 3 | 2.936 | 23699.9 |
| 338 | 2025-07-14 11:30:30 | troffer | 3 | 134027 | 315 | 25.046 | 5351.2 |
| 337 | 2025-07-14 01:39:39 | troffer | 2 | 107671 | 27 | 13.390 | 8041.2 |
| 336 | 2025-07-13 04:22:07 | troffer | 1 | 69583 | 3 | 3.233 | 21522.7 |
| 335 | 2025-07-12 21:15:24 | troffer | 1 | 69583 | 3 | 1.263 | 55093.4 |
| 334 | 2025-07-06 02:34:56 | troffer | 1 | 69583 | 3 | 1.186 | 58670.3 |
| 333 | 2025-07-05 02:34:34 | troffer | 1 | 69583 | 3 | 5.563 | 12508.2 |
| 332 | 2025-06-30 10:06:25 | troffer | 1 | 69583 | 3 | 5.986 | 11624.3 |
| 331 | 2025-06-24 15:44:18 | troffer | 1 | 69583 | 3 | 2.626 | 26497.7 |
| 330 | 2025-06-16 08:14:55 | troffer | 1 | 69583 | 3 | 8.033 | 8662.1 |
| 329 | 2025-06-12 04:07:17 | troffer | 1 | 69583 | 3 | 5.623 | 12374.7 |
| 328 | 2025-06-04 03:38:52 | troffer | 1 | 69583 | 3 | 5.750 | 12101.4 |
| 327 | 2025-06-04 00:28:31 | troffer | 1 | 69583 | 3 | 5.923 | 11747.9 |
| 326 | 2025-06-03 20:09:00 | troffer | 1 | 69583 | 3 | 6.296 | 11051.9 |
| 325 | 2025-05-18 04:58:16 | troffer | 1 | 69583 | 3 | 6.750 | 10308.6 |
| 324 | 2025-05-17 09:08:23 | troffer | 1 | 69583 | 3 | 6.233 | 11163.6 |
| 323 | 2025-05-12 03:59:46 | troffer | 1 | 69583 | 3 | 6.016 | 11566.3 |
| 322 | 2025-05-04 03:38:43 | troffer | 1 | 69583 | 3 | 4.420 | 15742.8 |
| 321 | 2025-04-21 15:41:21 | troffer | 1 | 69583 | 3 | 6.233 | 11163.6 |
| 320 | 2025-04-20 05:19:20 | troffer | 1 | 69583 | 3 | 5.953 | 11688.7 |
| 319 | 2025-04-16 15:56:47 | troffer | 1 | 69583 | 3 | 5.313 | 13096.7 |
| 318 | 2025-04-13 17:16:59 | troffer | 1 | 69583 | 3 | 1.236 | 56296.9 |