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 |
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 |
544 | 2024-09-07 22:30:53 | provider | 2 | 121059 | 18 | 13.346 | 9070.8 |
543 | 2024-09-06 20:30:40 | provider | 2 | 121059 | 18 | 36.846 | 3285.5 |
542 | 2024-09-06 20:21:09 | provider | 3 | 146162 | 173 | 6.563 | 22270.6 |
541 | 2024-09-05 11:32:41 | provider | 2 | 121059 | 18 | 20.516 | 5900.7 |
540 | 2024-09-05 00:42:09 | provider | 3 | 146162 | 173 | 67.143 | 2176.9 |
539 | 2024-09-05 00:42:10 | provider | 2 | 121059 | 18 | 42.176 | 2870.3 |
538 | 2024-09-04 23:41:33 | provider | 1 | 82945 | 5 | 1.530 | 54212.4 |
537 | 2024-09-04 10:52:57 | provider | 1 | 82945 | 5 | 10.033 | 8267.2 |
536 | 2024-08-22 09:02:52 | provider | 1 | 82945 | 5 | 12.800 | 6480.1 |
535 | 2024-08-02 23:25:23 | provider | 1 | 82945 | 5 | 2.686 | 30880.5 |
534 | 2024-08-01 00:23:26 | provider | 1 | 82945 | 5 | 6.643 | 12486.1 |
533 | 2024-07-11 16:29:02 | provider | 1 | 82945 | 5 | 3.203 | 25896.0 |
532 | 2024-07-11 03:46:19 | provider | 1 | 82945 | 5 | 2.500 | 33178.0 |
531 | 2024-07-07 05:27:50 | provider | 1 | 82945 | 5 | 6.066 | 13673.8 |
530 | 2024-07-03 08:02:06 | provider | 1 | 82945 | 5 | 5.830 | 14227.3 |
529 | 2024-06-25 21:48:33 | provider | 1 | 82945 | 5 | 5.233 | 15850.4 |
528 | 2024-06-05 23:19:28 | provider | 1 | 82945 | 5 | 3.813 | 21753.2 |
527 | 2024-06-04 07:07:47 | provider | 2 | 121059 | 18 | 3.906 | 30993.1 |
526 | 2024-06-04 07:04:19 | provider | 3 | 146162 | 173 | 6.986 | 20922.1 |
525 | 2024-06-03 14:58:16 | provider | 3 | 146162 | 173 | 8.093 | 18060.3 |
524 | 2024-06-03 14:58:12 | provider | 2 | 121059 | 18 | 8.280 | 14620.7 |
523 | 2024-06-03 11:02:19 | provider | 3 | 146162 | 173 | 7.813 | 18707.5 |
522 | 2024-06-03 02:19:51 | provider | 1 | 82945 | 5 | 1.843 | 45005.4 |
521 | 2024-06-03 00:07:50 | provider | 1 | 82945 | 5 | 6.170 | 13443.3 |
520 | 2024-06-02 23:10:26 | provider | 2 | 121059 | 18 | 12.550 | 9646.1 |
519 | 2024-06-02 22:06:36 | provider | 2 | 121059 | 18 | 3.783 | 32000.8 |
518 | 2024-06-02 21:56:40 | provider | 3 | 146162 | 173 | 8.360 | 17483.5 |
517 | 2024-06-02 10:01:00 | provider | 2 | 121059 | 18 | 3.780 | 32026.2 |
516 | 2024-06-02 10:00:48 | provider | 3 | 146162 | 173 | 8.876 | 16467.1 |
515 | 2024-06-02 04:07:00 | provider | 3 | 146162 | 173 | 42.923 | 3405.2 |
514 | 2024-06-02 04:06:58 | provider | 2 | 121059 | 18 | 18.360 | 6593.6 |
513 | 2024-06-02 01:28:21 | provider | 1 | 82945 | 5 | 1.546 | 53651.4 |
512 | 2024-05-27 13:07:12 | provider | 1 | 82945 | 5 | 2.000 | 41472.5 |
511 | 2024-05-03 03:58:06 | provider | 1 | 82945 | 5 | 2.890 | 28700.7 |