History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"complain"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
633 | 2024-04-27 09:50:22 | complain | 1 | 82945 | 4 | 1.690 | 49079.9 |
632 | 2024-04-25 12:57:18 | complain | 3 | 146162 | 79 | 16.300 | 8967.0 |
631 | 2024-04-24 12:54:17 | complain | 3 | 146162 | 79 | 10.846 | 13476.1 |
630 | 2024-04-22 00:00:13 | complain | 2 | 121059 | 12 | 10.486 | 11544.8 |
629 | 2024-04-22 00:00:12 | complain | 3 | 146162 | 79 | 11.813 | 12373.0 |
628 | 2024-04-21 23:59:54 | complain | 3 | 146162 | 79 | 16.644 | 8781.7 |
627 | 2024-04-21 23:59:56 | complain | 1 | 82945 | 4 | 1.936 | 42843.5 |
626 | 2024-04-21 23:59:44 | complain | 2 | 121059 | 12 | 5.376 | 22518.4 |
625 | 2024-04-20 20:22:33 | complain | 2 | 121059 | 12 | 3.250 | 37248.9 |
624 | 2024-04-13 14:22:19 | complain | 1 | 82945 | 4 | 1.500 | 55296.7 |
623 | 2024-04-10 17:09:04 | complain | 4 | 161609 | 601 | 58.253 | 2774.3 |
622 | 2024-04-10 07:03:44 | complain | 4 | 161609 | 601 | 13.690 | 11804.9 |
621 | 2024-04-02 19:32:13 | complain | 4 | 161609 | 601 | 18.250 | 8855.3 |
620 | 2024-04-01 14:52:26 | complain | 4 | 161609 | 601 | 39.393 | 4102.5 |
619 | 2024-04-01 00:38:13 | complain | 4 | 161609 | 601 | 28.796 | 5612.2 |
618 | 2024-04-01 00:09:54 | complain | 4 | 161609 | 601 | 37.363 | 4325.4 |
617 | 2024-04-01 00:09:40 | complain | 1 | 82945 | 4 | 1.686 | 49196.3 |
616 | 2024-03-29 11:34:17 | complain | 1 | 82945 | 4 | 3.546 | 23391.1 |
615 | 2024-03-17 19:34:30 | complain | 3 | 146162 | 79 | 6.953 | 21021.4 |
614 | 2024-03-11 22:58:35 | complain | 2 | 121059 | 12 | 5.080 | 23830.5 |
613 | 2024-03-11 05:11:23 | complain | 4 | 161609 | 601 | 31.156 | 5187.1 |
612 | 2024-03-11 04:05:45 | complain | 4 | 161609 | 601 | 14.313 | 11291.1 |
611 | 2024-03-11 04:05:46 | complain | 2 | 121059 | 12 | 3.810 | 31774.0 |
610 | 2024-03-11 03:57:23 | complain | 3 | 146162 | 79 | 8.283 | 17646.0 |
609 | 2024-03-10 11:50:58 | complain | 3 | 146162 | 79 | 14.736 | 9918.7 |
608 | 2024-03-10 06:59:07 | complain | 3 | 146162 | 79 | 17.660 | 8276.4 |
607 | 2024-03-10 00:18:23 | complain | 3 | 146162 | 79 | 25.283 | 5781.0 |
606 | 2024-03-08 22:04:59 | complain | 1 | 82945 | 4 | 3.080 | 26930.2 |
605 | 2024-03-07 08:02:51 | complain | 1 | 82945 | 4 | 5.060 | 16392.3 |
604 | 2024-03-01 23:42:28 | complain | 3 | 146162 | 79 | 10.513 | 13903.0 |
603 | 2024-03-01 23:37:05 | complain | 2 | 121059 | 12 | 7.033 | 17213.0 |
602 | 2024-02-28 00:39:02 | complain | 4 | 161609 | 601 | 11.563 | 13976.4 |
601 | 2024-02-28 00:39:09 | complain | 1 | 82945 | 4 | 1.533 | 54106.3 |
600 | 2024-02-28 00:39:03 | complain | 2 | 121059 | 12 | 3.780 | 32026.2 |
599 | 2024-02-26 04:24:58 | complain | 1 | 82945 | 4 | 1.686 | 49196.3 |
598 | 2024-02-07 16:11:46 | complain | 3 | 146162 | 79 | 11.156 | 13101.6 |
597 | 2024-02-07 09:23:55 | complain | 2 | 121059 | 12 | 6.873 | 17613.7 |
596 | 2024-02-07 09:22:31 | complain | 3 | 146162 | 79 | 9.000 | 16240.2 |
595 | 2024-02-06 13:50:54 | complain | 3 | 146162 | 79 | 6.920 | 21121.7 |
594 | 2024-02-06 13:50:50 | complain | 2 | 121059 | 12 | 3.140 | 38553.8 |
593 | 2024-02-05 13:30:19 | complain | 3 | 146162 | 79 | 22.796 | 6411.7 |
592 | 2024-02-05 08:35:59 | complain | 3 | 146162 | 79 | 12.890 | 11339.2 |
591 | 2024-02-05 08:36:03 | complain | 2 | 121059 | 12 | 8.050 | 15038.4 |
590 | 2024-02-04 08:36:35 | complain | 4 | 161609 | 601 | 13.593 | 11889.1 |
589 | 2024-02-01 18:26:23 | complain | 1 | 82945 | 4 | 1.283 | 64649.3 |
588 | 2024-01-27 17:13:39 | complain | 4 | 161609 | 601 | 12.080 | 13378.2 |
587 | 2023-12-22 15:11:27 | complain | 3 | 146162 | 79 | 7.140 | 20470.9 |
586 | 2023-12-16 18:37:07 | complain | 2 | 121059 | 12 | 3.766 | 32145.2 |
585 | 2023-12-12 23:58:10 | complain | 4 | 161609 | 601 | 11.000 | 14691.7 |
584 | 2023-12-12 23:58:07 | complain | 3 | 146162 | 79 | 7.106 | 20568.8 |
583 | 2023-12-12 23:58:06 | complain | 2 | 121059 | 12 | 3.626 | 33386.4 |
582 | 2023-12-03 18:32:10 | complain | 4 | 161609 | 601 | 11.830 | 13660.9 |
581 | 2023-12-03 18:32:08 | complain | 3 | 146162 | 79 | 7.076 | 20656.0 |
580 | 2023-12-03 18:32:04 | complain | 2 | 121059 | 12 | 3.310 | 36573.7 |
579 | 2023-12-03 11:53:08 | complain | 4 | 161609 | 601 | 11.296 | 14306.7 |
578 | 2023-12-03 11:48:20 | complain | 4 | 161609 | 601 | 10.610 | 15231.8 |
577 | 2023-12-03 11:44:08 | complain | 4 | 161609 | 601 | 11.423 | 14147.7 |
576 | 2023-12-01 14:42:31 | complain | 3 | 146162 | 79 | 6.376 | 22923.8 |
575 | 2023-11-28 09:26:25 | complain | 4 | 161609 | 601 | 11.313 | 14285.2 |
574 | 2023-11-28 09:26:23 | complain | 3 | 146162 | 79 | 7.110 | 20557.2 |
573 | 2023-11-28 09:26:21 | complain | 2 | 121059 | 12 | 3.343 | 36212.7 |
572 | 2023-11-26 07:09:10 | complain | 1 | 82945 | 4 | 1.330 | 62364.7 |
571 | 2023-11-24 16:00:16 | complain | 1 | 82945 | 4 | 1.313 | 63172.1 |
570 | 2023-11-11 03:29:11 | complain | 1 | 82945 | 4 | 1.440 | 57600.7 |
569 | 2023-11-10 02:12:11 | complain | 1 | 82945 | 4 | 1.406 | 58993.6 |
568 | 2023-11-07 07:57:44 | complain | 1 | 82945 | 4 | 1.410 | 58826.2 |
567 | 2023-10-27 23:57:20 | complain | 1 | 82945 | 4 | 1.406 | 58993.6 |
566 | 2023-10-20 04:10:46 | complain | 1 | 82945 | 4 | 1.440 | 57600.7 |
565 | 2023-10-18 01:06:07 | complain | 1 | 82945 | 4 | 1.483 | 55930.5 |
564 | 2023-10-12 03:50:41 | complain | 1 | 82945 | 4 | 1.313 | 63172.1 |
563 | 2023-10-04 05:48:52 | complain | 1 | 82945 | 4 | 1.296 | 64000.8 |
562 | 2023-09-23 12:32:20 | complain | 1 | 82945 | 4 | 1.296 | 64000.8 |
561 | 2023-09-17 00:26:39 | complain | 2 | 121059 | 12 | 3.720 | 32542.7 |
560 | 2023-09-12 09:41:29 | complain | 1 | 82945 | 4 | 1.296 | 64000.8 |
559 | 2023-09-12 05:42:21 | complain | 1 | 82945 | 4 | 1.483 | 55930.5 |
558 | 2023-08-30 23:59:47 | complain | 3 | 146162 | 79 | 6.830 | 21400.0 |
557 | 2023-07-28 05:50:33 | complain | 1 | 82945 | 4 | 1.420 | 58412.0 |
556 | 2023-06-20 06:35:03 | complain | 2 | 121059 | 12 | 3.343 | 36212.7 |
555 | 2023-06-19 06:28:28 | complain | 1 | 82945 | 4 | 1.390 | 59672.7 |
554 | 2023-05-26 18:22:48 | complain | 3 | 146162 | 79 | 6.813 | 21453.4 |
553 | 2023-05-17 19:17:08 | complain | 3 | 146162 | 79 | 6.236 | 23438.4 |
552 | 2023-04-12 15:00:52 | complain | 1 | 82945 | 4 | 1.453 | 57085.3 |
551 | 2023-04-01 22:04:13 | complain | 1 | 82945 | 4 | 1.280 | 64800.8 |
550 | 2023-03-16 02:00:13 | complain | 2 | 121059 | 12 | 3.093 | 39139.7 |
549 | 2023-02-25 05:56:30 | complain | 3 | 146162 | 79 | 6.093 | 23988.5 |
548 | 2023-01-15 05:11:56 | complain | 1 | 82945 | 4 | 1.406 | 58993.6 |
547 | 2022-12-23 15:39:05 | complain | 1 | 82945 | 4 | 1.280 | 64800.8 |
546 | 2022-12-19 11:47:34 | complain | 2 | 121059 | 12 | 3.203 | 37795.5 |
545 | 2022-12-07 16:39:03 | complain | 3 | 146162 | 79 | 6.123 | 23871.0 |
544 | 2022-11-04 15:11:53 | complain | 1 | 82945 | 4 | 1.343 | 61761.0 |
543 | 2022-09-21 07:47:03 | complain | 3 | 146162 | 79 | 6.186 | 23627.9 |
542 | 2022-09-17 18:06:37 | complain | 3 | 146162 | 79 | 6.453 | 22650.2 |
541 | 2022-09-01 18:23:57 | complain | 3 | 146162 | 79 | 6.656 | 21959.4 |
540 | 2022-09-01 09:18:22 | complain | 1 | 82945 | 4 | 1.313 | 63172.1 |
539 | 2022-08-27 01:50:59 | complain | 1 | 82945 | 4 | 1.296 | 64000.8 |
538 | 2022-08-15 00:55:58 | complain | 2 | 121059 | 12 | 3.686 | 32842.9 |
537 | 2022-07-21 21:07:46 | complain | 3 | 146162 | 79 | 6.236 | 23438.4 |
536 | 2022-07-12 09:30:01 | complain | 4 | 161609 | 601 | 10.513 | 15372.3 |
535 | 2022-06-23 21:57:33 | complain | 1 | 82945 | 4 | 1.300 | 63803.8 |
534 | 2022-04-26 09:39:38 | complain | 1 | 82945 | 4 | 1.436 | 57761.1 |