History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"customer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
602 | 2025-09-27 16:23:32 | customer | 1 | 82945 | 2 | 1.470 | 56425.2 |
601 | 2025-08-28 04:59:18 | customer | 3 | 146162 | 90 | 7.110 | 20557.2 |
600 | 2025-08-26 20:36:15 | customer | 1 | 82945 | 2 | 1.453 | 57085.3 |
599 | 2025-08-17 05:45:23 | customer | 1 | 82945 | 2 | 7.250 | 11440.7 |
598 | 2025-08-09 07:28:47 | customer | 1 | 82945 | 2 | 6.283 | 13201.5 |
597 | 2025-08-08 07:22:45 | customer | 1 | 82945 | 2 | 1.530 | 54212.4 |
596 | 2025-08-05 02:18:46 | customer | 1 | 82945 | 2 | 4.453 | 18626.8 |
595 | 2025-07-07 08:07:19 | customer | 1 | 82945 | 2 | 6.673 | 12429.9 |
594 | 2025-07-02 07:29:21 | customer | 1 | 82945 | 2 | 5.136 | 16149.7 |
593 | 2025-06-26 01:09:34 | customer | 1 | 82945 | 2 | 4.860 | 17066.9 |
592 | 2025-06-14 07:00:10 | customer | 1 | 82945 | 2 | 6.813 | 12174.5 |
591 | 2025-06-04 06:18:10 | customer | 1 | 82945 | 2 | 6.093 | 13613.2 |
590 | 2025-05-31 07:51:20 | customer | 1 | 82945 | 2 | 5.906 | 14044.2 |
589 | 2025-05-29 07:12:50 | customer | 1 | 82945 | 2 | 7.530 | 11015.3 |
588 | 2025-05-16 15:19:07 | customer | 3 | 146162 | 90 | 33.656 | 4342.8 |
587 | 2025-05-11 06:33:28 | customer | 3 | 146162 | 90 | 7.013 | 20841.6 |
586 | 2025-05-08 04:07:04 | customer | 2 | 121059 | 9 | 24.750 | 4891.3 |
585 | 2025-05-05 07:20:23 | customer | 2 | 121059 | 9 | 3.843 | 31501.2 |
584 | 2025-05-03 23:53:24 | customer | 3 | 146162 | 90 | 37.330 | 3915.4 |
583 | 2025-05-03 23:09:12 | customer | 3 | 146162 | 90 | 35.673 | 4097.3 |
582 | 2025-05-03 17:25:25 | customer | 1 | 82945 | 2 | 1.546 | 53651.4 |
581 | 2025-05-02 05:47:07 | customer | 1 | 82945 | 2 | 6.593 | 12580.8 |
580 | 2025-05-01 06:45:40 | customer | 3 | 146162 | 90 | 41.130 | 3553.7 |
579 | 2025-04-29 00:15:12 | customer | 3 | 146162 | 90 | 45.423 | 3217.8 |
578 | 2025-04-28 05:14:49 | customer | 2 | 121059 | 9 | 9.470 | 12783.4 |
577 | 2025-04-28 01:17:09 | customer | 3 | 146162 | 90 | 35.376 | 4131.7 |
576 | 2025-04-26 07:27:11 | customer | 1 | 82945 | 2 | 6.533 | 12696.3 |
575 | 2025-04-23 07:36:06 | customer | 1 | 82945 | 2 | 7.173 | 11563.5 |
574 | 2025-04-16 00:58:54 | customer | 1 | 82945 | 2 | 6.733 | 12319.2 |
573 | 2025-04-14 00:36:13 | customer | 3 | 146162 | 90 | 37.063 | 3943.6 |
572 | 2025-04-11 10:17:41 | customer | 1 | 82945 | 2 | 6.250 | 13271.2 |
571 | 2025-04-10 19:57:53 | customer | 3 | 146162 | 90 | 9.263 | 15779.1 |
570 | 2025-04-03 06:51:26 | customer | 1 | 82945 | 2 | 1.500 | 55296.7 |
569 | 2025-03-28 07:08:45 | customer | 1 | 82945 | 2 | 3.236 | 25632.0 |
568 | 2025-03-27 19:41:57 | customer | 1 | 82945 | 2 | 7.936 | 10451.7 |
567 | 2025-03-25 23:36:23 | customer | 4 | 161609 | 842 | 62.486 | 2586.3 |
566 | 2025-03-24 22:28:04 | customer | 4 | 161609 | 842 | 63.426 | 2548.0 |
565 | 2025-03-24 15:11:54 | customer | 4 | 161609 | 842 | 36.863 | 4384.0 |
564 | 2025-03-22 09:23:19 | customer | 4 | 161609 | 842 | 63.613 | 2540.5 |
563 | 2025-03-22 09:22:29 | customer | 2 | 121059 | 9 | 18.330 | 6604.4 |
562 | 2025-03-21 09:28:08 | customer | 1 | 82945 | 2 | 3.203 | 25896.0 |
561 | 2025-03-20 20:25:59 | customer | 3 | 146162 | 90 | 7.440 | 19645.4 |
560 | 2025-03-15 02:05:14 | customer | 1 | 82945 | 2 | 2.360 | 35146.2 |
559 | 2025-03-13 21:46:54 | customer | 3 | 146162 | 90 | 37.676 | 3879.4 |
558 | 2025-03-13 21:46:48 | customer | 2 | 121059 | 9 | 19.643 | 6163.0 |
557 | 2025-03-11 10:33:25 | customer | 3 | 146162 | 90 | 49.563 | 2949.0 |
556 | 2025-03-11 10:33:25 | customer | 2 | 121059 | 9 | 17.843 | 6784.7 |
555 | 2025-03-08 02:59:47 | customer | 1 | 82945 | 2 | 7.796 | 10639.4 |
554 | 2025-03-05 08:36:52 | customer | 3 | 146162 | 90 | 44.300 | 3299.4 |
553 | 2025-03-05 05:15:24 | customer | 3 | 146162 | 90 | 38.970 | 3750.6 |
552 | 2025-03-05 05:15:25 | customer | 3 | 146162 | 90 | 29.596 | 4938.6 |
551 | 2025-03-05 05:15:23 | customer | 2 | 121059 | 9 | 15.423 | 7849.3 |
550 | 2025-03-05 05:15:33 | customer | 1 | 82945 | 2 | 3.513 | 23610.9 |
549 | 2025-03-04 23:09:54 | customer | 3 | 146162 | 90 | 33.986 | 4300.7 |
548 | 2025-03-03 12:42:05 | customer | 3 | 146162 | 90 | 34.406 | 4248.2 |
547 | 2025-02-22 21:53:53 | customer | 3 | 146162 | 90 | 49.333 | 2962.8 |
546 | 2025-02-10 09:12:36 | customer | 3 | 146162 | 90 | 29.546 | 4946.9 |
545 | 2025-02-08 08:22:24 | customer | 1 | 82945 | 2 | 6.546 | 12671.1 |
544 | 2025-02-07 09:32:15 | customer | 1 | 82945 | 2 | 10.623 | 7808.1 |
543 | 2025-02-07 09:01:35 | customer | 2 | 121059 | 9 | 3.906 | 30993.1 |
542 | 2025-02-05 20:52:09 | customer | 2 | 121059 | 9 | 7.580 | 15970.8 |
541 | 2025-02-04 16:16:27 | customer | 3 | 146162 | 90 | 31.300 | 4669.7 |
540 | 2025-02-04 16:16:20 | customer | 2 | 121059 | 9 | 14.326 | 8450.3 |
539 | 2025-02-04 16:16:10 | customer | 1 | 82945 | 2 | 5.376 | 15428.8 |
538 | 2025-02-01 05:35:57 | customer | 1 | 82945 | 2 | 10.140 | 8180.0 |
537 | 2025-02-01 02:29:41 | customer | 3 | 146162 | 90 | 32.973 | 4432.8 |
536 | 2025-01-29 17:58:02 | customer | 3 | 146162 | 90 | 35.430 | 4125.4 |
535 | 2025-01-29 10:41:55 | customer | 3 | 146162 | 90 | 6.203 | 23563.1 |
534 | 2025-01-15 04:53:54 | customer | 3 | 146162 | 90 | 16.783 | 8708.9 |
533 | 2025-01-11 09:04:55 | customer | 3 | 146162 | 90 | 42.233 | 3460.8 |
532 | 2025-01-06 22:54:59 | customer | 1 | 82945 | 2 | 6.173 | 13436.7 |
531 | 2025-01-04 21:54:09 | customer | 4 | 161609 | 842 | 34.550 | 4677.5 |
530 | 2025-01-02 21:58:39 | customer | 4 | 161609 | 842 | 36.346 | 4446.4 |
529 | 2025-01-01 04:55:57 | customer | 4 | 161609 | 842 | 60.190 | 2685.0 |
528 | 2024-12-30 21:49:42 | customer | 4 | 161609 | 842 | 22.470 | 7192.2 |
527 | 2024-12-30 21:49:42 | customer | 1 | 82945 | 2 | 2.860 | 29001.7 |
526 | 2024-12-29 11:25:15 | customer | 3 | 146162 | 90 | 26.910 | 5431.5 |
525 | 2024-12-29 06:36:12 | customer | 3 | 146162 | 90 | 17.126 | 8534.5 |
524 | 2024-12-29 00:08:41 | customer | 3 | 146162 | 90 | 38.956 | 3752.0 |
523 | 2024-12-21 08:49:36 | customer | 1 | 82945 | 2 | 1.436 | 57761.1 |
522 | 2024-12-15 12:24:23 | customer | 3 | 146162 | 90 | 38.000 | 3846.4 |
521 | 2024-12-07 14:41:17 | customer | 1 | 82945 | 2 | 4.610 | 17992.4 |
520 | 2024-12-07 10:30:15 | customer | 3 | 146162 | 90 | 45.003 | 3247.8 |
519 | 2024-12-06 02:47:11 | customer | 3 | 146162 | 90 | 49.760 | 2937.3 |
518 | 2024-12-03 10:04:36 | customer | 4 | 161609 | 842 | 65.440 | 2469.6 |
517 | 2024-12-03 06:51:21 | customer | 2 | 121059 | 9 | 8.970 | 13496.0 |
516 | 2024-11-28 03:01:22 | customer | 4 | 161609 | 842 | 12.873 | 12554.1 |
515 | 2024-11-28 01:03:19 | customer | 4 | 161609 | 842 | 45.003 | 3591.1 |
514 | 2024-11-25 15:50:21 | customer | 3 | 146162 | 90 | 13.063 | 11189.0 |
513 | 2024-11-25 15:50:25 | customer | 2 | 121059 | 9 | 7.123 | 16995.5 |
512 | 2024-11-25 10:33:11 | customer | 2 | 121059 | 9 | 3.373 | 35890.6 |
511 | 2024-11-24 01:26:19 | customer | 3 | 146162 | 90 | 35.376 | 4131.7 |
510 | 2024-11-22 13:03:23 | customer | 1 | 82945 | 2 | 7.296 | 11368.6 |
509 | 2024-11-19 12:16:52 | customer | 1 | 82945 | 2 | 10.030 | 8269.7 |
508 | 2024-11-08 02:32:28 | customer | 3 | 146162 | 90 | 38.126 | 3833.7 |
507 | 2024-11-07 10:50:11 | customer | 3 | 146162 | 90 | 13.390 | 10915.8 |
506 | 2024-11-04 20:35:18 | customer | 3 | 146162 | 90 | 7.580 | 19282.6 |
505 | 2024-11-04 20:35:19 | customer | 2 | 121059 | 9 | 3.876 | 31233.0 |
504 | 2024-11-04 20:35:17 | customer | 1 | 82945 | 2 | 1.343 | 61761.0 |
503 | 2024-11-03 01:10:28 | customer | 4 | 161609 | 842 | 61.253 | 2638.4 |