History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparges"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
484 | 2024-04-22 21:14:50 | sparges | 1 | 69583 | 9 | 1.313 | 52995.4 |
483 | 2024-03-31 03:30:13 | sparges | 1 | 69583 | 9 | 1.250 | 55666.4 |
482 | 2024-02-21 19:11:15 | sparges | 2 | 107671 | 74 | 3.763 | 28613.1 |
481 | 2024-02-19 12:15:05 | sparges | 2 | 107671 | 74 | 7.690 | 14001.4 |
480 | 2024-02-04 03:07:26 | sparges | 2 | 107671 | 74 | 3.563 | 30219.2 |
479 | 2024-02-02 23:24:08 | sparges | 3 | 134027 | 800 | 7.720 | 17361.0 |
478 | 2024-02-02 23:24:00 | sparges | 2 | 107671 | 74 | 3.656 | 29450.5 |
477 | 2024-02-02 22:03:47 | sparges | 2 | 107671 | 74 | 3.016 | 35699.9 |
476 | 2024-01-30 07:58:25 | sparges | 2 | 107671 | 74 | 3.156 | 34116.3 |
475 | 2024-01-30 07:57:53 | sparges | 3 | 134027 | 800 | 7.296 | 18369.9 |
474 | 2024-01-19 00:40:00 | sparges | 3 | 134027 | 800 | 6.003 | 22326.7 |
473 | 2023-12-30 12:50:33 | sparges | 2 | 107671 | 74 | 7.140 | 15080.0 |
472 | 2023-12-29 21:08:01 | sparges | 2 | 107671 | 74 | 3.173 | 33933.5 |
471 | 2023-12-28 13:02:24 | sparges | 3 | 134027 | 800 | 6.576 | 20381.2 |
470 | 2023-12-26 00:30:27 | sparges | 3 | 134027 | 800 | 8.190 | 16364.7 |
469 | 2023-12-24 17:11:47 | sparges | 3 | 134027 | 800 | 7.796 | 17191.8 |
468 | 2023-12-20 17:18:09 | sparges | 1 | 69583 | 9 | 1.093 | 63662.4 |
467 | 2023-12-14 09:49:55 | sparges | 3 | 134027 | 800 | 7.080 | 18930.4 |
466 | 2023-12-01 20:10:50 | sparges | 1 | 69583 | 9 | 1.110 | 62687.4 |
465 | 2023-11-25 13:15:26 | sparges | 1 | 69583 | 9 | 1.170 | 59472.6 |
464 | 2023-11-19 21:14:08 | sparges | 1 | 69583 | 9 | 1.280 | 54361.7 |
463 | 2023-11-16 15:52:13 | sparges | 2 | 107671 | 74 | 2.843 | 37872.3 |
462 | 2023-11-12 21:57:10 | sparges | 3 | 134027 | 800 | 6.750 | 19855.9 |
461 | 2023-11-12 21:57:08 | sparges | 2 | 107671 | 74 | 3.250 | 33129.5 |
460 | 2023-11-04 22:29:40 | sparges | 1 | 69583 | 9 | 1.110 | 62687.4 |
459 | 2023-10-31 06:57:28 | sparges | 1 | 69583 | 9 | 1.263 | 55093.4 |
458 | 2023-10-28 20:53:12 | sparges | 3 | 134027 | 800 | 7.780 | 17227.1 |
457 | 2023-10-21 23:30:03 | sparges | 1 | 69583 | 9 | 1.296 | 53690.6 |
456 | 2023-10-14 02:56:07 | sparges | 1 | 69583 | 9 | 1.076 | 64668.2 |
455 | 2023-10-06 22:46:17 | sparges | 1 | 69583 | 9 | 1.080 | 64428.7 |
454 | 2023-09-28 09:16:00 | sparges | 1 | 69583 | 9 | 1.420 | 49002.1 |
453 | 2023-09-23 22:14:16 | sparges | 1 | 69583 | 9 | 1.236 | 56296.9 |
452 | 2023-08-17 14:39:17 | sparges | 2 | 107671 | 74 | 2.970 | 36252.9 |
451 | 2023-08-06 15:21:24 | sparges | 3 | 134027 | 800 | 5.890 | 22755.0 |
450 | 2023-08-02 22:16:37 | sparges | 1 | 69583 | 9 | 1.110 | 62687.4 |
449 | 2023-07-05 14:29:58 | sparges | 1 | 69583 | 9 | 1.080 | 64428.7 |
448 | 2023-04-30 02:10:59 | sparges | 1 | 69583 | 9 | 1.110 | 62687.4 |
447 | 2023-04-29 18:40:04 | sparges | 2 | 107671 | 74 | 2.813 | 38276.2 |
446 | 2023-04-27 23:55:06 | sparges | 3 | 134027 | 800 | 6.783 | 19759.3 |
445 | 2023-04-16 14:02:44 | sparges | 3 | 134027 | 800 | 5.783 | 23176.0 |
444 | 2023-03-12 06:02:51 | sparges | 1 | 69583 | 9 | 1.110 | 62687.4 |
443 | 2023-02-19 02:28:34 | sparges | 1 | 69583 | 9 | 1.063 | 65459.1 |
442 | 2023-02-03 15:07:00 | sparges | 2 | 107671 | 74 | 2.796 | 38508.9 |
441 | 2023-01-21 15:28:00 | sparges | 3 | 134027 | 800 | 6.203 | 21606.8 |
440 | 2023-01-17 08:31:29 | sparges | 1 | 69583 | 9 | 1.220 | 57035.2 |
439 | 2022-12-17 10:46:26 | sparges | 1 | 69583 | 9 | 1.063 | 65459.1 |
438 | 2022-11-20 16:03:42 | sparges | 1 | 69583 | 9 | 1.076 | 64668.2 |
437 | 2022-11-15 05:14:29 | sparges | 2 | 107671 | 74 | 2.810 | 38317.1 |
436 | 2022-11-02 14:47:47 | sparges | 3 | 134027 | 800 | 9.546 | 14040.1 |
435 | 2022-10-26 13:34:42 | sparges | 3 | 134027 | 800 | 18.143 | 7387.3 |
434 | 2022-09-25 19:04:50 | sparges | 3 | 134027 | 800 | 5.736 | 23365.9 |
433 | 2022-09-18 12:21:03 | sparges | 3 | 134027 | 800 | 5.953 | 22514.2 |
432 | 2022-08-28 23:27:51 | sparges | 1 | 69583 | 9 | 1.123 | 61961.7 |
431 | 2022-08-27 19:26:07 | sparges | 1 | 69583 | 9 | 1.093 | 63662.4 |
430 | 2022-08-20 12:53:08 | sparges | 3 | 134027 | 800 | 6.716 | 19956.4 |
429 | 2022-08-18 16:21:03 | sparges | 1 | 69583 | 9 | 1.093 | 63662.4 |
428 | 2022-08-16 19:00:30 | sparges | 1 | 69583 | 9 | 1.156 | 60192.9 |
427 | 2022-07-26 10:37:19 | sparges | 1 | 69583 | 9 | 2.423 | 28717.7 |
426 | 2022-06-17 21:26:09 | sparges | 2 | 107671 | 74 | 2.890 | 37256.4 |
425 | 2022-06-03 23:30:21 | sparges | 3 | 134027 | 800 | 5.813 | 23056.4 |
424 | 2022-04-12 15:36:42 | sparges | 1 | 69583 | 9 | 1.263 | 55093.4 |
423 | 2022-04-08 23:39:15 | sparges | 1 | 69583 | 9 | 1.280 | 54361.7 |
422 | 2022-04-05 18:57:41 | sparges | 1 | 69583 | 9 | 1.250 | 55666.4 |
421 | 2022-01-10 12:26:33 | sparges | 1 | 69583 | 9 | 1.296 | 53690.6 |
420 | 2021-12-29 05:20:54 | sparges | 1 | 69583 | 9 | 1.343 | 51811.6 |
419 | 2021-12-19 13:31:05 | sparges | 1 | 69583 | 9 | 1.313 | 52995.4 |
418 | 2021-12-19 02:38:01 | sparges | 1 | 69583 | 9 | 1.266 | 54962.9 |
417 | 2021-12-18 16:21:21 | sparges | 1 | 69583 | 9 | 2.576 | 27012.0 |
416 | 2021-12-17 19:45:22 | sparges | 1 | 69583 | 9 | 1.123 | 61961.7 |
415 | 2021-12-12 05:59:40 | sparges | 1 | 69583 | 9 | 1.093 | 63662.4 |
414 | 2021-11-26 01:26:55 | sparges | 1 | 69583 | 9 | 1.140 | 61037.7 |
413 | 2021-11-19 06:54:13 | sparges | 1 | 69583 | 9 | 1.266 | 54962.9 |
412 | 2021-11-15 23:20:25 | sparges | 1 | 69583 | 9 | 1.233 | 56433.9 |
411 | 2021-11-15 13:44:58 | sparges | 1 | 69583 | 9 | 1.233 | 56433.9 |
410 | 2021-11-15 00:27:41 | sparges | 1 | 69583 | 9 | 1.216 | 57222.9 |
409 | 2021-11-14 23:19:49 | sparges | 1 | 69583 | 9 | 1.283 | 54234.6 |
408 | 2021-11-14 13:57:01 | sparges | 1 | 69583 | 9 | 1.266 | 54962.9 |
407 | 2021-11-13 23:21:01 | sparges | 1 | 69583 | 9 | 1.263 | 55093.4 |
406 | 2021-11-13 14:45:29 | sparges | 1 | 69583 | 9 | 2.423 | 28717.7 |
405 | 2021-11-13 00:47:18 | sparges | 1 | 69583 | 9 | 1.216 | 57222.9 |
404 | 2021-11-12 14:40:46 | sparges | 1 | 69583 | 9 | 1.076 | 64668.2 |
403 | 2021-11-11 17:31:13 | sparges | 1 | 69583 | 9 | 1.236 | 56296.9 |
402 | 2021-11-11 06:38:04 | sparges | 1 | 69583 | 9 | 1.283 | 54234.6 |
401 | 2021-11-10 16:44:04 | sparges | 1 | 69583 | 9 | 1.123 | 61961.7 |
400 | 2021-11-09 21:25:08 | sparges | 2 | 107671 | 74 | 2.876 | 37437.8 |
399 | 2021-11-07 23:01:19 | sparges | 1 | 69583 | 9 | 1.080 | 64428.7 |
398 | 2021-11-07 13:03:37 | sparges | 1 | 69583 | 9 | 1.203 | 57841.2 |
397 | 2021-11-07 01:37:07 | sparges | 1 | 69583 | 9 | 1.216 | 57222.9 |
396 | 2021-11-06 14:34:01 | sparges | 1 | 69583 | 9 | 1.233 | 56433.9 |
395 | 2021-11-06 07:47:08 | sparges | 1 | 69583 | 9 | 1.046 | 66522.9 |
394 | 2021-11-05 15:06:48 | sparges | 1 | 69583 | 9 | 1.076 | 64668.2 |
393 | 2021-11-05 03:09:15 | sparges | 1 | 69583 | 9 | 1.266 | 54962.9 |
392 | 2021-11-04 20:14:23 | sparges | 1 | 69583 | 9 | 1.186 | 58670.3 |
391 | 2021-11-03 22:44:35 | sparges | 1 | 69583 | 9 | 1.123 | 61961.7 |
390 | 2021-10-12 20:16:35 | sparges | 1 | 69583 | 9 | 1.280 | 54361.7 |
389 | 2021-10-11 23:29:57 | sparges | 1 | 69583 | 9 | 1.203 | 57841.2 |
388 | 2021-10-10 20:08:49 | sparges | 1 | 69583 | 9 | 1.170 | 59472.6 |
387 | 2021-10-04 04:52:10 | sparges | 3 | 134027 | 800 | 6.253 | 21434.0 |
386 | 2021-09-28 07:04:46 | sparges | 1 | 69583 | 9 | 1.143 | 60877.5 |
385 | 2021-09-26 03:55:21 | sparges | 1 | 69583 | 9 | 1.080 | 64428.7 |