History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sparse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
619 | 2024-12-19 13:00:06 | sparse | 1 | 48755 | 7 | 3.656 | 13335.6 |
618 | 2024-11-27 22:03:41 | sparse | 1 | 48755 | 7 | 3.483 | 13998.0 |
617 | 2024-11-19 06:24:35 | sparse | 1 | 48755 | 7 | 1.720 | 28345.9 |
616 | 2024-11-12 05:27:17 | sparse | 1 | 48755 | 7 | 0.860 | 56691.9 |
615 | 2024-11-10 01:47:13 | sparse | 2 | 82551 | 101 | 8.843 | 9335.2 |
614 | 2024-11-09 12:49:55 | sparse | 2 | 82551 | 101 | 9.830 | 8397.9 |
613 | 2024-11-09 09:26:43 | sparse | 1 | 48755 | 7 | 0.860 | 56691.9 |
612 | 2024-10-28 20:53:57 | sparse | 1 | 48755 | 7 | 2.046 | 23829.4 |
611 | 2024-10-27 05:27:39 | sparse | 1 | 48755 | 7 | 6.046 | 8064.0 |
610 | 2024-10-26 12:04:57 | sparse | 1 | 48755 | 7 | 6.313 | 7723.0 |
609 | 2024-10-20 10:09:17 | sparse | 1 | 48755 | 7 | 4.063 | 11999.8 |
608 | 2024-10-20 04:01:25 | sparse | 1 | 48755 | 7 | 4.360 | 11182.3 |
607 | 2024-09-30 01:10:30 | sparse | 1 | 48755 | 7 | 8.640 | 5642.9 |
606 | 2024-09-28 16:57:38 | sparse | 1 | 48755 | 7 | 6.420 | 7594.2 |
605 | 2024-09-09 02:34:59 | sparse | 1 | 48755 | 7 | 7.250 | 6724.8 |
604 | 2024-09-04 22:50:57 | sparse | 1 | 48755 | 7 | 3.220 | 15141.3 |
603 | 2024-09-02 06:15:39 | sparse | 1 | 48755 | 7 | 4.640 | 10507.5 |
602 | 2024-08-30 23:44:55 | sparse | 1 | 48755 | 7 | 3.736 | 13050.1 |
601 | 2024-08-29 07:41:28 | sparse | 1 | 48755 | 7 | 5.876 | 8297.3 |
600 | 2024-08-17 20:27:39 | sparse | 1 | 48755 | 7 | 3.313 | 14716.3 |
599 | 2024-08-14 05:12:58 | sparse | 1 | 48755 | 7 | 7.703 | 6329.4 |
598 | 2024-08-11 08:10:56 | sparse | 1 | 48755 | 7 | 2.970 | 16415.8 |
597 | 2024-08-11 08:08:57 | sparse | 1 | 48755 | 7 | 3.156 | 15448.4 |
596 | 2024-07-30 16:02:19 | sparse | 1 | 48755 | 7 | 4.266 | 11428.7 |
595 | 2024-07-30 14:12:42 | sparse | 1 | 48755 | 7 | 1.500 | 32503.3 |
594 | 2024-07-30 05:36:06 | sparse | 1 | 48755 | 7 | 1.876 | 25988.8 |
593 | 2024-07-30 05:34:32 | sparse | 2 | 82551 | 101 | 8.220 | 10042.7 |
592 | 2024-07-30 01:57:26 | sparse | 2 | 82551 | 101 | 4.373 | 18877.4 |
591 | 2024-07-30 01:56:52 | sparse | 1 | 48755 | 7 | 1.796 | 27146.4 |
590 | 2024-07-21 09:45:24 | sparse | 1 | 48755 | 7 | 2.530 | 19270.8 |
589 | 2024-07-11 07:20:53 | sparse | 1 | 48755 | 7 | 7.266 | 6710.0 |
588 | 2024-07-04 23:35:58 | sparse | 1 | 48755 | 7 | 3.126 | 15596.6 |
587 | 2024-07-04 22:58:51 | sparse | 1 | 48755 | 7 | 4.436 | 10990.8 |
586 | 2024-07-04 22:58:47 | sparse | 1 | 48755 | 7 | 3.403 | 14327.1 |
585 | 2024-07-04 22:45:37 | sparse | 1 | 48755 | 7 | 3.763 | 12956.4 |
584 | 2024-06-30 01:12:43 | sparse | 1 | 48755 | 7 | 1.593 | 30605.8 |
583 | 2024-06-29 23:19:42 | sparse | 1 | 48755 | 7 | 2.890 | 16870.2 |
582 | 2024-06-29 21:18:01 | sparse | 1 | 48755 | 7 | 2.953 | 16510.3 |
581 | 2024-06-28 19:21:53 | sparse | 2 | 82551 | 101 | 10.250 | 8053.8 |
580 | 2024-06-28 19:21:21 | sparse | 1 | 48755 | 7 | 3.423 | 14243.4 |
579 | 2024-05-29 15:52:28 | sparse | 1 | 48755 | 7 | 2.453 | 19875.7 |
578 | 2024-05-27 22:02:12 | sparse | 2 | 82551 | 101 | 9.656 | 8549.2 |
577 | 2024-05-27 22:01:57 | sparse | 1 | 48755 | 7 | 4.546 | 10724.8 |
576 | 2024-05-27 12:16:13 | sparse | 1 | 48755 | 7 | 1.123 | 43415.0 |
575 | 2024-05-12 10:09:16 | sparse | 2 | 82551 | 101 | 2.516 | 32810.4 |
574 | 2024-05-12 10:09:12 | sparse | 1 | 48755 | 7 | 0.830 | 58741.0 |
573 | 2024-05-12 10:09:06 | sparse | 2 | 82551 | 101 | 2.470 | 33421.5 |
572 | 2024-05-11 12:07:24 | sparse | 2 | 82551 | 101 | 7.626 | 10824.9 |
571 | 2024-04-29 20:21:29 | sparse | 1 | 48755 | 7 | 0.800 | 60943.8 |
570 | 2024-04-27 23:24:03 | sparse | 1 | 48755 | 7 | 2.453 | 19875.7 |
569 | 2024-04-20 18:45:49 | sparse | 1 | 48755 | 7 | 3.093 | 15763.0 |
568 | 2024-04-03 11:22:15 | sparse | 2 | 82551 | 101 | 5.050 | 16346.7 |
567 | 2024-04-03 11:22:12 | sparse | 1 | 48755 | 7 | 1.013 | 48129.3 |
566 | 2024-04-03 11:22:00 | sparse | 2 | 82551 | 101 | 6.000 | 13758.5 |
565 | 2024-04-03 11:21:53 | sparse | 1 | 48755 | 7 | 2.093 | 23294.3 |
564 | 2024-03-31 00:05:07 | sparse | 1 | 48755 | 7 | 1.143 | 42655.3 |
563 | 2024-03-29 06:27:23 | sparse | 1 | 48755 | 7 | 2.846 | 17131.1 |
562 | 2024-03-20 18:35:16 | sparse | 1 | 48755 | 7 | 1.466 | 33257.2 |
561 | 2024-03-04 07:36:58 | sparse | 1 | 48755 | 7 | 2.563 | 19022.6 |
560 | 2024-03-04 07:36:57 | sparse | 2 | 82551 | 101 | 2.860 | 28864.0 |
559 | 2024-02-28 08:02:39 | sparse | 2 | 82551 | 101 | 2.813 | 29346.2 |
558 | 2024-02-28 04:52:15 | sparse | 2 | 82551 | 101 | 6.173 | 13372.9 |
557 | 2024-02-28 01:56:16 | sparse | 2 | 82551 | 101 | 4.296 | 19215.8 |
556 | 2024-02-28 01:56:02 | sparse | 1 | 48755 | 7 | 1.063 | 45865.5 |
555 | 2024-02-19 23:07:22 | sparse | 2 | 82551 | 101 | 7.453 | 11076.2 |
554 | 2024-02-19 12:50:19 | sparse | 1 | 48755 | 7 | 0.813 | 59969.2 |
553 | 2024-01-16 17:27:52 | sparse | 1 | 48755 | 7 | 0.830 | 58741.0 |
552 | 2024-01-16 01:41:22 | sparse | 2 | 82551 | 101 | 2.126 | 38829.3 |
551 | 2024-01-13 15:37:54 | sparse | 2 | 82551 | 101 | 2.106 | 39198.0 |
550 | 2024-01-05 20:29:35 | sparse | 1 | 48755 | 7 | 0.856 | 56956.8 |
549 | 2023-12-21 14:33:53 | sparse | 1 | 48755 | 7 | 0.763 | 63899.1 |
548 | 2023-11-20 08:40:41 | sparse | 1 | 48755 | 7 | 0.843 | 57835.1 |
547 | 2023-11-17 05:59:42 | sparse | 1 | 48755 | 7 | 0.766 | 63648.8 |
546 | 2023-11-16 04:15:06 | sparse | 1 | 48755 | 7 | 0.766 | 63648.8 |
545 | 2023-11-04 14:09:30 | sparse | 1 | 48755 | 7 | 0.856 | 56956.8 |
544 | 2023-10-22 23:22:21 | sparse | 1 | 48755 | 7 | 0.763 | 63899.1 |
543 | 2023-10-19 18:51:23 | sparse | 1 | 48755 | 7 | 0.766 | 63648.8 |
542 | 2023-10-11 06:51:54 | sparse | 1 | 48755 | 7 | 0.813 | 59969.2 |
541 | 2023-10-08 17:26:09 | sparse | 1 | 48755 | 7 | 0.906 | 53813.5 |
540 | 2023-10-08 16:25:37 | sparse | 1 | 48755 | 7 | 0.813 | 59969.2 |
539 | 2023-09-26 19:25:07 | sparse | 1 | 48755 | 7 | 0.876 | 55656.4 |
538 | 2023-09-12 10:50:31 | sparse | 1 | 48755 | 7 | 0.813 | 59969.2 |
537 | 2023-08-20 18:42:39 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
536 | 2023-08-03 23:02:08 | sparse | 1 | 48755 | 7 | 0.766 | 63648.8 |
535 | 2023-04-30 18:18:24 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
534 | 2023-04-22 01:18:44 | sparse | 1 | 48755 | 7 | 0.736 | 66243.2 |
533 | 2023-02-18 00:47:15 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
532 | 2023-01-17 08:31:30 | sparse | 1 | 48755 | 7 | 0.843 | 57835.1 |
531 | 2022-12-22 02:17:59 | sparse | 1 | 48755 | 7 | 0.860 | 56691.9 |
530 | 2022-12-15 09:35:56 | sparse | 1 | 48755 | 7 | 0.826 | 59025.4 |
529 | 2022-08-22 19:40:02 | sparse | 1 | 48755 | 7 | 0.843 | 57835.1 |
528 | 2022-08-11 22:36:31 | sparse | 1 | 48755 | 7 | 0.846 | 57630.0 |
527 | 2022-08-06 10:41:44 | sparse | 1 | 48755 | 7 | 0.830 | 58741.0 |
526 | 2022-07-29 04:01:42 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
525 | 2022-07-18 19:33:22 | sparse | 1 | 48755 | 7 | 0.796 | 61250.0 |
524 | 2022-07-17 22:40:56 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
523 | 2022-07-03 02:24:55 | sparse | 1 | 48755 | 7 | 1.013 | 48129.3 |
522 | 2022-06-08 22:44:33 | sparse | 1 | 48755 | 7 | 0.873 | 55847.7 |
521 | 2022-06-07 04:16:28 | sparse | 1 | 48755 | 7 | 0.750 | 65006.7 |
520 | 2022-04-07 10:52:42 | sparse | 1 | 48755 | 7 | 0.796 | 61250.0 |