History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"provider"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
644 | 2025-08-17 21:18:12 | provider | 1 | 82945 | 5 | 3.123 | 26559.4 |
643 | 2025-08-16 21:54:53 | provider | 1 | 82945 | 5 | 3.546 | 23391.1 |
642 | 2025-08-10 16:34:07 | provider | 1 | 82945 | 5 | 3.610 | 22976.5 |
641 | 2025-08-05 04:36:12 | provider | 1 | 82945 | 5 | 5.126 | 16181.2 |
640 | 2025-08-05 04:27:43 | provider | 1 | 82945 | 5 | 3.250 | 25521.5 |
639 | 2025-08-03 18:17:09 | provider | 1 | 82945 | 5 | 4.253 | 19502.7 |
638 | 2025-07-27 12:16:15 | provider | 1 | 82945 | 5 | 4.300 | 19289.5 |
637 | 2025-07-26 21:27:36 | provider | 1 | 82945 | 5 | 3.840 | 21600.3 |
636 | 2025-07-25 03:17:13 | provider | 1 | 82945 | 5 | 3.750 | 22118.7 |
635 | 2025-07-23 20:41:05 | provider | 1 | 82945 | 5 | 7.890 | 10512.7 |
634 | 2025-07-21 03:14:56 | provider | 1 | 82945 | 5 | 1.360 | 60989.0 |
633 | 2025-07-14 11:35:29 | provider | 2 | 121059 | 18 | 21.456 | 5642.2 |
632 | 2025-07-13 14:25:04 | provider | 3 | 146162 | 173 | 7.580 | 19282.6 |
631 | 2025-07-10 18:04:43 | provider | 2 | 121059 | 18 | 16.846 | 7186.2 |
630 | 2025-07-10 09:03:59 | provider | 3 | 146162 | 173 | 42.643 | 3427.6 |
629 | 2025-07-09 01:42:31 | provider | 1 | 82945 | 5 | 1.436 | 57761.1 |
628 | 2025-07-07 09:58:13 | provider | 1 | 82945 | 5 | 4.203 | 19734.7 |
627 | 2025-07-06 18:00:22 | provider | 1 | 82945 | 5 | 2.733 | 30349.4 |
626 | 2025-07-06 15:08:02 | provider | 1 | 82945 | 5 | 5.530 | 14999.1 |
625 | 2025-07-03 01:44:46 | provider | 1 | 82945 | 5 | 7.390 | 11224.0 |
624 | 2025-06-30 04:24:07 | provider | 1 | 82945 | 5 | 7.220 | 11488.2 |
623 | 2025-06-29 03:20:43 | provider | 1 | 82945 | 5 | 2.390 | 34705.0 |
622 | 2025-06-18 11:13:16 | provider | 1 | 82945 | 5 | 7.406 | 11199.7 |
621 | 2025-06-17 04:46:36 | provider | 1 | 82945 | 5 | 2.466 | 33635.4 |
620 | 2025-06-08 02:09:58 | provider | 1 | 82945 | 5 | 7.983 | 10390.2 |
619 | 2025-06-06 21:59:02 | provider | 1 | 82945 | 5 | 2.140 | 38759.3 |
618 | 2025-06-06 21:04:57 | provider | 1 | 82945 | 5 | 3.046 | 27230.8 |
617 | 2025-06-03 15:11:19 | provider | 1 | 82945 | 5 | 7.283 | 11388.9 |
616 | 2025-06-02 09:36:01 | provider | 1 | 82945 | 5 | 5.686 | 14587.6 |
615 | 2025-05-30 03:53:18 | provider | 1 | 82945 | 5 | 6.750 | 12288.1 |
614 | 2025-05-18 11:50:25 | provider | 1 | 82945 | 5 | 8.360 | 9921.7 |
613 | 2025-05-08 10:32:34 | provider | 2 | 121059 | 18 | 18.813 | 6434.9 |
612 | 2025-05-07 01:48:31 | provider | 1 | 82945 | 5 | 1.326 | 62552.8 |
611 | 2025-04-30 11:21:00 | provider | 2 | 121059 | 18 | 12.610 | 9600.2 |
610 | 2025-04-29 04:01:33 | provider | 1 | 82945 | 5 | 4.516 | 18366.9 |
609 | 2025-04-22 13:53:18 | provider | 1 | 82945 | 5 | 1.453 | 57085.3 |
608 | 2025-04-18 10:41:37 | provider | 1 | 82945 | 5 | 3.250 | 25521.5 |
607 | 2025-04-06 14:52:14 | provider | 1 | 82945 | 5 | 4.890 | 16962.2 |
606 | 2025-03-31 03:28:49 | provider | 1 | 82945 | 5 | 5.280 | 15709.3 |
605 | 2025-03-29 15:10:45 | provider | 2 | 121059 | 18 | 23.986 | 5047.1 |
604 | 2025-03-28 11:33:59 | provider | 1 | 82945 | 5 | 3.856 | 21510.6 |
603 | 2025-03-22 15:28:42 | provider | 3 | 146162 | 173 | 54.283 | 2692.6 |
602 | 2025-03-22 10:32:39 | provider | 2 | 121059 | 18 | 28.936 | 4183.7 |
601 | 2025-03-21 17:43:05 | provider | 1 | 82945 | 5 | 9.893 | 8384.2 |
600 | 2025-03-20 15:38:38 | provider | 1 | 82945 | 5 | 8.703 | 9530.6 |
599 | 2025-03-17 23:46:14 | provider | 1 | 82945 | 5 | 3.376 | 24569.0 |
598 | 2025-03-14 16:45:56 | provider | 2 | 121059 | 18 | 17.530 | 6905.8 |
597 | 2025-03-14 16:05:26 | provider | 1 | 82945 | 5 | 1.343 | 61761.0 |
596 | 2025-02-25 04:47:15 | provider | 3 | 146162 | 173 | 36.676 | 3985.2 |
595 | 2025-02-24 18:49:29 | provider | 1 | 82945 | 5 | 6.640 | 12491.7 |
594 | 2025-02-24 13:49:28 | provider | 2 | 121059 | 18 | 13.283 | 9113.8 |
593 | 2025-02-24 12:33:54 | provider | 3 | 146162 | 173 | 13.890 | 10522.8 |
592 | 2025-02-24 04:28:50 | provider | 1 | 82945 | 5 | 1.440 | 57600.7 |
591 | 2025-02-24 04:26:08 | provider | 2 | 121059 | 18 | 18.690 | 6477.2 |
590 | 2025-02-23 11:30:44 | provider | 3 | 146162 | 173 | 40.983 | 3566.4 |
589 | 2025-02-22 11:30:14 | provider | 3 | 146162 | 173 | 52.453 | 2786.5 |
588 | 2025-02-22 11:30:12 | provider | 2 | 121059 | 18 | 20.393 | 5936.3 |
587 | 2025-02-22 11:29:09 | provider | 1 | 82945 | 5 | 7.033 | 11793.7 |
586 | 2025-02-06 03:42:40 | provider | 1 | 82945 | 5 | 9.076 | 9138.9 |
585 | 2025-01-22 19:22:33 | provider | 1 | 82945 | 5 | 1.486 | 55817.6 |
584 | 2025-01-10 02:21:14 | provider | 1 | 82945 | 5 | 5.856 | 14164.1 |
583 | 2025-01-08 14:59:15 | provider | 2 | 121059 | 18 | 3.466 | 34927.6 |
582 | 2025-01-08 14:59:14 | provider | 1 | 82945 | 5 | 1.326 | 62552.8 |
581 | 2025-01-06 17:12:18 | provider | 2 | 121059 | 18 | 3.906 | 30993.1 |
580 | 2025-01-06 17:12:16 | provider | 1 | 82945 | 5 | 1.466 | 56579.1 |
579 | 2025-01-02 18:16:15 | provider | 1 | 82945 | 5 | 3.593 | 23085.2 |
578 | 2024-12-27 00:20:31 | provider | 1 | 82945 | 5 | 5.220 | 15889.8 |
577 | 2024-12-19 12:46:27 | provider | 3 | 146162 | 173 | 35.766 | 4086.6 |
576 | 2024-12-18 08:31:35 | provider | 3 | 146162 | 173 | 44.660 | 3272.8 |
575 | 2024-12-11 12:26:47 | provider | 3 | 146162 | 173 | 35.880 | 4073.6 |
574 | 2024-12-09 13:14:59 | provider | 1 | 82945 | 5 | 6.533 | 12696.3 |
573 | 2024-12-07 11:50:01 | provider | 2 | 121059 | 18 | 3.860 | 31362.4 |
572 | 2024-12-02 20:17:36 | provider | 3 | 146162 | 173 | 44.096 | 3314.6 |
571 | 2024-12-02 20:17:36 | provider | 2 | 121059 | 18 | 18.783 | 6445.1 |
570 | 2024-12-02 20:17:30 | provider | 1 | 82945 | 5 | 3.986 | 20809.1 |
569 | 2024-11-20 02:02:36 | provider | 1 | 82945 | 5 | 6.516 | 12729.4 |
568 | 2024-11-09 07:02:46 | provider | 3 | 146162 | 173 | 6.936 | 21073.0 |
567 | 2024-11-09 07:02:47 | provider | 2 | 121059 | 18 | 3.670 | 32986.1 |
566 | 2024-11-09 06:40:49 | provider | 1 | 82945 | 5 | 1.420 | 58412.0 |
565 | 2024-11-03 12:47:41 | provider | 1 | 82945 | 5 | 1.486 | 55817.6 |
564 | 2024-10-27 10:12:06 | provider | 2 | 121059 | 18 | 14.266 | 8485.8 |
563 | 2024-10-27 02:46:52 | provider | 2 | 121059 | 18 | 19.423 | 6232.8 |
562 | 2024-10-24 11:31:51 | provider | 3 | 146162 | 173 | 37.376 | 3910.6 |
561 | 2024-10-24 11:31:52 | provider | 2 | 121059 | 18 | 17.516 | 6911.3 |
560 | 2024-10-23 19:08:23 | provider | 1 | 82945 | 5 | 7.610 | 10899.5 |
559 | 2024-10-23 19:04:13 | provider | 1 | 82945 | 5 | 6.970 | 11900.3 |
558 | 2024-10-23 18:56:28 | provider | 2 | 121059 | 18 | 13.780 | 8785.1 |
557 | 2024-10-23 18:56:06 | provider | 3 | 146162 | 173 | 19.890 | 7348.5 |
556 | 2024-10-23 18:52:52 | provider | 1 | 82945 | 5 | 6.030 | 13755.4 |
555 | 2024-10-23 18:49:59 | provider | 1 | 82945 | 5 | 10.860 | 7637.7 |
554 | 2024-10-09 23:57:00 | provider | 3 | 146162 | 173 | 41.706 | 3504.6 |
553 | 2024-10-09 11:17:30 | provider | 3 | 146162 | 173 | 33.300 | 4389.2 |
552 | 2024-10-08 11:04:34 | provider | 3 | 146162 | 173 | 52.250 | 2797.4 |
551 | 2024-10-08 11:02:18 | provider | 1 | 82945 | 5 | 8.673 | 9563.6 |
550 | 2024-09-29 18:18:38 | provider | 1 | 82945 | 5 | 8.066 | 10283.3 |
549 | 2024-09-29 10:59:21 | provider | 1 | 82945 | 5 | 4.110 | 20181.3 |
548 | 2024-09-24 10:38:02 | provider | 1 | 82945 | 5 | 9.703 | 8548.4 |
547 | 2024-09-16 14:13:31 | provider | 3 | 146162 | 173 | 37.970 | 3849.4 |
546 | 2024-09-10 03:25:43 | provider | 2 | 121059 | 18 | 13.780 | 8785.1 |
545 | 2024-09-09 16:15:05 | provider | 2 | 121059 | 18 | 34.613 | 3497.5 |