History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gayety"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
663 | 2024-05-04 05:01:16 | gayety | 1 | 48755 | 2 | 0.876 | 55656.4 |
662 | 2024-04-30 08:49:10 | gayety | 1 | 48755 | 2 | 3.093 | 15763.0 |
661 | 2024-04-28 16:09:38 | gayety | 2 | 82551 | 14 | 2.610 | 31628.7 |
660 | 2024-04-28 16:09:17 | gayety | 3 | 112716 | 335 | 5.953 | 18934.3 |
659 | 2024-04-25 21:45:33 | gayety | 2 | 82551 | 14 | 2.593 | 31836.1 |
658 | 2024-04-25 21:45:28 | gayety | 3 | 112716 | 335 | 5.953 | 18934.3 |
657 | 2024-04-25 21:45:24 | gayety | 1 | 48755 | 2 | 1.076 | 45311.3 |
656 | 2024-04-25 21:45:12 | gayety | 2 | 82551 | 14 | 5.766 | 14316.9 |
655 | 2024-04-25 21:44:56 | gayety | 3 | 112716 | 335 | 6.423 | 17548.8 |
654 | 2024-04-22 11:12:03 | gayety | 3 | 112716 | 335 | 7.236 | 15577.1 |
653 | 2024-04-17 23:57:20 | gayety | 1 | 48755 | 2 | 1.906 | 25579.7 |
652 | 2024-03-29 19:23:22 | gayety | 1 | 48755 | 2 | 1.813 | 26891.9 |
651 | 2024-03-18 22:23:44 | gayety | 1 | 48755 | 2 | 2.470 | 19738.9 |
650 | 2024-03-03 14:18:07 | gayety | 3 | 112716 | 335 | 5.076 | 22205.7 |
649 | 2024-02-28 16:48:22 | gayety | 1 | 48755 | 2 | 0.906 | 53813.5 |
648 | 2024-02-28 11:18:04 | gayety | 2 | 82551 | 14 | 3.296 | 25045.8 |
647 | 2024-02-28 11:17:48 | gayety | 3 | 112716 | 335 | 5.796 | 19447.2 |
646 | 2024-02-28 01:32:57 | gayety | 3 | 112716 | 335 | 9.983 | 11290.8 |
645 | 2024-02-28 01:25:20 | gayety | 3 | 112716 | 335 | 7.826 | 14402.8 |
644 | 2024-02-28 01:25:21 | gayety | 2 | 82551 | 14 | 2.846 | 29006.0 |
643 | 2024-02-28 01:25:15 | gayety | 1 | 48755 | 2 | 0.953 | 51159.5 |
642 | 2024-02-23 02:59:47 | gayety | 1 | 48755 | 2 | 0.876 | 55656.4 |
641 | 2024-02-17 02:37:15 | gayety | 2 | 82551 | 14 | 3.216 | 25668.8 |
640 | 2024-02-16 21:01:53 | gayety | 1 | 48755 | 2 | 0.860 | 56691.9 |
639 | 2024-01-26 17:31:23 | gayety | 3 | 112716 | 335 | 5.893 | 19127.1 |
638 | 2024-01-26 01:10:15 | gayety | 3 | 112716 | 335 | 4.720 | 23880.5 |
637 | 2024-01-26 01:10:11 | gayety | 2 | 82551 | 14 | 2.360 | 34979.2 |
636 | 2024-01-14 03:08:02 | gayety | 3 | 112716 | 335 | 5.640 | 19985.1 |
635 | 2024-01-14 03:08:01 | gayety | 2 | 82551 | 14 | 2.533 | 32590.2 |
634 | 2024-01-11 07:24:36 | gayety | 1 | 48755 | 2 | 0.750 | 65006.7 |
633 | 2024-01-05 23:17:42 | gayety | 3 | 112716 | 335 | 5.250 | 21469.7 |
632 | 2023-12-27 16:54:52 | gayety | 1 | 48755 | 2 | 0.873 | 55847.7 |
631 | 2023-12-17 23:55:37 | gayety | 1 | 48755 | 2 | 0.763 | 63899.1 |
630 | 2023-12-05 10:26:26 | gayety | 1 | 48755 | 2 | 0.890 | 54780.9 |
629 | 2023-11-22 03:07:02 | gayety | 3 | 112716 | 335 | 4.906 | 22975.1 |
628 | 2023-11-17 06:39:08 | gayety | 1 | 48755 | 2 | 0.856 | 56956.8 |
627 | 2023-11-05 02:33:26 | gayety | 1 | 48755 | 2 | 0.873 | 55847.7 |
626 | 2023-10-19 08:44:07 | gayety | 1 | 48755 | 2 | 0.796 | 61250.0 |
625 | 2023-10-17 03:44:45 | gayety | 3 | 112716 | 335 | 6.096 | 18490.2 |
624 | 2023-10-11 17:09:46 | gayety | 1 | 48755 | 2 | 1.656 | 29441.4 |
623 | 2023-10-05 06:23:08 | gayety | 1 | 48755 | 2 | 0.813 | 59969.2 |
622 | 2023-09-24 12:21:57 | gayety | 1 | 48755 | 2 | 0.750 | 65006.7 |
621 | 2023-09-19 06:49:58 | gayety | 1 | 48755 | 2 | 0.750 | 65006.7 |
620 | 2023-09-12 20:46:46 | gayety | 1 | 48755 | 2 | 0.843 | 57835.1 |
619 | 2023-09-03 14:44:14 | gayety | 3 | 112716 | 335 | 5.376 | 20966.5 |
618 | 2023-09-02 17:19:54 | gayety | 3 | 112716 | 335 | 4.593 | 24540.8 |
617 | 2023-09-01 23:31:31 | gayety | 3 | 112716 | 335 | 5.516 | 20434.4 |
616 | 2023-09-01 16:37:09 | gayety | 3 | 112716 | 335 | 5.236 | 21527.1 |
615 | 2023-08-30 23:10:40 | gayety | 3 | 112716 | 335 | 4.563 | 24702.2 |
614 | 2023-08-24 15:14:24 | gayety | 3 | 112716 | 335 | 4.906 | 22975.1 |
613 | 2023-08-15 06:34:42 | gayety | 1 | 48755 | 2 | 0.810 | 60191.4 |
612 | 2023-07-13 17:38:56 | gayety | 1 | 48755 | 2 | 0.750 | 65006.7 |
611 | 2023-04-25 09:45:33 | gayety | 1 | 48755 | 2 | 0.843 | 57835.1 |
610 | 2023-04-23 08:54:05 | gayety | 1 | 48755 | 2 | 0.826 | 59025.4 |
609 | 2023-04-19 19:56:08 | gayety | 1 | 48755 | 2 | 0.766 | 63648.8 |
608 | 2023-03-22 15:57:19 | gayety | 1 | 48755 | 2 | 0.830 | 58741.0 |
607 | 2023-03-21 17:08:43 | gayety | 3 | 112716 | 335 | 4.530 | 24882.1 |
606 | 2023-02-07 11:01:19 | gayety | 1 | 48755 | 2 | 0.813 | 59969.2 |
605 | 2023-02-06 05:17:58 | gayety | 3 | 112716 | 335 | 4.530 | 24882.1 |
604 | 2023-02-01 10:28:08 | gayety | 3 | 112716 | 335 | 5.546 | 20323.8 |
603 | 2023-01-26 02:07:19 | gayety | 3 | 112716 | 335 | 4.560 | 24718.4 |
602 | 2023-01-07 06:13:30 | gayety | 1 | 48755 | 2 | 0.843 | 57835.1 |
601 | 2022-12-16 16:37:27 | gayety | 3 | 112716 | 335 | 5.190 | 21717.9 |
600 | 2022-12-11 21:52:01 | gayety | 3 | 112716 | 335 | 4.546 | 24794.5 |
599 | 2022-12-10 04:57:34 | gayety | 3 | 112716 | 335 | 4.890 | 23050.3 |
598 | 2022-12-06 00:55:26 | gayety | 1 | 48755 | 2 | 0.750 | 65006.7 |
597 | 2022-11-13 01:30:23 | gayety | 3 | 112716 | 335 | 4.766 | 23650.0 |
596 | 2022-11-07 21:05:02 | gayety | 3 | 112716 | 335 | 5.453 | 20670.5 |
595 | 2022-11-02 20:24:27 | gayety | 3 | 112716 | 335 | 4.640 | 24292.2 |
594 | 2022-10-30 03:27:42 | gayety | 3 | 112716 | 335 | 5.360 | 21029.1 |
593 | 2022-10-25 12:00:48 | gayety | 3 | 112716 | 335 | 5.453 | 20670.5 |
592 | 2022-10-24 00:25:20 | gayety | 3 | 112716 | 335 | 4.940 | 22817.0 |
591 | 2022-10-01 14:36:37 | gayety | 3 | 112716 | 335 | 4.703 | 23966.8 |
590 | 2022-09-28 11:49:38 | gayety | 3 | 112716 | 335 | 4.906 | 22975.1 |
589 | 2022-09-11 20:50:10 | gayety | 3 | 112716 | 335 | 5.593 | 20153.0 |
588 | 2022-09-05 13:51:18 | gayety | 1 | 48755 | 2 | 0.733 | 66514.3 |
587 | 2022-08-25 13:28:51 | gayety | 3 | 112716 | 335 | 4.923 | 22895.8 |
586 | 2022-08-04 20:48:44 | gayety | 1 | 48755 | 2 | 0.733 | 66514.3 |
585 | 2022-08-02 11:48:12 | gayety | 1 | 48755 | 2 | 0.736 | 66243.2 |
584 | 2022-07-24 05:05:31 | gayety | 3 | 112716 | 335 | 4.690 | 24033.3 |
583 | 2022-07-22 03:41:00 | gayety | 3 | 112716 | 335 | 4.670 | 24136.2 |
582 | 2022-07-19 23:22:02 | gayety | 3 | 112716 | 335 | 4.686 | 24053.8 |
581 | 2022-07-14 00:42:49 | gayety | 3 | 112716 | 335 | 5.313 | 21215.1 |
580 | 2022-06-18 11:02:28 | gayety | 3 | 112716 | 335 | 5.313 | 21215.1 |
579 | 2022-06-04 23:52:08 | gayety | 3 | 112716 | 335 | 4.716 | 23900.8 |
578 | 2022-06-02 23:42:40 | gayety | 3 | 112716 | 335 | 5.406 | 20850.2 |
577 | 2022-06-01 08:11:33 | gayety | 3 | 112716 | 335 | 5.313 | 21215.1 |
576 | 2022-05-31 17:49:02 | gayety | 3 | 112716 | 335 | 5.220 | 21593.1 |
575 | 2022-05-31 16:46:33 | gayety | 3 | 112716 | 335 | 4.593 | 24540.8 |
574 | 2022-05-29 07:00:37 | gayety | 3 | 112716 | 335 | 5.983 | 18839.4 |
573 | 2022-05-28 13:01:15 | gayety | 3 | 112716 | 335 | 5.983 | 18839.4 |
572 | 2022-05-27 05:53:23 | gayety | 3 | 112716 | 335 | 5.733 | 19660.9 |
571 | 2022-05-26 09:26:59 | gayety | 3 | 112716 | 335 | 5.533 | 20371.6 |
570 | 2022-05-17 19:00:44 | gayety | 3 | 112716 | 335 | 5.236 | 21527.1 |
569 | 2022-04-26 02:14:35 | gayety | 1 | 48755 | 2 | 0.736 | 66243.2 |
568 | 2022-04-17 23:33:19 | gayety | 3 | 112716 | 335 | 4.733 | 23814.9 |
567 | 2022-04-14 01:08:13 | gayety | 3 | 112716 | 335 | 5.453 | 20670.5 |
566 | 2022-03-31 20:18:59 | gayety | 3 | 112716 | 335 | 4.906 | 22975.1 |
565 | 2022-02-27 15:13:24 | gayety | 3 | 112716 | 335 | 5.406 | 20850.2 |
564 | 2022-02-24 20:27:39 | gayety | 3 | 112716 | 335 | 4.846 | 23259.6 |