History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fatso"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1331 | 2024-04-27 10:47:43 | fatso | 3 | 83667 | 1090 | 10.453 | 8004.1 |
1330 | 2024-04-27 10:25:12 | fatso | 3 | 83667 | 1090 | 17.233 | 4855.0 |
1329 | 2024-04-27 00:41:31 | fatso | 3 | 83667 | 1090 | 16.826 | 4972.5 |
1328 | 2024-04-26 11:21:24 | fatso | 3 | 83667 | 1090 | 4.606 | 18164.8 |
1327 | 2024-04-26 01:04:58 | fatso | 3 | 83667 | 1090 | 6.593 | 12690.3 |
1326 | 2024-04-25 21:10:37 | fatso | 3 | 83667 | 1090 | 7.593 | 11019.0 |
1325 | 2024-04-25 07:42:38 | fatso | 3 | 83667 | 1090 | 13.453 | 6219.2 |
1324 | 2024-04-25 01:42:01 | fatso | 3 | 83667 | 1090 | 4.530 | 18469.5 |
1323 | 2024-04-25 00:52:21 | fatso | 3 | 83667 | 1090 | 18.890 | 4429.2 |
1322 | 2024-04-24 21:04:40 | fatso | 3 | 83667 | 1090 | 9.560 | 8751.8 |
1321 | 2024-04-24 09:07:44 | fatso | 1 | 28756 | 3 | 0.843 | 34111.5 |
1320 | 2024-04-23 20:58:39 | fatso | 3 | 83667 | 1090 | 6.983 | 11981.5 |
1319 | 2024-04-23 05:30:07 | fatso | 3 | 83667 | 1090 | 4.686 | 17854.7 |
1318 | 2024-04-22 17:56:18 | fatso | 3 | 83667 | 1090 | 9.860 | 8485.5 |
1317 | 2024-04-22 14:00:47 | fatso | 3 | 83667 | 1090 | 11.783 | 7100.7 |
1316 | 2024-04-22 05:19:18 | fatso | 3 | 83667 | 1090 | 3.593 | 23286.1 |
1315 | 2024-04-21 14:06:19 | fatso | 3 | 83667 | 1090 | 4.390 | 19058.5 |
1314 | 2024-04-20 13:49:53 | fatso | 3 | 83667 | 1090 | 4.220 | 19826.3 |
1313 | 2024-04-19 23:05:08 | fatso | 3 | 83667 | 1090 | 9.220 | 9074.5 |
1312 | 2024-04-19 20:05:37 | fatso | 3 | 83667 | 1090 | 10.063 | 8314.3 |
1311 | 2024-04-19 15:12:34 | fatso | 2 | 53800 | 68 | 2.220 | 24234.2 |
1310 | 2024-04-19 15:12:01 | fatso | 3 | 83667 | 1090 | 5.063 | 16525.2 |
1309 | 2024-04-19 06:00:54 | fatso | 3 | 83667 | 1090 | 3.750 | 22311.2 |
1308 | 2024-04-18 19:57:15 | fatso | 3 | 83667 | 1090 | 3.516 | 23796.1 |
1307 | 2024-04-18 07:12:03 | fatso | 3 | 83667 | 1090 | 7.766 | 10773.5 |
1306 | 2024-04-17 07:32:16 | fatso | 3 | 83667 | 1090 | 4.670 | 17915.8 |
1305 | 2024-04-16 20:17:53 | fatso | 3 | 83667 | 1090 | 6.690 | 12506.3 |
1304 | 2024-04-15 19:52:19 | fatso | 3 | 83667 | 1090 | 16.066 | 5207.7 |
1303 | 2024-04-14 19:49:29 | fatso | 3 | 83667 | 1090 | 9.376 | 8923.5 |
1302 | 2024-04-13 19:51:44 | fatso | 3 | 83667 | 1090 | 4.890 | 17109.8 |
1301 | 2024-04-13 06:33:39 | fatso | 3 | 83667 | 1090 | 4.063 | 20592.4 |
1300 | 2024-04-12 07:00:04 | fatso | 3 | 83667 | 1090 | 9.266 | 9029.5 |
1299 | 2024-04-11 06:37:45 | fatso | 3 | 83667 | 1090 | 11.716 | 7141.3 |
1298 | 2024-04-10 13:14:07 | fatso | 3 | 83667 | 1090 | 4.153 | 20146.2 |
1297 | 2024-04-10 02:38:13 | fatso | 3 | 83667 | 1090 | 6.783 | 12334.8 |
1296 | 2024-04-09 13:09:46 | fatso | 3 | 83667 | 1090 | 14.093 | 5936.8 |
1295 | 2024-04-08 13:17:29 | fatso | 3 | 83667 | 1090 | 13.016 | 6428.0 |
1294 | 2024-04-07 18:27:26 | fatso | 3 | 83667 | 1090 | 10.766 | 7771.4 |
1293 | 2024-04-06 18:35:02 | fatso | 3 | 83667 | 1090 | 12.126 | 6899.8 |
1292 | 2024-04-06 05:47:46 | fatso | 1 | 28756 | 3 | 1.673 | 17188.3 |
1291 | 2024-04-05 18:31:26 | fatso | 3 | 83667 | 1090 | 7.046 | 11874.4 |
1290 | 2024-04-05 17:47:19 | fatso | 3 | 83667 | 1090 | 4.126 | 20278.0 |
1289 | 2024-04-04 23:05:01 | fatso | 3 | 83667 | 1090 | 3.970 | 21074.8 |
1288 | 2024-04-04 02:28:59 | fatso | 3 | 83667 | 1090 | 8.343 | 10028.4 |
1287 | 2024-04-03 01:51:12 | fatso | 3 | 83667 | 1090 | 7.093 | 11795.7 |
1286 | 2024-04-02 14:04:55 | fatso | 3 | 83667 | 1090 | 5.236 | 15979.2 |
1285 | 2024-04-02 04:02:55 | fatso | 3 | 83667 | 1090 | 12.063 | 6935.8 |
1284 | 2024-04-02 01:20:25 | fatso | 1 | 28756 | 3 | 0.500 | 57512.0 |
1283 | 2024-04-01 17:40:19 | fatso | 1 | 28756 | 3 | 1.123 | 25606.4 |
1282 | 2024-04-01 14:07:58 | fatso | 3 | 83667 | 1090 | 7.843 | 10667.7 |
1281 | 2024-03-31 15:38:52 | fatso | 1 | 28756 | 3 | 0.530 | 54256.6 |
1280 | 2024-03-31 14:04:17 | fatso | 3 | 83667 | 1090 | 11.156 | 7499.7 |
1279 | 2024-03-31 06:37:37 | fatso | 3 | 83667 | 1090 | 4.093 | 20441.5 |
1278 | 2024-03-31 06:04:59 | fatso | 3 | 83667 | 1090 | 4.016 | 20833.4 |
1277 | 2024-03-30 17:41:36 | fatso | 1 | 28756 | 3 | 1.343 | 21411.8 |
1276 | 2024-03-30 15:26:44 | fatso | 3 | 83667 | 1090 | 13.016 | 6428.0 |
1275 | 2024-03-30 06:03:10 | fatso | 3 | 83667 | 1090 | 8.690 | 9628.0 |
1274 | 2024-03-29 23:49:43 | fatso | 1 | 28756 | 3 | 0.500 | 57512.0 |
1273 | 2024-03-29 16:16:59 | fatso | 3 | 83667 | 1090 | 5.206 | 16071.3 |
1272 | 2024-03-29 05:56:14 | fatso | 3 | 83667 | 1090 | 6.873 | 12173.3 |
1271 | 2024-03-28 23:32:37 | fatso | 3 | 83667 | 1090 | 11.440 | 7313.5 |
1270 | 2024-03-28 13:05:17 | fatso | 3 | 83667 | 1090 | 3.906 | 21420.1 |
1269 | 2024-03-27 23:05:03 | fatso | 3 | 83667 | 1090 | 4.140 | 20209.4 |
1268 | 2024-03-27 13:14:35 | fatso | 3 | 83667 | 1090 | 6.360 | 13155.2 |
1267 | 2024-03-26 23:08:55 | fatso | 3 | 83667 | 1090 | 3.500 | 23904.9 |
1266 | 2024-03-26 11:59:26 | fatso | 3 | 83667 | 1090 | 4.300 | 19457.4 |
1265 | 2024-03-25 22:30:35 | fatso | 3 | 83667 | 1090 | 7.780 | 10754.1 |
1264 | 2024-03-25 07:34:02 | fatso | 3 | 83667 | 1090 | 3.546 | 23594.8 |
1263 | 2024-03-24 06:33:22 | fatso | 3 | 83667 | 1090 | 4.093 | 20441.5 |
1262 | 2024-03-24 01:56:49 | fatso | 3 | 83667 | 1090 | 4.080 | 20506.6 |
1261 | 2024-03-23 14:41:58 | fatso | 3 | 83667 | 1090 | 3.266 | 25617.6 |
1260 | 2024-03-23 09:41:09 | fatso | 3 | 83667 | 1090 | 3.546 | 23594.8 |
1259 | 2024-03-23 06:26:08 | fatso | 3 | 83667 | 1090 | 4.593 | 18216.2 |
1258 | 2024-03-22 23:09:39 | fatso | 3 | 83667 | 1090 | 3.266 | 25617.6 |
1257 | 2024-03-21 21:34:20 | fatso | 3 | 83667 | 1090 | 14.390 | 5814.2 |
1256 | 2024-03-21 21:34:01 | fatso | 3 | 83667 | 1090 | 7.173 | 11664.2 |
1255 | 2024-03-21 12:01:19 | fatso | 3 | 83667 | 1090 | 13.330 | 6276.6 |
1254 | 2024-03-20 21:06:41 | fatso | 3 | 83667 | 1090 | 5.860 | 14277.6 |
1253 | 2024-03-19 21:12:30 | fatso | 3 | 83667 | 1090 | 3.440 | 24321.8 |
1252 | 2024-03-19 12:57:10 | fatso | 3 | 83667 | 1090 | 4.966 | 16848.0 |
1251 | 2024-03-19 02:22:16 | fatso | 3 | 83667 | 1090 | 7.296 | 11467.5 |
1250 | 2024-03-18 13:18:24 | fatso | 3 | 83667 | 1090 | 10.156 | 8238.2 |
1249 | 2024-03-18 02:53:35 | fatso | 3 | 83667 | 1090 | 4.310 | 19412.3 |
1248 | 2024-03-16 19:01:24 | fatso | 3 | 83667 | 1090 | 9.716 | 8611.3 |
1247 | 2024-03-16 14:40:47 | fatso | 3 | 83667 | 1090 | 11.596 | 7215.2 |
1246 | 2024-03-15 19:08:07 | fatso | 3 | 83667 | 1090 | 3.280 | 25508.2 |
1245 | 2024-03-15 17:35:48 | fatso | 3 | 83667 | 1090 | 3.546 | 23594.8 |
1244 | 2024-03-14 15:54:28 | fatso | 3 | 83667 | 1090 | 4.313 | 19398.8 |
1243 | 2024-03-14 02:12:46 | fatso | 3 | 83667 | 1090 | 4.143 | 20194.8 |
1242 | 2024-03-13 14:57:49 | fatso | 3 | 83667 | 1090 | 9.626 | 8691.8 |
1241 | 2024-03-13 07:35:27 | fatso | 3 | 83667 | 1090 | 5.313 | 15747.6 |
1240 | 2024-03-12 15:56:49 | fatso | 3 | 83667 | 1090 | 3.593 | 23286.1 |
1239 | 2024-03-12 10:33:58 | fatso | 3 | 83667 | 1090 | 3.643 | 22966.5 |
1238 | 2024-03-11 23:38:57 | fatso | 3 | 83667 | 1090 | 4.266 | 19612.5 |
1237 | 2024-03-11 12:41:34 | fatso | 3 | 83667 | 1090 | 10.233 | 8176.2 |
1236 | 2024-03-10 22:02:17 | fatso | 3 | 83667 | 1090 | 4.576 | 18283.9 |
1235 | 2024-03-10 13:46:30 | fatso | 3 | 83667 | 1090 | 5.220 | 16028.2 |
1234 | 2024-03-09 21:17:31 | fatso | 3 | 83667 | 1090 | 4.966 | 16848.0 |
1233 | 2024-03-09 11:21:16 | fatso | 3 | 83667 | 1090 | 3.266 | 25617.6 |
1232 | 2024-03-09 01:45:16 | fatso | 3 | 83667 | 1090 | 6.610 | 12657.6 |