History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pekin"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1216 | 2024-04-03 03:34:44 | pekin | 2 | 53800 | 66 | 5.173 | 10400.2 |
1215 | 2024-04-03 03:25:01 | pekin | 1 | 28756 | 4 | 0.563 | 51076.4 |
1214 | 2024-04-02 21:00:14 | pekin | 3 | 83667 | 1057 | 4.156 | 20131.6 |
1213 | 2024-03-31 20:17:27 | pekin | 3 | 83667 | 1057 | 7.143 | 11713.1 |
1212 | 2024-03-31 15:48:01 | pekin | 1 | 28756 | 4 | 0.516 | 55728.7 |
1211 | 2024-03-30 23:48:31 | pekin | 2 | 53800 | 66 | 3.813 | 14109.6 |
1210 | 2024-03-30 23:47:48 | pekin | 3 | 83667 | 1057 | 5.390 | 15522.6 |
1209 | 2024-03-30 23:06:10 | pekin | 3 | 83667 | 1057 | 6.216 | 13459.9 |
1208 | 2024-03-28 16:05:04 | pekin | 1 | 28756 | 4 | 0.500 | 57512.0 |
1207 | 2024-03-27 06:07:55 | pekin | 1 | 28756 | 4 | 0.876 | 32826.5 |
1206 | 2024-03-20 18:15:24 | pekin | 1 | 28756 | 4 | 0.486 | 59168.7 |
1205 | 2024-03-20 18:14:26 | pekin | 3 | 83667 | 1057 | 7.846 | 10663.7 |
1204 | 2024-03-19 21:10:53 | pekin | 3 | 83667 | 1057 | 3.533 | 23681.6 |
1203 | 2024-03-17 23:33:45 | pekin | 3 | 83667 | 1057 | 8.313 | 10064.6 |
1202 | 2024-03-15 18:53:14 | pekin | 3 | 83667 | 1057 | 3.373 | 24804.9 |
1201 | 2024-03-13 19:03:23 | pekin | 3 | 83667 | 1057 | 11.703 | 7149.2 |
1200 | 2024-03-05 18:10:29 | pekin | 1 | 28756 | 4 | 1.750 | 16432.0 |
1199 | 2024-03-03 23:01:17 | pekin | 1 | 28756 | 4 | 1.156 | 24875.4 |
1198 | 2024-03-01 12:01:12 | pekin | 1 | 28756 | 4 | 1.110 | 25906.3 |
1197 | 2024-02-25 22:57:38 | pekin | 1 | 28756 | 4 | 0.563 | 51076.4 |
1196 | 2024-02-22 21:18:21 | pekin | 2 | 53800 | 66 | 1.686 | 31909.8 |
1195 | 2024-02-22 21:17:17 | pekin | 3 | 83667 | 1057 | 3.826 | 21868.0 |
1194 | 2024-02-18 07:58:44 | pekin | 3 | 83667 | 1057 | 10.156 | 8238.2 |
1193 | 2024-02-17 20:49:46 | pekin | 3 | 83667 | 1057 | 3.783 | 22116.6 |
1192 | 2024-02-16 21:34:15 | pekin | 3 | 83667 | 1057 | 4.220 | 19826.3 |
1191 | 2024-02-06 21:14:36 | pekin | 3 | 83667 | 1057 | 4.423 | 18916.3 |
1190 | 2024-02-05 19:45:22 | pekin | 3 | 83667 | 1057 | 4.016 | 20833.4 |
1189 | 2024-02-05 19:11:57 | pekin | 2 | 53800 | 66 | 3.203 | 16796.8 |
1188 | 2024-02-05 19:11:09 | pekin | 3 | 83667 | 1057 | 5.750 | 14550.8 |
1187 | 2024-02-05 15:33:03 | pekin | 2 | 53800 | 66 | 2.640 | 20378.8 |
1186 | 2024-02-05 15:32:39 | pekin | 3 | 83667 | 1057 | 5.173 | 16173.8 |
1185 | 2024-02-05 04:15:13 | pekin | 3 | 83667 | 1057 | 4.360 | 19189.7 |
1184 | 2024-02-04 20:58:12 | pekin | 3 | 83667 | 1057 | 6.940 | 12055.8 |
1183 | 2024-01-30 04:28:54 | pekin | 1 | 28756 | 4 | 0.533 | 53951.2 |
1182 | 2024-01-29 10:18:03 | pekin | 1 | 28756 | 4 | 0.500 | 57512.0 |
1181 | 2024-01-26 21:07:41 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1180 | 2024-01-23 03:57:56 | pekin | 3 | 83667 | 1057 | 9.016 | 9279.8 |
1179 | 2024-01-23 00:54:05 | pekin | 3 | 83667 | 1057 | 4.750 | 17614.1 |
1178 | 2024-01-09 15:29:53 | pekin | 3 | 83667 | 1057 | 3.453 | 24230.2 |
1177 | 2023-12-30 12:30:20 | pekin | 3 | 83667 | 1057 | 3.436 | 24350.1 |
1176 | 2023-12-30 12:30:22 | pekin | 2 | 53800 | 66 | 1.580 | 34050.6 |
1175 | 2023-12-26 17:21:22 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1174 | 2023-12-24 03:55:47 | pekin | 3 | 83667 | 1057 | 3.576 | 23396.8 |
1173 | 2023-12-21 01:14:10 | pekin | 2 | 53800 | 66 | 1.406 | 38264.6 |
1172 | 2023-12-17 02:07:52 | pekin | 3 | 83667 | 1057 | 3.610 | 23176.5 |
1171 | 2023-12-15 14:26:42 | pekin | 3 | 83667 | 1057 | 3.326 | 25155.4 |
1170 | 2023-12-14 01:50:47 | pekin | 2 | 53800 | 66 | 1.500 | 35866.7 |
1169 | 2023-12-14 01:50:39 | pekin | 3 | 83667 | 1057 | 3.266 | 25617.6 |
1168 | 2023-12-03 13:47:34 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1167 | 2023-12-03 13:47:33 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1166 | 2023-11-24 22:58:41 | pekin | 1 | 28756 | 4 | 0.470 | 61183.0 |
1165 | 2023-11-23 13:50:59 | pekin | 1 | 28756 | 4 | 0.486 | 59168.7 |
1164 | 2023-11-22 23:08:55 | pekin | 3 | 83667 | 1057 | 3.766 | 22216.4 |
1163 | 2023-11-19 05:22:04 | pekin | 1 | 28756 | 4 | 0.470 | 61183.0 |
1162 | 2023-11-13 10:55:50 | pekin | 1 | 28756 | 4 | 0.470 | 61183.0 |
1161 | 2023-10-29 04:59:34 | pekin | 1 | 28756 | 4 | 0.533 | 53951.2 |
1160 | 2023-10-28 19:52:50 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1159 | 2023-10-23 19:28:19 | pekin | 1 | 28756 | 4 | 0.546 | 52666.7 |
1158 | 2023-10-17 07:37:42 | pekin | 3 | 83667 | 1057 | 3.623 | 23093.3 |
1157 | 2023-10-15 18:31:12 | pekin | 1 | 28756 | 4 | 0.483 | 59536.2 |
1156 | 2023-10-15 10:27:57 | pekin | 1 | 28756 | 4 | 0.516 | 55728.7 |
1155 | 2023-10-13 23:55:04 | pekin | 3 | 83667 | 1057 | 4.500 | 18592.7 |
1154 | 2023-10-07 03:49:10 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1153 | 2023-09-26 13:40:36 | pekin | 1 | 28756 | 4 | 0.486 | 59168.7 |
1152 | 2023-09-22 16:53:17 | pekin | 1 | 28756 | 4 | 0.470 | 61183.0 |
1151 | 2023-09-21 20:32:10 | pekin | 2 | 53800 | 66 | 1.550 | 34709.7 |
1150 | 2023-09-10 07:55:39 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1149 | 2023-08-14 09:54:46 | pekin | 3 | 83667 | 1057 | 3.906 | 21420.1 |
1148 | 2023-08-12 19:03:24 | pekin | 3 | 83667 | 1057 | 3.796 | 22040.8 |
1147 | 2023-08-08 08:23:59 | pekin | 3 | 83667 | 1057 | 3.750 | 22311.2 |
1146 | 2023-07-28 04:24:18 | pekin | 3 | 83667 | 1057 | 3.733 | 22412.8 |
1145 | 2023-07-01 23:19:04 | pekin | 2 | 53800 | 66 | 1.436 | 37465.2 |
1144 | 2023-06-24 19:06:43 | pekin | 1 | 28756 | 4 | 0.500 | 57512.0 |
1143 | 2023-06-20 10:18:49 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1142 | 2023-04-08 11:04:44 | pekin | 3 | 83667 | 1057 | 3.250 | 25743.7 |
1141 | 2023-04-04 03:39:44 | pekin | 1 | 28756 | 4 | 1.000 | 28756.0 |
1140 | 2023-03-22 22:26:09 | pekin | 2 | 53800 | 66 | 1.546 | 34799.5 |
1139 | 2023-03-05 23:41:50 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1138 | 2023-02-18 23:49:46 | pekin | 3 | 83667 | 1057 | 3.936 | 21256.9 |
1137 | 2023-01-14 21:53:31 | pekin | 1 | 28756 | 4 | 0.420 | 68466.7 |
1136 | 2023-01-05 19:33:53 | pekin | 3 | 83667 | 1057 | 3.906 | 21420.1 |
1135 | 2022-12-22 06:15:54 | pekin | 2 | 53800 | 66 | 1.330 | 40451.1 |
1134 | 2022-12-20 15:35:10 | pekin | 3 | 83667 | 1057 | 3.923 | 21327.3 |
1133 | 2022-12-02 15:41:27 | pekin | 3 | 83667 | 1057 | 3.873 | 21602.6 |
1132 | 2022-11-13 20:00:13 | pekin | 1 | 28756 | 4 | 0.486 | 59168.7 |
1131 | 2022-11-08 04:59:40 | pekin | 1 | 28756 | 4 | 0.456 | 63061.4 |
1130 | 2022-11-01 22:51:18 | pekin | 3 | 83667 | 1057 | 4.126 | 20278.0 |
1129 | 2022-09-11 04:51:16 | pekin | 3 | 83667 | 1057 | 3.203 | 26121.4 |
1128 | 2022-08-21 11:40:12 | pekin | 2 | 53800 | 66 | 1.360 | 39558.8 |
1127 | 2022-07-20 22:26:55 | pekin | 1 | 28756 | 4 | 0.513 | 56054.6 |
1126 | 2022-07-17 05:10:14 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1125 | 2022-06-30 04:36:44 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1124 | 2022-06-27 23:55:05 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1123 | 2022-05-25 06:27:50 | pekin | 3 | 83667 | 1057 | 3.546 | 23594.8 |
1122 | 2022-04-27 04:26:47 | pekin | 1 | 28756 | 4 | 0.453 | 63479.0 |
1121 | 2022-03-30 09:58:39 | pekin | 3 | 83667 | 1057 | 3.766 | 22216.4 |
1120 | 2022-03-13 00:36:32 | pekin | 1 | 28756 | 4 | 0.486 | 59168.7 |
1119 | 2022-03-09 16:14:30 | pekin | 1 | 28756 | 4 | 0.436 | 65954.1 |
1118 | 2022-03-02 23:16:33 | pekin | 1 | 28756 | 4 | 0.440 | 65354.5 |
1117 | 2021-12-19 20:17:20 | pekin | 1 | 28756 | 4 | 0.483 | 59536.2 |