History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"firms"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
625 | 2025-09-02 17:46:21 | firms | 1 | 28756 | 8 | 0.436 | 65954.1 |
624 | 2025-09-01 16:53:03 | firms | 1 | 28756 | 8 | 0.530 | 54256.6 |
623 | 2025-08-27 09:08:02 | firms | 1 | 28756 | 8 | 0.533 | 53951.2 |
622 | 2025-08-19 05:23:50 | firms | 1 | 28756 | 8 | 1.186 | 24246.2 |
621 | 2025-08-14 00:47:20 | firms | 1 | 28756 | 8 | 0.516 | 55728.7 |
620 | 2025-08-09 21:13:34 | firms | 1 | 28756 | 8 | 1.346 | 21364.0 |
619 | 2025-08-06 16:46:39 | firms | 2 | 53800 | 160 | 3.936 | 13668.7 |
618 | 2025-08-05 00:37:40 | firms | 2 | 53800 | 160 | 4.923 | 10928.3 |
617 | 2025-08-04 12:54:01 | firms | 1 | 28756 | 8 | 2.673 | 10757.9 |
616 | 2025-08-04 03:45:40 | firms | 1 | 28756 | 8 | 4.076 | 7055.0 |
615 | 2025-07-30 22:25:04 | firms | 1 | 28756 | 8 | 0.516 | 55728.7 |
614 | 2025-07-30 21:11:07 | firms | 1 | 28756 | 8 | 0.500 | 57512.0 |
613 | 2025-07-27 15:23:24 | firms | 1 | 28756 | 8 | 0.953 | 30174.2 |
612 | 2025-07-24 07:26:32 | firms | 1 | 28756 | 8 | 0.936 | 30722.2 |
611 | 2025-07-22 09:19:50 | firms | 1 | 28756 | 8 | 1.936 | 14853.3 |
610 | 2025-07-16 15:49:30 | firms | 1 | 28756 | 8 | 0.546 | 52666.7 |
609 | 2025-07-12 17:24:36 | firms | 1 | 28756 | 8 | 1.906 | 15087.1 |
608 | 2025-07-11 03:39:56 | firms | 1 | 28756 | 8 | 2.263 | 12707.0 |
607 | 2025-07-07 21:00:31 | firms | 1 | 28756 | 8 | 0.940 | 30591.5 |
606 | 2025-06-20 04:55:36 | firms | 1 | 28756 | 8 | 3.653 | 7871.9 |
605 | 2025-06-13 21:25:06 | firms | 2 | 53800 | 160 | 9.360 | 5747.9 |
604 | 2025-06-12 11:51:02 | firms | 2 | 53800 | 160 | 9.310 | 5778.7 |
603 | 2025-06-05 09:36:24 | firms | 1 | 28756 | 8 | 1.640 | 17534.1 |
602 | 2025-06-04 03:18:50 | firms | 1 | 28756 | 8 | 3.796 | 7575.3 |
601 | 2025-06-01 19:47:58 | firms | 1 | 28756 | 8 | 0.483 | 59536.2 |
600 | 2025-05-31 05:54:35 | firms | 1 | 28756 | 8 | 1.063 | 27051.7 |
599 | 2025-05-30 12:28:18 | firms | 1 | 28756 | 8 | 1.266 | 22714.1 |
598 | 2025-05-19 17:08:02 | firms | 1 | 28756 | 8 | 0.453 | 63479.0 |
597 | 2025-05-12 09:03:01 | firms | 1 | 28756 | 8 | 2.250 | 12780.4 |
596 | 2025-05-07 20:54:40 | firms | 1 | 28756 | 8 | 3.656 | 7865.4 |
595 | 2025-05-07 20:44:58 | firms | 1 | 28756 | 8 | 1.656 | 17364.7 |
594 | 2025-05-07 20:22:33 | firms | 1 | 28756 | 8 | 1.110 | 25906.3 |
593 | 2025-05-06 07:58:36 | firms | 1 | 28756 | 8 | 1.126 | 25538.2 |
592 | 2025-05-05 08:57:10 | firms | 1 | 28756 | 8 | 1.093 | 26309.2 |
591 | 2025-05-03 02:22:25 | firms | 1 | 28756 | 8 | 3.623 | 7937.1 |
590 | 2025-05-02 15:11:29 | firms | 1 | 28756 | 8 | 1.203 | 23903.6 |
589 | 2025-04-14 05:31:20 | firms | 1 | 28756 | 8 | 0.966 | 29768.1 |
588 | 2025-04-09 09:08:04 | firms | 1 | 28756 | 8 | 2.216 | 12976.5 |
587 | 2025-04-07 20:26:09 | firms | 1 | 28756 | 8 | 0.500 | 57512.0 |
586 | 2025-04-02 02:44:11 | firms | 1 | 28756 | 8 | 1.266 | 22714.1 |
585 | 2025-03-31 00:33:21 | firms | 2 | 53800 | 160 | 3.953 | 13609.9 |
584 | 2025-03-29 07:58:04 | firms | 1 | 28756 | 8 | 0.966 | 29768.1 |
583 | 2025-03-20 07:06:57 | firms | 2 | 53800 | 160 | 7.050 | 7631.2 |
582 | 2025-03-15 01:09:02 | firms | 2 | 53800 | 160 | 8.436 | 6377.4 |
581 | 2025-03-14 23:18:25 | firms | 1 | 28756 | 8 | 0.873 | 32939.3 |
580 | 2025-03-12 09:28:17 | firms | 1 | 28756 | 8 | 2.330 | 12341.6 |
579 | 2025-03-09 19:59:29 | firms | 1 | 28756 | 8 | 1.690 | 17015.4 |
578 | 2025-03-07 19:34:05 | firms | 1 | 28756 | 8 | 2.123 | 13545.0 |
577 | 2025-03-04 22:10:49 | firms | 1 | 28756 | 8 | 1.156 | 24875.4 |
576 | 2025-03-01 06:51:28 | firms | 1 | 28756 | 8 | 1.343 | 21411.8 |
575 | 2025-02-26 17:43:42 | firms | 2 | 53800 | 160 | 3.780 | 14232.8 |
574 | 2025-02-26 11:26:06 | firms | 2 | 53800 | 160 | 5.516 | 9753.4 |
573 | 2025-02-26 11:04:05 | firms | 1 | 28756 | 8 | 0.483 | 59536.2 |
572 | 2025-02-17 10:09:34 | firms | 1 | 28756 | 8 | 0.876 | 32826.5 |
571 | 2025-01-29 14:17:06 | firms | 1 | 28756 | 8 | 0.436 | 65954.1 |
570 | 2025-01-26 18:45:41 | firms | 2 | 53800 | 160 | 10.300 | 5223.3 |
569 | 2025-01-26 17:31:21 | firms | 2 | 53800 | 160 | 11.080 | 4855.6 |
568 | 2025-01-26 17:30:35 | firms | 1 | 28756 | 8 | 0.516 | 55728.7 |
567 | 2025-01-06 12:48:35 | firms | 1 | 28756 | 8 | 2.500 | 11502.4 |
566 | 2024-12-30 13:45:24 | firms | 1 | 28756 | 8 | 0.953 | 30174.2 |
565 | 2024-12-28 03:36:32 | firms | 2 | 53800 | 160 | 8.643 | 6224.7 |
564 | 2024-12-27 16:48:59 | firms | 2 | 53800 | 160 | 3.923 | 13714.0 |
563 | 2024-12-27 15:27:21 | firms | 2 | 53800 | 160 | 5.720 | 9405.6 |
562 | 2024-12-27 15:24:25 | firms | 1 | 28756 | 8 | 2.046 | 14054.7 |
561 | 2024-12-27 08:06:41 | firms | 1 | 28756 | 8 | 0.983 | 29253.3 |
560 | 2024-11-29 23:15:33 | firms | 1 | 28756 | 8 | 2.046 | 14054.7 |
559 | 2024-11-27 11:52:36 | firms | 2 | 53800 | 160 | 5.956 | 9032.9 |
558 | 2024-11-27 10:05:29 | firms | 2 | 53800 | 160 | 10.830 | 4967.7 |
557 | 2024-11-27 09:14:01 | firms | 1 | 28756 | 8 | 0.516 | 55728.7 |
556 | 2024-11-26 15:07:25 | firms | 1 | 28756 | 8 | 3.423 | 8400.8 |
555 | 2024-11-07 05:31:18 | firms | 1 | 28756 | 8 | 1.093 | 26309.2 |
554 | 2024-10-30 21:06:00 | firms | 1 | 28756 | 8 | 0.436 | 65954.1 |
553 | 2024-10-27 21:27:27 | firms | 1 | 28756 | 8 | 0.563 | 51076.4 |
552 | 2024-10-27 12:50:46 | firms | 1 | 28756 | 8 | 2.076 | 13851.6 |
551 | 2024-10-27 08:26:54 | firms | 1 | 28756 | 8 | 1.140 | 25224.6 |
550 | 2024-10-07 21:28:21 | firms | 2 | 53800 | 160 | 6.846 | 7858.6 |
549 | 2024-10-07 15:38:29 | firms | 2 | 53800 | 160 | 11.533 | 4664.9 |
548 | 2024-10-07 11:09:19 | firms | 1 | 28756 | 8 | 1.703 | 16885.5 |
547 | 2024-10-04 08:07:02 | firms | 2 | 53800 | 160 | 6.953 | 7737.7 |
546 | 2024-10-03 04:58:09 | firms | 2 | 53800 | 160 | 13.610 | 3953.0 |
545 | 2024-10-03 04:57:51 | firms | 1 | 28756 | 8 | 4.923 | 5841.2 |
544 | 2024-09-30 11:02:50 | firms | 1 | 28756 | 8 | 3.623 | 7937.1 |
543 | 2024-09-27 15:34:10 | firms | 1 | 28756 | 8 | 3.030 | 9490.4 |
542 | 2024-09-06 21:21:17 | firms | 1 | 28756 | 8 | 3.996 | 7196.2 |
541 | 2024-08-31 07:41:01 | firms | 2 | 53800 | 160 | 8.800 | 6113.6 |
540 | 2024-08-31 01:00:48 | firms | 2 | 53800 | 160 | 18.703 | 2876.5 |
539 | 2024-08-31 00:53:28 | firms | 1 | 28756 | 8 | 0.500 | 57512.0 |
538 | 2024-08-30 00:08:19 | firms | 1 | 28756 | 8 | 2.920 | 9847.9 |
537 | 2024-08-28 08:03:36 | firms | 1 | 28756 | 8 | 3.076 | 9348.5 |
536 | 2024-08-19 21:51:51 | firms | 1 | 28756 | 8 | 5.360 | 5364.9 |
535 | 2024-08-09 21:51:23 | firms | 2 | 53800 | 160 | 5.640 | 9539.0 |
534 | 2024-08-09 16:32:07 | firms | 2 | 53800 | 160 | 5.300 | 10150.9 |
533 | 2024-08-09 15:35:26 | firms | 1 | 28756 | 8 | 2.876 | 9998.6 |
532 | 2024-08-04 09:23:24 | firms | 1 | 28756 | 8 | 1.750 | 16432.0 |
531 | 2024-07-30 10:16:08 | firms | 1 | 28756 | 8 | 0.716 | 40162.0 |
530 | 2024-07-29 10:59:42 | firms | 2 | 53800 | 160 | 6.250 | 8608.0 |
529 | 2024-07-29 07:58:06 | firms | 2 | 53800 | 160 | 6.593 | 8160.2 |
528 | 2024-07-29 06:50:28 | firms | 2 | 53800 | 160 | 4.860 | 11070.0 |
527 | 2024-07-29 06:22:46 | firms | 1 | 28756 | 8 | 1.080 | 26625.9 |
526 | 2024-07-28 17:26:11 | firms | 1 | 28756 | 8 | 1.140 | 25224.6 |