History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"footlight"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 405 | 2025-10-26 15:50:21 | footlight | 3 | 148641 | 30 | 7.720 | 19254.0 |
| 404 | 2025-10-20 09:08:29 | footlight | 4 | 165329 | 171 | 57.000 | 2900.5 |
| 403 | 2025-10-20 09:08:27 | footlight | 3 | 148641 | 30 | 40.890 | 3635.1 |
| 402 | 2025-10-20 06:46:13 | footlight | 1 | 81242 | 2 | 1.376 | 59042.2 |
| 401 | 2025-09-20 02:26:56 | footlight | 4 | 165329 | 171 | 12.220 | 13529.4 |
| 400 | 2025-08-25 05:11:04 | footlight | 1 | 81242 | 2 | 3.296 | 24648.7 |
| 399 | 2025-08-23 05:05:09 | footlight | 4 | 165329 | 171 | 70.043 | 2360.4 |
| 398 | 2025-08-16 22:05:28 | footlight | 4 | 165329 | 171 | 46.580 | 3549.4 |
| 397 | 2025-08-16 07:44:51 | footlight | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 396 | 2025-08-13 05:16:48 | footlight | 4 | 165329 | 171 | 48.436 | 3413.3 |
| 395 | 2025-08-09 02:46:04 | footlight | 4 | 165329 | 171 | 57.173 | 2891.7 |
| 394 | 2025-08-08 21:54:03 | footlight | 1 | 81242 | 2 | 6.390 | 12713.9 |
| 393 | 2025-08-06 23:35:09 | footlight | 4 | 165329 | 171 | 56.483 | 2927.1 |
| 392 | 2025-08-04 09:12:25 | footlight | 1 | 81242 | 2 | 7.253 | 11201.2 |
| 391 | 2025-08-02 16:56:33 | footlight | 1 | 81242 | 2 | 3.143 | 25848.6 |
| 390 | 2025-08-02 15:46:45 | footlight | 4 | 165329 | 171 | 41.796 | 3955.6 |
| 389 | 2025-08-02 10:15:44 | footlight | 3 | 148641 | 30 | 18.750 | 7927.5 |
| 388 | 2025-08-01 10:42:25 | footlight | 3 | 148641 | 30 | 20.076 | 7403.9 |
| 387 | 2025-07-27 02:27:36 | footlight | 3 | 148641 | 30 | 29.503 | 5038.2 |
| 386 | 2025-07-25 18:02:46 | footlight | 1 | 81242 | 2 | 4.576 | 17753.9 |
| 385 | 2025-07-24 22:23:04 | footlight | 1 | 81242 | 2 | 6.376 | 12741.8 |
| 384 | 2025-07-22 13:47:24 | footlight | 4 | 165329 | 171 | 37.610 | 4395.9 |
| 383 | 2025-07-17 00:23:26 | footlight | 3 | 148641 | 30 | 14.076 | 10559.9 |
| 382 | 2025-07-14 14:18:51 | footlight | 1 | 81242 | 2 | 3.423 | 23734.2 |
| 381 | 2025-07-14 04:13:46 | footlight | 3 | 148641 | 30 | 41.376 | 3592.4 |
| 380 | 2025-07-11 16:11:47 | footlight | 4 | 165329 | 171 | 82.350 | 2007.6 |
| 379 | 2025-07-11 08:42:36 | footlight | 2 | 121436 | 6 | 16.390 | 7409.2 |
| 378 | 2025-07-09 18:41:29 | footlight | 2 | 121436 | 6 | 4.106 | 29575.3 |
| 377 | 2025-07-09 00:39:16 | footlight | 4 | 165329 | 171 | 11.890 | 13904.9 |
| 376 | 2025-07-07 14:52:47 | footlight | 1 | 81242 | 2 | 3.356 | 24208.0 |
| 375 | 2025-07-02 09:01:44 | footlight | 1 | 81242 | 2 | 7.156 | 11353.0 |
| 374 | 2025-07-02 01:48:01 | footlight | 4 | 165329 | 171 | 48.753 | 3391.2 |
| 373 | 2025-06-30 22:01:45 | footlight | 4 | 165329 | 171 | 33.173 | 4983.8 |
| 372 | 2025-06-16 08:02:12 | footlight | 1 | 81242 | 2 | 6.923 | 11735.1 |
| 371 | 2025-06-14 02:17:12 | footlight | 2 | 121436 | 6 | 15.016 | 8087.1 |
| 370 | 2025-06-13 13:26:29 | footlight | 1 | 81242 | 2 | 3.483 | 23325.3 |
| 369 | 2025-06-12 22:54:15 | footlight | 1 | 81242 | 2 | 2.796 | 29056.5 |
| 368 | 2025-06-10 11:57:00 | footlight | 4 | 165329 | 171 | 62.783 | 2633.3 |
| 367 | 2025-06-09 21:20:33 | footlight | 1 | 81242 | 2 | 6.970 | 11656.0 |
| 366 | 2025-06-05 13:31:21 | footlight | 4 | 165329 | 171 | 31.483 | 5251.4 |
| 365 | 2025-06-03 23:36:09 | footlight | 4 | 165329 | 171 | 66.783 | 2475.6 |
| 364 | 2025-06-02 21:19:04 | footlight | 4 | 165329 | 171 | 17.270 | 9573.2 |
| 363 | 2025-06-01 01:05:51 | footlight | 4 | 165329 | 171 | 56.876 | 2906.8 |
| 362 | 2025-05-30 07:26:07 | footlight | 4 | 165329 | 171 | 58.536 | 2824.4 |
| 361 | 2025-05-24 23:48:48 | footlight | 2 | 121436 | 6 | 4.170 | 29121.3 |
| 360 | 2025-05-24 23:40:27 | footlight | 3 | 148641 | 30 | 7.360 | 20195.8 |
| 359 | 2025-05-24 16:11:42 | footlight | 1 | 81242 | 2 | 6.440 | 12615.2 |
| 358 | 2025-05-20 15:41:56 | footlight | 1 | 81242 | 2 | 6.050 | 13428.4 |
| 357 | 2025-05-18 04:14:53 | footlight | 3 | 148641 | 30 | 30.843 | 4819.3 |
| 356 | 2025-05-17 07:55:33 | footlight | 1 | 81242 | 2 | 1.423 | 57092.1 |
| 355 | 2025-05-07 17:40:12 | footlight | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 354 | 2025-04-20 07:08:37 | footlight | 1 | 81242 | 2 | 8.033 | 10113.5 |
| 353 | 2025-04-18 18:52:20 | footlight | 3 | 148641 | 30 | 33.373 | 4453.9 |
| 352 | 2025-04-05 18:05:58 | footlight | 3 | 148641 | 30 | 7.580 | 19609.6 |
| 351 | 2025-04-02 03:26:25 | footlight | 3 | 148641 | 30 | 40.113 | 3705.6 |
| 350 | 2025-03-31 10:13:19 | footlight | 3 | 148641 | 30 | 48.423 | 3069.6 |
| 349 | 2025-03-28 13:38:50 | footlight | 2 | 121436 | 6 | 3.356 | 36184.7 |
| 348 | 2025-03-28 13:21:41 | footlight | 3 | 148641 | 30 | 7.423 | 20024.4 |
| 347 | 2025-03-25 17:49:37 | footlight | 1 | 81242 | 2 | 6.343 | 12808.1 |
| 346 | 2025-03-22 05:01:05 | footlight | 2 | 121436 | 6 | 10.626 | 11428.2 |
| 345 | 2025-03-22 03:28:38 | footlight | 3 | 148641 | 30 | 41.580 | 3574.8 |
| 344 | 2025-03-21 09:22:07 | footlight | 1 | 81242 | 2 | 6.610 | 12290.8 |
| 343 | 2025-03-14 03:58:39 | footlight | 3 | 148641 | 30 | 31.486 | 4720.9 |
| 342 | 2025-03-03 15:20:00 | footlight | 2 | 121436 | 6 | 18.310 | 6632.2 |
| 341 | 2025-03-03 15:18:57 | footlight | 1 | 81242 | 2 | 6.623 | 12266.6 |
| 340 | 2025-02-28 01:35:00 | footlight | 2 | 121436 | 6 | 17.796 | 6823.8 |
| 339 | 2025-02-18 10:30:41 | footlight | 3 | 148641 | 30 | 31.190 | 4765.7 |
| 338 | 2025-02-16 23:34:23 | footlight | 3 | 148641 | 30 | 33.766 | 4402.1 |
| 337 | 2025-02-16 18:33:52 | footlight | 1 | 81242 | 2 | 5.966 | 13617.5 |
| 336 | 2025-02-15 03:36:42 | footlight | 3 | 148641 | 30 | 36.440 | 4079.1 |
| 335 | 2025-02-14 14:44:10 | footlight | 1 | 81242 | 2 | 7.890 | 10296.8 |
| 334 | 2025-02-14 05:45:13 | footlight | 2 | 121436 | 6 | 15.343 | 7914.7 |
| 333 | 2025-02-13 09:54:55 | footlight | 1 | 81242 | 2 | 6.483 | 12531.5 |
| 332 | 2025-02-10 20:13:16 | footlight | 3 | 148641 | 30 | 35.970 | 4132.4 |
| 331 | 2025-02-06 01:34:29 | footlight | 2 | 121436 | 6 | 15.716 | 7726.9 |
| 330 | 2025-01-27 07:13:24 | footlight | 2 | 121436 | 6 | 9.123 | 13311.0 |
| 329 | 2025-01-21 00:09:33 | footlight | 1 | 81242 | 2 | 7.360 | 11038.3 |
| 328 | 2025-01-19 08:17:26 | footlight | 3 | 148641 | 30 | 48.926 | 3038.1 |
| 327 | 2025-01-18 10:24:27 | footlight | 3 | 148641 | 30 | 41.423 | 3588.4 |
| 326 | 2025-01-16 04:34:03 | footlight | 3 | 148641 | 30 | 39.266 | 3785.5 |
| 325 | 2025-01-16 04:33:04 | footlight | 1 | 81242 | 2 | 5.280 | 15386.7 |
| 324 | 2025-01-15 15:19:44 | footlight | 4 | 165329 | 171 | 63.330 | 2610.6 |
| 323 | 2025-01-14 12:29:32 | footlight | 1 | 81242 | 2 | 9.953 | 8162.6 |
| 322 | 2025-01-14 03:19:00 | footlight | 4 | 165329 | 171 | 61.456 | 2690.2 |
| 321 | 2025-01-12 21:49:11 | footlight | 4 | 165329 | 171 | 67.470 | 2450.4 |
| 320 | 2025-01-09 10:26:19 | footlight | 4 | 165329 | 171 | 66.140 | 2499.7 |
| 319 | 2024-12-31 10:03:48 | footlight | 1 | 81242 | 2 | 6.393 | 12708.0 |
| 318 | 2024-12-24 02:35:10 | footlight | 2 | 121436 | 6 | 15.736 | 7717.1 |
| 317 | 2024-12-15 05:01:02 | footlight | 1 | 81242 | 2 | 5.110 | 15898.6 |
| 316 | 2024-12-15 01:17:24 | footlight | 4 | 165329 | 171 | 43.393 | 3810.0 |
| 315 | 2024-12-15 01:06:21 | footlight | 4 | 165329 | 171 | 67.066 | 2465.2 |
| 314 | 2024-12-13 01:09:50 | footlight | 4 | 165329 | 171 | 53.953 | 3064.3 |
| 313 | 2024-12-13 01:09:32 | footlight | 2 | 121436 | 6 | 18.186 | 6677.4 |
| 312 | 2024-12-13 01:08:32 | footlight | 1 | 81242 | 2 | 5.766 | 14089.8 |
| 311 | 2024-12-12 14:04:22 | footlight | 3 | 148641 | 30 | 20.940 | 7098.4 |
| 310 | 2024-12-10 11:03:37 | footlight | 3 | 148641 | 30 | 39.860 | 3729.1 |
| 309 | 2024-12-10 09:41:21 | footlight | 3 | 148641 | 30 | 37.503 | 3963.4 |
| 308 | 2024-12-09 08:32:53 | footlight | 3 | 148641 | 30 | 36.173 | 4109.2 |
| 307 | 2024-12-09 04:50:24 | footlight | 3 | 148641 | 30 | 35.970 | 4132.4 |
| 306 | 2024-11-29 19:22:55 | footlight | 2 | 121436 | 6 | 17.733 | 6848.0 |