History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scottie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
653 | 2024-06-01 07:27:12 | scottie | 3 | 134027 | 211 | 19.343 | 6929.0 |
652 | 2024-06-01 01:08:49 | scottie | 3 | 134027 | 211 | 23.093 | 5803.8 |
651 | 2024-06-01 00:32:01 | scottie | 3 | 134027 | 211 | 32.766 | 4090.4 |
650 | 2024-06-01 00:32:05 | scottie | 2 | 107671 | 15 | 13.750 | 7830.6 |
649 | 2024-06-01 00:31:56 | scottie | 1 | 69583 | 2 | 1.860 | 37410.2 |
648 | 2024-05-27 14:11:46 | scottie | 1 | 69583 | 2 | 4.143 | 16795.3 |
647 | 2024-04-25 23:53:46 | scottie | 3 | 134027 | 211 | 17.003 | 7882.6 |
646 | 2024-04-06 07:53:38 | scottie | 3 | 134027 | 211 | 16.686 | 8032.3 |
645 | 2024-04-05 02:15:19 | scottie | 3 | 134027 | 211 | 16.250 | 8247.8 |
644 | 2024-04-04 06:52:13 | scottie | 3 | 134027 | 211 | 17.220 | 7783.2 |
643 | 2024-04-04 06:52:14 | scottie | 2 | 107671 | 15 | 9.203 | 11699.6 |
642 | 2024-04-04 06:52:05 | scottie | 1 | 69583 | 2 | 4.343 | 16021.9 |
641 | 2024-04-04 06:51:53 | scottie | 3 | 134027 | 211 | 16.406 | 8169.4 |
640 | 2024-04-04 06:51:54 | scottie | 2 | 107671 | 15 | 7.686 | 14008.7 |
639 | 2024-04-04 06:51:52 | scottie | 1 | 69583 | 2 | 2.810 | 24762.6 |
638 | 2024-03-07 23:32:26 | scottie | 1 | 69583 | 2 | 2.640 | 26357.2 |
637 | 2024-02-25 20:28:30 | scottie | 1 | 69583 | 2 | 1.436 | 48456.1 |
636 | 2024-02-08 01:55:36 | scottie | 2 | 107671 | 15 | 2.813 | 38276.2 |
635 | 2023-12-27 01:22:47 | scottie | 2 | 107671 | 15 | 4.050 | 26585.4 |
634 | 2023-12-13 20:00:21 | scottie | 1 | 69583 | 2 | 1.186 | 58670.3 |
633 | 2023-12-09 00:07:10 | scottie | 1 | 69583 | 2 | 1.080 | 64428.7 |
632 | 2023-11-29 02:16:59 | scottie | 1 | 69583 | 2 | 1.080 | 64428.7 |
631 | 2023-11-26 12:10:23 | scottie | 1 | 69583 | 2 | 1.093 | 63662.4 |
630 | 2023-11-20 14:40:38 | scottie | 1 | 69583 | 2 | 1.173 | 59320.5 |
629 | 2023-11-13 05:50:35 | scottie | 2 | 107671 | 15 | 3.200 | 33647.2 |
628 | 2023-10-11 17:31:05 | scottie | 1 | 69583 | 2 | 1.220 | 57035.2 |
627 | 2023-09-27 18:28:48 | scottie | 1 | 69583 | 2 | 1.266 | 54962.9 |
626 | 2023-09-23 02:56:08 | scottie | 1 | 69583 | 2 | 1.266 | 54962.9 |
625 | 2023-09-15 06:45:39 | scottie | 1 | 69583 | 2 | 1.080 | 64428.7 |
624 | 2023-08-15 09:27:30 | scottie | 2 | 107671 | 15 | 2.843 | 37872.3 |
623 | 2023-07-19 11:34:15 | scottie | 1 | 69583 | 2 | 1.080 | 64428.7 |
622 | 2023-05-29 09:30:24 | scottie | 1 | 69583 | 2 | 1.063 | 65459.1 |
621 | 2023-05-15 08:45:27 | scottie | 3 | 134027 | 211 | 6.546 | 20474.6 |
620 | 2023-05-01 08:06:26 | scottie | 2 | 107671 | 15 | 2.906 | 37051.3 |
619 | 2023-04-22 11:53:56 | scottie | 1 | 69583 | 2 | 1.093 | 63662.4 |
618 | 2023-04-05 05:24:03 | scottie | 3 | 134027 | 211 | 6.703 | 19995.1 |
617 | 2023-03-16 20:50:52 | scottie | 3 | 134027 | 211 | 5.606 | 23907.8 |
616 | 2023-02-17 16:21:34 | scottie | 3 | 134027 | 211 | 5.796 | 23124.1 |
615 | 2023-02-11 10:37:04 | scottie | 1 | 69583 | 2 | 1.093 | 63662.4 |
614 | 2023-02-06 16:22:15 | scottie | 2 | 107671 | 15 | 2.830 | 38046.3 |
613 | 2023-01-26 13:32:45 | scottie | 1 | 69583 | 2 | 2.156 | 32274.1 |
612 | 2022-12-29 02:32:08 | scottie | 3 | 134027 | 211 | 5.826 | 23005.0 |
611 | 2022-12-24 02:37:25 | scottie | 3 | 134027 | 211 | 6.016 | 22278.4 |
610 | 2022-12-10 03:12:30 | scottie | 3 | 134027 | 211 | 6.000 | 22337.8 |
609 | 2022-12-08 21:36:41 | scottie | 1 | 69583 | 2 | 1.093 | 63662.4 |
608 | 2022-11-20 08:41:48 | scottie | 2 | 107671 | 15 | 2.796 | 38508.9 |
607 | 2022-11-13 11:30:06 | scottie | 3 | 134027 | 211 | 6.406 | 20922.1 |
606 | 2022-09-20 14:24:24 | scottie | 1 | 69583 | 2 | 1.076 | 64668.2 |
605 | 2022-08-08 15:11:37 | scottie | 1 | 69583 | 2 | 1.203 | 57841.2 |
604 | 2022-07-18 17:49:20 | scottie | 1 | 69583 | 2 | 1.280 | 54361.7 |
603 | 2022-05-10 07:35:30 | scottie | 2 | 107671 | 15 | 2.843 | 37872.3 |
602 | 2022-05-06 17:23:29 | scottie | 1 | 69583 | 2 | 1.110 | 62687.4 |
601 | 2022-05-05 22:26:11 | scottie | 2 | 107671 | 15 | 3.373 | 31921.4 |
600 | 2022-04-30 12:43:57 | scottie | 1 | 69583 | 2 | 1.063 | 65459.1 |
599 | 2022-04-26 03:58:07 | scottie | 3 | 134027 | 211 | 7.423 | 18055.6 |
598 | 2022-04-04 13:02:38 | scottie | 1 | 69583 | 2 | 1.580 | 44039.9 |
597 | 2022-04-02 09:04:40 | scottie | 1 | 69583 | 2 | 1.063 | 65459.1 |
596 | 2022-01-21 20:39:48 | scottie | 3 | 134027 | 211 | 6.016 | 22278.4 |
595 | 2022-01-20 18:59:48 | scottie | 3 | 134027 | 211 | 6.563 | 20421.6 |
594 | 2022-01-18 10:40:06 | scottie | 2 | 107671 | 15 | 3.016 | 35699.9 |
593 | 2022-01-17 22:39:16 | scottie | 3 | 134027 | 211 | 7.283 | 18402.7 |
592 | 2022-01-09 09:57:01 | scottie | 3 | 134027 | 211 | 7.296 | 18369.9 |
591 | 2022-01-08 18:10:21 | scottie | 3 | 134027 | 211 | 7.000 | 19146.7 |
590 | 2022-01-07 21:38:42 | scottie | 3 | 134027 | 211 | 6.656 | 20136.3 |
589 | 2022-01-07 11:01:04 | scottie | 3 | 134027 | 211 | 5.920 | 22639.7 |
588 | 2022-01-06 20:37:19 | scottie | 3 | 134027 | 211 | 5.906 | 22693.4 |
587 | 2022-01-05 17:44:58 | scottie | 3 | 134027 | 211 | 5.983 | 22401.3 |
586 | 2022-01-03 17:55:12 | scottie | 1 | 69583 | 2 | 2.233 | 31161.2 |
585 | 2021-12-30 17:46:00 | scottie | 1 | 69583 | 2 | 1.280 | 54361.7 |
584 | 2021-12-23 13:00:58 | scottie | 3 | 134027 | 211 | 6.796 | 19721.5 |
583 | 2021-12-23 01:39:04 | scottie | 3 | 134027 | 211 | 6.063 | 22105.7 |
582 | 2021-12-22 17:30:13 | scottie | 3 | 134027 | 211 | 5.766 | 23244.4 |
581 | 2021-12-22 06:16:55 | scottie | 3 | 134027 | 211 | 5.736 | 23365.9 |
580 | 2021-12-21 13:02:58 | scottie | 3 | 134027 | 211 | 6.330 | 21173.3 |
579 | 2021-12-21 01:38:30 | scottie | 3 | 134027 | 211 | 7.046 | 19021.7 |
578 | 2021-12-20 14:56:28 | scottie | 3 | 134027 | 211 | 7.500 | 17870.3 |
577 | 2021-12-20 03:09:00 | scottie | 3 | 134027 | 211 | 7.173 | 18684.9 |
576 | 2021-12-19 07:13:55 | scottie | 3 | 134027 | 211 | 6.890 | 19452.4 |
575 | 2021-12-18 20:33:23 | scottie | 3 | 134027 | 211 | 9.266 | 14464.4 |
574 | 2021-12-18 02:50:03 | scottie | 3 | 134027 | 211 | 6.940 | 19312.2 |
573 | 2021-12-17 15:12:35 | scottie | 3 | 134027 | 211 | 6.376 | 21020.5 |
572 | 2021-12-14 06:45:31 | scottie | 3 | 134027 | 211 | 7.203 | 18607.1 |
571 | 2021-12-13 21:01:34 | scottie | 3 | 134027 | 211 | 6.906 | 19407.3 |
570 | 2021-12-13 12:08:30 | scottie | 3 | 134027 | 211 | 6.626 | 20227.4 |
569 | 2021-12-12 19:00:42 | scottie | 3 | 134027 | 211 | 6.783 | 19759.3 |
568 | 2021-12-12 07:12:34 | scottie | 3 | 134027 | 211 | 7.390 | 18136.3 |
567 | 2021-12-11 19:52:54 | scottie | 3 | 134027 | 211 | 14.143 | 9476.6 |
566 | 2021-12-10 23:52:59 | scottie | 3 | 134027 | 211 | 6.953 | 19276.1 |
565 | 2021-11-28 20:32:07 | scottie | 3 | 134027 | 211 | 7.186 | 18651.1 |
564 | 2021-11-28 08:41:09 | scottie | 3 | 134027 | 211 | 6.673 | 20085.0 |
563 | 2021-11-27 17:13:51 | scottie | 3 | 134027 | 211 | 5.813 | 23056.4 |
562 | 2021-11-27 00:57:48 | scottie | 3 | 134027 | 211 | 5.796 | 23124.1 |
561 | 2021-11-26 13:23:52 | scottie | 3 | 134027 | 211 | 6.893 | 19443.9 |
560 | 2021-11-25 22:39:48 | scottie | 3 | 134027 | 211 | 7.046 | 19021.7 |
559 | 2021-11-25 10:56:50 | scottie | 3 | 134027 | 211 | 12.970 | 10333.6 |
558 | 2021-11-24 13:02:58 | scottie | 3 | 134027 | 211 | 7.283 | 18402.7 |
557 | 2021-11-24 00:55:11 | scottie | 3 | 134027 | 211 | 6.860 | 19537.5 |
556 | 2021-11-23 05:11:39 | scottie | 3 | 134027 | 211 | 6.283 | 21331.7 |
555 | 2021-11-22 16:55:55 | scottie | 3 | 134027 | 211 | 6.656 | 20136.3 |
554 | 2021-11-22 03:59:42 | scottie | 3 | 134027 | 211 | 6.360 | 21073.4 |