History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"umpire"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
623 | 2024-05-01 16:59:09 | umpire | 3 | 112716 | 330 | 13.266 | 8496.6 |
622 | 2024-05-01 15:10:18 | umpire | 3 | 112716 | 330 | 15.936 | 7073.0 |
621 | 2024-05-01 15:10:29 | umpire | 1 | 48755 | 4 | 1.516 | 32160.3 |
620 | 2024-05-01 15:10:13 | umpire | 2 | 82551 | 24 | 4.296 | 19215.8 |
619 | 2024-04-25 20:14:03 | umpire | 1 | 48755 | 4 | 1.233 | 39541.8 |
618 | 2024-03-31 21:29:29 | umpire | 3 | 112716 | 330 | 9.986 | 11287.4 |
617 | 2024-03-31 21:29:31 | umpire | 2 | 82551 | 24 | 2.766 | 29844.9 |
616 | 2024-03-31 21:29:25 | umpire | 1 | 48755 | 4 | 1.890 | 25796.3 |
615 | 2024-03-31 21:29:09 | umpire | 3 | 112716 | 330 | 6.486 | 17378.4 |
614 | 2024-03-31 21:29:10 | umpire | 2 | 82551 | 24 | 5.750 | 14356.7 |
613 | 2024-03-31 21:29:02 | umpire | 1 | 48755 | 4 | 0.950 | 51321.1 |
612 | 2024-03-30 01:43:15 | umpire | 1 | 48755 | 4 | 2.783 | 17518.9 |
611 | 2024-03-07 02:10:32 | umpire | 1 | 48755 | 4 | 0.843 | 57835.1 |
610 | 2024-02-18 04:26:52 | umpire | 1 | 48755 | 4 | 2.686 | 18151.5 |
609 | 2024-01-15 14:53:37 | umpire | 1 | 48755 | 4 | 0.796 | 61250.0 |
608 | 2024-01-13 02:21:12 | umpire | 3 | 112716 | 330 | 5.516 | 20434.4 |
607 | 2024-01-09 06:21:12 | umpire | 3 | 112716 | 330 | 5.156 | 21861.1 |
606 | 2024-01-05 02:35:00 | umpire | 2 | 82551 | 24 | 3.156 | 26156.8 |
605 | 2024-01-05 02:17:44 | umpire | 3 | 112716 | 330 | 4.796 | 23502.1 |
604 | 2024-01-01 13:53:28 | umpire | 3 | 112716 | 330 | 4.940 | 22817.0 |
603 | 2024-01-01 13:53:30 | umpire | 2 | 82551 | 24 | 2.453 | 33653.1 |
602 | 2023-11-17 03:41:02 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
601 | 2023-11-14 22:02:58 | umpire | 2 | 82551 | 24 | 2.000 | 41275.5 |
600 | 2023-11-14 21:15:25 | umpire | 3 | 112716 | 330 | 5.033 | 22395.4 |
599 | 2023-11-13 12:28:04 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
598 | 2023-11-11 09:29:05 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
597 | 2023-11-10 23:39:05 | umpire | 1 | 48755 | 4 | 0.800 | 60943.8 |
596 | 2023-10-21 10:08:18 | umpire | 1 | 48755 | 4 | 0.843 | 57835.1 |
595 | 2023-10-18 12:30:10 | umpire | 1 | 48755 | 4 | 0.860 | 56691.9 |
594 | 2023-10-14 01:48:05 | umpire | 1 | 48755 | 4 | 0.890 | 54780.9 |
593 | 2023-10-07 02:03:33 | umpire | 1 | 48755 | 4 | 0.720 | 67715.3 |
592 | 2023-09-27 04:56:05 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
591 | 2023-09-26 09:36:58 | umpire | 1 | 48755 | 4 | 0.826 | 59025.4 |
590 | 2023-09-16 14:58:16 | umpire | 1 | 48755 | 4 | 0.906 | 53813.5 |
589 | 2023-08-31 06:50:10 | umpire | 1 | 48755 | 4 | 0.813 | 59969.2 |
588 | 2023-06-01 08:48:25 | umpire | 1 | 48755 | 4 | 0.720 | 67715.3 |
587 | 2023-05-13 18:11:08 | umpire | 1 | 48755 | 4 | 0.796 | 61250.0 |
586 | 2023-03-26 04:39:44 | umpire | 1 | 48755 | 4 | 0.703 | 69352.8 |
585 | 2023-01-09 23:54:21 | umpire | 1 | 48755 | 4 | 0.796 | 61250.0 |
584 | 2023-01-05 14:10:37 | umpire | 1 | 48755 | 4 | 0.720 | 67715.3 |
583 | 2022-10-12 04:52:52 | umpire | 1 | 48755 | 4 | 0.750 | 65006.7 |
582 | 2022-09-18 06:42:16 | umpire | 1 | 48755 | 4 | 0.733 | 66514.3 |
581 | 2022-08-25 05:33:53 | umpire | 1 | 48755 | 4 | 0.720 | 67715.3 |
580 | 2022-08-23 10:34:41 | umpire | 1 | 48755 | 4 | 0.733 | 66514.3 |
579 | 2022-05-31 13:19:25 | umpire | 1 | 48755 | 4 | 0.796 | 61250.0 |
578 | 2022-04-10 14:15:19 | umpire | 1 | 48755 | 4 | 0.720 | 67715.3 |
577 | 2022-02-19 03:34:44 | umpire | 1 | 48755 | 4 | 0.736 | 66243.2 |
576 | 2021-12-20 23:19:48 | umpire | 1 | 48755 | 4 | 0.876 | 55656.4 |
575 | 2021-12-10 07:52:00 | umpire | 1 | 48755 | 4 | 0.843 | 57835.1 |
574 | 2021-12-07 01:33:38 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
573 | 2021-08-10 16:05:57 | umpire | 1 | 48755 | 4 | 0.783 | 62266.9 |
572 | 2021-07-06 02:49:12 | umpire | 1 | 48755 | 4 | 0.846 | 57630.0 |
571 | 2021-05-26 16:14:38 | umpire | 3 | 112716 | 330 | 5.456 | 20659.1 |
570 | 2021-04-22 01:51:43 | umpire | 1 | 48755 | 4 | 0.970 | 50262.9 |
569 | 2021-04-20 12:17:00 | umpire | 1 | 48755 | 4 | 0.826 | 59025.4 |
568 | 2021-01-29 02:54:32 | umpire | 1 | 48755 | 4 | 0.826 | 59025.4 |
567 | 2021-01-15 17:05:48 | umpire | 3 | 112716 | 330 | 4.563 | 24702.2 |
566 | 2021-01-08 22:31:36 | umpire | 1 | 48755 | 4 | 0.750 | 65006.7 |
565 | 2021-01-05 06:10:50 | umpire | 1 | 48755 | 4 | 0.826 | 59025.4 |
564 | 2021-01-04 19:34:48 | umpire | 1 | 48755 | 4 | 0.716 | 68093.6 |
563 | 2020-12-13 17:30:30 | umpire | 3 | 112716 | 330 | 4.653 | 24224.4 |
562 | 2020-11-20 07:55:56 | umpire | 3 | 112716 | 330 | 4.500 | 25048.0 |
561 | 2020-11-16 21:16:21 | umpire | 1 | 48755 | 4 | 0.733 | 66514.3 |
560 | 2020-11-13 08:27:26 | umpire | 1 | 48755 | 4 | 0.766 | 63648.8 |
559 | 2020-11-12 14:45:57 | umpire | 1 | 48755 | 4 | 0.733 | 66514.3 |
558 | 2020-11-05 20:39:16 | umpire | 3 | 112716 | 330 | 9.826 | 11471.2 |
557 | 2020-11-01 05:48:26 | umpire | 3 | 112716 | 330 | 10.830 | 10407.8 |
556 | 2020-10-27 20:24:52 | umpire | 3 | 112716 | 330 | 4.830 | 23336.6 |
555 | 2020-10-27 00:54:07 | umpire | 3 | 112716 | 330 | 5.016 | 22471.3 |
554 | 2020-10-19 11:57:15 | umpire | 1 | 48755 | 4 | 0.843 | 57835.1 |
553 | 2020-09-24 21:10:28 | umpire | 1 | 48755 | 4 | 0.733 | 66514.3 |
552 | 2020-09-06 11:14:00 | umpire | 3 | 112716 | 330 | 4.796 | 23502.1 |
551 | 2020-09-01 13:58:23 | umpire | 1 | 48755 | 4 | 0.780 | 62506.4 |
550 | 2020-08-28 04:49:43 | umpire | 3 | 112716 | 330 | 4.643 | 24276.5 |
549 | 2020-08-27 20:32:17 | umpire | 3 | 112716 | 330 | 4.830 | 23336.6 |
548 | 2020-08-22 05:13:22 | umpire | 3 | 112716 | 330 | 4.640 | 24292.2 |
547 | 2020-07-28 07:36:26 | umpire | 3 | 112716 | 330 | 4.796 | 23502.1 |
546 | 2020-07-23 11:24:56 | umpire | 1 | 48755 | 4 | 0.750 | 65006.7 |
545 | 2020-07-15 13:12:10 | umpire | 3 | 112716 | 330 | 4.670 | 24136.2 |
544 | 2020-06-16 02:14:50 | umpire | 3 | 112716 | 330 | 5.173 | 21789.3 |
543 | 2020-06-15 07:29:43 | umpire | 3 | 112716 | 330 | 4.656 | 24208.8 |
542 | 2020-06-13 04:36:30 | umpire | 3 | 112716 | 330 | 4.686 | 24053.8 |
541 | 2020-06-12 08:31:54 | umpire | 3 | 112716 | 330 | 4.670 | 24136.2 |
540 | 2020-06-07 10:47:56 | umpire | 3 | 112716 | 330 | 4.703 | 23966.8 |
539 | 2020-06-05 08:07:48 | umpire | 3 | 112716 | 330 | 4.656 | 24208.8 |
538 | 2020-06-03 07:46:46 | umpire | 3 | 112716 | 330 | 4.533 | 24865.7 |
537 | 2020-06-02 01:15:47 | umpire | 3 | 112716 | 330 | 4.593 | 24540.8 |
536 | 2020-06-01 10:26:00 | umpire | 1 | 48755 | 4 | 0.796 | 61250.0 |
535 | 2020-06-01 01:54:39 | umpire | 3 | 112716 | 330 | 6.313 | 17854.6 |
534 | 2020-05-26 03:06:39 | umpire | 3 | 112716 | 330 | 4.483 | 25143.0 |
533 | 2020-05-25 03:46:15 | umpire | 3 | 112716 | 330 | 4.453 | 25312.4 |
532 | 2020-05-22 06:30:58 | umpire | 3 | 112716 | 330 | 5.500 | 20493.8 |
531 | 2020-05-21 06:30:07 | umpire | 3 | 112716 | 330 | 4.580 | 24610.5 |
530 | 2020-05-18 10:11:16 | umpire | 3 | 112716 | 330 | 4.486 | 25126.2 |
529 | 2020-05-17 09:24:56 | umpire | 3 | 112716 | 330 | 4.563 | 24702.2 |
528 | 2020-05-17 01:57:12 | umpire | 3 | 112716 | 330 | 4.626 | 24365.8 |
527 | 2020-05-15 09:07:46 | umpire | 3 | 112716 | 330 | 4.813 | 23419.1 |
526 | 2020-05-10 09:01:51 | umpire | 3 | 112716 | 330 | 4.500 | 25048.0 |
525 | 2020-05-05 08:23:22 | umpire | 3 | 112716 | 330 | 5.283 | 21335.6 |
524 | 2020-05-05 00:49:31 | umpire | 3 | 112716 | 330 | 4.733 | 23814.9 |