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 |
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 |
305 | 2024-11-27 16:41:35 | footlight | 2 | 121436 | 6 | 18.003 | 6745.3 |
304 | 2024-11-27 15:39:57 | footlight | 1 | 81242 | 2 | 1.390 | 58447.5 |
303 | 2024-11-24 10:19:40 | footlight | 1 | 81242 | 2 | 6.030 | 13473.0 |
302 | 2024-11-14 13:51:07 | footlight | 1 | 81242 | 2 | 1.203 | 67532.8 |
301 | 2024-11-09 13:56:48 | footlight | 3 | 148641 | 30 | 35.050 | 4240.8 |
300 | 2024-11-09 07:55:19 | footlight | 3 | 148641 | 30 | 23.470 | 6333.2 |
299 | 2024-11-07 20:46:52 | footlight | 4 | 165329 | 171 | 56.830 | 2909.2 |
298 | 2024-11-07 11:58:07 | footlight | 4 | 165329 | 171 | 64.833 | 2550.1 |
297 | 2024-11-07 10:13:01 | footlight | 3 | 148641 | 30 | 26.206 | 5672.0 |
296 | 2024-11-07 07:44:34 | footlight | 4 | 165329 | 171 | 63.536 | 2602.1 |
295 | 2024-11-07 07:44:35 | footlight | 3 | 148641 | 30 | 36.080 | 4119.8 |
294 | 2024-11-07 07:44:39 | footlight | 2 | 121436 | 6 | 14.033 | 8653.6 |
293 | 2024-11-07 07:44:24 | footlight | 1 | 81242 | 2 | 3.266 | 24875.1 |
292 | 2024-10-25 17:42:48 | footlight | 1 | 81242 | 2 | 4.343 | 18706.4 |
291 | 2024-10-10 19:02:04 | footlight | 1 | 81242 | 2 | 5.720 | 14203.1 |
290 | 2024-10-01 23:08:14 | footlight | 1 | 81242 | 2 | 7.500 | 10832.3 |
289 | 2024-09-18 05:53:21 | footlight | 1 | 81242 | 2 | 9.736 | 8344.5 |
288 | 2024-09-03 23:41:32 | footlight | 1 | 81242 | 2 | 6.936 | 11713.1 |
287 | 2024-08-31 10:52:37 | footlight | 1 | 81242 | 2 | 9.156 | 8873.1 |
286 | 2024-08-13 11:53:25 | footlight | 1 | 81242 | 2 | 11.423 | 7112.1 |
285 | 2024-07-19 21:03:10 | footlight | 3 | 148641 | 30 | 23.953 | 6205.5 |
284 | 2024-07-18 14:47:14 | footlight | 3 | 148641 | 30 | 31.723 | 4685.6 |
283 | 2024-07-18 11:28:20 | footlight | 3 | 148641 | 30 | 21.750 | 6834.1 |