History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gallop"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
619 | 2024-04-06 05:36:08 | gallop | 2 | 82551 | 54 | 5.423 | 15222.4 |
618 | 2024-04-06 05:36:06 | gallop | 1 | 48755 | 5 | 1.906 | 25579.7 |
617 | 2024-04-02 22:53:10 | gallop | 3 | 112716 | 392 | 17.690 | 6371.7 |
616 | 2024-03-31 20:48:44 | gallop | 3 | 112716 | 392 | 20.326 | 5545.4 |
615 | 2024-03-29 19:27:01 | gallop | 2 | 82551 | 54 | 4.623 | 17856.6 |
614 | 2024-03-29 19:26:24 | gallop | 3 | 112716 | 392 | 6.033 | 18683.2 |
613 | 2024-03-28 19:46:38 | gallop | 2 | 82551 | 54 | 3.110 | 26543.7 |
612 | 2024-03-28 18:40:52 | gallop | 1 | 48755 | 5 | 2.123 | 22965.1 |
611 | 2024-03-28 07:16:49 | gallop | 2 | 82551 | 54 | 2.673 | 30883.3 |
610 | 2024-03-28 07:16:48 | gallop | 1 | 48755 | 5 | 1.546 | 31536.2 |
609 | 2024-03-28 07:16:29 | gallop | 3 | 112716 | 392 | 6.093 | 18499.3 |
608 | 2024-03-28 03:56:39 | gallop | 3 | 112716 | 392 | 5.626 | 20034.8 |
607 | 2024-03-13 17:03:45 | gallop | 2 | 82551 | 54 | 9.046 | 9125.7 |
606 | 2024-03-12 09:45:47 | gallop | 2 | 82551 | 54 | 8.296 | 9950.7 |
605 | 2024-02-07 17:43:29 | gallop | 3 | 112716 | 392 | 13.206 | 8535.2 |
604 | 2024-02-07 17:41:17 | gallop | 2 | 82551 | 54 | 5.986 | 13790.7 |
603 | 2024-02-07 00:31:46 | gallop | 2 | 82551 | 54 | 2.703 | 30540.5 |
602 | 2024-02-07 00:31:22 | gallop | 3 | 112716 | 392 | 5.313 | 21215.1 |
601 | 2024-02-04 19:45:49 | gallop | 2 | 82551 | 54 | 5.156 | 16010.7 |
600 | 2024-02-04 19:45:29 | gallop | 3 | 112716 | 392 | 6.033 | 18683.2 |
599 | 2024-02-04 14:18:28 | gallop | 2 | 82551 | 54 | 5.843 | 14128.2 |
598 | 2024-02-04 14:18:02 | gallop | 3 | 112716 | 392 | 8.486 | 13282.6 |
597 | 2024-02-04 12:00:54 | gallop | 3 | 112716 | 392 | 5.796 | 19447.2 |
596 | 2024-02-04 12:00:50 | gallop | 2 | 82551 | 54 | 2.513 | 32849.6 |
595 | 2024-01-24 04:05:58 | gallop | 2 | 82551 | 54 | 2.110 | 39123.7 |
594 | 2024-01-08 22:55:18 | gallop | 1 | 48755 | 5 | 0.873 | 55847.7 |
593 | 2024-01-07 21:24:31 | gallop | 1 | 48755 | 5 | 0.890 | 54780.9 |
592 | 2023-12-29 06:02:10 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
591 | 2023-12-21 14:23:37 | gallop | 1 | 48755 | 5 | 0.733 | 66514.3 |
590 | 2023-12-21 04:42:35 | gallop | 2 | 82551 | 54 | 2.686 | 30733.8 |
589 | 2023-12-20 02:41:33 | gallop | 3 | 112716 | 392 | 5.360 | 21029.1 |
588 | 2023-12-08 01:17:22 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |
587 | 2023-12-08 01:17:21 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |
586 | 2023-12-06 06:37:32 | gallop | 2 | 82551 | 54 | 2.200 | 37523.2 |
585 | 2023-12-03 20:03:32 | gallop | 3 | 112716 | 392 | 4.720 | 23880.5 |
584 | 2023-12-02 09:49:05 | gallop | 3 | 112716 | 392 | 4.813 | 23419.1 |
583 | 2023-11-21 23:33:20 | gallop | 1 | 48755 | 5 | 0.766 | 63648.8 |
582 | 2023-11-12 01:58:59 | gallop | 1 | 48755 | 5 | 1.030 | 47335.0 |
581 | 2023-11-11 00:20:58 | gallop | 1 | 48755 | 5 | 0.860 | 56691.9 |
580 | 2023-11-04 09:41:48 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
579 | 2023-11-02 06:01:13 | gallop | 1 | 48755 | 5 | 0.813 | 59969.2 |
578 | 2023-10-24 10:07:10 | gallop | 1 | 48755 | 5 | 0.876 | 55656.4 |
577 | 2023-10-17 02:12:33 | gallop | 1 | 48755 | 5 | 0.920 | 52994.6 |
576 | 2023-10-13 18:28:42 | gallop | 1 | 48755 | 5 | 0.890 | 54780.9 |
575 | 2023-10-07 19:20:58 | gallop | 1 | 48755 | 5 | 0.783 | 62266.9 |
574 | 2023-09-24 23:31:33 | gallop | 1 | 48755 | 5 | 0.906 | 53813.5 |
573 | 2023-09-15 17:02:29 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |
572 | 2023-09-06 05:14:21 | gallop | 1 | 48755 | 5 | 0.860 | 56691.9 |
571 | 2023-08-30 20:53:15 | gallop | 3 | 112716 | 392 | 5.580 | 20200.0 |
570 | 2023-08-24 22:38:08 | gallop | 1 | 48755 | 5 | 0.763 | 63899.1 |
569 | 2023-05-26 02:53:32 | gallop | 1 | 48755 | 5 | 0.733 | 66514.3 |
568 | 2023-05-17 05:08:13 | gallop | 3 | 112716 | 392 | 5.843 | 19290.8 |
567 | 2023-05-17 00:35:31 | gallop | 1 | 48755 | 5 | 0.720 | 67715.3 |
566 | 2023-03-23 03:34:51 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
565 | 2023-02-22 20:51:02 | gallop | 3 | 112716 | 392 | 5.326 | 21163.3 |
564 | 2023-01-23 23:58:25 | gallop | 1 | 48755 | 5 | 0.736 | 66243.2 |
563 | 2023-01-09 15:41:12 | gallop | 1 | 48755 | 5 | 0.733 | 66514.3 |
562 | 2022-12-03 03:26:21 | gallop | 3 | 112716 | 392 | 4.610 | 24450.3 |
561 | 2022-10-05 15:04:16 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |
560 | 2022-10-02 12:14:17 | gallop | 1 | 48755 | 5 | 0.763 | 63899.1 |
559 | 2022-06-19 06:40:30 | gallop | 1 | 48755 | 5 | 0.813 | 59969.2 |
558 | 2022-05-20 09:52:27 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
557 | 2022-04-06 00:55:39 | gallop | 3 | 112716 | 392 | 5.936 | 18988.5 |
556 | 2022-03-03 15:52:35 | gallop | 1 | 48755 | 5 | 1.283 | 38000.8 |
555 | 2022-02-04 00:03:39 | gallop | 1 | 48755 | 5 | 0.890 | 54780.9 |
554 | 2022-02-01 19:55:53 | gallop | 1 | 48755 | 5 | 0.860 | 56691.9 |
553 | 2021-12-30 08:34:04 | gallop | 1 | 48755 | 5 | 0.893 | 54596.9 |
552 | 2021-11-25 20:05:43 | gallop | 1 | 48755 | 5 | 0.800 | 60943.8 |
551 | 2021-11-23 10:45:36 | gallop | 1 | 48755 | 5 | 0.873 | 55847.7 |
550 | 2021-11-05 01:44:57 | gallop | 1 | 48755 | 5 | 0.766 | 63648.8 |
549 | 2021-10-05 07:44:25 | gallop | 1 | 48755 | 5 | 0.846 | 57630.0 |
548 | 2021-09-18 08:07:11 | gallop | 1 | 48755 | 5 | 0.873 | 55847.7 |
547 | 2021-08-20 10:15:37 | gallop | 1 | 48755 | 5 | 0.796 | 61250.0 |
546 | 2021-08-19 04:17:13 | gallop | 1 | 48755 | 5 | 1.673 | 29142.3 |
545 | 2021-08-18 13:59:14 | gallop | 1 | 48755 | 5 | 0.826 | 59025.4 |
544 | 2021-08-17 12:19:53 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
543 | 2021-07-10 20:16:47 | gallop | 1 | 48755 | 5 | 0.780 | 62506.4 |
542 | 2021-05-25 06:07:38 | gallop | 1 | 48755 | 5 | 0.906 | 53813.5 |
541 | 2021-05-19 18:19:27 | gallop | 1 | 48755 | 5 | 0.920 | 52994.6 |
540 | 2021-05-14 22:38:17 | gallop | 1 | 48755 | 5 | 0.860 | 56691.9 |
539 | 2021-04-14 00:55:46 | gallop | 1 | 48755 | 5 | 0.906 | 53813.5 |
538 | 2021-03-17 18:17:07 | gallop | 1 | 48755 | 5 | 0.856 | 56956.8 |
537 | 2021-02-16 21:38:52 | gallop | 1 | 48755 | 5 | 0.763 | 63899.1 |
536 | 2020-12-02 07:34:39 | gallop | 1 | 48755 | 5 | 0.766 | 63648.8 |
535 | 2020-11-17 16:36:58 | gallop | 1 | 48755 | 5 | 0.783 | 62266.9 |
534 | 2020-11-04 10:59:31 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |
533 | 2020-11-02 04:32:20 | gallop | 1 | 48755 | 5 | 1.843 | 26454.2 |
532 | 2020-09-04 08:02:24 | gallop | 1 | 48755 | 5 | 0.876 | 55656.4 |
531 | 2020-08-28 19:14:22 | gallop | 1 | 48755 | 5 | 0.796 | 61250.0 |
530 | 2020-08-28 16:49:56 | gallop | 1 | 48755 | 5 | 0.796 | 61250.0 |
529 | 2020-08-09 01:12:38 | gallop | 1 | 48755 | 5 | 1.500 | 32503.3 |
528 | 2020-07-28 05:30:46 | gallop | 1 | 48755 | 5 | 0.813 | 59969.2 |
527 | 2020-05-30 07:16:42 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
526 | 2020-05-07 19:42:49 | gallop | 1 | 48755 | 5 | 0.796 | 61250.0 |
525 | 2020-03-29 05:14:41 | gallop | 1 | 48755 | 5 | 1.733 | 28133.3 |
524 | 2020-03-28 00:45:46 | gallop | 1 | 48755 | 5 | 0.843 | 57835.1 |
523 | 2020-03-23 13:58:51 | gallop | 1 | 48755 | 5 | 0.890 | 54780.9 |
522 | 2020-03-22 17:32:53 | gallop | 1 | 48755 | 5 | 2.610 | 18680.1 |
521 | 2020-03-18 15:25:20 | gallop | 1 | 48755 | 5 | 1.736 | 28084.7 |
520 | 2020-03-07 19:46:09 | gallop | 1 | 48755 | 5 | 0.750 | 65006.7 |