History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"willie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1020 | 2024-04-26 23:09:52 | willie | 1 | 48755 | 8 | 1.860 | 26212.4 |
1019 | 2024-04-23 15:17:00 | willie | 1 | 48755 | 8 | 1.076 | 45311.3 |
1018 | 2024-04-23 15:00:35 | willie | 1 | 48755 | 8 | 1.143 | 42655.3 |
1017 | 2024-04-14 10:43:50 | willie | 2 | 82551 | 54 | 2.280 | 36206.6 |
1016 | 2024-03-30 07:38:03 | willie | 1 | 48755 | 8 | 2.813 | 17332.0 |
1015 | 2024-03-26 06:08:21 | willie | 1 | 48755 | 8 | 0.890 | 54780.9 |
1014 | 2024-03-07 06:21:05 | willie | 3 | 112716 | 550 | 5.593 | 20153.0 |
1013 | 2024-03-07 04:41:22 | willie | 1 | 48755 | 8 | 0.800 | 60943.8 |
1012 | 2024-03-05 01:44:55 | willie | 3 | 112716 | 550 | 9.220 | 12225.2 |
1011 | 2024-02-29 08:19:43 | willie | 2 | 82551 | 54 | 2.436 | 33887.9 |
1010 | 2024-02-29 08:18:19 | willie | 3 | 112716 | 550 | 4.813 | 23419.1 |
1009 | 2024-02-27 14:49:12 | willie | 3 | 112716 | 550 | 5.550 | 20309.2 |
1008 | 2024-02-27 14:49:11 | willie | 2 | 82551 | 54 | 2.440 | 33832.4 |
1007 | 2024-02-27 14:49:10 | willie | 1 | 48755 | 8 | 0.813 | 59969.2 |
1006 | 2024-02-11 12:32:07 | willie | 1 | 48755 | 8 | 0.753 | 64747.7 |
1005 | 2024-02-11 03:58:01 | willie | 3 | 112716 | 550 | 4.783 | 23566.0 |
1004 | 2024-02-10 12:51:35 | willie | 3 | 112716 | 550 | 4.610 | 24450.3 |
1003 | 2024-02-09 13:28:23 | willie | 3 | 112716 | 550 | 5.170 | 21801.9 |
1002 | 2024-02-08 19:25:16 | willie | 3 | 112716 | 550 | 12.796 | 8808.7 |
1001 | 2024-01-30 00:30:26 | willie | 2 | 82551 | 54 | 2.390 | 34540.2 |
1000 | 2024-01-30 00:28:34 | willie | 3 | 112716 | 550 | 6.563 | 17174.5 |
999 | 2024-01-28 10:52:51 | willie | 2 | 82551 | 54 | 2.110 | 39123.7 |
998 | 2024-01-28 10:52:27 | willie | 3 | 112716 | 550 | 5.080 | 22188.2 |
997 | 2024-01-28 06:25:34 | willie | 3 | 112716 | 550 | 4.686 | 24053.8 |
996 | 2024-01-27 09:47:17 | willie | 3 | 112716 | 550 | 4.686 | 24053.8 |
995 | 2024-01-25 20:54:28 | willie | 3 | 112716 | 550 | 5.560 | 20272.7 |
994 | 2024-01-24 15:38:25 | willie | 3 | 112716 | 550 | 4.500 | 25048.0 |
993 | 2024-01-23 21:28:36 | willie | 3 | 112716 | 550 | 4.530 | 24882.1 |
992 | 2024-01-22 16:21:51 | willie | 3 | 112716 | 550 | 4.623 | 24381.6 |
991 | 2024-01-05 21:47:42 | willie | 3 | 112716 | 550 | 5.330 | 21147.5 |
990 | 2024-01-05 00:51:15 | willie | 3 | 112716 | 550 | 5.500 | 20493.8 |
989 | 2024-01-03 04:56:29 | willie | 3 | 112716 | 550 | 5.093 | 22131.6 |
988 | 2024-01-02 04:32:36 | willie | 3 | 112716 | 550 | 5.236 | 21527.1 |
987 | 2023-12-30 17:35:17 | willie | 3 | 112716 | 550 | 4.856 | 23211.7 |
986 | 2023-12-29 12:31:18 | willie | 3 | 112716 | 550 | 4.580 | 24610.5 |
985 | 2023-12-28 18:59:26 | willie | 3 | 112716 | 550 | 8.983 | 12547.7 |
984 | 2023-12-27 08:50:22 | willie | 3 | 112716 | 550 | 5.436 | 20735.1 |
983 | 2023-12-26 08:20:26 | willie | 3 | 112716 | 550 | 4.780 | 23580.8 |
982 | 2023-12-24 00:10:29 | willie | 3 | 112716 | 550 | 4.813 | 23419.1 |
981 | 2023-12-22 09:53:18 | willie | 3 | 112716 | 550 | 5.453 | 20670.5 |
980 | 2023-12-21 04:58:42 | willie | 3 | 112716 | 550 | 5.236 | 21527.1 |
979 | 2023-12-20 04:03:56 | willie | 3 | 112716 | 550 | 4.656 | 24208.8 |
978 | 2023-12-18 21:29:49 | willie | 1 | 48755 | 8 | 0.750 | 65006.7 |
977 | 2023-12-17 19:43:04 | willie | 3 | 112716 | 550 | 5.516 | 20434.4 |
976 | 2023-12-17 16:36:22 | willie | 3 | 112716 | 550 | 5.626 | 20034.8 |
975 | 2023-12-17 10:23:42 | willie | 2 | 82551 | 54 | 5.203 | 15866.0 |
974 | 2023-12-16 12:39:15 | willie | 3 | 112716 | 550 | 5.300 | 21267.2 |
973 | 2023-12-15 10:28:09 | willie | 3 | 112716 | 550 | 5.406 | 20850.2 |
972 | 2023-12-14 08:34:39 | willie | 2 | 82551 | 54 | 2.110 | 39123.7 |
971 | 2023-12-13 04:47:17 | willie | 3 | 112716 | 550 | 5.250 | 21469.7 |
970 | 2023-12-08 23:34:55 | willie | 3 | 112716 | 550 | 4.936 | 22835.5 |
969 | 2023-12-07 00:01:19 | willie | 3 | 112716 | 550 | 4.986 | 22606.5 |
968 | 2023-12-06 00:16:37 | willie | 3 | 112716 | 550 | 4.906 | 22975.1 |
967 | 2023-12-04 19:32:37 | willie | 3 | 112716 | 550 | 5.266 | 21404.5 |
966 | 2023-12-02 09:08:37 | willie | 2 | 82551 | 54 | 2.250 | 36689.3 |
965 | 2023-11-26 21:57:56 | willie | 3 | 112716 | 550 | 5.080 | 22188.2 |
964 | 2023-11-25 21:54:02 | willie | 3 | 112716 | 550 | 5.403 | 20861.7 |
963 | 2023-11-25 19:57:23 | willie | 3 | 112716 | 550 | 5.940 | 18975.8 |
962 | 2023-11-24 20:32:01 | willie | 3 | 112716 | 550 | 5.123 | 22002.0 |
961 | 2023-11-22 21:38:31 | willie | 3 | 112716 | 550 | 4.563 | 24702.2 |
960 | 2023-11-22 18:03:03 | willie | 2 | 82551 | 54 | 2.110 | 39123.7 |
959 | 2023-11-21 21:30:39 | willie | 3 | 112716 | 550 | 4.560 | 24718.4 |
958 | 2023-11-20 21:29:42 | willie | 3 | 112716 | 550 | 4.516 | 24959.3 |
957 | 2023-11-20 12:14:09 | willie | 3 | 112716 | 550 | 6.206 | 18162.4 |
956 | 2023-11-20 07:35:27 | willie | 3 | 112716 | 550 | 6.826 | 16512.7 |
955 | 2023-11-19 21:28:39 | willie | 3 | 112716 | 550 | 5.296 | 21283.2 |
954 | 2023-11-19 13:22:13 | willie | 3 | 112716 | 550 | 4.533 | 24865.7 |
953 | 2023-11-19 06:11:09 | willie | 3 | 112716 | 550 | 5.346 | 21084.2 |
952 | 2023-11-18 21:27:22 | willie | 3 | 112716 | 550 | 5.796 | 19447.2 |
951 | 2023-11-18 15:23:17 | willie | 3 | 112716 | 550 | 5.233 | 21539.5 |
950 | 2023-11-18 00:46:46 | willie | 3 | 112716 | 550 | 5.500 | 20493.8 |
949 | 2023-11-17 23:22:02 | willie | 1 | 48755 | 8 | 0.810 | 60191.4 |
948 | 2023-11-17 21:07:08 | willie | 3 | 112716 | 550 | 4.533 | 24865.7 |
947 | 2023-11-17 04:42:03 | willie | 3 | 112716 | 550 | 5.236 | 21527.1 |
946 | 2023-11-16 21:23:39 | willie | 3 | 112716 | 550 | 4.703 | 23966.8 |
945 | 2023-11-16 03:21:05 | willie | 3 | 112716 | 550 | 4.470 | 25216.1 |
944 | 2023-11-15 21:20:04 | willie | 3 | 112716 | 550 | 4.763 | 23664.9 |
943 | 2023-11-15 04:05:44 | willie | 3 | 112716 | 550 | 5.576 | 20214.5 |
942 | 2023-11-14 20:44:59 | willie | 3 | 112716 | 550 | 5.080 | 22188.2 |
941 | 2023-11-14 03:48:57 | willie | 3 | 112716 | 550 | 4.623 | 24381.6 |
940 | 2023-11-14 03:34:25 | willie | 2 | 82551 | 54 | 2.423 | 34069.7 |
939 | 2023-11-14 03:34:23 | willie | 1 | 48755 | 8 | 0.780 | 62506.4 |
938 | 2023-11-13 20:31:22 | willie | 3 | 112716 | 550 | 4.626 | 24365.8 |
937 | 2023-11-13 03:46:24 | willie | 3 | 112716 | 550 | 6.326 | 17817.9 |
936 | 2023-11-12 04:15:02 | willie | 3 | 112716 | 550 | 5.000 | 22543.2 |
935 | 2023-11-11 02:35:38 | willie | 3 | 112716 | 550 | 9.233 | 12207.9 |
934 | 2023-11-10 15:05:45 | willie | 3 | 112716 | 550 | 4.500 | 25048.0 |
933 | 2023-11-10 03:05:47 | willie | 3 | 112716 | 550 | 4.843 | 23274.0 |
932 | 2023-11-09 04:27:47 | willie | 3 | 112716 | 550 | 5.796 | 19447.2 |
931 | 2023-11-09 03:35:40 | willie | 3 | 112716 | 550 | 4.673 | 24120.7 |
930 | 2023-11-07 23:45:07 | willie | 3 | 112716 | 550 | 4.750 | 23729.7 |
929 | 2023-11-07 23:04:26 | willie | 3 | 112716 | 550 | 7.220 | 15611.6 |
928 | 2023-11-07 17:00:04 | willie | 3 | 112716 | 550 | 5.266 | 21404.5 |
927 | 2023-11-07 09:51:05 | willie | 3 | 112716 | 550 | 9.923 | 11359.1 |
926 | 2023-11-07 09:50:51 | willie | 3 | 112716 | 550 | 19.876 | 5671.0 |
925 | 2023-11-06 16:07:38 | willie | 3 | 112716 | 550 | 15.766 | 7149.3 |
924 | 2023-11-05 16:16:22 | willie | 3 | 112716 | 550 | 5.373 | 20978.2 |
923 | 2023-11-04 16:08:43 | willie | 3 | 112716 | 550 | 4.953 | 22757.1 |
922 | 2023-11-04 09:37:26 | willie | 1 | 48755 | 8 | 0.766 | 63648.8 |
921 | 2023-11-03 17:13:41 | willie | 3 | 112716 | 550 | 10.843 | 10395.3 |