History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"messy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
615 | 2024-12-27 09:10:41 | messy | 1 | 28756 | 7 | 0.436 | 65954.1 |
614 | 2024-12-27 06:42:25 | messy | 3 | 83667 | 956 | 18.670 | 4481.4 |
613 | 2024-12-27 06:40:55 | messy | 2 | 53800 | 83 | 5.876 | 9155.9 |
612 | 2024-12-27 05:51:44 | messy | 3 | 83667 | 956 | 19.266 | 4342.7 |
611 | 2024-12-27 05:51:44 | messy | 2 | 53800 | 83 | 6.516 | 8256.6 |
610 | 2024-12-27 05:37:23 | messy | 1 | 28756 | 7 | 0.516 | 55728.7 |
609 | 2024-12-07 01:33:07 | messy | 1 | 28756 | 7 | 1.360 | 21144.1 |
608 | 2024-12-04 17:50:06 | messy | 3 | 83667 | 956 | 13.780 | 6071.6 |
607 | 2024-12-04 01:47:30 | messy | 3 | 83667 | 956 | 26.996 | 3099.2 |
606 | 2024-12-03 17:06:50 | messy | 3 | 83667 | 956 | 21.050 | 3974.7 |
605 | 2024-11-27 07:51:42 | messy | 2 | 53800 | 83 | 6.186 | 8697.1 |
604 | 2024-11-27 04:29:41 | messy | 3 | 83667 | 956 | 17.216 | 4859.8 |
603 | 2024-11-27 04:29:39 | messy | 2 | 53800 | 83 | 13.826 | 3891.2 |
602 | 2024-11-27 04:07:39 | messy | 1 | 28756 | 7 | 1.470 | 19561.9 |
601 | 2024-11-27 03:50:12 | messy | 3 | 83667 | 956 | 17.406 | 4806.8 |
600 | 2024-11-27 03:50:09 | messy | 2 | 53800 | 83 | 10.216 | 5266.2 |
599 | 2024-11-27 03:35:28 | messy | 1 | 28756 | 7 | 1.060 | 27128.3 |
598 | 2024-11-26 09:45:53 | messy | 1 | 28756 | 7 | 3.953 | 7274.5 |
597 | 2024-11-24 00:15:47 | messy | 3 | 83667 | 956 | 10.656 | 7851.6 |
596 | 2024-11-06 22:37:04 | messy | 1 | 28756 | 7 | 2.296 | 12524.4 |
595 | 2024-10-29 20:45:19 | messy | 3 | 83667 | 956 | 25.050 | 3340.0 |
594 | 2024-10-29 02:36:50 | messy | 3 | 83667 | 956 | 26.253 | 3187.0 |
593 | 2024-10-28 03:55:58 | messy | 3 | 83667 | 956 | 25.733 | 3251.4 |
592 | 2024-10-28 03:55:39 | messy | 2 | 53800 | 83 | 8.173 | 6582.7 |
591 | 2024-10-28 03:27:24 | messy | 1 | 28756 | 7 | 2.376 | 12102.7 |
590 | 2024-10-28 02:40:17 | messy | 3 | 83667 | 956 | 3.780 | 22134.1 |
589 | 2024-10-28 02:40:16 | messy | 2 | 53800 | 83 | 1.530 | 35163.4 |
588 | 2024-10-28 02:40:13 | messy | 1 | 28756 | 7 | 0.486 | 59168.7 |
587 | 2024-10-27 07:11:15 | messy | 1 | 28756 | 7 | 1.546 | 18600.3 |
586 | 2024-10-22 13:24:40 | messy | 1 | 28756 | 7 | 2.780 | 10343.9 |
585 | 2024-10-11 07:32:16 | messy | 1 | 28756 | 7 | 1.236 | 23265.4 |
584 | 2024-10-07 14:37:15 | messy | 1 | 28756 | 7 | 2.516 | 11429.3 |
583 | 2024-09-29 19:51:47 | messy | 3 | 83667 | 956 | 26.376 | 3172.1 |
582 | 2024-09-28 15:22:32 | messy | 3 | 83667 | 956 | 30.000 | 2788.9 |
581 | 2024-09-28 01:47:47 | messy | 3 | 83667 | 956 | 21.176 | 3951.0 |
580 | 2024-09-28 01:47:48 | messy | 2 | 53800 | 83 | 17.410 | 3090.2 |
579 | 2024-09-28 00:28:01 | messy | 1 | 28756 | 7 | 0.453 | 63479.0 |
578 | 2024-09-28 00:23:18 | messy | 1 | 28756 | 7 | 0.436 | 65954.1 |
577 | 2024-09-27 02:09:56 | messy | 1 | 28756 | 7 | 4.516 | 6367.6 |
576 | 2024-09-07 12:56:09 | messy | 1 | 28756 | 7 | 1.703 | 16885.5 |
575 | 2024-08-30 00:10:08 | messy | 1 | 28756 | 7 | 0.513 | 56054.6 |
574 | 2024-08-29 00:23:35 | messy | 1 | 28756 | 7 | 1.763 | 16310.8 |
573 | 2024-08-28 16:04:03 | messy | 1 | 28756 | 7 | 2.140 | 13437.4 |
572 | 2024-08-27 07:19:50 | messy | 1 | 28756 | 7 | 3.640 | 7900.0 |
571 | 2024-08-09 05:33:23 | messy | 1 | 28756 | 7 | 1.703 | 16885.5 |
570 | 2024-08-07 23:31:43 | messy | 1 | 28756 | 7 | 1.296 | 22188.3 |
569 | 2024-08-07 19:21:56 | messy | 1 | 28756 | 7 | 0.530 | 54256.6 |
568 | 2024-07-29 22:11:19 | messy | 1 | 28756 | 7 | 0.470 | 61183.0 |
567 | 2024-07-29 15:03:43 | messy | 1 | 28756 | 7 | 0.483 | 59536.2 |
566 | 2024-07-28 00:27:16 | messy | 1 | 28756 | 7 | 1.843 | 15602.8 |
565 | 2024-07-09 22:02:40 | messy | 1 | 28756 | 7 | 2.500 | 11502.4 |
564 | 2024-06-29 20:49:02 | messy | 1 | 28756 | 7 | 1.686 | 17055.8 |
563 | 2024-06-29 13:04:58 | messy | 1 | 28756 | 7 | 0.486 | 59168.7 |
562 | 2024-06-28 07:04:11 | messy | 1 | 28756 | 7 | 0.656 | 43835.4 |
561 | 2024-06-27 14:08:28 | messy | 1 | 28756 | 7 | 1.626 | 17685.1 |
560 | 2024-06-24 20:09:47 | messy | 1 | 28756 | 7 | 0.796 | 36125.6 |
559 | 2024-06-13 23:23:27 | messy | 1 | 28756 | 7 | 2.186 | 13154.6 |
558 | 2024-06-04 18:51:50 | messy | 3 | 83667 | 956 | 13.186 | 6345.1 |
557 | 2024-06-03 20:30:24 | messy | 3 | 83667 | 956 | 20.156 | 4151.0 |
556 | 2024-06-03 20:30:25 | messy | 2 | 53800 | 83 | 8.423 | 6387.3 |
555 | 2024-06-03 19:37:47 | messy | 1 | 28756 | 7 | 1.126 | 25538.2 |
554 | 2024-05-30 07:42:40 | messy | 2 | 53800 | 83 | 2.640 | 20378.8 |
553 | 2024-05-30 07:30:16 | messy | 1 | 28756 | 7 | 0.640 | 44931.3 |
552 | 2024-05-28 11:36:12 | messy | 1 | 28756 | 7 | 1.903 | 15110.9 |
551 | 2024-05-14 12:44:06 | messy | 2 | 53800 | 83 | 1.626 | 33087.3 |
550 | 2024-05-04 06:45:52 | messy | 1 | 28756 | 7 | 1.096 | 26237.2 |
549 | 2024-05-03 20:43:29 | messy | 3 | 83667 | 956 | 10.783 | 7759.2 |
548 | 2024-05-03 05:10:55 | messy | 2 | 53800 | 83 | 3.106 | 17321.3 |
547 | 2024-05-03 03:07:35 | messy | 3 | 83667 | 956 | 3.843 | 21771.3 |
546 | 2024-05-02 22:24:11 | messy | 2 | 53800 | 83 | 1.750 | 30742.9 |
545 | 2024-05-02 22:24:00 | messy | 1 | 28756 | 7 | 1.030 | 27918.4 |
544 | 2024-05-02 21:40:59 | messy | 3 | 83667 | 956 | 3.936 | 21256.9 |
543 | 2024-05-02 10:58:04 | messy | 3 | 83667 | 956 | 12.296 | 6804.4 |
542 | 2024-04-30 10:28:51 | messy | 1 | 28756 | 7 | 0.983 | 29253.3 |
541 | 2024-04-28 16:56:47 | messy | 1 | 28756 | 7 | 0.593 | 48492.4 |
540 | 2024-04-27 10:32:14 | messy | 1 | 28756 | 7 | 1.106 | 26000.0 |
539 | 2024-04-25 18:32:47 | messy | 1 | 28756 | 7 | 1.063 | 27051.7 |
538 | 2024-04-15 18:26:39 | messy | 1 | 28756 | 7 | 0.640 | 44931.3 |
537 | 2024-04-15 18:26:36 | messy | 1 | 28756 | 7 | 0.953 | 30174.2 |
536 | 2024-04-02 20:33:12 | messy | 1 | 28756 | 7 | 0.453 | 63479.0 |
535 | 2024-03-31 06:37:59 | messy | 1 | 28756 | 7 | 0.513 | 56054.6 |
534 | 2024-03-29 02:55:30 | messy | 1 | 28756 | 7 | 0.530 | 54256.6 |
533 | 2024-03-06 05:48:04 | messy | 1 | 28756 | 7 | 1.606 | 17905.4 |
532 | 2024-03-02 21:11:34 | messy | 1 | 28756 | 7 | 0.486 | 59168.7 |
531 | 2024-03-02 19:13:49 | messy | 2 | 53800 | 83 | 2.670 | 20149.8 |
530 | 2024-03-02 19:13:12 | messy | 3 | 83667 | 956 | 4.343 | 19264.8 |
529 | 2024-03-02 18:00:58 | messy | 3 | 83667 | 956 | 9.283 | 9012.9 |
528 | 2024-03-02 18:00:58 | messy | 2 | 53800 | 83 | 5.643 | 9533.9 |
527 | 2024-03-02 17:53:59 | messy | 1 | 28756 | 7 | 1.093 | 26309.2 |
526 | 2024-03-01 03:48:29 | messy | 1 | 28756 | 7 | 0.546 | 52666.7 |
525 | 2024-02-27 20:05:34 | messy | 1 | 28756 | 7 | 0.546 | 52666.7 |
524 | 2024-01-28 19:26:21 | messy | 1 | 28756 | 7 | 0.436 | 65954.1 |
523 | 2024-01-05 16:44:00 | messy | 3 | 83667 | 956 | 3.563 | 23482.2 |
522 | 2024-01-03 07:08:59 | messy | 3 | 83667 | 956 | 3.733 | 22412.8 |
521 | 2024-01-03 07:08:56 | messy | 2 | 53800 | 83 | 1.470 | 36598.6 |
520 | 2023-12-31 14:51:28 | messy | 2 | 53800 | 83 | 3.076 | 17490.2 |
519 | 2023-12-31 14:51:27 | messy | 3 | 83667 | 956 | 3.920 | 21343.6 |
518 | 2023-12-29 21:00:08 | messy | 1 | 28756 | 7 | 0.486 | 59168.7 |
517 | 2023-11-29 23:16:57 | messy | 3 | 83667 | 956 | 3.766 | 22216.4 |
516 | 2023-11-14 01:38:00 | messy | 1 | 28756 | 7 | 0.560 | 51350.0 |