History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hafters"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
410 | 2024-04-27 19:16:02 | hafters | 1 | 69583 | 9 | 1.156 | 60192.9 |
409 | 2024-04-27 17:38:38 | hafters | 1 | 69583 | 9 | 1.373 | 50679.5 |
408 | 2024-04-24 14:44:11 | hafters | 1 | 69583 | 9 | 1.453 | 47889.2 |
407 | 2024-04-22 20:07:06 | hafters | 1 | 69583 | 9 | 1.173 | 59320.5 |
406 | 2024-04-20 23:36:06 | hafters | 1 | 69583 | 9 | 1.420 | 49002.1 |
405 | 2024-04-09 20:34:32 | hafters | 1 | 69583 | 9 | 1.250 | 55666.4 |
404 | 2024-04-09 20:05:34 | hafters | 1 | 69583 | 9 | 1.220 | 57035.2 |
403 | 2024-01-30 09:32:05 | hafters | 2 | 107671 | 117 | 3.390 | 31761.4 |
402 | 2024-01-28 22:54:57 | hafters | 2 | 107671 | 117 | 3.423 | 31455.2 |
401 | 2023-12-29 10:19:35 | hafters | 1 | 69583 | 9 | 1.093 | 63662.4 |
400 | 2023-12-26 22:17:45 | hafters | 1 | 69583 | 9 | 1.216 | 57222.9 |
399 | 2023-12-13 15:42:13 | hafters | 1 | 69583 | 9 | 1.250 | 55666.4 |
398 | 2023-11-25 15:15:08 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
397 | 2023-11-20 15:54:01 | hafters | 1 | 69583 | 9 | 1.170 | 59472.6 |
396 | 2023-11-20 15:37:10 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
395 | 2023-11-19 16:11:54 | hafters | 1 | 69583 | 9 | 1.186 | 58670.3 |
394 | 2023-11-06 04:32:39 | hafters | 2 | 107671 | 117 | 2.750 | 39153.1 |
393 | 2023-10-31 15:03:55 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
392 | 2023-10-17 10:34:58 | hafters | 1 | 69583 | 9 | 2.860 | 24329.7 |
391 | 2023-10-15 19:40:58 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
390 | 2023-10-08 17:33:37 | hafters | 1 | 69583 | 9 | 1.236 | 56296.9 |
389 | 2023-09-26 21:08:17 | hafters | 1 | 69583 | 9 | 1.156 | 60192.9 |
388 | 2023-09-26 07:23:41 | hafters | 1 | 69583 | 9 | 1.140 | 61037.7 |
387 | 2023-08-24 00:55:11 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
386 | 2023-08-13 03:36:57 | hafters | 1 | 69583 | 9 | 1.093 | 63662.4 |
385 | 2023-08-10 15:53:23 | hafters | 2 | 107671 | 117 | 2.813 | 38276.2 |
384 | 2023-07-03 04:02:08 | hafters | 1 | 69583 | 9 | 1.096 | 63488.1 |
383 | 2023-05-27 12:21:02 | hafters | 1 | 69583 | 9 | 1.173 | 59320.5 |
382 | 2023-05-14 00:39:21 | hafters | 1 | 69583 | 9 | 1.156 | 60192.9 |
381 | 2023-05-12 02:14:55 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
380 | 2023-04-21 11:41:24 | hafters | 2 | 107671 | 117 | 3.233 | 33303.7 |
379 | 2023-04-07 17:32:44 | hafters | 1 | 69583 | 9 | 1.233 | 56433.9 |
378 | 2023-03-21 02:23:45 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
377 | 2023-03-20 20:49:30 | hafters | 1 | 69583 | 9 | 1.220 | 57035.2 |
376 | 2023-03-06 06:23:16 | hafters | 1 | 69583 | 9 | 1.156 | 60192.9 |
375 | 2023-03-04 14:42:41 | hafters | 1 | 69583 | 9 | 1.236 | 56296.9 |
374 | 2023-02-20 17:51:56 | hafters | 2 | 107671 | 117 | 3.390 | 31761.4 |
373 | 2023-02-13 23:01:38 | hafters | 1 | 69583 | 9 | 1.190 | 58473.1 |
372 | 2023-01-28 03:14:20 | hafters | 1 | 69583 | 9 | 1.170 | 59472.6 |
371 | 2023-01-25 09:55:38 | hafters | 1 | 69583 | 9 | 1.263 | 55093.4 |
370 | 2023-01-23 13:21:22 | hafters | 2 | 107671 | 117 | 2.766 | 38926.6 |
369 | 2023-01-01 22:25:33 | hafters | 2 | 107671 | 117 | 2.843 | 37872.3 |
368 | 2022-12-31 18:30:30 | hafters | 2 | 107671 | 117 | 2.780 | 38730.6 |
367 | 2022-12-28 04:40:53 | hafters | 1 | 69583 | 9 | 1.170 | 59472.6 |
366 | 2022-12-25 19:09:54 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
365 | 2022-12-11 05:16:39 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
364 | 2022-11-20 14:59:15 | hafters | 2 | 107671 | 117 | 3.250 | 33129.5 |
363 | 2022-11-16 07:10:36 | hafters | 2 | 107671 | 117 | 2.876 | 37437.8 |
362 | 2022-11-09 01:57:49 | hafters | 1 | 69583 | 9 | 1.046 | 66522.9 |
361 | 2022-11-05 11:18:24 | hafters | 2 | 107671 | 117 | 2.763 | 38968.9 |
360 | 2022-10-24 21:34:51 | hafters | 1 | 69583 | 9 | 1.203 | 57841.2 |
359 | 2022-10-14 19:29:40 | hafters | 2 | 107671 | 117 | 2.750 | 39153.1 |
358 | 2022-10-13 21:25:07 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
357 | 2022-09-17 09:36:34 | hafters | 1 | 69583 | 9 | 1.140 | 61037.7 |
356 | 2022-09-11 07:10:01 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
355 | 2022-09-10 09:43:51 | hafters | 2 | 107671 | 117 | 3.453 | 31181.9 |
354 | 2022-09-04 14:30:10 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
353 | 2022-08-07 23:33:36 | hafters | 2 | 107671 | 117 | 2.936 | 36672.7 |
352 | 2022-07-29 00:30:02 | hafters | 2 | 107671 | 117 | 3.000 | 35890.3 |
351 | 2022-07-23 00:52:34 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
350 | 2022-07-15 11:44:57 | hafters | 1 | 69583 | 9 | 1.046 | 66522.9 |
349 | 2022-07-05 01:44:31 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
348 | 2022-06-29 16:18:02 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
347 | 2022-06-07 02:10:20 | hafters | 2 | 107671 | 117 | 2.796 | 38508.9 |
346 | 2022-06-03 23:57:22 | hafters | 1 | 69583 | 9 | 1.050 | 66269.5 |
345 | 2022-05-27 19:53:18 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
344 | 2022-04-16 19:42:36 | hafters | 1 | 69583 | 9 | 1.173 | 59320.5 |
343 | 2022-04-09 06:41:10 | hafters | 1 | 69583 | 9 | 1.126 | 61796.6 |
342 | 2022-03-21 04:30:29 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
341 | 2022-03-17 17:56:04 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
340 | 2022-02-26 03:23:38 | hafters | 1 | 69583 | 9 | 1.250 | 55666.4 |
339 | 2022-02-11 18:05:58 | hafters | 1 | 69583 | 9 | 1.236 | 56296.9 |
338 | 2022-01-26 06:14:05 | hafters | 2 | 107671 | 117 | 3.546 | 30364.1 |
337 | 2021-12-15 03:49:31 | hafters | 1 | 69583 | 9 | 1.310 | 53116.8 |
336 | 2021-12-13 00:55:59 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
335 | 2021-12-07 07:05:47 | hafters | 1 | 69583 | 9 | 1.186 | 58670.3 |
334 | 2021-12-04 00:16:37 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
333 | 2021-11-23 15:41:52 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
332 | 2021-11-11 15:12:11 | hafters | 1 | 69583 | 9 | 1.216 | 57222.9 |
331 | 2021-10-25 12:21:49 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
330 | 2021-10-20 07:00:12 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
329 | 2021-09-10 06:23:16 | hafters | 1 | 69583 | 9 | 1.060 | 65644.3 |
328 | 2021-09-08 01:46:39 | hafters | 1 | 69583 | 9 | 1.093 | 63662.4 |
327 | 2021-08-30 22:11:22 | hafters | 1 | 69583 | 9 | 1.096 | 63488.1 |
326 | 2021-08-19 06:27:58 | hafters | 1 | 69583 | 9 | 1.076 | 64668.2 |
325 | 2021-06-28 06:42:10 | hafters | 1 | 69583 | 9 | 1.266 | 54962.9 |
324 | 2021-05-30 05:15:27 | hafters | 1 | 69583 | 9 | 1.220 | 57035.2 |
323 | 2021-05-20 05:51:10 | hafters | 1 | 69583 | 9 | 1.143 | 60877.5 |
322 | 2021-04-20 09:51:28 | hafters | 1 | 69583 | 9 | 1.266 | 54962.9 |
321 | 2021-04-10 05:54:30 | hafters | 1 | 69583 | 9 | 1.063 | 65459.1 |
320 | 2021-03-23 02:50:55 | hafters | 1 | 69583 | 9 | 1.280 | 54361.7 |
319 | 2021-03-14 07:24:45 | hafters | 1 | 69583 | 9 | 1.186 | 58670.3 |
318 | 2021-02-27 15:15:12 | hafters | 1 | 69583 | 9 | 1.266 | 54962.9 |
317 | 2021-02-25 07:50:55 | hafters | 1 | 69583 | 9 | 1.093 | 63662.4 |
316 | 2021-02-24 12:42:43 | hafters | 2 | 107671 | 117 | 2.936 | 36672.7 |
315 | 2021-02-01 13:07:23 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
314 | 2021-01-24 17:13:32 | hafters | 1 | 69583 | 9 | 1.080 | 64428.7 |
313 | 2021-01-05 02:01:39 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |
312 | 2020-11-29 11:05:50 | hafters | 1 | 69583 | 9 | 1.170 | 59472.6 |
311 | 2020-11-22 23:32:24 | hafters | 1 | 69583 | 9 | 1.110 | 62687.4 |