History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"smithy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
438 | 2024-05-02 03:24:29 | smithy | 1 | 48755 | 4 | 0.860 | 56691.9 |
437 | 2024-05-01 08:11:34 | smithy | 1 | 48755 | 4 | 0.983 | 49598.2 |
436 | 2024-04-30 14:01:06 | smithy | 1 | 48755 | 4 | 1.360 | 35849.3 |
435 | 2024-04-03 11:14:38 | smithy | 1 | 48755 | 4 | 0.970 | 50262.9 |
434 | 2024-03-31 17:14:45 | smithy | 1 | 48755 | 4 | 2.970 | 16415.8 |
433 | 2024-03-30 01:06:48 | smithy | 1 | 48755 | 4 | 2.876 | 16952.4 |
432 | 2024-03-28 23:33:13 | smithy | 1 | 48755 | 4 | 2.970 | 16415.8 |
431 | 2024-03-28 13:29:57 | smithy | 1 | 48755 | 4 | 0.846 | 57630.0 |
430 | 2024-03-04 07:29:24 | smithy | 1 | 48755 | 4 | 2.280 | 21383.8 |
429 | 2024-02-29 07:25:04 | smithy | 2 | 82551 | 29 | 2.390 | 34540.2 |
428 | 2024-02-29 07:24:00 | smithy | 3 | 112716 | 350 | 5.420 | 20796.3 |
427 | 2024-02-29 07:10:09 | smithy | 2 | 82551 | 29 | 5.236 | 15766.0 |
426 | 2024-02-29 07:09:48 | smithy | 3 | 112716 | 350 | 8.610 | 13091.3 |
425 | 2024-02-27 23:45:18 | smithy | 2 | 82551 | 29 | 2.483 | 33246.5 |
424 | 2024-02-27 23:45:00 | smithy | 3 | 112716 | 350 | 9.173 | 12287.8 |
423 | 2024-02-27 22:44:33 | smithy | 3 | 112716 | 350 | 10.513 | 10721.6 |
422 | 2024-02-27 22:44:32 | smithy | 2 | 82551 | 29 | 4.250 | 19423.8 |
421 | 2024-02-27 22:44:29 | smithy | 1 | 48755 | 4 | 0.953 | 51159.5 |
420 | 2024-02-21 08:27:51 | smithy | 1 | 48755 | 4 | 2.003 | 24341.0 |
419 | 2024-02-19 21:58:12 | smithy | 1 | 48755 | 4 | 0.983 | 49598.2 |
418 | 2023-12-29 13:35:39 | smithy | 3 | 112716 | 350 | 4.610 | 24450.3 |
417 | 2023-12-29 04:37:21 | smithy | 2 | 82551 | 29 | 2.403 | 34353.3 |
416 | 2023-12-29 04:37:09 | smithy | 3 | 112716 | 350 | 4.546 | 24794.5 |
415 | 2023-12-29 04:14:32 | smithy | 3 | 112716 | 350 | 4.920 | 22909.8 |
414 | 2023-12-29 04:14:30 | smithy | 2 | 82551 | 29 | 2.220 | 37185.1 |
413 | 2023-12-06 05:40:07 | smithy | 1 | 48755 | 4 | 0.906 | 53813.5 |
412 | 2023-12-01 09:06:38 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
411 | 2023-11-23 02:41:59 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
410 | 2023-11-20 21:59:34 | smithy | 3 | 112716 | 350 | 5.436 | 20735.1 |
409 | 2023-11-20 21:59:37 | smithy | 2 | 82551 | 29 | 2.546 | 32423.8 |
408 | 2023-11-13 23:39:39 | smithy | 1 | 48755 | 4 | 0.830 | 58741.0 |
407 | 2023-11-06 17:30:09 | smithy | 1 | 48755 | 4 | 0.906 | 53813.5 |
406 | 2023-10-21 16:05:56 | smithy | 1 | 48755 | 4 | 0.783 | 62266.9 |
405 | 2023-10-19 08:18:54 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
404 | 2023-10-13 23:49:30 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
403 | 2023-10-04 07:20:19 | smithy | 3 | 112716 | 350 | 11.953 | 9429.9 |
402 | 2023-10-01 18:10:31 | smithy | 3 | 112716 | 350 | 4.643 | 24276.5 |
401 | 2023-09-26 08:45:30 | smithy | 1 | 48755 | 4 | 0.860 | 56691.9 |
400 | 2023-09-21 10:13:00 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
399 | 2023-09-13 11:50:20 | smithy | 1 | 48755 | 4 | 0.766 | 63648.8 |
398 | 2023-07-13 00:58:04 | smithy | 1 | 48755 | 4 | 0.766 | 63648.8 |
397 | 2023-07-12 00:34:11 | smithy | 3 | 112716 | 350 | 5.220 | 21593.1 |
396 | 2023-03-26 09:55:18 | smithy | 3 | 112716 | 350 | 5.550 | 20309.2 |
395 | 2023-03-08 20:13:22 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
394 | 2022-12-23 07:33:41 | smithy | 3 | 112716 | 350 | 4.516 | 24959.3 |
393 | 2022-10-26 12:58:17 | smithy | 1 | 48755 | 4 | 0.936 | 52088.7 |
392 | 2022-10-19 18:45:50 | smithy | 1 | 48755 | 4 | 0.733 | 66514.3 |
391 | 2022-08-28 21:23:16 | smithy | 1 | 48755 | 4 | 0.846 | 57630.0 |
390 | 2022-08-23 05:02:45 | smithy | 3 | 112716 | 350 | 4.596 | 24524.8 |
389 | 2022-08-20 19:38:44 | smithy | 3 | 112716 | 350 | 4.563 | 24702.2 |
388 | 2022-08-18 14:04:50 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
387 | 2022-07-26 07:39:35 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
386 | 2022-06-10 10:37:11 | smithy | 1 | 48755 | 4 | 0.860 | 56691.9 |
385 | 2022-06-08 04:50:34 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
384 | 2022-06-06 23:18:42 | smithy | 1 | 48755 | 4 | 0.846 | 57630.0 |
383 | 2022-02-18 00:34:25 | smithy | 1 | 48755 | 4 | 0.780 | 62506.4 |
382 | 2022-01-23 06:26:03 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
381 | 2021-12-16 18:35:00 | smithy | 2 | 82551 | 29 | 2.483 | 33246.5 |
380 | 2021-12-07 06:28:05 | smithy | 1 | 48755 | 4 | 0.796 | 61250.0 |
379 | 2021-10-22 20:10:39 | smithy | 1 | 48755 | 4 | 0.860 | 56691.9 |
378 | 2021-09-25 18:25:40 | smithy | 1 | 48755 | 4 | 0.830 | 58741.0 |
377 | 2021-09-24 05:01:48 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
376 | 2021-06-17 23:14:47 | smithy | 1 | 48755 | 4 | 0.876 | 55656.4 |
375 | 2021-04-23 18:49:04 | smithy | 1 | 48755 | 4 | 0.860 | 56691.9 |
374 | 2021-03-15 03:00:16 | smithy | 1 | 48755 | 4 | 0.766 | 63648.8 |
373 | 2021-02-28 01:27:15 | smithy | 1 | 48755 | 4 | 0.763 | 63899.1 |
372 | 2021-01-09 10:19:25 | smithy | 3 | 112716 | 350 | 4.716 | 23900.8 |
371 | 2020-12-30 18:45:13 | smithy | 1 | 48755 | 4 | 0.796 | 61250.0 |
370 | 2020-12-12 02:26:59 | smithy | 1 | 48755 | 4 | 0.783 | 62266.9 |
369 | 2020-11-15 20:40:49 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
368 | 2020-11-06 08:41:32 | smithy | 3 | 112716 | 350 | 4.923 | 22895.8 |
367 | 2020-11-02 02:41:01 | smithy | 3 | 112716 | 350 | 5.766 | 19548.4 |
366 | 2020-09-28 13:53:20 | smithy | 3 | 112716 | 350 | 5.533 | 20371.6 |
365 | 2020-09-27 21:57:52 | smithy | 3 | 112716 | 350 | 5.766 | 19548.4 |
364 | 2020-09-23 21:39:22 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
363 | 2020-09-05 09:25:12 | smithy | 1 | 48755 | 4 | 0.733 | 66514.3 |
362 | 2020-08-20 20:51:48 | smithy | 3 | 112716 | 350 | 4.936 | 22835.5 |
361 | 2020-07-31 10:27:28 | smithy | 1 | 48755 | 4 | 0.796 | 61250.0 |
360 | 2020-07-20 16:24:42 | smithy | 3 | 112716 | 350 | 4.766 | 23650.0 |
359 | 2020-06-20 01:46:47 | smithy | 3 | 112716 | 350 | 5.733 | 19660.9 |
358 | 2020-06-16 14:07:26 | smithy | 3 | 112716 | 350 | 6.830 | 16503.1 |
357 | 2020-05-22 00:42:19 | smithy | 1 | 48755 | 4 | 0.813 | 59969.2 |
356 | 2020-05-18 23:15:16 | smithy | 1 | 48755 | 4 | 0.750 | 65006.7 |
355 | 2020-05-18 21:16:08 | smithy | 1 | 48755 | 4 | 0.810 | 60191.4 |
354 | 2020-05-02 01:21:52 | smithy | 3 | 112716 | 350 | 4.843 | 23274.0 |
353 | 2020-04-05 13:06:49 | smithy | 1 | 48755 | 4 | 0.780 | 62506.4 |
352 | 2020-04-02 16:07:42 | smithy | 3 | 112716 | 350 | 4.920 | 22909.8 |
351 | 2020-03-27 19:24:02 | smithy | 1 | 48755 | 4 | 1.826 | 26700.4 |
350 | 2020-03-26 05:31:03 | smithy | 1 | 48755 | 4 | 1.783 | 27344.4 |
349 | 2020-03-24 05:45:25 | smithy | 1 | 48755 | 4 | 0.843 | 57835.1 |
348 | 2020-03-23 17:58:27 | smithy | 1 | 48755 | 4 | 0.890 | 54780.9 |
347 | 2020-03-18 15:23:10 | smithy | 1 | 48755 | 4 | 1.500 | 32503.3 |
346 | 2020-03-02 18:13:34 | smithy | 3 | 112716 | 350 | 12.203 | 9236.7 |
345 | 2020-02-28 18:37:25 | smithy | 1 | 48755 | 4 | 1.356 | 35955.0 |
344 | 2020-02-28 07:00:05 | smithy | 1 | 48755 | 4 | 1.736 | 28084.7 |
343 | 2020-02-28 06:14:52 | smithy | 1 | 48755 | 4 | 1.670 | 29194.6 |
342 | 2020-02-27 05:31:11 | smithy | 1 | 48755 | 4 | 0.830 | 58741.0 |
341 | 2020-02-26 05:31:50 | smithy | 1 | 48755 | 4 | 0.830 | 58741.0 |
340 | 2020-02-26 00:30:48 | smithy | 3 | 112716 | 350 | 8.016 | 14061.4 |
339 | 2020-02-25 12:09:57 | smithy | 3 | 112716 | 350 | 13.330 | 8455.8 |