History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shoji"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1100 | 2024-04-06 14:35:49 | shoji | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1099 | 2024-03-31 15:12:10 | shoji | 1 | 28756 | 3 | 0.703 | 40904.7 |
| 1098 | 2024-03-28 20:44:29 | shoji | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1097 | 2024-03-07 08:03:35 | shoji | 2 | 53800 | 48 | 3.826 | 14061.7 |
| 1096 | 2024-03-07 06:11:04 | shoji | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1095 | 2024-03-06 23:28:32 | shoji | 3 | 83667 | 643 | 13.906 | 6016.6 |
| 1094 | 2024-03-06 12:19:12 | shoji | 3 | 83667 | 643 | 9.953 | 8406.2 |
| 1093 | 2024-03-06 09:34:19 | shoji | 3 | 83667 | 643 | 4.483 | 18663.2 |
| 1092 | 2024-03-01 12:37:56 | shoji | 1 | 28756 | 3 | 0.656 | 43835.4 |
| 1091 | 2024-02-26 20:00:36 | shoji | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1090 | 2024-02-03 18:45:47 | shoji | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1089 | 2024-01-30 21:29:11 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1088 | 2024-01-29 07:03:55 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1087 | 2024-01-28 20:15:54 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1086 | 2024-01-27 14:34:57 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1085 | 2024-01-27 13:28:28 | shoji | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1084 | 2024-01-26 20:11:10 | shoji | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1083 | 2024-01-26 08:20:07 | shoji | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1082 | 2024-01-15 10:19:43 | shoji | 2 | 53800 | 48 | 1.606 | 33499.4 |
| 1081 | 2024-01-04 22:20:41 | shoji | 1 | 28756 | 3 | 0.456 | 63061.4 |
| 1080 | 2024-01-03 17:25:31 | shoji | 2 | 53800 | 48 | 1.923 | 27977.1 |
| 1079 | 2023-12-13 01:45:15 | shoji | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1078 | 2023-12-11 06:31:35 | shoji | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1077 | 2023-12-01 06:47:02 | shoji | 3 | 83667 | 643 | 3.673 | 22778.9 |
| 1076 | 2023-11-25 16:44:11 | shoji | 3 | 83667 | 643 | 3.373 | 24804.9 |
| 1075 | 2023-11-24 18:10:15 | shoji | 2 | 53800 | 48 | 1.453 | 37026.8 |
| 1074 | 2023-11-22 15:27:24 | shoji | 3 | 83667 | 643 | 3.296 | 25384.4 |
| 1073 | 2023-11-19 10:53:56 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1072 | 2023-11-18 23:02:23 | shoji | 3 | 83667 | 643 | 3.720 | 22491.1 |
| 1071 | 2023-11-16 23:19:27 | shoji | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1070 | 2023-11-13 22:37:42 | shoji | 3 | 83667 | 643 | 3.440 | 24321.8 |
| 1069 | 2023-11-13 22:37:44 | shoji | 2 | 53800 | 48 | 1.576 | 34137.1 |
| 1068 | 2023-11-11 04:14:27 | shoji | 3 | 83667 | 643 | 3.703 | 22594.4 |
| 1067 | 2023-11-06 02:28:44 | shoji | 3 | 83667 | 643 | 4.253 | 19672.5 |
| 1066 | 2023-10-31 12:52:45 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1065 | 2023-10-27 00:48:08 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1064 | 2023-10-26 19:05:29 | shoji | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1063 | 2023-10-21 14:39:45 | shoji | 3 | 83667 | 643 | 3.343 | 25027.5 |
| 1062 | 2023-10-21 13:57:20 | shoji | 2 | 53800 | 48 | 1.530 | 35163.4 |
| 1061 | 2023-10-19 08:45:16 | shoji | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1060 | 2023-10-11 11:45:46 | shoji | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1059 | 2023-10-07 08:05:02 | shoji | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1058 | 2023-09-26 08:08:51 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1057 | 2023-09-13 06:48:55 | shoji | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1056 | 2023-09-10 06:59:05 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1055 | 2023-08-29 22:33:19 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1054 | 2023-08-24 17:14:01 | shoji | 3 | 83667 | 643 | 3.296 | 25384.4 |
| 1053 | 2023-08-21 18:41:30 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1052 | 2023-08-03 11:30:15 | shoji | 3 | 83667 | 643 | 3.313 | 25254.2 |
| 1051 | 2023-08-01 20:26:23 | shoji | 2 | 53800 | 48 | 1.466 | 36698.5 |
| 1050 | 2023-07-31 15:09:43 | shoji | 1 | 28756 | 3 | 0.486 | 59168.7 |
| 1049 | 2023-05-24 00:27:58 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1048 | 2023-05-08 21:53:45 | shoji | 3 | 83667 | 643 | 3.843 | 21771.3 |
| 1047 | 2023-04-16 08:18:19 | shoji | 3 | 83667 | 643 | 3.500 | 23904.9 |
| 1046 | 2023-04-08 18:43:54 | shoji | 2 | 53800 | 48 | 1.623 | 33148.5 |
| 1045 | 2023-04-05 09:17:29 | shoji | 3 | 83667 | 643 | 3.220 | 25983.5 |
| 1044 | 2023-04-04 20:46:01 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1043 | 2023-03-19 05:16:41 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1042 | 2023-02-14 04:14:19 | shoji | 3 | 83667 | 643 | 3.266 | 25617.6 |
| 1041 | 2023-01-25 18:49:28 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1040 | 2023-01-23 07:09:06 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1039 | 2023-01-21 15:09:24 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1038 | 2023-01-19 05:07:40 | shoji | 1 | 28756 | 3 | 0.500 | 57512.0 |
| 1037 | 2023-01-16 14:25:16 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1036 | 2023-01-12 20:44:24 | shoji | 2 | 53800 | 48 | 1.326 | 40573.2 |
| 1035 | 2023-01-11 19:13:24 | shoji | 1 | 28756 | 3 | 0.970 | 29645.4 |
| 1034 | 2023-01-09 10:39:39 | shoji | 1 | 28756 | 3 | 0.873 | 32939.3 |
| 1033 | 2023-01-06 22:41:15 | shoji | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1032 | 2023-01-05 01:03:22 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1031 | 2023-01-04 07:49:03 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |
| 1030 | 2022-12-06 15:47:48 | shoji | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1029 | 2022-11-25 10:20:08 | shoji | 3 | 83667 | 643 | 4.796 | 17445.2 |
| 1028 | 2022-10-14 08:53:00 | shoji | 2 | 53800 | 48 | 1.656 | 32487.9 |
| 1027 | 2022-09-28 16:24:41 | shoji | 1 | 28756 | 3 | 0.440 | 65354.5 |
| 1026 | 2022-07-23 12:50:22 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1025 | 2022-07-19 20:19:25 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1024 | 2022-05-16 05:10:14 | shoji | 2 | 53800 | 48 | 1.563 | 34421.0 |
| 1023 | 2022-05-15 14:17:22 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1022 | 2022-05-07 11:20:27 | shoji | 3 | 83667 | 643 | 3.453 | 24230.2 |
| 1021 | 2022-04-30 18:05:25 | shoji | 3 | 83667 | 643 | 3.236 | 25855.1 |
| 1020 | 2022-03-22 08:23:43 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1019 | 2022-01-30 05:40:42 | shoji | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1018 | 2022-01-28 00:42:33 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1017 | 2021-11-25 00:31:34 | shoji | 1 | 28756 | 3 | 0.546 | 52666.7 |
| 1016 | 2021-11-21 05:46:36 | shoji | 1 | 28756 | 3 | 0.466 | 61708.2 |
| 1015 | 2021-11-19 04:18:51 | shoji | 1 | 28756 | 3 | 0.470 | 61183.0 |
| 1014 | 2021-11-03 09:16:45 | shoji | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1013 | 2021-10-02 18:52:12 | shoji | 1 | 28756 | 3 | 0.530 | 54256.6 |
| 1012 | 2021-09-15 18:15:09 | shoji | 1 | 28756 | 3 | 0.533 | 53951.2 |
| 1011 | 2021-08-15 09:53:34 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1010 | 2021-07-24 01:38:16 | shoji | 1 | 28756 | 3 | 0.483 | 59536.2 |
| 1009 | 2021-05-13 22:19:44 | shoji | 1 | 28756 | 3 | 0.560 | 51350.0 |
| 1008 | 2021-05-04 12:49:55 | shoji | 1 | 28756 | 3 | 0.516 | 55728.7 |
| 1007 | 2021-04-12 21:04:23 | shoji | 1 | 28756 | 3 | 0.750 | 38341.3 |
| 1006 | 2021-02-01 20:03:27 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1005 | 2021-01-26 16:51:01 | shoji | 1 | 28756 | 3 | 0.453 | 63479.0 |
| 1004 | 2020-11-02 11:26:09 | shoji | 1 | 28756 | 3 | 0.563 | 51076.4 |
| 1003 | 2020-10-30 18:48:49 | shoji | 1 | 28756 | 3 | 0.450 | 63902.2 |
| 1002 | 2020-10-06 01:31:05 | shoji | 1 | 28756 | 3 | 0.456 | 63061.4 |
| 1001 | 2020-09-30 03:16:16 | shoji | 1 | 28756 | 3 | 0.436 | 65954.1 |