History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"kerry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
634 | 2024-05-03 23:23:43 | kerry | 1 | 28756 | 11 | 0.546 | 52666.7 |
633 | 2024-04-29 06:39:51 | kerry | 2 | 53800 | 77 | 2.533 | 21239.6 |
632 | 2024-04-29 06:39:48 | kerry | 3 | 83667 | 854 | 4.406 | 18989.3 |
631 | 2024-04-29 06:39:42 | kerry | 1 | 28756 | 11 | 0.533 | 53951.2 |
630 | 2024-04-29 06:39:41 | kerry | 2 | 53800 | 77 | 1.686 | 31909.8 |
629 | 2024-04-29 06:39:13 | kerry | 3 | 83667 | 854 | 4.563 | 18336.0 |
628 | 2024-04-27 04:17:12 | kerry | 2 | 53800 | 77 | 2.296 | 23432.1 |
627 | 2024-04-27 02:21:21 | kerry | 3 | 83667 | 854 | 9.733 | 8596.2 |
626 | 2024-04-19 14:11:10 | kerry | 1 | 28756 | 11 | 1.076 | 26724.9 |
625 | 2024-04-03 02:46:35 | kerry | 1 | 28756 | 11 | 1.733 | 16593.2 |
624 | 2024-03-31 03:25:45 | kerry | 1 | 28756 | 11 | 0.580 | 49579.3 |
623 | 2024-03-29 01:17:39 | kerry | 1 | 28756 | 11 | 0.563 | 51076.4 |
622 | 2024-03-08 04:46:31 | kerry | 1 | 28756 | 11 | 0.546 | 52666.7 |
621 | 2024-03-05 03:38:44 | kerry | 2 | 53800 | 77 | 5.470 | 9835.5 |
620 | 2024-03-04 11:11:37 | kerry | 2 | 53800 | 77 | 2.750 | 19563.6 |
619 | 2024-03-03 22:16:28 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
618 | 2024-03-01 09:29:34 | kerry | 1 | 28756 | 11 | 1.266 | 22714.1 |
617 | 2024-02-27 20:12:55 | kerry | 1 | 28756 | 11 | 0.470 | 61183.0 |
616 | 2024-01-29 00:26:06 | kerry | 1 | 28756 | 11 | 0.470 | 61183.0 |
615 | 2024-01-19 05:04:35 | kerry | 1 | 28756 | 11 | 0.483 | 59536.2 |
614 | 2024-01-18 21:49:02 | kerry | 3 | 83667 | 854 | 3.986 | 20990.2 |
613 | 2024-01-13 04:11:45 | kerry | 3 | 83667 | 854 | 3.406 | 24564.6 |
612 | 2024-01-13 04:11:46 | kerry | 2 | 53800 | 77 | 1.516 | 35488.1 |
611 | 2023-12-30 10:08:15 | kerry | 1 | 28756 | 11 | 0.420 | 68466.7 |
610 | 2023-12-16 21:15:28 | kerry | 3 | 83667 | 854 | 3.343 | 25027.5 |
609 | 2023-12-10 18:35:17 | kerry | 3 | 83667 | 854 | 3.610 | 23176.5 |
608 | 2023-12-10 18:35:18 | kerry | 2 | 53800 | 77 | 1.563 | 34421.0 |
607 | 2023-12-03 17:04:03 | kerry | 3 | 83667 | 854 | 3.920 | 21343.6 |
606 | 2023-11-24 20:52:56 | kerry | 2 | 53800 | 77 | 1.373 | 39184.3 |
605 | 2023-11-16 07:40:15 | kerry | 1 | 28756 | 11 | 0.483 | 59536.2 |
604 | 2023-11-11 09:54:33 | kerry | 1 | 28756 | 11 | 0.466 | 61708.2 |
603 | 2023-11-04 02:14:35 | kerry | 1 | 28756 | 11 | 0.466 | 61708.2 |
602 | 2023-11-03 13:25:15 | kerry | 1 | 28756 | 11 | 0.423 | 67981.1 |
601 | 2023-10-27 22:43:09 | kerry | 3 | 83667 | 854 | 3.640 | 22985.4 |
600 | 2023-10-23 02:37:52 | kerry | 1 | 28756 | 11 | 0.486 | 59168.7 |
599 | 2023-10-19 10:25:30 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
598 | 2023-10-19 05:10:40 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
597 | 2023-10-14 23:24:19 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
596 | 2023-10-04 15:00:11 | kerry | 1 | 28756 | 11 | 0.420 | 68466.7 |
595 | 2023-09-24 18:47:16 | kerry | 2 | 53800 | 77 | 1.563 | 34421.0 |
594 | 2023-09-24 18:47:13 | kerry | 3 | 83667 | 854 | 3.453 | 24230.2 |
593 | 2023-09-23 10:40:01 | kerry | 1 | 28756 | 11 | 1.063 | 27051.7 |
592 | 2023-09-19 12:00:05 | kerry | 1 | 28756 | 11 | 0.466 | 61708.2 |
591 | 2023-08-24 15:48:22 | kerry | 2 | 53800 | 77 | 1.343 | 40059.6 |
590 | 2023-08-15 04:38:31 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
589 | 2023-08-05 07:01:34 | kerry | 3 | 83667 | 854 | 3.203 | 26121.4 |
588 | 2023-07-07 18:38:13 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
587 | 2023-05-14 14:01:13 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
586 | 2023-05-10 00:14:06 | kerry | 2 | 53800 | 77 | 1.360 | 39558.8 |
585 | 2023-04-25 15:20:17 | kerry | 3 | 83667 | 854 | 3.233 | 25879.1 |
584 | 2023-04-19 00:44:10 | kerry | 3 | 83667 | 854 | 4.016 | 20833.4 |
583 | 2023-03-20 17:30:55 | kerry | 1 | 28756 | 11 | 0.440 | 65354.5 |
582 | 2023-03-08 08:45:19 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
581 | 2023-02-15 02:45:10 | kerry | 2 | 53800 | 77 | 1.313 | 40974.9 |
580 | 2023-02-10 05:22:51 | kerry | 1 | 28756 | 11 | 0.423 | 67981.1 |
579 | 2023-01-23 12:19:17 | kerry | 3 | 83667 | 854 | 3.123 | 26790.6 |
578 | 2022-12-29 19:33:15 | kerry | 1 | 28756 | 11 | 0.470 | 61183.0 |
577 | 2022-12-22 17:13:18 | kerry | 1 | 28756 | 11 | 0.940 | 30591.5 |
576 | 2022-11-29 06:45:07 | kerry | 1 | 28756 | 11 | 0.940 | 30591.5 |
575 | 2022-11-27 12:25:01 | kerry | 2 | 53800 | 77 | 1.313 | 40974.9 |
574 | 2022-11-25 23:52:25 | kerry | 1 | 28756 | 11 | 0.470 | 61183.0 |
573 | 2022-11-13 05:17:27 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
572 | 2022-11-07 15:02:54 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
571 | 2022-11-05 16:00:54 | kerry | 3 | 83667 | 854 | 3.143 | 26620.1 |
570 | 2022-09-19 04:37:01 | kerry | 1 | 28756 | 11 | 0.420 | 68466.7 |
569 | 2022-09-18 18:07:58 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
568 | 2022-09-12 10:15:52 | kerry | 1 | 28756 | 11 | 0.466 | 61708.2 |
567 | 2022-09-04 20:14:11 | kerry | 3 | 83667 | 854 | 3.670 | 22797.5 |
566 | 2022-08-31 01:51:01 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
565 | 2022-08-25 17:44:16 | kerry | 3 | 83667 | 854 | 3.580 | 23370.7 |
564 | 2022-08-23 03:22:16 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
563 | 2022-08-20 11:04:44 | kerry | 3 | 83667 | 854 | 3.203 | 26121.4 |
562 | 2022-08-17 16:54:12 | kerry | 3 | 83667 | 854 | 3.186 | 26260.8 |
561 | 2022-08-15 10:30:28 | kerry | 1 | 28756 | 11 | 0.470 | 61183.0 |
560 | 2022-08-14 13:13:50 | kerry | 1 | 28756 | 11 | 0.420 | 68466.7 |
559 | 2022-08-11 20:19:45 | kerry | 3 | 83667 | 854 | 3.203 | 26121.4 |
558 | 2022-08-07 23:32:52 | kerry | 3 | 83667 | 854 | 3.220 | 25983.5 |
557 | 2022-08-02 09:17:26 | kerry | 1 | 28756 | 11 | 0.860 | 33437.2 |
556 | 2022-07-17 20:18:45 | kerry | 3 | 83667 | 854 | 3.220 | 25983.5 |
555 | 2022-07-16 17:02:43 | kerry | 3 | 83667 | 854 | 3.203 | 26121.4 |
554 | 2022-07-15 05:20:34 | kerry | 3 | 83667 | 854 | 3.610 | 23176.5 |
553 | 2022-07-10 09:46:09 | kerry | 3 | 83667 | 854 | 3.233 | 25879.1 |
552 | 2022-07-08 22:03:12 | kerry | 3 | 83667 | 854 | 3.703 | 22594.4 |
551 | 2022-06-07 04:02:10 | kerry | 3 | 83667 | 854 | 3.670 | 22797.5 |
550 | 2022-04-26 10:36:29 | kerry | 1 | 28756 | 11 | 0.533 | 53951.2 |
549 | 2022-04-17 18:36:14 | kerry | 2 | 53800 | 77 | 1.530 | 35163.4 |
548 | 2022-04-15 14:09:43 | kerry | 2 | 53800 | 77 | 1.640 | 32804.9 |
547 | 2022-04-04 07:56:59 | kerry | 1 | 28756 | 11 | 0.436 | 65954.1 |
546 | 2022-01-30 18:02:57 | kerry | 3 | 83667 | 854 | 3.610 | 23176.5 |
545 | 2022-01-19 20:53:38 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
544 | 2021-12-25 11:28:29 | kerry | 1 | 28756 | 11 | 0.576 | 49923.6 |
543 | 2021-12-20 13:36:53 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
542 | 2021-12-18 23:58:48 | kerry | 2 | 53800 | 77 | 1.360 | 39558.8 |
541 | 2021-11-13 12:04:11 | kerry | 1 | 28756 | 11 | 0.876 | 32826.5 |
540 | 2021-11-06 20:54:30 | kerry | 1 | 28756 | 11 | 0.483 | 59536.2 |
539 | 2021-11-03 04:12:14 | kerry | 3 | 83667 | 854 | 3.216 | 26015.9 |
538 | 2021-10-05 10:42:05 | kerry | 2 | 53800 | 77 | 1.373 | 39184.3 |
537 | 2021-10-01 04:53:50 | kerry | 1 | 28756 | 11 | 0.500 | 57512.0 |
536 | 2021-09-10 02:36:08 | kerry | 1 | 28756 | 11 | 0.440 | 65354.5 |
535 | 2021-08-31 21:25:38 | kerry | 1 | 28756 | 11 | 0.466 | 61708.2 |