History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"doggie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
459 | 2024-04-29 13:07:11 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
458 | 2024-04-20 03:57:48 | doggie | 1 | 48755 | 6 | 1.623 | 30040.0 |
457 | 2024-04-13 07:19:50 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
456 | 2024-04-13 07:19:10 | doggie | 1 | 48755 | 6 | 0.890 | 54780.9 |
455 | 2024-04-03 09:49:08 | doggie | 1 | 48755 | 6 | 2.796 | 17437.4 |
454 | 2024-03-31 09:52:17 | doggie | 2 | 82551 | 56 | 9.563 | 8632.3 |
453 | 2024-03-31 09:52:01 | doggie | 1 | 48755 | 6 | 3.780 | 12898.1 |
452 | 2024-03-30 19:29:03 | doggie | 3 | 112716 | 439 | 17.313 | 6510.5 |
451 | 2024-03-30 02:12:54 | doggie | 2 | 82551 | 56 | 4.783 | 17259.3 |
450 | 2024-03-29 23:35:10 | doggie | 3 | 112716 | 439 | 14.266 | 7901.0 |
449 | 2024-03-29 10:35:42 | doggie | 3 | 112716 | 439 | 5.813 | 19390.3 |
448 | 2024-03-29 10:35:43 | doggie | 2 | 82551 | 56 | 2.563 | 32208.7 |
447 | 2024-03-29 10:35:38 | doggie | 1 | 48755 | 6 | 0.940 | 51867.0 |
446 | 2024-03-29 10:35:30 | doggie | 3 | 112716 | 439 | 6.720 | 16773.2 |
445 | 2024-03-29 10:35:28 | doggie | 2 | 82551 | 56 | 2.876 | 28703.4 |
444 | 2024-03-29 10:35:28 | doggie | 1 | 48755 | 6 | 0.920 | 52994.6 |
443 | 2024-01-17 05:59:08 | doggie | 3 | 112716 | 439 | 4.673 | 24120.7 |
442 | 2024-01-07 01:21:44 | doggie | 3 | 112716 | 439 | 4.626 | 24365.8 |
441 | 2024-01-04 04:36:22 | doggie | 1 | 48755 | 6 | 0.860 | 56691.9 |
440 | 2023-12-27 02:58:48 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
439 | 2023-12-26 13:05:31 | doggie | 2 | 82551 | 56 | 2.220 | 37185.1 |
438 | 2023-12-14 20:27:51 | doggie | 1 | 48755 | 6 | 0.826 | 59025.4 |
437 | 2023-12-12 10:20:04 | doggie | 2 | 82551 | 56 | 2.440 | 33832.4 |
436 | 2023-11-19 09:11:32 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
435 | 2023-11-17 13:38:45 | doggie | 1 | 48755 | 6 | 1.703 | 28628.9 |
434 | 2023-11-14 16:29:04 | doggie | 1 | 48755 | 6 | 0.830 | 58741.0 |
433 | 2023-11-14 16:23:37 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
432 | 2023-11-11 12:00:28 | doggie | 2 | 82551 | 56 | 2.580 | 31996.5 |
431 | 2023-11-10 16:26:39 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
430 | 2023-11-03 08:54:18 | doggie | 3 | 112716 | 439 | 6.033 | 18683.2 |
429 | 2023-11-02 07:10:34 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
428 | 2023-11-01 06:59:28 | doggie | 3 | 112716 | 439 | 4.843 | 23274.0 |
427 | 2023-10-26 00:27:45 | doggie | 3 | 112716 | 439 | 4.920 | 22909.8 |
426 | 2023-10-26 00:27:47 | doggie | 2 | 82551 | 56 | 2.466 | 33475.7 |
425 | 2023-10-25 00:59:07 | doggie | 1 | 48755 | 6 | 0.780 | 62506.4 |
424 | 2023-10-19 19:19:00 | doggie | 1 | 48755 | 6 | 0.856 | 56956.8 |
423 | 2023-10-18 17:37:06 | doggie | 1 | 48755 | 6 | 0.906 | 53813.5 |
422 | 2023-10-13 14:58:47 | doggie | 1 | 48755 | 6 | 0.813 | 59969.2 |
421 | 2023-10-05 00:28:59 | doggie | 1 | 48755 | 6 | 0.780 | 62506.4 |
420 | 2023-09-24 23:17:17 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
419 | 2023-09-14 02:11:03 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
418 | 2023-08-19 20:30:44 | doggie | 1 | 48755 | 6 | 0.846 | 57630.0 |
417 | 2023-08-06 09:05:03 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
416 | 2023-05-21 13:41:13 | doggie | 1 | 48755 | 6 | 0.826 | 59025.4 |
415 | 2023-04-21 11:22:35 | doggie | 1 | 48755 | 6 | 0.830 | 58741.0 |
414 | 2023-03-17 01:20:38 | doggie | 1 | 48755 | 6 | 0.813 | 59969.2 |
413 | 2023-01-05 07:46:04 | doggie | 1 | 48755 | 6 | 0.736 | 66243.2 |
412 | 2023-01-03 10:41:52 | doggie | 1 | 48755 | 6 | 0.733 | 66514.3 |
411 | 2022-11-09 23:07:11 | doggie | 2 | 82551 | 56 | 2.173 | 37989.4 |
410 | 2022-10-19 01:59:08 | doggie | 2 | 82551 | 56 | 2.110 | 39123.7 |
409 | 2022-09-25 12:05:26 | doggie | 1 | 48755 | 6 | 0.733 | 66514.3 |
408 | 2022-09-18 01:53:08 | doggie | 1 | 48755 | 6 | 0.763 | 63899.1 |
407 | 2022-09-16 21:16:11 | doggie | 2 | 82551 | 56 | 2.186 | 37763.5 |
406 | 2022-06-08 06:08:06 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
405 | 2022-05-07 20:00:06 | doggie | 1 | 48755 | 6 | 0.860 | 56691.9 |
404 | 2022-02-24 19:32:32 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
403 | 2022-01-26 18:52:07 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
402 | 2021-11-20 02:16:39 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
401 | 2021-11-19 23:52:25 | doggie | 1 | 48755 | 6 | 0.796 | 61250.0 |
400 | 2021-10-07 22:11:32 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
399 | 2021-09-24 23:52:59 | doggie | 1 | 48755 | 6 | 0.856 | 56956.8 |
398 | 2021-09-05 21:10:50 | doggie | 1 | 48755 | 6 | 0.813 | 59969.2 |
397 | 2021-08-19 05:41:35 | doggie | 1 | 48755 | 6 | 0.733 | 66514.3 |
396 | 2021-08-17 02:55:01 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
395 | 2021-08-12 11:20:20 | doggie | 2 | 82551 | 56 | 2.123 | 38884.1 |
394 | 2021-05-21 17:06:59 | doggie | 1 | 48755 | 6 | 0.780 | 62506.4 |
393 | 2021-05-16 10:52:43 | doggie | 1 | 48755 | 6 | 0.873 | 55847.7 |
392 | 2021-05-13 02:04:12 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
391 | 2021-04-22 06:55:58 | doggie | 1 | 48755 | 6 | 1.000 | 48755.0 |
390 | 2021-03-24 15:47:13 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
389 | 2021-02-15 00:02:27 | doggie | 2 | 82551 | 56 | 2.140 | 38575.2 |
388 | 2021-02-09 07:47:12 | doggie | 1 | 48755 | 6 | 0.826 | 59025.4 |
387 | 2021-02-03 00:37:50 | doggie | 1 | 48755 | 6 | 0.753 | 64747.7 |
386 | 2021-01-07 11:56:00 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
385 | 2020-12-04 20:26:29 | doggie | 1 | 48755 | 6 | 0.750 | 65006.7 |
384 | 2020-11-18 09:13:21 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
383 | 2020-11-10 16:07:29 | doggie | 1 | 48755 | 6 | 0.796 | 61250.0 |
382 | 2020-11-07 14:38:49 | doggie | 1 | 48755 | 6 | 0.920 | 52994.6 |
381 | 2020-10-19 08:09:03 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
380 | 2020-08-28 05:36:41 | doggie | 1 | 48755 | 6 | 0.763 | 63899.1 |
379 | 2020-08-24 06:04:46 | doggie | 1 | 48755 | 6 | 0.783 | 62266.9 |
378 | 2020-08-02 20:37:05 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
377 | 2020-06-20 09:26:53 | doggie | 1 | 48755 | 6 | 0.766 | 63648.8 |
376 | 2020-05-04 13:26:34 | doggie | 1 | 48755 | 6 | 0.860 | 56691.9 |
375 | 2020-03-27 18:20:10 | doggie | 1 | 48755 | 6 | 0.843 | 57835.1 |
374 | 2020-03-26 18:36:19 | doggie | 1 | 48755 | 6 | 0.826 | 59025.4 |
373 | 2020-03-24 03:54:34 | doggie | 1 | 48755 | 6 | 1.703 | 28628.9 |
372 | 2020-03-23 23:48:33 | doggie | 1 | 48755 | 6 | 0.906 | 53813.5 |
371 | 2020-03-19 02:08:24 | doggie | 1 | 48755 | 6 | 0.753 | 64747.7 |
370 | 2020-03-18 16:12:36 | doggie | 1 | 48755 | 6 | 0.813 | 59969.2 |
369 | 2020-02-25 12:33:55 | doggie | 1 | 48755 | 6 | 0.906 | 53813.5 |
368 | 2020-02-22 11:20:25 | doggie | 1 | 48755 | 6 | 0.936 | 52088.7 |
367 | 2020-02-21 12:35:35 | doggie | 1 | 48755 | 6 | 0.876 | 55656.4 |
366 | 2020-02-15 00:04:35 | doggie | 1 | 48755 | 6 | 1.813 | 26891.9 |
365 | 2020-02-06 14:25:26 | doggie | 1 | 48755 | 6 | 0.936 | 52088.7 |
364 | 2020-02-05 04:37:49 | doggie | 1 | 48755 | 6 | 0.826 | 59025.4 |
363 | 2020-02-02 07:59:15 | doggie | 1 | 48755 | 6 | 0.813 | 59969.2 |
362 | 2020-02-02 07:41:05 | doggie | 1 | 48755 | 6 | 1.830 | 26642.1 |
361 | 2020-02-01 12:15:56 | doggie | 1 | 48755 | 6 | 0.890 | 54780.9 |
360 | 2020-01-26 20:24:05 | doggie | 1 | 48755 | 6 | 1.716 | 28412.0 |