History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subcounty"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
263 | 2025-10-02 01:55:57 | subcounty | 1 | 81242 | 1 | 1.360 | 59736.8 |
262 | 2025-09-27 21:56:56 | subcounty | 1 | 81242 | 1 | 1.390 | 58447.5 |
261 | 2025-09-08 22:07:16 | subcounty | 1 | 81242 | 1 | 1.296 | 62686.7 |
260 | 2025-08-29 11:29:04 | subcounty | 1 | 81242 | 1 | 1.313 | 61875.1 |
259 | 2025-08-27 21:51:19 | subcounty | 1 | 81242 | 1 | 1.470 | 55266.7 |
258 | 2025-08-09 23:05:51 | subcounty | 1 | 81242 | 1 | 4.203 | 19329.5 |
257 | 2025-08-01 15:09:39 | subcounty | 1 | 81242 | 1 | 7.676 | 10583.9 |
256 | 2025-07-25 09:56:58 | subcounty | 1 | 81242 | 1 | 7.390 | 10993.5 |
255 | 2025-07-24 21:27:00 | subcounty | 1 | 81242 | 1 | 6.470 | 12556.7 |
254 | 2025-07-24 17:57:05 | subcounty | 1 | 81242 | 1 | 4.516 | 17989.8 |
253 | 2025-07-22 01:39:00 | subcounty | 1 | 81242 | 1 | 1.470 | 55266.7 |
252 | 2025-07-16 05:24:44 | subcounty | 1 | 81242 | 1 | 5.233 | 15524.9 |
251 | 2025-06-04 13:15:51 | subcounty | 1 | 81242 | 1 | 6.953 | 11684.5 |
250 | 2025-05-24 00:35:47 | subcounty | 2 | 121436 | 1 | 11.003 | 11036.6 |
249 | 2025-05-03 09:40:19 | subcounty | 1 | 81242 | 1 | 1.373 | 59171.2 |
248 | 2025-04-30 06:53:26 | subcounty | 1 | 81242 | 1 | 5.656 | 14363.9 |
247 | 2025-04-29 21:18:43 | subcounty | 1 | 81242 | 1 | 3.423 | 23734.2 |
246 | 2025-03-31 12:09:38 | subcounty | 1 | 81242 | 1 | 6.173 | 13160.9 |
245 | 2025-03-26 16:27:46 | subcounty | 1 | 81242 | 1 | 9.436 | 8609.8 |
244 | 2025-03-25 06:18:13 | subcounty | 3 | 148641 | 16 | 35.890 | 4141.6 |
243 | 2025-03-22 20:42:28 | subcounty | 4 | 165329 | 130 | 51.816 | 3190.7 |
242 | 2025-03-21 03:48:54 | subcounty | 4 | 165329 | 130 | 76.140 | 2171.4 |
241 | 2025-03-16 15:36:41 | subcounty | 4 | 165329 | 130 | 63.440 | 2606.1 |
240 | 2025-03-11 23:35:00 | subcounty | 3 | 148641 | 16 | 27.580 | 5389.4 |
239 | 2025-03-10 21:27:52 | subcounty | 4 | 165329 | 130 | 76.813 | 2152.4 |
238 | 2025-03-10 21:27:51 | subcounty | 3 | 148641 | 16 | 47.063 | 3158.3 |
237 | 2025-03-10 21:27:46 | subcounty | 2 | 121436 | 1 | 15.576 | 7796.4 |
236 | 2025-03-10 20:34:09 | subcounty | 1 | 81242 | 1 | 1.516 | 53589.7 |
235 | 2025-03-08 02:03:57 | subcounty | 1 | 81242 | 1 | 9.063 | 8964.1 |
234 | 2025-03-07 16:44:09 | subcounty | 3 | 148641 | 16 | 28.203 | 5270.4 |
233 | 2025-03-03 04:06:28 | subcounty | 1 | 81242 | 1 | 6.470 | 12556.7 |
232 | 2025-02-13 20:09:36 | subcounty | 3 | 148641 | 16 | 32.720 | 4542.8 |
231 | 2025-02-13 20:09:38 | subcounty | 3 | 148641 | 16 | 29.483 | 5041.6 |
230 | 2025-02-13 01:19:28 | subcounty | 3 | 148641 | 16 | 37.016 | 4015.6 |
229 | 2025-02-13 01:19:27 | subcounty | 3 | 148641 | 16 | 33.533 | 4432.7 |
228 | 2025-02-13 01:19:25 | subcounty | 2 | 121436 | 1 | 24.626 | 4931.2 |
227 | 2025-02-12 13:28:14 | subcounty | 1 | 81242 | 1 | 1.406 | 57782.4 |
226 | 2025-01-31 18:31:24 | subcounty | 1 | 81242 | 1 | 7.283 | 11155.0 |
225 | 2025-01-30 21:40:26 | subcounty | 3 | 148641 | 16 | 33.156 | 4483.1 |
224 | 2025-01-29 08:23:52 | subcounty | 3 | 148641 | 16 | 36.030 | 4125.5 |
223 | 2025-01-21 14:05:52 | subcounty | 1 | 81242 | 1 | 10.720 | 7578.5 |
222 | 2025-01-20 22:54:33 | subcounty | 3 | 148641 | 16 | 34.093 | 4359.9 |
221 | 2025-01-13 17:21:42 | subcounty | 3 | 148641 | 16 | 34.733 | 4279.5 |
220 | 2025-01-12 02:11:27 | subcounty | 3 | 148641 | 16 | 28.033 | 5302.4 |
219 | 2025-01-12 02:11:32 | subcounty | 2 | 121436 | 1 | 17.563 | 6914.3 |
218 | 2025-01-12 02:10:31 | subcounty | 1 | 81242 | 1 | 7.513 | 10813.5 |
217 | 2025-01-10 14:30:24 | subcounty | 4 | 165329 | 130 | 67.716 | 2441.5 |
216 | 2025-01-01 12:16:41 | subcounty | 4 | 165329 | 130 | 79.503 | 2079.5 |
215 | 2024-12-27 02:41:21 | subcounty | 1 | 81242 | 1 | 1.296 | 62686.7 |
214 | 2024-12-14 06:53:55 | subcounty | 1 | 81242 | 1 | 6.546 | 12410.9 |
213 | 2024-12-14 03:44:42 | subcounty | 4 | 165329 | 130 | 32.326 | 5114.4 |
212 | 2024-12-13 21:11:12 | subcounty | 4 | 165329 | 130 | 61.453 | 2690.3 |
211 | 2024-12-11 11:58:29 | subcounty | 4 | 165329 | 130 | 73.176 | 2259.3 |
210 | 2024-11-29 19:54:44 | subcounty | 4 | 165329 | 130 | 63.080 | 2620.9 |
209 | 2024-11-26 18:26:20 | subcounty | 1 | 81242 | 1 | 1.266 | 64172.2 |
208 | 2024-11-16 00:22:09 | subcounty | 1 | 81242 | 1 | 7.420 | 10949.1 |
207 | 2024-11-09 20:00:30 | subcounty | 4 | 165329 | 130 | 61.490 | 2688.7 |
206 | 2024-11-09 14:03:24 | subcounty | 4 | 165329 | 130 | 75.163 | 2199.6 |
205 | 2024-11-03 20:09:26 | subcounty | 3 | 148641 | 16 | 23.156 | 6419.1 |
204 | 2024-10-30 06:15:43 | subcounty | 3 | 148641 | 16 | 48.910 | 3039.1 |
203 | 2024-10-30 06:15:44 | subcounty | 3 | 148641 | 16 | 36.063 | 4121.7 |
202 | 2024-10-09 08:30:15 | subcounty | 2 | 121436 | 1 | 13.936 | 8713.8 |
201 | 2024-10-09 08:28:53 | subcounty | 1 | 81242 | 1 | 7.203 | 11278.9 |
200 | 2024-10-09 06:56:01 | subcounty | 1 | 81242 | 1 | 3.873 | 20976.5 |
199 | 2024-10-07 16:13:10 | subcounty | 3 | 148641 | 16 | 57.676 | 2577.2 |
198 | 2024-09-29 10:06:43 | subcounty | 3 | 148641 | 16 | 75.833 | 1960.1 |
197 | 2024-09-29 10:06:44 | subcounty | 3 | 148641 | 16 | 45.300 | 3281.3 |
196 | 2024-09-27 19:15:31 | subcounty | 3 | 148641 | 16 | 52.626 | 2824.5 |
195 | 2024-09-25 21:41:57 | subcounty | 4 | 165329 | 130 | 117.976 | 1401.4 |
194 | 2024-09-25 21:42:01 | subcounty | 3 | 148641 | 16 | 77.353 | 1921.6 |
193 | 2024-09-25 21:42:05 | subcounty | 2 | 121436 | 1 | 13.766 | 8821.4 |
192 | 2024-09-25 21:35:38 | subcounty | 1 | 81242 | 1 | 4.703 | 17274.5 |
191 | 2024-09-20 06:12:58 | subcounty | 2 | 121436 | 1 | 39.320 | 3088.4 |
190 | 2024-09-20 06:12:53 | subcounty | 3 | 148641 | 16 | 27.616 | 5382.4 |
189 | 2024-09-20 06:12:32 | subcounty | 1 | 81242 | 1 | 7.153 | 11357.8 |
188 | 2024-08-27 20:46:32 | subcounty | 3 | 148641 | 16 | 76.840 | 1934.4 |
187 | 2024-08-27 14:01:57 | subcounty | 1 | 81242 | 1 | 1.266 | 64172.2 |
186 | 2024-08-26 01:22:38 | subcounty | 2 | 121436 | 1 | 19.720 | 6158.0 |
185 | 2024-08-26 01:20:54 | subcounty | 3 | 148641 | 16 | 28.190 | 5272.8 |
184 | 2024-08-26 01:19:59 | subcounty | 1 | 81242 | 1 | 4.766 | 17046.2 |
183 | 2024-08-16 11:05:03 | subcounty | 3 | 148641 | 16 | 47.126 | 3154.1 |
182 | 2024-08-15 15:42:00 | subcounty | 1 | 81242 | 1 | 10.000 | 8124.2 |
181 | 2024-08-11 04:31:30 | subcounty | 3 | 148641 | 16 | 40.833 | 3640.2 |
180 | 2024-08-02 18:56:55 | subcounty | 1 | 81242 | 1 | 7.093 | 11453.8 |
179 | 2024-07-28 10:35:28 | subcounty | 3 | 148641 | 16 | 33.206 | 4476.3 |
178 | 2024-07-26 22:10:42 | subcounty | 3 | 148641 | 16 | 25.516 | 5825.4 |
177 | 2024-07-26 14:09:03 | subcounty | 3 | 148641 | 16 | 32.300 | 4601.9 |
176 | 2024-07-25 22:22:13 | subcounty | 3 | 148641 | 16 | 16.483 | 9017.8 |
175 | 2024-07-25 22:22:13 | subcounty | 2 | 121436 | 1 | 13.000 | 9341.2 |
174 | 2024-07-25 22:21:11 | subcounty | 1 | 81242 | 1 | 2.216 | 36661.6 |
173 | 2024-07-16 06:57:45 | subcounty | 1 | 81242 | 1 | 8.203 | 9903.9 |
172 | 2024-06-25 19:18:01 | subcounty | 2 | 121436 | 1 | 11.110 | 10930.3 |
171 | 2024-06-14 21:52:00 | subcounty | 2 | 121436 | 1 | 11.313 | 10734.2 |
170 | 2024-06-14 21:47:44 | subcounty | 1 | 81242 | 1 | 3.343 | 24302.1 |
169 | 2024-06-12 10:51:18 | subcounty | 3 | 148641 | 16 | 38.796 | 3831.3 |
168 | 2024-06-11 05:06:28 | subcounty | 1 | 81242 | 1 | 4.283 | 18968.5 |
167 | 2024-06-10 08:04:40 | subcounty | 3 | 148641 | 16 | 23.923 | 6213.3 |
166 | 2024-06-06 00:26:50 | subcounty | 3 | 148641 | 16 | 17.766 | 8366.6 |
165 | 2024-06-06 00:26:47 | subcounty | 2 | 121436 | 1 | 15.830 | 7671.3 |
164 | 2024-06-05 23:38:10 | subcounty | 1 | 81242 | 1 | 6.566 | 12373.1 |