History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reseller"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1006 | 2024-04-23 02:38:04 | reseller | 1 | 82945 | 4 | 1.513 | 54821.5 |
1005 | 2024-04-23 02:37:46 | reseller | 2 | 121059 | 34 | 7.313 | 16553.9 |
1004 | 2024-04-23 02:37:49 | reseller | 1 | 82945 | 4 | 1.623 | 51106.0 |
1003 | 2024-04-03 09:14:23 | reseller | 3 | 146162 | 253 | 12.876 | 11351.5 |
1002 | 2024-04-01 20:00:17 | reseller | 3 | 146162 | 253 | 18.016 | 8112.9 |
1001 | 2024-03-31 18:53:23 | reseller | 3 | 146162 | 253 | 16.203 | 9020.7 |
1000 | 2024-03-30 22:37:59 | reseller | 3 | 146162 | 253 | 13.750 | 10630.0 |
999 | 2024-03-30 08:46:05 | reseller | 3 | 146162 | 253 | 21.580 | 6773.0 |
998 | 2024-03-30 08:34:47 | reseller | 3 | 146162 | 253 | 22.156 | 6596.9 |
997 | 2024-03-30 08:34:48 | reseller | 2 | 121059 | 34 | 12.220 | 9906.6 |
996 | 2024-03-30 08:27:28 | reseller | 1 | 82945 | 4 | 1.750 | 47397.1 |
995 | 2024-03-30 01:20:38 | reseller | 1 | 82945 | 4 | 4.873 | 17021.3 |
994 | 2024-03-23 18:08:52 | reseller | 1 | 82945 | 4 | 5.110 | 16231.9 |
993 | 2024-03-13 17:00:12 | reseller | 1 | 82945 | 4 | 3.360 | 24686.0 |
992 | 2024-03-13 16:59:58 | reseller | 2 | 121059 | 34 | 4.656 | 26000.6 |
991 | 2024-03-01 14:32:53 | reseller | 3 | 146162 | 253 | 22.453 | 6509.7 |
990 | 2024-02-29 01:30:32 | reseller | 1 | 82945 | 4 | 2.936 | 28251.0 |
989 | 2024-02-22 17:54:30 | reseller | 3 | 146162 | 253 | 7.936 | 18417.6 |
988 | 2024-02-22 17:54:32 | reseller | 2 | 121059 | 34 | 4.013 | 30166.7 |
987 | 2024-02-22 07:08:36 | reseller | 1 | 82945 | 4 | 1.513 | 54821.5 |
986 | 2024-02-09 17:58:29 | reseller | 1 | 82945 | 4 | 3.186 | 26034.2 |
985 | 2024-02-04 11:14:36 | reseller | 3 | 146162 | 253 | 17.080 | 8557.5 |
984 | 2024-01-29 08:24:29 | reseller | 3 | 146162 | 253 | 7.533 | 19402.9 |
983 | 2024-01-23 03:44:51 | reseller | 2 | 121059 | 34 | 4.406 | 27475.9 |
982 | 2024-01-23 02:48:27 | reseller | 1 | 82945 | 4 | 1.486 | 55817.6 |
981 | 2024-01-14 13:06:23 | reseller | 3 | 146162 | 253 | 7.813 | 18707.5 |
980 | 2024-01-12 04:03:48 | reseller | 3 | 146162 | 253 | 7.876 | 18557.9 |
979 | 2023-12-25 07:42:03 | reseller | 1 | 82945 | 4 | 1.466 | 56579.1 |
978 | 2023-12-12 20:03:51 | reseller | 1 | 82945 | 4 | 1.376 | 60279.8 |
977 | 2023-11-29 01:11:57 | reseller | 1 | 82945 | 4 | 1.453 | 57085.3 |
976 | 2023-11-21 22:28:51 | reseller | 3 | 146162 | 253 | 7.516 | 19446.8 |
975 | 2023-11-15 19:41:44 | reseller | 3 | 146162 | 253 | 6.763 | 21612.0 |
974 | 2023-11-11 06:08:56 | reseller | 1 | 82945 | 4 | 2.626 | 31586.1 |
973 | 2023-11-05 08:15:59 | reseller | 1 | 82945 | 4 | 1.283 | 64649.3 |
972 | 2023-11-03 15:29:27 | reseller | 1 | 82945 | 4 | 1.283 | 64649.3 |
971 | 2023-10-28 16:25:06 | reseller | 3 | 146162 | 253 | 9.546 | 15311.3 |
970 | 2023-10-24 02:29:45 | reseller | 3 | 146162 | 253 | 7.593 | 19249.6 |
969 | 2023-10-21 08:55:52 | reseller | 3 | 146162 | 253 | 8.110 | 18022.4 |
968 | 2023-10-15 16:11:01 | reseller | 1 | 82945 | 4 | 2.970 | 27927.6 |
967 | 2023-10-09 19:34:03 | reseller | 1 | 82945 | 4 | 1.343 | 61761.0 |
966 | 2023-09-13 22:45:52 | reseller | 1 | 82945 | 4 | 1.453 | 57085.3 |
965 | 2023-08-27 22:04:08 | reseller | 3 | 146162 | 253 | 10.516 | 13899.0 |
964 | 2023-07-20 10:40:34 | reseller | 1 | 82945 | 4 | 1.313 | 63172.1 |
963 | 2023-06-24 05:09:54 | reseller | 1 | 82945 | 4 | 1.563 | 53067.8 |
962 | 2023-04-05 04:01:04 | reseller | 1 | 82945 | 4 | 1.500 | 55296.7 |
961 | 2023-04-01 09:55:59 | reseller | 1 | 82945 | 4 | 2.750 | 30161.8 |
960 | 2023-03-28 17:07:38 | reseller | 1 | 82945 | 4 | 1.283 | 64649.3 |
959 | 2023-03-20 05:07:00 | reseller | 3 | 146162 | 253 | 6.763 | 21612.0 |
958 | 2023-03-16 22:00:28 | reseller | 3 | 146162 | 253 | 6.720 | 21750.3 |
957 | 2023-02-25 08:52:25 | reseller | 3 | 146162 | 253 | 7.563 | 19325.9 |
956 | 2023-01-20 10:14:56 | reseller | 1 | 82945 | 4 | 1.296 | 64000.8 |
955 | 2022-12-06 22:15:17 | reseller | 1 | 82945 | 4 | 1.453 | 57085.3 |
954 | 2022-11-16 13:31:15 | reseller | 1 | 82945 | 4 | 1.406 | 58993.6 |
953 | 2022-09-10 19:51:16 | reseller | 1 | 82945 | 4 | 1.313 | 63172.1 |
952 | 2022-08-31 17:28:34 | reseller | 1 | 82945 | 4 | 1.420 | 58412.0 |
951 | 2022-08-03 08:46:31 | reseller | 1 | 82945 | 4 | 1.593 | 52068.4 |
950 | 2022-07-10 05:35:23 | reseller | 1 | 82945 | 4 | 2.623 | 31622.2 |
949 | 2022-07-08 00:46:59 | reseller | 1 | 82945 | 4 | 1.313 | 63172.1 |
948 | 2022-07-02 07:18:56 | reseller | 1 | 82945 | 4 | 1.296 | 64000.8 |
947 | 2022-04-05 09:33:52 | reseller | 1 | 82945 | 4 | 1.733 | 47862.1 |
946 | 2022-04-01 22:26:33 | reseller | 1 | 82945 | 4 | 1.313 | 63172.1 |
945 | 2022-03-12 18:21:00 | reseller | 1 | 82945 | 4 | 1.533 | 54106.3 |
944 | 2021-12-23 06:16:18 | reseller | 3 | 146162 | 253 | 13.376 | 10927.2 |
943 | 2021-12-23 03:15:46 | reseller | 1 | 82945 | 4 | 1.513 | 54821.5 |
942 | 2021-12-16 19:12:31 | reseller | 1 | 82945 | 4 | 1.486 | 55817.6 |
941 | 2021-12-15 02:29:37 | reseller | 1 | 82945 | 4 | 1.436 | 57761.1 |
940 | 2021-11-26 06:54:48 | reseller | 3 | 146162 | 253 | 6.780 | 21557.8 |
939 | 2021-10-31 23:29:29 | reseller | 3 | 146162 | 253 | 6.470 | 22590.7 |
938 | 2021-10-31 07:00:13 | reseller | 3 | 146162 | 253 | 6.970 | 20970.2 |
937 | 2021-10-28 00:16:44 | reseller | 1 | 82945 | 4 | 1.373 | 60411.5 |
936 | 2021-10-26 13:37:20 | reseller | 3 | 146162 | 253 | 6.500 | 22486.5 |
935 | 2021-10-25 19:37:08 | reseller | 3 | 146162 | 253 | 7.533 | 19402.9 |
934 | 2021-10-25 02:01:57 | reseller | 3 | 146162 | 253 | 7.703 | 18974.7 |
933 | 2021-10-24 19:23:47 | reseller | 3 | 146162 | 253 | 8.216 | 17789.9 |
932 | 2021-10-24 07:33:59 | reseller | 3 | 146162 | 253 | 6.533 | 22372.9 |
931 | 2021-10-23 20:38:49 | reseller | 3 | 146162 | 253 | 7.080 | 20644.4 |
930 | 2021-10-23 13:03:36 | reseller | 3 | 146162 | 253 | 8.736 | 16731.0 |
929 | 2021-10-23 02:01:01 | reseller | 3 | 146162 | 253 | 7.873 | 18565.0 |
928 | 2021-10-22 19:17:49 | reseller | 3 | 146162 | 253 | 7.236 | 20199.3 |
927 | 2021-10-13 19:23:09 | reseller | 3 | 146162 | 253 | 7.660 | 19081.2 |
926 | 2021-10-10 00:04:28 | reseller | 3 | 146162 | 253 | 8.486 | 17223.9 |
925 | 2021-10-09 11:58:22 | reseller | 3 | 146162 | 253 | 8.313 | 17582.3 |
924 | 2021-10-08 23:34:17 | reseller | 3 | 146162 | 253 | 7.656 | 19091.2 |
923 | 2021-10-08 14:15:10 | reseller | 3 | 146162 | 253 | 13.050 | 11200.2 |
922 | 2021-10-08 03:20:46 | reseller | 3 | 146162 | 253 | 6.796 | 21507.1 |
921 | 2021-10-07 16:41:20 | reseller | 3 | 146162 | 253 | 8.063 | 18127.5 |
920 | 2021-10-07 04:55:00 | reseller | 3 | 146162 | 253 | 6.580 | 22213.1 |
919 | 2021-10-06 18:59:23 | reseller | 3 | 146162 | 253 | 14.313 | 10211.8 |
918 | 2021-10-06 07:35:36 | reseller | 3 | 146162 | 253 | 6.876 | 21256.8 |
917 | 2021-10-05 22:17:00 | reseller | 3 | 146162 | 253 | 7.393 | 19770.3 |
916 | 2021-10-05 10:14:46 | reseller | 3 | 146162 | 253 | 7.250 | 20160.3 |
915 | 2021-10-04 13:17:51 | reseller | 3 | 146162 | 253 | 8.093 | 18060.3 |
914 | 2021-10-04 00:42:51 | reseller | 3 | 146162 | 253 | 12.236 | 11945.2 |
913 | 2021-10-03 13:11:35 | reseller | 3 | 146162 | 253 | 10.016 | 14592.9 |
912 | 2021-10-03 06:26:04 | reseller | 1 | 82945 | 4 | 1.466 | 56579.1 |
911 | 2021-10-03 00:29:48 | reseller | 3 | 146162 | 253 | 7.406 | 19735.6 |
910 | 2021-10-02 12:28:54 | reseller | 3 | 146162 | 253 | 7.390 | 19778.3 |
909 | 2021-09-18 23:31:04 | reseller | 3 | 146162 | 253 | 7.326 | 19951.1 |
908 | 2021-09-17 22:39:40 | reseller | 3 | 146162 | 253 | 7.763 | 18828.0 |
907 | 2021-09-17 00:38:04 | reseller | 3 | 146162 | 253 | 6.720 | 21750.3 |