History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"town"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1143 | 2025-05-21 14:59:43 | town | 2 | 29872 | 239 | 4.703 | 6351.7 |
1142 | 2025-05-20 13:47:12 | town | 1 | 13983 | 15 | 1.390 | 10059.7 |
1141 | 2025-05-16 04:57:09 | town | 1 | 13983 | 15 | 1.376 | 10162.1 |
1140 | 2025-05-14 07:44:12 | town | 1 | 13983 | 15 | 1.546 | 9044.6 |
1139 | 2025-05-10 13:52:31 | town | 2 | 29872 | 239 | 4.703 | 6351.7 |
1138 | 2025-05-10 08:59:38 | town | 1 | 13983 | 15 | 1.236 | 11313.1 |
1137 | 2025-05-09 10:07:09 | town | 2 | 29872 | 239 | 0.906 | 32971.3 |
1136 | 2025-05-09 00:04:26 | town | 1 | 13983 | 15 | 0.266 | 52567.7 |
1135 | 2025-05-07 23:49:51 | town | 1 | 13983 | 15 | 0.983 | 14224.8 |
1134 | 2025-05-03 18:15:30 | town | 1 | 13983 | 15 | 0.236 | 59250.0 |
1133 | 2025-05-03 03:06:20 | town | 1 | 13983 | 15 | 0.986 | 14181.5 |
1132 | 2025-05-02 13:34:37 | town | 2 | 29872 | 239 | 4.296 | 6953.4 |
1131 | 2025-05-02 07:31:28 | town | 2 | 29872 | 239 | 3.110 | 9605.1 |
1130 | 2025-05-02 01:47:17 | town | 1 | 13983 | 15 | 1.656 | 8443.8 |
1129 | 2025-05-02 00:54:54 | town | 2 | 29872 | 239 | 3.453 | 8651.0 |
1128 | 2025-05-01 01:10:42 | town | 2 | 29872 | 239 | 4.343 | 6878.2 |
1127 | 2025-04-30 16:37:02 | town | 1 | 13983 | 15 | 1.390 | 10059.7 |
1126 | 2025-04-27 22:42:42 | town | 1 | 13983 | 15 | 0.966 | 14475.2 |
1125 | 2025-04-27 11:31:39 | town | 1 | 13983 | 15 | 0.216 | 64736.1 |
1124 | 2025-04-21 04:05:50 | town | 1 | 13983 | 15 | 0.936 | 14939.1 |
1123 | 2025-04-18 13:30:46 | town | 1 | 13983 | 15 | 0.500 | 27966.0 |
1122 | 2025-04-18 13:11:58 | town | 1 | 13983 | 15 | 0.690 | 20265.2 |
1121 | 2025-04-16 19:01:17 | town | 1 | 13983 | 15 | 0.250 | 55932.0 |
1120 | 2025-04-14 16:54:53 | town | 1 | 13983 | 15 | 1.423 | 9826.4 |
1119 | 2025-04-08 08:08:19 | town | 1 | 13983 | 15 | 2.000 | 6991.5 |
1118 | 2025-04-08 01:47:10 | town | 1 | 13983 | 15 | 1.703 | 8210.8 |
1117 | 2025-04-03 04:27:14 | town | 1 | 13983 | 15 | 0.843 | 16587.2 |
1116 | 2025-04-02 20:58:33 | town | 1 | 13983 | 15 | 0.500 | 27966.0 |
1115 | 2025-04-01 02:44:45 | town | 1 | 13983 | 15 | 0.703 | 19890.5 |
1114 | 2025-03-29 19:08:30 | town | 1 | 13983 | 15 | 1.686 | 8293.6 |
1113 | 2025-03-27 14:42:01 | town | 2 | 29872 | 239 | 2.706 | 11039.2 |
1112 | 2025-03-27 10:32:20 | town | 1 | 13983 | 15 | 1.076 | 12995.4 |
1111 | 2025-03-26 23:43:29 | town | 1 | 13983 | 15 | 1.063 | 13154.3 |
1110 | 2025-03-26 15:35:48 | town | 1 | 13983 | 15 | 0.250 | 55932.0 |
1109 | 2025-03-25 06:26:05 | town | 1 | 13983 | 15 | 0.670 | 20870.1 |
1108 | 2025-03-24 01:53:06 | town | 1 | 13983 | 15 | 0.936 | 14939.1 |
1107 | 2025-03-23 05:12:54 | town | 1 | 13983 | 15 | 0.733 | 19076.4 |
1106 | 2025-03-20 23:15:35 | town | 2 | 29872 | 239 | 4.360 | 6851.4 |
1105 | 2025-03-19 09:09:48 | town | 2 | 29872 | 239 | 0.923 | 32364.0 |
1104 | 2025-03-18 18:30:07 | town | 1 | 13983 | 15 | 0.220 | 63559.1 |
1103 | 2025-03-18 15:49:00 | town | 1 | 13983 | 15 | 0.266 | 52567.7 |
1102 | 2025-03-18 02:23:08 | town | 1 | 13983 | 15 | 1.686 | 8293.6 |
1101 | 2025-03-16 23:18:02 | town | 1 | 13983 | 15 | 1.330 | 10513.5 |
1100 | 2025-03-15 02:08:56 | town | 1 | 13983 | 15 | 0.703 | 19890.5 |
1099 | 2025-03-14 22:30:10 | town | 1 | 13983 | 15 | 0.860 | 16259.3 |
1098 | 2025-03-14 21:03:31 | town | 1 | 13983 | 15 | 0.516 | 27098.8 |
1097 | 2025-03-11 22:40:10 | town | 1 | 13983 | 15 | 0.906 | 15433.8 |
1096 | 2025-03-06 23:18:34 | town | 2 | 29872 | 239 | 6.533 | 4572.5 |
1095 | 2025-03-06 23:00:35 | town | 1 | 13983 | 15 | 1.283 | 10898.7 |
1094 | 2025-03-06 18:28:49 | town | 2 | 29872 | 239 | 6.470 | 4617.0 |
1093 | 2025-03-06 17:47:43 | town | 1 | 13983 | 15 | 0.716 | 19529.3 |
1092 | 2025-02-26 00:23:07 | town | 1 | 13983 | 15 | 0.796 | 17566.6 |
1091 | 2025-02-25 08:46:52 | town | 1 | 13983 | 15 | 0.233 | 60012.9 |
1090 | 2025-02-24 19:27:55 | town | 1 | 13983 | 15 | 1.626 | 8599.6 |
1089 | 2025-02-20 21:57:21 | town | 1 | 13983 | 15 | 0.920 | 15198.9 |
1088 | 2025-02-19 04:32:40 | town | 1 | 13983 | 15 | 0.310 | 45106.5 |
1087 | 2025-02-07 23:02:14 | town | 2 | 29872 | 239 | 5.343 | 5590.9 |
1086 | 2025-02-04 23:40:55 | town | 2 | 29872 | 239 | 2.453 | 12177.7 |
1085 | 2025-02-04 15:17:09 | town | 2 | 29872 | 239 | 3.923 | 7614.6 |
1084 | 2025-02-04 15:14:37 | town | 1 | 13983 | 15 | 1.813 | 7712.6 |
1083 | 2025-01-26 19:42:04 | town | 2 | 29872 | 239 | 2.216 | 13480.1 |
1082 | 2025-01-26 19:25:15 | town | 1 | 13983 | 15 | 0.236 | 59250.0 |
1081 | 2025-01-26 07:30:12 | town | 1 | 13983 | 15 | 0.686 | 20383.4 |
1080 | 2025-01-25 09:18:29 | town | 1 | 13983 | 15 | 0.580 | 24108.6 |
1079 | 2025-01-05 11:35:58 | town | 2 | 29872 | 239 | 0.923 | 32364.0 |
1078 | 2025-01-05 11:35:52 | town | 1 | 13983 | 15 | 0.220 | 63559.1 |
1077 | 2024-12-27 14:37:00 | town | 1 | 13983 | 15 | 0.203 | 68881.8 |
1076 | 2024-12-27 06:10:29 | town | 1 | 13983 | 15 | 0.220 | 63559.1 |
1075 | 2024-12-21 20:04:14 | town | 1 | 13983 | 15 | 1.766 | 7917.9 |
1074 | 2024-12-09 20:54:08 | town | 1 | 13983 | 15 | 0.263 | 53167.3 |
1073 | 2024-12-06 09:41:11 | town | 2 | 29872 | 239 | 4.360 | 6851.4 |
1072 | 2024-12-06 09:06:36 | town | 1 | 13983 | 15 | 0.546 | 25609.9 |
1071 | 2024-11-27 05:55:59 | town | 2 | 29872 | 239 | 6.263 | 4769.6 |
1070 | 2024-11-27 04:08:44 | town | 2 | 29872 | 239 | 3.186 | 9376.0 |
1069 | 2024-11-27 03:37:36 | town | 1 | 13983 | 15 | 1.093 | 12793.2 |
1068 | 2024-11-27 03:05:49 | town | 1 | 13983 | 15 | 0.716 | 19529.3 |
1067 | 2024-11-26 05:48:44 | town | 1 | 13983 | 15 | 0.296 | 47239.9 |
1066 | 2024-11-06 07:31:00 | town | 1 | 13983 | 15 | 0.206 | 67878.6 |
1065 | 2024-10-28 08:15:32 | town | 2 | 29872 | 239 | 4.503 | 6633.8 |
1064 | 2024-10-28 03:03:44 | town | 2 | 29872 | 239 | 6.170 | 4841.5 |
1063 | 2024-10-28 02:48:56 | town | 1 | 13983 | 15 | 0.233 | 60012.9 |
1062 | 2024-10-27 23:54:07 | town | 1 | 13983 | 15 | 0.780 | 17926.9 |
1061 | 2024-10-27 06:57:15 | town | 1 | 13983 | 15 | 1.390 | 10059.7 |
1060 | 2024-10-23 01:39:26 | town | 1 | 13983 | 15 | 0.280 | 49939.3 |
1059 | 2024-10-21 15:47:15 | town | 1 | 13983 | 15 | 1.343 | 10411.8 |
1058 | 2024-10-15 17:58:04 | town | 1 | 13983 | 15 | 0.720 | 19420.8 |
1057 | 2024-10-10 17:08:36 | town | 1 | 13983 | 15 | 1.310 | 10674.0 |
1056 | 2024-10-09 12:25:51 | town | 1 | 13983 | 15 | 0.376 | 37188.8 |
1055 | 2024-10-07 09:15:34 | town | 2 | 29872 | 239 | 7.736 | 3861.4 |
1054 | 2024-10-07 09:12:49 | town | 1 | 13983 | 15 | 1.640 | 8526.2 |
1053 | 2024-10-01 15:19:00 | town | 1 | 13983 | 15 | 1.750 | 7990.3 |
1052 | 2024-09-28 07:12:29 | town | 2 | 29872 | 239 | 10.813 | 2762.6 |
1051 | 2024-09-28 02:21:45 | town | 2 | 29872 | 239 | 6.720 | 4445.2 |
1050 | 2024-09-27 23:49:11 | town | 1 | 13983 | 15 | 0.266 | 52567.7 |
1049 | 2024-09-27 16:20:29 | town | 1 | 13983 | 15 | 0.220 | 63559.1 |
1048 | 2024-09-27 02:50:57 | town | 1 | 13983 | 15 | 0.250 | 55932.0 |
1047 | 2024-09-06 23:10:27 | town | 1 | 13983 | 15 | 1.766 | 7917.9 |
1046 | 2024-09-02 11:12:11 | town | 1 | 13983 | 15 | 3.300 | 4237.3 |
1045 | 2024-08-30 04:23:32 | town | 1 | 13983 | 15 | 0.376 | 37188.8 |
1044 | 2024-08-29 10:41:14 | town | 2 | 29872 | 239 | 0.906 | 32971.3 |