History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"deviance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
643 | 2024-06-01 02:09:04 | deviance | 1 | 82945 | 4 | 6.936 | 11958.6 |
642 | 2024-06-01 01:35:56 | deviance | 2 | 121059 | 12 | 5.283 | 22914.8 |
641 | 2024-06-01 01:33:00 | deviance | 3 | 146162 | 73 | 9.560 | 15288.9 |
640 | 2024-05-31 04:27:56 | deviance | 3 | 146162 | 73 | 13.253 | 11028.6 |
639 | 2024-05-31 04:27:59 | deviance | 1 | 82945 | 4 | 1.530 | 54212.4 |
638 | 2024-05-31 04:27:52 | deviance | 2 | 121059 | 12 | 8.456 | 14316.3 |
637 | 2024-05-30 20:05:53 | deviance | 1 | 82945 | 4 | 1.500 | 55296.7 |
636 | 2024-05-16 07:45:07 | deviance | 3 | 146162 | 73 | 11.140 | 13120.5 |
635 | 2024-05-16 07:18:34 | deviance | 4 | 161609 | 640 | 22.753 | 7102.8 |
634 | 2024-05-15 15:16:10 | deviance | 3 | 146162 | 73 | 13.546 | 10790.0 |
633 | 2024-05-14 12:42:04 | deviance | 3 | 146162 | 73 | 7.766 | 18820.8 |
632 | 2024-05-14 12:42:02 | deviance | 2 | 121059 | 12 | 4.080 | 29671.3 |
631 | 2024-05-14 12:42:01 | deviance | 1 | 82945 | 4 | 1.563 | 53067.8 |
630 | 2024-05-13 14:43:06 | deviance | 4 | 161609 | 640 | 36.593 | 4416.4 |
629 | 2024-05-10 19:43:22 | deviance | 1 | 82945 | 4 | 3.530 | 23497.2 |
628 | 2024-05-06 06:37:31 | deviance | 4 | 161609 | 640 | 13.513 | 11959.5 |
627 | 2024-05-06 06:03:48 | deviance | 4 | 161609 | 640 | 12.733 | 12692.1 |
626 | 2024-05-05 22:11:20 | deviance | 4 | 161609 | 640 | 26.720 | 6048.2 |
625 | 2024-05-05 20:35:39 | deviance | 4 | 161609 | 640 | 22.406 | 7212.8 |
624 | 2024-05-05 20:20:36 | deviance | 4 | 161609 | 640 | 32.626 | 4953.4 |
623 | 2024-04-30 17:35:14 | deviance | 1 | 82945 | 4 | 3.296 | 25165.4 |
622 | 2024-04-11 18:03:35 | deviance | 4 | 161609 | 640 | 14.936 | 10820.1 |
621 | 2024-04-11 01:09:56 | deviance | 4 | 161609 | 640 | 15.720 | 10280.5 |
620 | 2024-04-11 01:09:57 | deviance | 3 | 146162 | 73 | 13.140 | 11123.4 |
619 | 2024-04-11 01:09:45 | deviance | 2 | 121059 | 12 | 8.046 | 15045.9 |
618 | 2024-04-10 03:00:48 | deviance | 2 | 121059 | 12 | 10.936 | 11069.8 |
617 | 2024-04-09 23:42:16 | deviance | 1 | 82945 | 4 | 3.343 | 24811.5 |
616 | 2024-04-08 23:40:28 | deviance | 1 | 82945 | 4 | 1.670 | 49667.7 |
615 | 2024-04-08 23:40:17 | deviance | 2 | 121059 | 12 | 5.016 | 24134.6 |
614 | 2024-04-08 06:36:32 | deviance | 2 | 121059 | 12 | 3.843 | 31501.2 |
613 | 2024-04-02 20:32:33 | deviance | 4 | 161609 | 640 | 11.970 | 13501.2 |
612 | 2024-04-01 04:26:59 | deviance | 1 | 82945 | 4 | 4.330 | 19155.9 |
611 | 2024-03-31 22:20:08 | deviance | 3 | 146162 | 73 | 26.283 | 5561.1 |
610 | 2024-03-30 19:08:05 | deviance | 3 | 146162 | 73 | 21.173 | 6903.2 |
609 | 2024-03-30 19:07:13 | deviance | 4 | 161609 | 640 | 16.050 | 10069.1 |
608 | 2024-03-30 06:45:35 | deviance | 4 | 161609 | 640 | 40.316 | 4008.6 |
607 | 2024-03-30 06:20:31 | deviance | 4 | 161609 | 640 | 31.796 | 5082.7 |
606 | 2024-03-30 06:20:30 | deviance | 3 | 146162 | 73 | 17.186 | 8504.7 |
605 | 2024-03-30 06:20:28 | deviance | 2 | 121059 | 12 | 8.860 | 13663.5 |
604 | 2024-03-30 05:14:25 | deviance | 1 | 82945 | 4 | 1.423 | 58288.8 |
603 | 2024-03-29 22:10:02 | deviance | 1 | 82945 | 4 | 5.033 | 16480.2 |
602 | 2024-03-29 12:30:53 | deviance | 1 | 82945 | 4 | 2.876 | 28840.4 |
601 | 2024-03-10 18:17:30 | deviance | 4 | 161609 | 640 | 13.643 | 11845.6 |
600 | 2024-03-07 23:56:38 | deviance | 4 | 161609 | 640 | 16.093 | 10042.2 |
599 | 2024-03-01 18:48:33 | deviance | 3 | 146162 | 73 | 14.500 | 10080.1 |
598 | 2024-03-01 14:44:34 | deviance | 4 | 161609 | 640 | 15.500 | 10426.4 |
597 | 2024-02-29 13:32:43 | deviance | 3 | 146162 | 73 | 6.940 | 21060.8 |
596 | 2024-02-28 09:51:01 | deviance | 3 | 146162 | 73 | 20.453 | 7146.2 |
595 | 2024-02-28 09:50:54 | deviance | 2 | 121059 | 12 | 15.690 | 7715.7 |
594 | 2024-02-28 07:43:47 | deviance | 1 | 82945 | 4 | 1.563 | 53067.8 |
593 | 2024-02-28 06:28:57 | deviance | 4 | 161609 | 640 | 12.843 | 12583.4 |
592 | 2024-02-28 06:28:55 | deviance | 3 | 146162 | 73 | 8.093 | 18060.3 |
591 | 2024-02-28 06:28:54 | deviance | 2 | 121059 | 12 | 5.156 | 23479.2 |
590 | 2024-02-28 06:28:47 | deviance | 1 | 82945 | 4 | 1.313 | 63172.1 |
589 | 2024-02-26 05:20:54 | deviance | 1 | 82945 | 4 | 4.733 | 17524.8 |
588 | 2024-02-05 17:47:26 | deviance | 4 | 161609 | 640 | 14.453 | 11181.7 |
587 | 2024-02-05 02:10:03 | deviance | 4 | 161609 | 640 | 19.640 | 8228.6 |
586 | 2024-01-26 09:51:41 | deviance | 3 | 146162 | 73 | 6.843 | 21359.3 |
585 | 2024-01-25 17:32:39 | deviance | 2 | 121059 | 12 | 3.686 | 32842.9 |
584 | 2024-01-25 17:32:19 | deviance | 2 | 121059 | 12 | 3.783 | 32000.8 |
583 | 2024-01-25 17:32:07 | deviance | 3 | 146162 | 73 | 7.096 | 20597.8 |
582 | 2024-01-23 03:00:00 | deviance | 3 | 146162 | 73 | 16.940 | 8628.2 |
581 | 2024-01-22 12:40:00 | deviance | 4 | 161609 | 640 | 30.626 | 5276.9 |
580 | 2024-01-22 12:29:40 | deviance | 4 | 161609 | 640 | 15.546 | 10395.5 |
579 | 2024-01-21 19:29:15 | deviance | 4 | 161609 | 640 | 11.610 | 13919.8 |
578 | 2024-01-21 19:29:14 | deviance | 3 | 146162 | 73 | 7.360 | 19859.0 |
577 | 2024-01-21 19:29:09 | deviance | 2 | 121059 | 12 | 3.453 | 35059.1 |
576 | 2024-01-10 09:20:33 | deviance | 1 | 82945 | 4 | 1.423 | 58288.8 |
575 | 2024-01-05 05:35:38 | deviance | 4 | 161609 | 640 | 11.000 | 14691.7 |
574 | 2023-12-15 08:36:24 | deviance | 1 | 82945 | 4 | 1.483 | 55930.5 |
573 | 2023-12-09 16:34:08 | deviance | 2 | 121059 | 12 | 3.266 | 37066.4 |
572 | 2023-12-08 12:55:05 | deviance | 4 | 161609 | 640 | 12.326 | 13111.2 |
571 | 2023-12-08 12:48:40 | deviance | 4 | 161609 | 640 | 16.940 | 9540.1 |
570 | 2023-12-08 12:45:55 | deviance | 4 | 161609 | 640 | 12.080 | 13378.2 |
569 | 2023-12-05 10:04:01 | deviance | 4 | 161609 | 640 | 12.296 | 13143.2 |
568 | 2023-11-18 16:40:08 | deviance | 1 | 82945 | 4 | 1.283 | 64649.3 |
567 | 2023-11-18 04:28:10 | deviance | 1 | 82945 | 4 | 1.360 | 60989.0 |
566 | 2023-10-31 01:14:20 | deviance | 1 | 82945 | 4 | 1.576 | 52630.1 |
565 | 2023-10-25 09:08:03 | deviance | 1 | 82945 | 4 | 1.406 | 58993.6 |
564 | 2023-10-15 16:06:38 | deviance | 1 | 82945 | 4 | 1.266 | 65517.4 |
563 | 2023-10-05 16:07:09 | deviance | 1 | 82945 | 4 | 1.423 | 58288.8 |
562 | 2023-09-29 10:43:38 | deviance | 1 | 82945 | 4 | 1.470 | 56425.2 |
561 | 2023-09-15 12:30:37 | deviance | 1 | 82945 | 4 | 1.436 | 57761.1 |
560 | 2023-09-06 22:45:58 | deviance | 2 | 121059 | 12 | 3.233 | 37444.8 |
559 | 2023-09-01 08:24:49 | deviance | 4 | 161609 | 640 | 11.580 | 13955.9 |
558 | 2023-08-26 22:43:53 | deviance | 1 | 82945 | 4 | 1.280 | 64800.8 |
557 | 2023-08-11 14:09:44 | deviance | 4 | 161609 | 640 | 11.376 | 14206.1 |
556 | 2023-07-17 11:45:05 | deviance | 1 | 82945 | 4 | 1.296 | 64000.8 |
555 | 2023-07-09 18:27:06 | deviance | 2 | 121059 | 12 | 3.156 | 38358.4 |
554 | 2023-07-05 03:54:53 | deviance | 3 | 146162 | 73 | 6.953 | 21021.4 |
553 | 2023-06-14 15:21:27 | deviance | 4 | 161609 | 640 | 12.486 | 12943.2 |
552 | 2023-06-13 08:40:36 | deviance | 2 | 121059 | 12 | 3.126 | 38726.5 |
551 | 2023-06-07 19:04:28 | deviance | 3 | 146162 | 73 | 7.000 | 20880.3 |
550 | 2023-06-05 10:47:07 | deviance | 4 | 161609 | 640 | 10.500 | 15391.3 |
549 | 2023-05-24 23:57:45 | deviance | 1 | 82945 | 4 | 1.343 | 61761.0 |
548 | 2023-05-22 08:01:06 | deviance | 4 | 161609 | 640 | 11.266 | 14344.8 |
547 | 2023-05-20 09:13:55 | deviance | 4 | 161609 | 640 | 12.686 | 12739.2 |
546 | 2023-05-18 13:30:47 | deviance | 4 | 161609 | 640 | 12.016 | 13449.5 |
545 | 2023-04-07 14:22:11 | deviance | 4 | 161609 | 640 | 11.376 | 14206.1 |
544 | 2023-03-29 13:15:23 | deviance | 1 | 82945 | 4 | 1.266 | 65517.4 |