History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
639 | 2024-04-26 09:40:20 | spate | 2 | 53800 | 236 | 2.080 | 25865.4 |
638 | 2024-04-25 12:48:39 | spate | 1 | 28756 | 17 | 0.606 | 47452.1 |
637 | 2024-04-14 23:25:33 | spate | 2 | 53800 | 236 | 1.936 | 27789.3 |
636 | 2024-04-14 23:24:40 | spate | 1 | 28756 | 17 | 1.796 | 16011.1 |
635 | 2024-04-13 11:25:44 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
634 | 2024-04-03 03:34:59 | spate | 2 | 53800 | 236 | 2.686 | 20029.8 |
633 | 2024-04-03 03:19:32 | spate | 1 | 28756 | 17 | 1.030 | 27918.4 |
632 | 2024-03-31 02:46:10 | spate | 1 | 28756 | 17 | 0.513 | 56054.6 |
631 | 2024-03-29 04:31:02 | spate | 2 | 53800 | 236 | 2.783 | 19331.7 |
630 | 2024-03-29 04:30:58 | spate | 1 | 28756 | 17 | 1.783 | 16127.9 |
629 | 2024-03-29 04:30:50 | spate | 2 | 53800 | 236 | 1.843 | 29191.5 |
628 | 2024-03-29 04:30:27 | spate | 1 | 28756 | 17 | 0.533 | 53951.2 |
627 | 2024-03-03 20:56:23 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
626 | 2024-02-29 23:21:40 | spate | 1 | 28756 | 17 | 1.626 | 17685.1 |
625 | 2024-02-28 01:28:48 | spate | 2 | 53800 | 236 | 2.893 | 18596.6 |
624 | 2024-02-28 01:28:39 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
623 | 2024-02-03 13:23:53 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
622 | 2024-01-28 22:48:49 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
621 | 2024-01-28 17:25:28 | spate | 1 | 28756 | 17 | 0.970 | 29645.4 |
620 | 2024-01-12 20:30:40 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
619 | 2024-01-04 19:39:04 | spate | 2 | 53800 | 236 | 1.390 | 38705.0 |
618 | 2023-12-21 11:49:58 | spate | 2 | 53800 | 236 | 1.373 | 39184.3 |
617 | 2023-12-21 00:56:39 | spate | 2 | 53800 | 236 | 2.940 | 18299.3 |
616 | 2023-12-08 05:50:21 | spate | 2 | 53800 | 236 | 1.593 | 33772.8 |
615 | 2023-12-04 16:27:12 | spate | 1 | 28756 | 17 | 0.436 | 65954.1 |
614 | 2023-12-04 16:27:11 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
613 | 2023-11-27 17:43:14 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
612 | 2023-11-17 21:46:52 | spate | 2 | 53800 | 236 | 1.593 | 33772.8 |
611 | 2023-11-11 18:16:25 | spate | 2 | 53800 | 236 | 1.563 | 34421.0 |
610 | 2023-11-11 05:29:34 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
609 | 2023-11-07 12:39:42 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
608 | 2023-10-31 10:35:08 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
607 | 2023-10-20 22:43:32 | spate | 1 | 28756 | 17 | 1.140 | 25224.6 |
606 | 2023-10-18 20:48:31 | spate | 1 | 28756 | 17 | 0.436 | 65954.1 |
605 | 2023-10-11 06:55:10 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
604 | 2023-10-06 02:19:01 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
603 | 2023-09-26 07:27:37 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
602 | 2023-09-23 16:20:33 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
601 | 2023-09-22 18:29:24 | spate | 2 | 53800 | 236 | 1.673 | 32157.8 |
600 | 2023-09-16 12:45:56 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
599 | 2023-09-13 14:35:35 | spate | 1 | 28756 | 17 | 0.560 | 51350.0 |
598 | 2023-07-02 15:01:20 | spate | 2 | 53800 | 236 | 1.623 | 33148.5 |
597 | 2023-06-29 07:04:05 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
596 | 2023-05-27 03:24:22 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
595 | 2023-04-08 04:24:49 | spate | 1 | 28756 | 17 | 0.436 | 65954.1 |
594 | 2023-03-25 01:02:42 | spate | 2 | 53800 | 236 | 1.356 | 39675.5 |
593 | 2023-02-10 21:49:39 | spate | 1 | 28756 | 17 | 0.486 | 59168.7 |
592 | 2023-01-29 14:42:47 | spate | 1 | 28756 | 17 | 0.466 | 61708.2 |
591 | 2023-01-17 08:31:01 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
590 | 2022-12-23 11:36:24 | spate | 2 | 53800 | 236 | 1.360 | 39558.8 |
589 | 2022-11-26 06:22:01 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
588 | 2022-10-24 09:53:53 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
587 | 2022-10-20 19:48:07 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
586 | 2022-08-22 10:51:12 | spate | 2 | 53800 | 236 | 1.423 | 37807.4 |
585 | 2022-08-14 18:56:02 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
584 | 2022-07-29 04:31:54 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
583 | 2022-07-20 23:55:13 | spate | 1 | 28756 | 17 | 0.440 | 65354.5 |
582 | 2022-07-18 19:33:38 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
581 | 2022-07-18 17:07:13 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
580 | 2022-07-17 22:41:35 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
579 | 2022-07-03 02:25:52 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
578 | 2022-06-17 03:08:06 | spate | 1 | 28756 | 17 | 0.440 | 65354.5 |
577 | 2022-06-08 22:45:06 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
576 | 2022-06-07 09:09:16 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
575 | 2022-03-24 09:29:43 | spate | 2 | 53800 | 236 | 1.873 | 28724.0 |
574 | 2022-03-20 19:49:57 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
573 | 2022-03-17 09:13:32 | spate | 1 | 28756 | 17 | 0.703 | 40904.7 |
572 | 2022-03-16 04:01:05 | spate | 1 | 28756 | 17 | 0.596 | 48248.3 |
571 | 2021-12-26 09:47:54 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
570 | 2021-12-03 15:28:49 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
569 | 2021-10-29 04:31:26 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
568 | 2021-09-17 11:20:11 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
567 | 2021-08-30 22:34:44 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
566 | 2021-08-27 06:05:47 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
565 | 2021-08-23 22:42:04 | spate | 1 | 28756 | 17 | 0.513 | 56054.6 |
564 | 2021-06-09 22:47:14 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
563 | 2021-05-19 21:22:21 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
562 | 2021-03-19 01:17:13 | spate | 1 | 28756 | 17 | 0.440 | 65354.5 |
561 | 2021-02-17 01:35:54 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
560 | 2021-01-31 10:24:56 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
559 | 2020-12-31 09:06:43 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
558 | 2020-11-17 19:18:13 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
557 | 2020-10-30 23:44:44 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
556 | 2020-10-23 16:41:27 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
555 | 2020-10-21 22:30:58 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
554 | 2020-08-29 13:51:57 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
553 | 2020-08-23 11:32:46 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
552 | 2020-08-06 02:32:39 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
551 | 2020-07-23 17:30:45 | spate | 1 | 28756 | 17 | 0.466 | 61708.2 |
550 | 2020-06-16 04:46:07 | spate | 1 | 28756 | 17 | 0.470 | 61183.0 |
549 | 2020-06-09 15:53:47 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
548 | 2020-05-04 15:45:57 | spate | 1 | 28756 | 17 | 0.483 | 59536.2 |
547 | 2020-03-30 01:45:43 | spate | 1 | 28756 | 17 | 0.733 | 39230.6 |
546 | 2020-03-26 15:00:28 | spate | 1 | 28756 | 17 | 0.530 | 54256.6 |
545 | 2020-03-24 22:49:48 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
544 | 2020-03-23 17:14:31 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |
543 | 2020-03-21 14:29:31 | spate | 1 | 28756 | 17 | 0.516 | 55728.7 |
542 | 2020-03-21 03:59:38 | spate | 1 | 28756 | 17 | 0.513 | 56054.6 |
541 | 2020-03-20 16:32:01 | spate | 1 | 28756 | 17 | 0.453 | 63479.0 |
540 | 2020-03-18 02:06:40 | spate | 1 | 28756 | 17 | 0.500 | 57512.0 |