History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lacy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
674 | 2024-04-13 16:40:28 | lacy | 1 | 13983 | 12 | 0.283 | 49409.9 |
673 | 2024-04-06 06:48:01 | lacy | 2 | 29872 | 235 | 1.940 | 15397.9 |
672 | 2024-04-05 05:47:50 | lacy | 2 | 29872 | 235 | 1.843 | 16208.4 |
671 | 2024-04-04 22:59:34 | lacy | 2 | 29872 | 235 | 2.483 | 12030.6 |
670 | 2024-04-04 22:46:05 | lacy | 1 | 13983 | 12 | 0.593 | 23580.1 |
669 | 2024-04-02 23:33:45 | lacy | 1 | 13983 | 12 | 0.580 | 24108.6 |
668 | 2024-03-31 01:00:25 | lacy | 1 | 13983 | 12 | 0.580 | 24108.6 |
667 | 2024-03-25 13:16:50 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
666 | 2024-03-05 20:04:32 | lacy | 1 | 13983 | 12 | 0.560 | 24969.6 |
665 | 2024-03-05 02:30:38 | lacy | 1 | 13983 | 12 | 0.563 | 24836.6 |
664 | 2024-03-05 02:30:17 | lacy | 2 | 29872 | 235 | 3.953 | 7556.8 |
663 | 2024-03-05 02:30:11 | lacy | 1 | 13983 | 12 | 0.606 | 23074.3 |
662 | 2024-03-03 20:08:48 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
661 | 2024-02-29 20:17:56 | lacy | 1 | 13983 | 12 | 0.546 | 25609.9 |
660 | 2024-02-07 15:30:25 | lacy | 2 | 29872 | 235 | 0.903 | 33080.8 |
659 | 2024-02-02 22:15:45 | lacy | 1 | 13983 | 12 | 0.500 | 27966.0 |
658 | 2024-02-02 16:13:47 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
657 | 2024-01-28 14:07:32 | lacy | 1 | 13983 | 12 | 0.280 | 49939.3 |
656 | 2024-01-26 04:36:25 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
655 | 2024-01-04 18:26:38 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
654 | 2023-12-07 01:08:21 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
653 | 2023-11-25 17:09:27 | lacy | 2 | 29872 | 235 | 0.750 | 39829.3 |
652 | 2023-11-10 02:37:49 | lacy | 2 | 29872 | 235 | 0.920 | 32469.6 |
651 | 2023-11-09 18:32:55 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
650 | 2023-11-07 13:16:52 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
649 | 2023-11-07 11:01:10 | lacy | 1 | 13983 | 12 | 0.296 | 47239.9 |
648 | 2023-11-07 11:01:07 | lacy | 1 | 13983 | 12 | 0.860 | 16259.3 |
647 | 2023-11-05 16:09:58 | lacy | 2 | 29872 | 235 | 0.766 | 38997.4 |
646 | 2023-10-29 17:19:12 | lacy | 2 | 29872 | 235 | 0.983 | 30388.6 |
645 | 2023-10-28 08:42:22 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
644 | 2023-10-26 10:37:39 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
643 | 2023-10-23 12:41:08 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
642 | 2023-10-20 17:58:20 | lacy | 2 | 29872 | 235 | 0.826 | 36164.6 |
641 | 2023-10-20 02:29:24 | lacy | 1 | 13983 | 12 | 0.236 | 59250.0 |
640 | 2023-10-16 22:28:01 | lacy | 1 | 13983 | 12 | 0.263 | 53167.3 |
639 | 2023-10-11 21:19:53 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
638 | 2023-10-07 12:04:43 | lacy | 2 | 29872 | 235 | 0.766 | 38997.4 |
637 | 2023-10-03 12:03:48 | lacy | 1 | 13983 | 12 | 0.283 | 49409.9 |
636 | 2023-09-23 00:25:40 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
635 | 2023-09-15 22:16:18 | lacy | 2 | 29872 | 235 | 0.766 | 38997.4 |
634 | 2023-09-10 15:44:53 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
633 | 2023-08-22 07:03:58 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
632 | 2023-08-17 21:52:52 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
631 | 2023-05-21 01:57:51 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
630 | 2023-05-03 15:40:57 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
629 | 2023-03-14 10:04:23 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
628 | 2023-01-25 02:11:10 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
627 | 2023-01-03 15:15:10 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
626 | 2022-11-26 14:34:05 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
625 | 2022-10-10 18:55:24 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
624 | 2022-09-25 19:25:28 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
623 | 2022-09-10 20:42:02 | lacy | 1 | 13983 | 12 | 0.340 | 41126.5 |
622 | 2022-08-31 21:16:51 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
621 | 2022-08-07 10:36:24 | lacy | 1 | 13983 | 12 | 0.500 | 27966.0 |
620 | 2022-06-24 03:39:29 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
619 | 2022-05-09 04:14:58 | lacy | 1 | 13983 | 12 | 0.236 | 59250.0 |
618 | 2022-03-08 02:18:32 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
617 | 2022-02-23 09:35:41 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
616 | 2022-01-28 04:19:44 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
615 | 2022-01-25 05:08:11 | lacy | 1 | 13983 | 12 | 0.236 | 59250.0 |
614 | 2021-12-01 03:49:23 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
613 | 2021-11-23 11:37:41 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
612 | 2021-11-19 01:30:01 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
611 | 2021-11-11 19:36:27 | lacy | 1 | 13983 | 12 | 0.236 | 59250.0 |
610 | 2021-10-09 04:23:52 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
609 | 2021-09-04 23:25:27 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
608 | 2021-09-02 17:16:08 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
607 | 2021-08-28 04:01:03 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
606 | 2021-08-16 05:51:22 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
605 | 2021-08-12 13:18:34 | lacy | 1 | 13983 | 12 | 0.203 | 68881.8 |
604 | 2021-07-21 10:20:04 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
603 | 2021-06-27 14:42:03 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
602 | 2021-05-27 09:54:32 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
601 | 2021-05-10 15:36:39 | lacy | 1 | 13983 | 12 | 0.420 | 33292.9 |
600 | 2021-03-16 07:21:31 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
599 | 2021-02-26 08:31:37 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
598 | 2021-02-22 02:45:06 | lacy | 1 | 13983 | 12 | 0.203 | 68881.8 |
597 | 2021-01-24 03:07:16 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
596 | 2020-12-31 14:38:18 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
595 | 2020-11-19 21:30:07 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
594 | 2020-11-19 00:49:21 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
593 | 2020-11-04 00:54:43 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
592 | 2020-10-20 04:17:41 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
591 | 2020-10-17 01:31:00 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
590 | 2020-10-04 12:17:19 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
589 | 2020-08-25 19:38:23 | lacy | 1 | 13983 | 12 | 0.500 | 27966.0 |
588 | 2020-08-22 23:29:11 | lacy | 1 | 13983 | 12 | 0.296 | 47239.9 |
587 | 2020-08-19 00:56:27 | lacy | 1 | 13983 | 12 | 0.220 | 63559.1 |
586 | 2020-08-04 20:50:28 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
585 | 2020-08-04 20:21:52 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
584 | 2020-05-22 23:22:32 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
583 | 2020-05-17 19:20:05 | lacy | 1 | 13983 | 12 | 0.216 | 64736.1 |
582 | 2020-03-29 18:09:52 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
581 | 2020-03-24 19:40:18 | lacy | 1 | 13983 | 12 | 0.233 | 60012.9 |
580 | 2020-03-24 04:38:31 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
579 | 2020-03-22 13:25:27 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
578 | 2020-03-21 10:27:08 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |
577 | 2020-03-19 15:57:29 | lacy | 1 | 13983 | 12 | 0.236 | 59250.0 |
576 | 2020-03-18 22:23:02 | lacy | 1 | 13983 | 12 | 0.266 | 52567.7 |
575 | 2020-03-18 16:14:00 | lacy | 1 | 13983 | 12 | 0.250 | 55932.0 |