History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"settlers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
342 | 2024-04-27 16:05:16 | settlers | 1 | 82945 | 6 | 1.950 | 42535.9 |
341 | 2024-04-27 09:48:33 | settlers | 1 | 82945 | 6 | 1.690 | 49079.9 |
340 | 2024-04-06 08:48:43 | settlers | 1 | 82945 | 6 | 4.563 | 18177.7 |
339 | 2024-03-31 19:50:33 | settlers | 1 | 82945 | 6 | 5.046 | 16437.8 |
338 | 2024-03-31 19:50:19 | settlers | 2 | 121059 | 44 | 4.766 | 25400.5 |
337 | 2024-03-31 07:23:01 | settlers | 1 | 82945 | 6 | 1.310 | 63316.8 |
336 | 2024-03-30 20:12:33 | settlers | 3 | 146162 | 418 | 9.390 | 15565.7 |
335 | 2024-03-30 20:12:28 | settlers | 2 | 121059 | 44 | 12.033 | 10060.6 |
334 | 2024-03-30 04:00:11 | settlers | 3 | 146162 | 418 | 22.016 | 6638.9 |
333 | 2024-03-30 04:00:10 | settlers | 2 | 121059 | 44 | 12.596 | 9610.9 |
332 | 2024-03-30 02:30:19 | settlers | 1 | 82945 | 6 | 1.610 | 51518.6 |
331 | 2024-03-17 19:47:30 | settlers | 3 | 146162 | 418 | 26.423 | 5531.6 |
330 | 2024-03-16 04:58:25 | settlers | 3 | 146162 | 418 | 17.783 | 8219.2 |
329 | 2024-03-15 22:31:54 | settlers | 3 | 146162 | 418 | 11.906 | 12276.3 |
328 | 2024-03-14 12:33:02 | settlers | 3 | 146162 | 418 | 6.753 | 21644.0 |
327 | 2024-02-29 01:08:07 | settlers | 1 | 82945 | 6 | 1.580 | 52496.8 |
326 | 2024-01-15 23:55:57 | settlers | 2 | 121059 | 44 | 3.313 | 36540.6 |
325 | 2023-12-22 18:26:28 | settlers | 1 | 82945 | 6 | 1.436 | 57761.1 |
324 | 2023-12-17 02:05:51 | settlers | 3 | 146162 | 418 | 7.296 | 20033.2 |
323 | 2023-12-17 02:05:50 | settlers | 2 | 121059 | 44 | 3.703 | 32692.1 |
322 | 2023-12-10 21:49:58 | settlers | 1 | 82945 | 6 | 3.236 | 25632.0 |
321 | 2023-12-07 00:15:49 | settlers | 3 | 146162 | 418 | 7.843 | 18636.0 |
320 | 2023-12-07 00:15:48 | settlers | 2 | 121059 | 44 | 4.030 | 30039.5 |
319 | 2023-11-30 20:57:08 | settlers | 3 | 146162 | 418 | 8.190 | 17846.4 |
318 | 2023-11-18 07:35:50 | settlers | 2 | 121059 | 44 | 3.953 | 30624.6 |
317 | 2023-11-18 07:28:28 | settlers | 1 | 82945 | 6 | 1.406 | 58993.6 |
316 | 2023-11-12 06:29:25 | settlers | 1 | 82945 | 6 | 1.280 | 64800.8 |
315 | 2023-11-10 16:17:56 | settlers | 1 | 82945 | 6 | 1.576 | 52630.1 |
314 | 2023-11-03 07:07:11 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
313 | 2023-10-26 00:23:14 | settlers | 2 | 121059 | 44 | 4.016 | 30144.2 |
312 | 2023-10-20 04:54:21 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
311 | 2023-10-15 02:12:53 | settlers | 1 | 82945 | 6 | 1.313 | 63172.1 |
310 | 2023-10-09 19:18:31 | settlers | 1 | 82945 | 6 | 1.500 | 55296.7 |
309 | 2023-09-16 23:19:21 | settlers | 1 | 82945 | 6 | 1.313 | 63172.1 |
308 | 2023-08-30 15:41:48 | settlers | 3 | 146162 | 418 | 7.623 | 19173.8 |
307 | 2023-08-05 12:36:06 | settlers | 1 | 82945 | 6 | 1.330 | 62364.7 |
306 | 2023-08-03 20:53:39 | settlers | 2 | 121059 | 44 | 3.733 | 32429.4 |
305 | 2023-07-31 06:04:02 | settlers | 1 | 82945 | 6 | 1.326 | 62552.8 |
304 | 2023-05-12 03:43:04 | settlers | 3 | 146162 | 418 | 7.360 | 19859.0 |
303 | 2023-05-05 00:46:23 | settlers | 1 | 82945 | 6 | 1.453 | 57085.3 |
302 | 2023-04-13 17:25:10 | settlers | 2 | 121059 | 44 | 3.203 | 37795.5 |
301 | 2023-04-08 05:52:20 | settlers | 1 | 82945 | 6 | 1.440 | 57600.7 |
300 | 2023-02-27 00:49:02 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
299 | 2023-02-18 19:55:27 | settlers | 3 | 146162 | 418 | 6.313 | 23152.5 |
298 | 2023-01-19 17:31:12 | settlers | 2 | 121059 | 44 | 3.233 | 37444.8 |
297 | 2022-12-23 16:54:02 | settlers | 1 | 82945 | 6 | 1.283 | 64649.3 |
296 | 2022-12-09 14:31:21 | settlers | 1 | 82945 | 6 | 1.313 | 63172.1 |
295 | 2022-11-30 02:07:30 | settlers | 3 | 146162 | 418 | 6.343 | 23043.0 |
294 | 2022-10-30 22:35:49 | settlers | 2 | 121059 | 44 | 3.906 | 30993.1 |
293 | 2022-09-11 12:40:19 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
292 | 2022-08-02 18:59:28 | settlers | 1 | 82945 | 6 | 1.360 | 60989.0 |
291 | 2022-07-19 16:04:41 | settlers | 1 | 82945 | 6 | 1.420 | 58412.0 |
290 | 2022-07-08 13:04:50 | settlers | 3 | 146162 | 418 | 6.456 | 22639.7 |
289 | 2022-06-01 19:50:30 | settlers | 2 | 121059 | 44 | 3.250 | 37248.9 |
288 | 2022-05-30 14:58:22 | settlers | 2 | 121059 | 44 | 3.250 | 37248.9 |
287 | 2022-05-20 05:55:42 | settlers | 1 | 82945 | 6 | 1.326 | 62552.8 |
286 | 2022-05-01 17:17:46 | settlers | 1 | 82945 | 6 | 1.453 | 57085.3 |
285 | 2022-04-29 10:45:11 | settlers | 1 | 82945 | 6 | 1.813 | 45750.1 |
284 | 2022-03-28 20:59:16 | settlers | 1 | 82945 | 6 | 1.783 | 46519.9 |
283 | 2022-02-15 08:22:05 | settlers | 3 | 146162 | 418 | 7.453 | 19611.2 |
282 | 2022-01-21 01:40:57 | settlers | 2 | 121059 | 44 | 4.140 | 29241.3 |
281 | 2022-01-20 15:47:57 | settlers | 1 | 82945 | 6 | 1.533 | 54106.3 |
280 | 2021-12-08 02:43:51 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
279 | 2021-11-16 07:12:45 | settlers | 1 | 82945 | 6 | 1.310 | 63316.8 |
278 | 2021-11-14 06:22:18 | settlers | 1 | 82945 | 6 | 1.343 | 61761.0 |
277 | 2021-09-29 20:05:22 | settlers | 1 | 82945 | 6 | 1.546 | 53651.4 |
276 | 2021-09-27 17:31:33 | settlers | 1 | 82945 | 6 | 1.330 | 62364.7 |
275 | 2021-09-08 09:57:08 | settlers | 1 | 82945 | 6 | 1.500 | 55296.7 |
274 | 2021-08-18 09:17:57 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
273 | 2021-05-07 12:26:29 | settlers | 1 | 82945 | 6 | 1.623 | 51106.0 |
272 | 2021-02-06 17:58:05 | settlers | 1 | 82945 | 6 | 1.330 | 62364.7 |
271 | 2021-01-28 01:41:59 | settlers | 1 | 82945 | 6 | 1.440 | 57600.7 |
270 | 2021-01-26 00:54:43 | settlers | 1 | 82945 | 6 | 1.436 | 57761.1 |
269 | 2021-01-06 03:18:10 | settlers | 1 | 82945 | 6 | 1.376 | 60279.8 |
268 | 2020-12-12 07:38:50 | settlers | 3 | 146162 | 418 | 6.546 | 22328.4 |
267 | 2020-12-06 19:52:07 | settlers | 2 | 121059 | 44 | 3.360 | 36029.5 |
266 | 2020-12-06 09:39:59 | settlers | 1 | 82945 | 6 | 1.360 | 60989.0 |
265 | 2020-11-20 16:26:19 | settlers | 1 | 82945 | 6 | 1.330 | 62364.7 |
264 | 2020-10-30 02:00:39 | settlers | 1 | 82945 | 6 | 3.156 | 26281.7 |
263 | 2020-10-27 04:24:31 | settlers | 1 | 82945 | 6 | 1.470 | 56425.2 |
262 | 2020-10-26 18:37:44 | settlers | 1 | 82945 | 6 | 1.310 | 63316.8 |
261 | 2020-10-25 06:24:16 | settlers | 1 | 82945 | 6 | 1.530 | 54212.4 |
260 | 2020-10-18 12:59:57 | settlers | 1 | 82945 | 6 | 1.406 | 58993.6 |
259 | 2020-08-31 01:38:04 | settlers | 1 | 82945 | 6 | 1.343 | 61761.0 |
258 | 2020-08-30 10:28:15 | settlers | 1 | 82945 | 6 | 1.516 | 54713.1 |
257 | 2020-08-21 19:06:55 | settlers | 1 | 82945 | 6 | 1.436 | 57761.1 |
256 | 2020-07-21 23:11:27 | settlers | 1 | 82945 | 6 | 1.436 | 57761.1 |
255 | 2020-06-01 21:15:56 | settlers | 1 | 82945 | 6 | 1.340 | 61899.3 |
254 | 2020-04-20 00:25:43 | settlers | 1 | 82945 | 6 | 1.326 | 62552.8 |
253 | 2020-04-09 05:05:57 | settlers | 1 | 82945 | 6 | 1.296 | 64000.8 |
252 | 2020-03-22 08:29:10 | settlers | 1 | 82945 | 6 | 1.423 | 58288.8 |
251 | 2020-03-11 20:10:50 | settlers | 1 | 82945 | 6 | 1.343 | 61761.0 |
250 | 2020-03-04 03:39:46 | settlers | 1 | 82945 | 6 | 1.420 | 58412.0 |
249 | 2020-02-29 00:43:57 | settlers | 1 | 82945 | 6 | 2.846 | 29144.4 |
248 | 2020-02-26 09:16:32 | settlers | 1 | 82945 | 6 | 2.606 | 31828.5 |
247 | 2020-02-22 22:23:02 | settlers | 1 | 82945 | 6 | 3.596 | 23065.9 |
246 | 2020-02-11 09:27:15 | settlers | 1 | 82945 | 6 | 3.373 | 24590.9 |
245 | 2020-02-10 03:18:36 | settlers | 1 | 82945 | 6 | 1.593 | 52068.4 |
244 | 2020-02-05 21:28:06 | settlers | 1 | 82945 | 6 | 2.080 | 39877.4 |
243 | 2020-02-01 12:25:38 | settlers | 1 | 82945 | 6 | 1.656 | 50087.6 |