History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"towny"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1029 | 2024-04-29 05:37:57 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
1028 | 2024-04-03 06:03:42 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
1027 | 2024-04-02 05:43:47 | towny | 3 | 83667 | 1083 | 3.313 | 25254.2 |
1026 | 2024-03-31 15:52:28 | towny | 2 | 53800 | 80 | 1.656 | 32487.9 |
1025 | 2024-03-31 07:01:24 | towny | 1 | 28756 | 7 | 0.580 | 49579.3 |
1024 | 2024-03-30 19:50:56 | towny | 2 | 53800 | 80 | 3.763 | 14297.1 |
1023 | 2024-03-30 04:16:02 | towny | 2 | 53800 | 80 | 5.733 | 9384.3 |
1022 | 2024-03-30 01:25:32 | towny | 3 | 83667 | 1083 | 8.860 | 9443.2 |
1021 | 2024-03-29 08:32:24 | towny | 3 | 83667 | 1083 | 11.610 | 7206.5 |
1020 | 2024-03-29 08:32:24 | towny | 2 | 53800 | 80 | 2.873 | 18726.1 |
1019 | 2024-03-29 08:16:06 | towny | 1 | 28756 | 7 | 0.530 | 54256.6 |
1018 | 2024-03-19 06:01:28 | towny | 3 | 83667 | 1083 | 9.516 | 8792.2 |
1017 | 2024-03-18 12:43:59 | towny | 3 | 83667 | 1083 | 12.983 | 6444.4 |
1016 | 2024-03-09 10:04:14 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
1015 | 2024-03-06 12:16:59 | towny | 3 | 83667 | 1083 | 9.440 | 8863.0 |
1014 | 2024-03-06 11:56:38 | towny | 3 | 83667 | 1083 | 11.440 | 7313.5 |
1013 | 2024-03-06 06:44:07 | towny | 3 | 83667 | 1083 | 9.580 | 8733.5 |
1012 | 2024-03-04 00:05:19 | towny | 1 | 28756 | 7 | 1.063 | 27051.7 |
1011 | 2024-02-28 02:26:31 | towny | 1 | 28756 | 7 | 0.983 | 29253.3 |
1010 | 2024-02-02 22:46:11 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
1009 | 2024-01-28 21:56:13 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
1008 | 2024-01-28 05:40:09 | towny | 3 | 83667 | 1083 | 3.796 | 22040.8 |
1007 | 2023-12-31 16:03:39 | towny | 3 | 83667 | 1083 | 3.593 | 23286.1 |
1006 | 2023-12-31 16:03:35 | towny | 2 | 53800 | 80 | 1.606 | 33499.4 |
1005 | 2023-12-13 00:31:29 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
1004 | 2023-12-08 11:39:30 | towny | 2 | 53800 | 80 | 1.640 | 32804.9 |
1003 | 2023-12-06 16:19:45 | towny | 3 | 83667 | 1083 | 3.733 | 22412.8 |
1002 | 2023-12-05 21:27:20 | towny | 3 | 83667 | 1083 | 3.830 | 21845.2 |
1001 | 2023-11-14 08:54:17 | towny | 1 | 28756 | 7 | 0.563 | 51076.4 |
1000 | 2023-11-10 17:51:56 | towny | 1 | 28756 | 7 | 0.450 | 63902.2 |
999 | 2023-11-04 02:29:27 | towny | 1 | 28756 | 7 | 0.546 | 52666.7 |
998 | 2023-11-02 07:44:31 | towny | 1 | 28756 | 7 | 0.516 | 55728.7 |
997 | 2023-10-22 18:50:19 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
996 | 2023-10-19 21:53:21 | towny | 1 | 28756 | 7 | 0.436 | 65954.1 |
995 | 2023-10-14 09:31:02 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
994 | 2023-10-13 00:02:41 | towny | 3 | 83667 | 1083 | 3.250 | 25743.7 |
993 | 2023-10-07 00:48:01 | towny | 1 | 28756 | 7 | 0.436 | 65954.1 |
992 | 2023-09-29 03:52:17 | towny | 1 | 28756 | 7 | 0.470 | 61183.0 |
991 | 2023-09-28 15:32:09 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
990 | 2023-09-22 10:15:09 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
989 | 2023-09-13 18:04:14 | towny | 3 | 83667 | 1083 | 4.013 | 20849.0 |
988 | 2023-09-03 09:34:51 | towny | 3 | 83667 | 1083 | 3.703 | 22594.4 |
987 | 2023-08-11 02:55:39 | towny | 3 | 83667 | 1083 | 3.373 | 24804.9 |
986 | 2023-07-25 06:17:39 | towny | 1 | 28756 | 7 | 0.436 | 65954.1 |
985 | 2023-04-24 21:01:04 | towny | 1 | 28756 | 7 | 0.516 | 55728.7 |
984 | 2023-02-14 12:35:48 | towny | 3 | 83667 | 1083 | 3.690 | 22674.0 |
983 | 2023-02-13 01:36:19 | towny | 1 | 28756 | 7 | 0.436 | 65954.1 |
982 | 2023-02-06 22:57:13 | towny | 3 | 83667 | 1083 | 4.033 | 20745.6 |
981 | 2022-12-21 13:51:54 | towny | 3 | 83667 | 1083 | 3.203 | 26121.4 |
980 | 2022-12-19 04:47:17 | towny | 3 | 83667 | 1083 | 3.423 | 24442.6 |
979 | 2022-12-12 22:10:21 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
978 | 2022-11-22 06:17:29 | towny | 3 | 83667 | 1083 | 3.796 | 22040.8 |
977 | 2022-11-09 13:51:28 | towny | 3 | 83667 | 1083 | 3.483 | 24021.5 |
976 | 2022-11-05 12:42:50 | towny | 3 | 83667 | 1083 | 3.780 | 22134.1 |
975 | 2022-11-04 14:16:27 | towny | 3 | 83667 | 1083 | 3.300 | 25353.6 |
974 | 2022-11-04 00:26:02 | towny | 3 | 83667 | 1083 | 3.280 | 25508.2 |
973 | 2022-09-20 20:57:35 | towny | 3 | 83667 | 1083 | 3.313 | 25254.2 |
972 | 2022-09-14 23:53:31 | towny | 3 | 83667 | 1083 | 3.376 | 24782.9 |
971 | 2022-09-07 15:36:18 | towny | 3 | 83667 | 1083 | 3.283 | 25484.9 |
970 | 2022-09-01 01:11:43 | towny | 3 | 83667 | 1083 | 3.390 | 24680.5 |
969 | 2022-08-30 09:54:20 | towny | 3 | 83667 | 1083 | 3.313 | 25254.2 |
968 | 2022-08-17 23:37:48 | towny | 1 | 28756 | 7 | 0.436 | 65954.1 |
967 | 2022-08-15 13:43:06 | towny | 1 | 28756 | 7 | 0.453 | 63479.0 |
966 | 2022-08-09 05:30:58 | towny | 3 | 83667 | 1083 | 3.296 | 25384.4 |
965 | 2022-08-06 21:33:26 | towny | 3 | 83667 | 1083 | 3.343 | 25027.5 |
964 | 2022-05-22 21:27:09 | towny | 3 | 83667 | 1083 | 3.250 | 25743.7 |
963 | 2022-04-27 23:43:03 | towny | 3 | 83667 | 1083 | 3.796 | 22040.8 |
962 | 2022-04-18 19:49:30 | towny | 1 | 28756 | 7 | 0.640 | 44931.3 |
961 | 2022-04-14 05:16:39 | towny | 3 | 83667 | 1083 | 3.750 | 22311.2 |
960 | 2022-04-05 00:28:10 | towny | 3 | 83667 | 1083 | 4.826 | 17336.7 |
959 | 2022-03-25 21:56:16 | towny | 3 | 83667 | 1083 | 3.330 | 25125.2 |
958 | 2022-03-20 07:49:44 | towny | 3 | 83667 | 1083 | 3.376 | 24782.9 |
957 | 2022-03-08 02:22:05 | towny | 3 | 83667 | 1083 | 3.783 | 22116.6 |
956 | 2022-02-13 21:24:09 | towny | 3 | 83667 | 1083 | 3.436 | 24350.1 |
955 | 2022-01-27 22:39:28 | towny | 1 | 28756 | 7 | 0.500 | 57512.0 |
954 | 2022-01-03 21:26:50 | towny | 1 | 28756 | 7 | 0.546 | 52666.7 |
953 | 2022-01-01 16:29:32 | towny | 1 | 28756 | 7 | 0.516 | 55728.7 |
952 | 2021-12-29 12:09:08 | towny | 3 | 83667 | 1083 | 4.156 | 20131.6 |
951 | 2021-12-12 08:31:16 | towny | 1 | 28756 | 7 | 0.513 | 56054.6 |
950 | 2021-12-09 12:49:44 | towny | 3 | 83667 | 1083 | 3.796 | 22040.8 |
949 | 2021-12-08 13:32:05 | towny | 3 | 83667 | 1083 | 3.876 | 21585.9 |
948 | 2021-12-08 12:45:35 | towny | 3 | 83667 | 1083 | 4.513 | 18539.1 |
947 | 2021-12-07 12:37:22 | towny | 3 | 83667 | 1083 | 3.360 | 24900.9 |
946 | 2021-12-06 12:41:07 | towny | 3 | 83667 | 1083 | 3.763 | 22234.1 |
945 | 2021-12-05 07:55:56 | towny | 3 | 83667 | 1083 | 4.000 | 20916.8 |
944 | 2021-12-04 00:26:14 | towny | 3 | 83667 | 1083 | 3.266 | 25617.6 |
943 | 2021-12-01 19:54:24 | towny | 3 | 83667 | 1083 | 3.906 | 21420.1 |
942 | 2021-11-29 17:57:11 | towny | 3 | 83667 | 1083 | 3.483 | 24021.5 |
941 | 2021-11-20 07:57:35 | towny | 3 | 83667 | 1083 | 3.326 | 25155.4 |
940 | 2021-11-19 12:26:57 | towny | 3 | 83667 | 1083 | 6.813 | 12280.5 |
939 | 2021-11-18 12:24:44 | towny | 3 | 83667 | 1083 | 3.860 | 21675.4 |
938 | 2021-11-17 12:39:43 | towny | 3 | 83667 | 1083 | 8.656 | 9665.8 |
937 | 2021-11-15 12:15:06 | towny | 3 | 83667 | 1083 | 3.406 | 24564.6 |
936 | 2021-11-14 08:51:16 | towny | 3 | 83667 | 1083 | 4.313 | 19398.8 |
935 | 2021-11-13 08:48:04 | towny | 3 | 83667 | 1083 | 4.063 | 20592.4 |
934 | 2021-11-12 08:44:27 | towny | 3 | 83667 | 1083 | 4.016 | 20833.4 |
933 | 2021-11-07 21:07:49 | towny | 3 | 83667 | 1083 | 3.593 | 23286.1 |
932 | 2021-11-07 09:12:00 | towny | 3 | 83667 | 1083 | 3.936 | 21256.9 |
931 | 2021-11-06 22:09:48 | towny | 3 | 83667 | 1083 | 3.860 | 21675.4 |
930 | 2021-11-06 10:01:35 | towny | 3 | 83667 | 1083 | 3.450 | 24251.3 |