History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sailors"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
624 | 2024-04-27 00:43:09 | sailors | 2 | 107671 | 38 | 10.233 | 10521.9 |
623 | 2024-04-26 07:13:28 | sailors | 2 | 107671 | 38 | 6.483 | 16608.2 |
622 | 2024-04-26 06:13:01 | sailors | 3 | 134027 | 477 | 7.690 | 17428.7 |
621 | 2024-04-24 19:21:04 | sailors | 3 | 134027 | 477 | 8.610 | 15566.4 |
620 | 2024-04-24 19:21:03 | sailors | 2 | 107671 | 38 | 7.703 | 13977.8 |
619 | 2024-04-20 23:10:03 | sailors | 3 | 134027 | 477 | 21.376 | 6270.0 |
618 | 2024-04-20 22:26:48 | sailors | 3 | 134027 | 477 | 15.940 | 8408.2 |
617 | 2024-04-20 22:26:48 | sailors | 2 | 107671 | 38 | 13.753 | 7828.9 |
616 | 2024-04-20 22:26:44 | sailors | 1 | 69583 | 6 | 4.233 | 16438.2 |
615 | 2024-03-31 06:28:49 | sailors | 1 | 69583 | 6 | 4.330 | 16070.0 |
614 | 2024-03-28 18:56:17 | sailors | 1 | 69583 | 6 | 1.686 | 41271.1 |
613 | 2024-03-18 02:28:05 | sailors | 1 | 69583 | 6 | 2.890 | 24077.2 |
612 | 2024-03-12 21:51:29 | sailors | 1 | 69583 | 6 | 1.140 | 61037.7 |
611 | 2024-02-27 15:07:33 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
610 | 2024-02-14 17:00:05 | sailors | 1 | 69583 | 6 | 4.610 | 15093.9 |
609 | 2024-02-02 23:52:50 | sailors | 2 | 107671 | 38 | 5.826 | 18481.1 |
608 | 2024-01-18 23:50:33 | sailors | 3 | 134027 | 477 | 6.953 | 19276.1 |
607 | 2024-01-18 22:47:25 | sailors | 3 | 134027 | 477 | 7.360 | 18210.2 |
606 | 2024-01-17 07:18:46 | sailors | 1 | 69583 | 6 | 1.203 | 57841.2 |
605 | 2024-01-09 10:14:58 | sailors | 1 | 69583 | 6 | 1.220 | 57035.2 |
604 | 2023-12-23 05:41:00 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
603 | 2023-12-19 10:38:38 | sailors | 2 | 107671 | 38 | 3.356 | 32083.1 |
602 | 2023-12-14 01:19:07 | sailors | 1 | 69583 | 6 | 1.156 | 60192.9 |
601 | 2023-11-22 04:39:34 | sailors | 3 | 134027 | 477 | 6.580 | 20368.8 |
600 | 2023-11-19 18:48:21 | sailors | 1 | 69583 | 6 | 1.236 | 56296.9 |
599 | 2023-11-11 20:42:14 | sailors | 1 | 69583 | 6 | 1.203 | 57841.2 |
598 | 2023-11-11 05:40:16 | sailors | 2 | 107671 | 38 | 2.983 | 36094.9 |
597 | 2023-11-07 05:02:11 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
596 | 2023-10-27 01:09:44 | sailors | 3 | 134027 | 477 | 7.203 | 18607.1 |
595 | 2023-10-13 14:42:06 | sailors | 1 | 69583 | 6 | 1.216 | 57222.9 |
594 | 2023-09-28 15:06:08 | sailors | 1 | 69583 | 6 | 2.423 | 28717.7 |
593 | 2023-09-26 22:36:26 | sailors | 1 | 69583 | 6 | 1.346 | 51696.1 |
592 | 2023-09-24 23:27:17 | sailors | 1 | 69583 | 6 | 1.313 | 52995.4 |
591 | 2023-09-18 21:28:15 | sailors | 1 | 69583 | 6 | 1.186 | 58670.3 |
590 | 2023-08-27 09:24:47 | sailors | 1 | 69583 | 6 | 1.280 | 54361.7 |
589 | 2023-08-17 21:19:12 | sailors | 1 | 69583 | 6 | 1.123 | 61961.7 |
588 | 2023-08-14 03:13:21 | sailors | 2 | 107671 | 38 | 3.500 | 30763.1 |
587 | 2023-08-05 16:00:59 | sailors | 3 | 134027 | 477 | 6.000 | 22337.8 |
586 | 2023-06-09 22:28:36 | sailors | 1 | 69583 | 6 | 1.126 | 61796.6 |
585 | 2023-06-06 15:30:34 | sailors | 1 | 69583 | 6 | 1.140 | 61037.7 |
584 | 2023-04-28 19:54:10 | sailors | 2 | 107671 | 38 | 2.970 | 36252.9 |
583 | 2023-04-11 06:37:08 | sailors | 3 | 134027 | 477 | 14.173 | 9456.5 |
582 | 2023-02-21 21:26:56 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
581 | 2023-02-02 22:55:44 | sailors | 2 | 107671 | 38 | 2.873 | 37476.9 |
580 | 2023-01-22 21:36:30 | sailors | 3 | 134027 | 477 | 6.483 | 20673.6 |
579 | 2023-01-19 21:01:21 | sailors | 1 | 69583 | 6 | 1.156 | 60192.9 |
578 | 2023-01-17 20:26:51 | sailors | 3 | 134027 | 477 | 6.033 | 22215.6 |
577 | 2022-12-14 12:44:29 | sailors | 1 | 69583 | 6 | 1.203 | 57841.2 |
576 | 2022-12-05 22:42:06 | sailors | 1 | 69583 | 6 | 1.203 | 57841.2 |
575 | 2022-11-28 13:18:26 | sailors | 1 | 69583 | 6 | 1.263 | 55093.4 |
574 | 2022-11-14 17:26:42 | sailors | 2 | 107671 | 38 | 3.250 | 33129.5 |
573 | 2022-11-07 00:15:39 | sailors | 1 | 69583 | 6 | 1.220 | 57035.2 |
572 | 2022-11-01 09:02:04 | sailors | 1 | 69583 | 6 | 1.250 | 55666.4 |
571 | 2022-10-28 03:39:41 | sailors | 3 | 134027 | 477 | 6.750 | 19855.9 |
570 | 2022-08-29 00:18:07 | sailors | 1 | 69583 | 6 | 1.156 | 60192.9 |
569 | 2022-08-20 18:01:01 | sailors | 1 | 69583 | 6 | 1.220 | 57035.2 |
568 | 2022-08-18 17:15:57 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
567 | 2022-07-26 11:50:43 | sailors | 1 | 69583 | 6 | 1.250 | 55666.4 |
566 | 2022-07-18 23:26:57 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
565 | 2022-06-17 20:49:37 | sailors | 2 | 107671 | 38 | 2.936 | 36672.7 |
564 | 2022-06-15 15:43:57 | sailors | 2 | 107671 | 38 | 2.966 | 36301.8 |
563 | 2022-05-26 10:20:25 | sailors | 3 | 134027 | 477 | 5.936 | 22578.7 |
562 | 2022-04-12 15:40:37 | sailors | 1 | 69583 | 6 | 1.593 | 43680.5 |
561 | 2022-04-10 12:37:06 | sailors | 1 | 69583 | 6 | 1.296 | 53690.6 |
560 | 2022-03-24 23:21:22 | sailors | 1 | 69583 | 6 | 1.173 | 59320.5 |
559 | 2022-02-16 16:50:21 | sailors | 2 | 107671 | 38 | 3.140 | 34290.1 |
558 | 2022-01-30 10:17:21 | sailors | 3 | 134027 | 477 | 6.110 | 21935.7 |
557 | 2022-01-23 12:06:49 | sailors | 3 | 134027 | 477 | 6.093 | 21996.9 |
556 | 2022-01-08 12:19:21 | sailors | 1 | 69583 | 6 | 1.220 | 57035.2 |
555 | 2021-12-14 02:39:15 | sailors | 1 | 69583 | 6 | 2.533 | 27470.6 |
554 | 2021-11-04 13:09:03 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
553 | 2021-11-02 10:48:31 | sailors | 1 | 69583 | 6 | 1.203 | 57841.2 |
552 | 2021-10-04 16:33:50 | sailors | 1 | 69583 | 6 | 1.283 | 54234.6 |
551 | 2021-09-06 20:02:40 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
550 | 2021-06-05 19:54:55 | sailors | 1 | 69583 | 6 | 1.186 | 58670.3 |
549 | 2021-04-11 12:25:00 | sailors | 1 | 69583 | 6 | 1.126 | 61796.6 |
548 | 2021-03-15 11:32:07 | sailors | 1 | 69583 | 6 | 1.110 | 62687.4 |
547 | 2021-03-03 17:12:42 | sailors | 1 | 69583 | 6 | 1.140 | 61037.7 |
546 | 2020-11-30 11:23:00 | sailors | 1 | 69583 | 6 | 1.173 | 59320.5 |
545 | 2020-11-28 05:32:37 | sailors | 1 | 69583 | 6 | 1.173 | 59320.5 |
544 | 2020-11-24 01:38:27 | sailors | 1 | 69583 | 6 | 1.106 | 62914.1 |
543 | 2020-11-02 07:26:38 | sailors | 1 | 69583 | 6 | 1.313 | 52995.4 |
542 | 2020-10-30 13:50:33 | sailors | 3 | 134027 | 477 | 7.393 | 18128.9 |
541 | 2020-09-25 15:04:46 | sailors | 1 | 69583 | 6 | 2.513 | 27689.2 |
540 | 2020-09-18 21:05:14 | sailors | 1 | 69583 | 6 | 1.123 | 61961.7 |
539 | 2020-08-22 00:58:38 | sailors | 1 | 69583 | 6 | 1.156 | 60192.9 |
538 | 2020-08-17 02:50:51 | sailors | 1 | 69583 | 6 | 1.360 | 51164.0 |
537 | 2020-07-28 21:34:33 | sailors | 1 | 69583 | 6 | 1.170 | 59472.6 |
536 | 2020-07-27 14:40:18 | sailors | 1 | 69583 | 6 | 1.330 | 52318.0 |
535 | 2020-05-20 17:18:30 | sailors | 1 | 69583 | 6 | 1.390 | 50059.7 |
534 | 2020-04-14 02:43:58 | sailors | 1 | 69583 | 6 | 1.330 | 52318.0 |
533 | 2020-03-28 04:15:59 | sailors | 1 | 69583 | 6 | 1.330 | 52318.0 |
532 | 2020-03-26 09:17:41 | sailors | 1 | 69583 | 6 | 1.280 | 54361.7 |
531 | 2020-03-24 11:55:10 | sailors | 1 | 69583 | 6 | 1.393 | 49951.9 |
530 | 2020-03-23 12:52:53 | sailors | 1 | 69583 | 6 | 1.406 | 49490.0 |
529 | 2020-03-20 02:38:30 | sailors | 1 | 69583 | 6 | 1.330 | 52318.0 |
528 | 2020-02-21 12:41:10 | sailors | 1 | 69583 | 6 | 1.156 | 60192.9 |
527 | 2020-02-17 17:12:57 | sailors | 1 | 69583 | 6 | 1.313 | 52995.4 |
526 | 2020-02-15 12:31:31 | sailors | 1 | 69583 | 6 | 1.376 | 50569.0 |
525 | 2020-02-11 21:10:35 | sailors | 1 | 69583 | 6 | 2.690 | 25867.3 |