History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"facia"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1273 | 2024-05-10 02:00:54 | facia | 1 | 28756 | 5 | 1.610 | 17860.9 |
1272 | 2024-05-06 11:29:11 | facia | 2 | 53800 | 67 | 1.783 | 30173.9 |
1271 | 2024-05-06 11:28:47 | facia | 1 | 28756 | 5 | 1.063 | 27051.7 |
1270 | 2024-05-01 12:13:24 | facia | 3 | 83667 | 1029 | 10.140 | 8251.2 |
1269 | 2024-05-01 11:30:16 | facia | 1 | 28756 | 5 | 1.033 | 27837.4 |
1268 | 2024-05-01 05:10:24 | facia | 3 | 83667 | 1029 | 4.906 | 17054.0 |
1267 | 2024-05-01 00:20:43 | facia | 2 | 53800 | 67 | 1.643 | 32745.0 |
1266 | 2024-05-01 00:20:39 | facia | 3 | 83667 | 1029 | 4.236 | 19751.4 |
1265 | 2024-05-01 00:20:35 | facia | 1 | 28756 | 5 | 0.440 | 65354.5 |
1264 | 2024-04-30 21:40:55 | facia | 1 | 28756 | 5 | 1.063 | 27051.7 |
1263 | 2024-04-30 00:46:33 | facia | 1 | 28756 | 5 | 0.530 | 54256.6 |
1262 | 2024-04-26 09:18:06 | facia | 1 | 28756 | 5 | 0.563 | 51076.4 |
1261 | 2024-04-17 13:49:11 | facia | 2 | 53800 | 67 | 6.080 | 8848.7 |
1260 | 2024-04-17 13:48:07 | facia | 3 | 83667 | 1029 | 7.296 | 11467.5 |
1259 | 2024-04-16 01:08:13 | facia | 2 | 53800 | 67 | 3.546 | 15172.0 |
1258 | 2024-04-16 01:07:35 | facia | 3 | 83667 | 1029 | 3.390 | 24680.5 |
1257 | 2024-04-15 22:52:05 | facia | 3 | 83667 | 1029 | 13.123 | 6375.6 |
1256 | 2024-04-06 05:50:00 | facia | 1 | 28756 | 5 | 1.173 | 24514.9 |
1255 | 2024-03-31 16:12:50 | facia | 1 | 28756 | 5 | 0.516 | 55728.7 |
1254 | 2024-03-29 09:27:43 | facia | 1 | 28756 | 5 | 0.516 | 55728.7 |
1253 | 2024-03-16 09:19:00 | facia | 3 | 83667 | 1029 | 8.110 | 10316.5 |
1252 | 2024-03-07 03:52:08 | facia | 1 | 28756 | 5 | 1.030 | 27918.4 |
1251 | 2024-03-06 23:18:10 | facia | 3 | 83667 | 1029 | 4.596 | 18204.3 |
1250 | 2024-03-05 21:27:21 | facia | 3 | 83667 | 1029 | 3.953 | 21165.4 |
1249 | 2024-03-04 20:41:54 | facia | 2 | 53800 | 67 | 1.843 | 29191.5 |
1248 | 2024-03-04 20:41:53 | facia | 1 | 28756 | 5 | 0.530 | 54256.6 |
1247 | 2024-03-04 20:41:47 | facia | 2 | 53800 | 67 | 1.796 | 29955.5 |
1246 | 2024-03-04 20:41:20 | facia | 3 | 83667 | 1029 | 7.203 | 11615.6 |
1245 | 2024-03-04 20:41:10 | facia | 3 | 83667 | 1029 | 8.470 | 9878.0 |
1244 | 2024-03-01 11:46:45 | facia | 1 | 28756 | 5 | 0.440 | 65354.5 |
1243 | 2024-02-28 07:15:13 | facia | 3 | 83667 | 1029 | 5.360 | 15609.5 |
1242 | 2024-02-28 07:15:09 | facia | 1 | 28756 | 5 | 2.110 | 13628.4 |
1241 | 2024-02-23 22:48:36 | facia | 1 | 28756 | 5 | 0.503 | 57169.0 |
1240 | 2024-02-03 18:46:03 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1239 | 2024-02-01 03:44:12 | facia | 2 | 53800 | 67 | 1.500 | 35866.7 |
1238 | 2024-02-01 03:43:44 | facia | 3 | 83667 | 1029 | 3.720 | 22491.1 |
1237 | 2024-01-30 18:24:19 | facia | 2 | 53800 | 67 | 1.736 | 30990.8 |
1236 | 2024-01-30 18:23:51 | facia | 3 | 83667 | 1029 | 3.983 | 21006.0 |
1235 | 2024-01-29 10:22:23 | facia | 1 | 28756 | 5 | 0.483 | 59536.2 |
1234 | 2024-01-29 05:28:05 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1233 | 2024-01-27 11:46:43 | facia | 3 | 83667 | 1029 | 5.486 | 15251.0 |
1232 | 2024-01-26 15:31:37 | facia | 3 | 83667 | 1029 | 3.890 | 21508.2 |
1231 | 2024-01-17 10:56:08 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1230 | 2024-01-13 18:12:11 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1229 | 2023-12-30 19:37:04 | facia | 3 | 83667 | 1029 | 3.310 | 25277.0 |
1228 | 2023-12-24 16:33:05 | facia | 2 | 53800 | 67 | 1.423 | 37807.4 |
1227 | 2023-12-21 16:39:54 | facia | 2 | 53800 | 67 | 1.406 | 38264.6 |
1226 | 2023-12-05 02:14:37 | facia | 1 | 28756 | 5 | 0.516 | 55728.7 |
1225 | 2023-11-27 00:27:58 | facia | 3 | 83667 | 1029 | 5.686 | 14714.6 |
1224 | 2023-11-24 23:49:05 | facia | 3 | 83667 | 1029 | 4.266 | 19612.5 |
1223 | 2023-11-12 22:02:18 | facia | 1 | 28756 | 5 | 0.483 | 59536.2 |
1222 | 2023-11-12 14:09:30 | facia | 3 | 83667 | 1029 | 3.703 | 22594.4 |
1221 | 2023-11-12 14:09:28 | facia | 2 | 53800 | 67 | 1.500 | 35866.7 |
1220 | 2023-11-11 22:08:55 | facia | 1 | 28756 | 5 | 0.483 | 59536.2 |
1219 | 2023-11-09 18:50:39 | facia | 3 | 83667 | 1029 | 3.220 | 25983.5 |
1218 | 2023-11-03 07:08:58 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1217 | 2023-10-21 09:04:59 | facia | 1 | 28756 | 5 | 0.500 | 57512.0 |
1216 | 2023-10-18 11:58:54 | facia | 1 | 28756 | 5 | 0.500 | 57512.0 |
1215 | 2023-10-12 01:01:04 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1214 | 2023-10-05 04:13:18 | facia | 1 | 28756 | 5 | 0.486 | 59168.7 |
1213 | 2023-09-30 09:05:52 | facia | 1 | 28756 | 5 | 0.500 | 57512.0 |
1212 | 2023-09-27 01:11:52 | facia | 1 | 28756 | 5 | 0.450 | 63902.2 |
1211 | 2023-09-22 13:49:34 | facia | 1 | 28756 | 5 | 0.436 | 65954.1 |
1210 | 2023-09-18 02:26:54 | facia | 1 | 28756 | 5 | 0.440 | 65354.5 |
1209 | 2023-08-20 20:15:02 | facia | 3 | 83667 | 1029 | 4.280 | 19548.4 |
1208 | 2023-08-18 06:11:19 | facia | 3 | 83667 | 1029 | 3.420 | 24464.0 |
1207 | 2023-07-13 08:37:35 | facia | 3 | 83667 | 1029 | 3.236 | 25855.1 |
1206 | 2023-07-12 00:26:56 | facia | 3 | 83667 | 1029 | 3.406 | 24564.6 |
1205 | 2023-07-10 06:39:04 | facia | 3 | 83667 | 1029 | 3.750 | 22311.2 |
1204 | 2023-07-09 09:16:14 | facia | 3 | 83667 | 1029 | 3.780 | 22134.1 |
1203 | 2023-07-08 14:47:45 | facia | 1 | 28756 | 5 | 0.440 | 65354.5 |
1202 | 2023-07-08 14:44:10 | facia | 3 | 83667 | 1029 | 3.483 | 24021.5 |
1201 | 2023-07-07 01:36:00 | facia | 3 | 83667 | 1029 | 3.826 | 21868.0 |
1200 | 2023-07-06 07:42:10 | facia | 3 | 83667 | 1029 | 3.906 | 21420.1 |
1199 | 2023-07-04 17:39:26 | facia | 3 | 83667 | 1029 | 3.983 | 21006.0 |
1198 | 2023-07-04 02:44:24 | facia | 3 | 83667 | 1029 | 3.283 | 25484.9 |
1197 | 2023-07-03 04:50:57 | facia | 3 | 83667 | 1029 | 3.813 | 21942.6 |
1196 | 2023-07-02 11:47:06 | facia | 3 | 83667 | 1029 | 3.720 | 22491.1 |
1195 | 2023-07-01 17:19:14 | facia | 3 | 83667 | 1029 | 3.250 | 25743.7 |
1194 | 2023-07-01 00:00:49 | facia | 3 | 83667 | 1029 | 3.703 | 22594.4 |
1193 | 2023-06-30 04:47:16 | facia | 3 | 83667 | 1029 | 3.593 | 23286.1 |
1192 | 2023-06-29 15:02:38 | facia | 3 | 83667 | 1029 | 3.250 | 25743.7 |
1191 | 2023-06-28 22:08:07 | facia | 3 | 83667 | 1029 | 3.453 | 24230.2 |
1190 | 2023-06-28 01:14:58 | facia | 3 | 83667 | 1029 | 3.330 | 25125.2 |
1189 | 2023-06-27 06:00:39 | facia | 3 | 83667 | 1029 | 3.813 | 21942.6 |
1188 | 2023-06-26 16:38:19 | facia | 3 | 83667 | 1029 | 3.763 | 22234.1 |
1187 | 2023-06-25 19:32:57 | facia | 3 | 83667 | 1029 | 3.343 | 25027.5 |
1186 | 2023-06-25 00:05:54 | facia | 3 | 83667 | 1029 | 4.360 | 19189.7 |
1185 | 2023-06-24 04:36:40 | facia | 3 | 83667 | 1029 | 3.343 | 25027.5 |
1184 | 2023-06-23 15:38:44 | facia | 3 | 83667 | 1029 | 3.423 | 24442.6 |
1183 | 2023-06-23 02:58:24 | facia | 1 | 28756 | 5 | 0.483 | 59536.2 |
1182 | 2023-06-22 15:59:41 | facia | 3 | 83667 | 1029 | 3.266 | 25617.6 |
1181 | 2023-06-21 21:45:20 | facia | 3 | 83667 | 1029 | 3.533 | 23681.6 |
1180 | 2023-06-21 03:42:55 | facia | 3 | 83667 | 1029 | 3.623 | 23093.3 |
1179 | 2023-06-20 12:46:46 | facia | 3 | 83667 | 1029 | 3.423 | 24442.6 |
1178 | 2023-06-19 18:29:32 | facia | 3 | 83667 | 1029 | 3.343 | 25027.5 |
1177 | 2023-06-19 03:49:54 | facia | 3 | 83667 | 1029 | 3.313 | 25254.2 |
1176 | 2023-06-18 06:53:27 | facia | 3 | 83667 | 1029 | 3.283 | 25484.9 |
1175 | 2023-06-16 21:34:07 | facia | 3 | 83667 | 1029 | 3.406 | 24564.6 |
1174 | 2023-06-16 03:50:22 | facia | 3 | 83667 | 1029 | 3.440 | 24321.8 |