History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"detention"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
667 | 2025-04-29 06:30:25 | detention | 3 | 148641 | 101 | 56.846 | 2614.8 |
666 | 2025-04-27 23:33:24 | detention | 3 | 148641 | 101 | 30.486 | 4875.7 |
665 | 2025-04-27 03:10:28 | detention | 3 | 148641 | 101 | 7.330 | 20278.4 |
664 | 2025-04-27 01:31:04 | detention | 3 | 148641 | 101 | 6.626 | 22433.0 |
663 | 2025-04-25 15:45:21 | detention | 1 | 81242 | 4 | 1.423 | 57092.1 |
662 | 2025-04-23 11:00:06 | detention | 1 | 81242 | 4 | 3.483 | 23325.3 |
661 | 2025-04-23 07:41:26 | detention | 1 | 81242 | 4 | 7.263 | 11185.7 |
660 | 2025-04-20 17:55:20 | detention | 1 | 81242 | 4 | 1.453 | 55913.3 |
659 | 2025-04-19 10:42:07 | detention | 1 | 81242 | 4 | 1.483 | 54782.2 |
658 | 2025-04-15 20:49:41 | detention | 1 | 81242 | 4 | 4.876 | 16661.6 |
657 | 2025-03-23 17:53:31 | detention | 1 | 81242 | 4 | 7.296 | 11135.1 |
656 | 2025-03-20 17:18:02 | detention | 1 | 81242 | 4 | 10.173 | 7986.0 |
655 | 2025-03-14 11:26:05 | detention | 1 | 81242 | 4 | 2.736 | 29693.7 |
654 | 2025-03-01 15:33:59 | detention | 3 | 148641 | 101 | 46.550 | 3193.1 |
653 | 2025-02-28 16:31:18 | detention | 3 | 148641 | 101 | 24.520 | 6062.0 |
652 | 2025-02-28 12:29:49 | detention | 3 | 148641 | 101 | 38.766 | 3834.3 |
651 | 2025-02-25 16:37:28 | detention | 1 | 81242 | 4 | 1.360 | 59736.8 |
650 | 2025-02-20 10:32:53 | detention | 2 | 121436 | 17 | 27.343 | 4441.2 |
649 | 2025-02-20 10:32:01 | detention | 1 | 81242 | 4 | 6.436 | 12623.1 |
648 | 2025-02-15 16:59:03 | detention | 2 | 121436 | 17 | 20.656 | 5879.0 |
647 | 2025-02-15 16:59:00 | detention | 1 | 81242 | 4 | 6.563 | 12378.8 |
646 | 2025-02-11 06:23:47 | detention | 3 | 148641 | 101 | 54.520 | 2726.4 |
645 | 2025-02-08 21:44:37 | detention | 2 | 121436 | 17 | 18.633 | 6517.3 |
644 | 2025-02-08 21:43:19 | detention | 1 | 81242 | 4 | 6.780 | 11982.6 |
643 | 2025-01-22 09:38:54 | detention | 3 | 148641 | 101 | 37.046 | 4012.3 |
642 | 2025-01-22 03:38:59 | detention | 3 | 148641 | 101 | 34.643 | 4290.7 |
641 | 2025-01-21 11:14:18 | detention | 3 | 148641 | 101 | 36.766 | 4042.9 |
640 | 2025-01-21 08:24:42 | detention | 2 | 121436 | 17 | 20.123 | 6034.7 |
639 | 2025-01-21 08:22:25 | detention | 3 | 148641 | 101 | 36.470 | 4075.7 |
638 | 2025-01-21 08:21:54 | detention | 1 | 81242 | 4 | 5.360 | 15157.1 |
637 | 2025-01-15 14:33:51 | detention | 1 | 81242 | 4 | 3.406 | 23852.6 |
636 | 2025-01-14 13:36:29 | detention | 1 | 81242 | 4 | 3.173 | 25604.2 |
635 | 2025-01-09 12:10:09 | detention | 2 | 121436 | 17 | 19.410 | 6256.4 |
634 | 2025-01-09 08:56:32 | detention | 2 | 121436 | 17 | 15.283 | 7945.8 |
633 | 2025-01-09 08:56:08 | detention | 1 | 81242 | 4 | 1.610 | 50460.9 |
632 | 2024-12-18 22:04:11 | detention | 3 | 148641 | 101 | 50.283 | 2956.1 |
631 | 2024-12-18 22:04:01 | detention | 2 | 121436 | 17 | 17.813 | 6817.3 |
630 | 2024-12-18 13:36:26 | detention | 3 | 148641 | 101 | 30.690 | 4843.3 |
629 | 2024-12-16 13:47:46 | detention | 3 | 148641 | 101 | 17.390 | 8547.5 |
628 | 2024-12-16 13:47:45 | detention | 2 | 121436 | 17 | 9.016 | 13468.9 |
627 | 2024-12-16 13:47:35 | detention | 1 | 81242 | 4 | 4.250 | 19115.8 |
626 | 2024-12-16 09:28:14 | detention | 1 | 81242 | 4 | 9.423 | 8621.7 |
625 | 2024-12-10 01:31:53 | detention | 1 | 81242 | 4 | 2.653 | 30622.7 |
624 | 2024-12-09 04:11:49 | detention | 1 | 81242 | 4 | 5.153 | 15766.0 |
623 | 2024-11-16 05:53:16 | detention | 3 | 148641 | 101 | 37.330 | 3981.8 |
622 | 2024-11-12 15:36:45 | detention | 3 | 148641 | 101 | 36.143 | 4112.6 |
621 | 2024-11-11 21:43:31 | detention | 3 | 148641 | 101 | 27.940 | 5320.0 |
620 | 2024-11-11 21:19:48 | detention | 1 | 81242 | 4 | 3.610 | 22504.7 |
619 | 2024-11-02 01:50:46 | detention | 2 | 121436 | 17 | 25.003 | 4856.9 |
618 | 2024-11-02 01:50:48 | detention | 2 | 121436 | 17 | 14.690 | 8266.6 |
617 | 2024-11-02 01:48:09 | detention | 1 | 81242 | 4 | 1.420 | 57212.7 |
616 | 2024-10-26 21:21:46 | detention | 1 | 81242 | 4 | 6.346 | 12802.1 |
615 | 2024-10-09 13:03:22 | detention | 1 | 81242 | 4 | 6.656 | 12205.8 |
614 | 2024-10-02 03:42:08 | detention | 2 | 121436 | 17 | 39.270 | 3092.3 |
613 | 2024-10-02 03:41:57 | detention | 3 | 148641 | 101 | 41.050 | 3621.0 |
612 | 2024-10-02 03:40:34 | detention | 1 | 81242 | 4 | 5.720 | 14203.1 |
611 | 2024-09-29 10:56:51 | detention | 2 | 121436 | 17 | 23.780 | 5106.6 |
610 | 2024-09-29 10:56:00 | detention | 1 | 81242 | 4 | 14.830 | 5478.2 |
609 | 2024-09-23 18:33:15 | detention | 3 | 148641 | 101 | 58.676 | 2533.3 |
608 | 2024-09-22 22:28:18 | detention | 1 | 81242 | 4 | 10.280 | 7902.9 |
607 | 2024-09-18 20:10:54 | detention | 3 | 148641 | 101 | 58.363 | 2546.8 |
606 | 2024-09-18 14:56:28 | detention | 3 | 148641 | 101 | 52.330 | 2840.5 |
605 | 2024-09-06 18:22:31 | detention | 3 | 148641 | 101 | 56.956 | 2609.8 |
604 | 2024-09-06 01:03:42 | detention | 1 | 81242 | 4 | 9.016 | 9010.9 |
603 | 2024-09-01 08:50:23 | detention | 3 | 148641 | 101 | 33.673 | 4414.2 |
602 | 2024-08-25 05:38:05 | detention | 3 | 148641 | 101 | 70.643 | 2104.1 |
601 | 2024-08-24 10:35:47 | detention | 3 | 148641 | 101 | 88.846 | 1673.0 |
600 | 2024-08-21 22:19:38 | detention | 3 | 148641 | 101 | 43.656 | 3404.8 |
599 | 2024-08-21 22:19:48 | detention | 2 | 121436 | 17 | 28.216 | 4303.8 |
598 | 2024-08-19 08:07:11 | detention | 1 | 81242 | 4 | 2.846 | 28546.0 |
597 | 2024-07-31 14:10:59 | detention | 1 | 81242 | 4 | 5.093 | 15951.7 |
596 | 2024-07-29 17:06:44 | detention | 1 | 81242 | 4 | 5.170 | 15714.1 |
595 | 2024-07-21 05:54:05 | detention | 1 | 81242 | 4 | 3.923 | 20709.2 |
594 | 2024-07-18 01:05:31 | detention | 1 | 81242 | 4 | 6.390 | 12713.9 |
593 | 2024-07-18 01:04:37 | detention | 2 | 121436 | 17 | 18.936 | 6413.0 |
592 | 2024-07-17 22:24:53 | detention | 2 | 121436 | 17 | 13.500 | 8995.3 |
591 | 2024-07-17 22:22:25 | detention | 1 | 81242 | 4 | 1.423 | 57092.1 |
590 | 2024-07-17 21:00:24 | detention | 3 | 148641 | 101 | 24.550 | 6054.6 |
589 | 2024-07-17 19:36:44 | detention | 1 | 81242 | 4 | 3.170 | 25628.4 |
588 | 2024-07-17 03:53:45 | detention | 3 | 148641 | 101 | 13.873 | 10714.4 |
587 | 2024-07-17 00:51:25 | detention | 3 | 148641 | 101 | 39.346 | 3777.8 |
586 | 2024-07-16 07:11:11 | detention | 3 | 148641 | 101 | 38.893 | 3821.8 |
585 | 2024-07-16 07:11:11 | detention | 2 | 121436 | 17 | 21.516 | 5644.0 |
584 | 2024-07-16 07:10:16 | detention | 1 | 81242 | 4 | 7.216 | 11258.6 |
583 | 2024-07-06 14:23:55 | detention | 3 | 148641 | 101 | 48.126 | 3088.6 |
582 | 2024-07-06 01:03:30 | detention | 1 | 81242 | 4 | 5.940 | 13677.1 |
581 | 2024-07-03 08:53:04 | detention | 3 | 148641 | 101 | 41.753 | 3560.0 |
580 | 2024-07-01 21:52:33 | detention | 3 | 148641 | 101 | 34.346 | 4327.8 |
579 | 2024-07-01 21:52:32 | detention | 2 | 121436 | 17 | 13.763 | 8823.4 |
578 | 2024-06-23 01:51:52 | detention | 1 | 81242 | 4 | 9.266 | 8767.8 |
577 | 2024-06-15 05:50:33 | detention | 3 | 148641 | 101 | 16.610 | 8948.9 |
576 | 2024-06-12 01:54:58 | detention | 3 | 148641 | 101 | 17.173 | 8655.5 |
575 | 2024-06-11 19:23:23 | detention | 3 | 148641 | 101 | 32.316 | 4599.6 |
574 | 2024-06-10 15:23:22 | detention | 3 | 148641 | 101 | 31.536 | 4713.4 |
573 | 2024-06-10 15:23:21 | detention | 2 | 121436 | 17 | 21.313 | 5697.7 |
572 | 2024-06-10 15:21:53 | detention | 1 | 81242 | 4 | 5.233 | 15524.9 |
571 | 2024-06-07 07:15:15 | detention | 1 | 81242 | 4 | 4.063 | 19995.6 |
570 | 2024-06-02 19:00:27 | detention | 1 | 81242 | 4 | 1.500 | 54161.3 |
569 | 2024-06-01 22:37:59 | detention | 1 | 81242 | 4 | 1.436 | 56575.2 |
568 | 2024-06-01 11:53:44 | detention | 1 | 81242 | 4 | 1.576 | 51549.5 |