History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pear"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1339 | 2024-04-18 18:44:40 | pear | 1 | 13983 | 28 | 0.326 | 42892.6 |
1338 | 2024-04-12 08:51:05 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1337 | 2024-04-07 21:45:09 | pear | 1 | 13983 | 28 | 0.906 | 15433.8 |
1336 | 2024-04-01 15:51:25 | pear | 1 | 13983 | 28 | 0.546 | 25609.9 |
1335 | 2024-03-30 19:53:18 | pear | 2 | 29872 | 320 | 3.123 | 9565.2 |
1334 | 2024-03-30 18:39:48 | pear | 1 | 13983 | 28 | 0.530 | 26383.0 |
1333 | 2024-03-07 06:04:46 | pear | 2 | 29872 | 320 | 2.533 | 11793.1 |
1332 | 2024-03-04 12:44:41 | pear | 1 | 13983 | 28 | 0.860 | 16259.3 |
1331 | 2024-03-02 14:35:29 | pear | 2 | 29872 | 320 | 1.703 | 17540.8 |
1330 | 2024-03-02 13:41:56 | pear | 1 | 13983 | 28 | 0.263 | 53167.3 |
1329 | 2024-03-01 10:43:43 | pear | 1 | 13983 | 28 | 0.766 | 18254.6 |
1328 | 2024-02-27 03:26:33 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1327 | 2024-02-25 20:32:11 | pear | 2 | 29872 | 320 | 1.033 | 28917.7 |
1326 | 2024-01-26 06:44:13 | pear | 1 | 13983 | 28 | 0.470 | 29751.1 |
1325 | 2024-01-21 08:31:33 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1324 | 2024-01-06 01:42:07 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1323 | 2023-12-31 03:22:24 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1322 | 2023-12-08 15:34:22 | pear | 2 | 29872 | 320 | 0.750 | 39829.3 |
1321 | 2023-12-01 16:34:43 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1320 | 2023-11-29 00:56:23 | pear | 2 | 29872 | 320 | 0.783 | 38150.7 |
1319 | 2023-11-24 19:32:58 | pear | 2 | 29872 | 320 | 0.860 | 34734.9 |
1318 | 2023-11-18 22:44:10 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1317 | 2023-11-10 22:47:11 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1316 | 2023-11-10 08:00:24 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1315 | 2023-10-27 14:16:47 | pear | 2 | 29872 | 320 | 0.936 | 31914.5 |
1314 | 2023-10-27 13:09:17 | pear | 1 | 13983 | 28 | 0.263 | 53167.3 |
1313 | 2023-10-25 02:27:16 | pear | 2 | 29872 | 320 | 0.923 | 32364.0 |
1312 | 2023-10-24 20:04:31 | pear | 1 | 13983 | 28 | 0.263 | 53167.3 |
1311 | 2023-10-24 18:44:51 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1310 | 2023-10-24 15:25:12 | pear | 2 | 29872 | 320 | 0.750 | 39829.3 |
1309 | 2023-10-23 02:51:30 | pear | 2 | 29872 | 320 | 0.893 | 33451.3 |
1308 | 2023-10-21 20:15:38 | pear | 1 | 13983 | 28 | 0.266 | 52567.7 |
1307 | 2023-10-19 18:49:48 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1306 | 2023-10-17 17:15:55 | pear | 1 | 13983 | 28 | 0.516 | 27098.8 |
1305 | 2023-10-17 00:40:43 | pear | 2 | 29872 | 320 | 0.830 | 35990.4 |
1304 | 2023-10-10 22:29:50 | pear | 1 | 13983 | 28 | 0.470 | 29751.1 |
1303 | 2023-10-04 08:05:05 | pear | 1 | 13983 | 28 | 0.236 | 59250.0 |
1302 | 2023-09-28 13:01:57 | pear | 2 | 29872 | 320 | 0.830 | 35990.4 |
1301 | 2023-09-22 06:44:31 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1300 | 2023-09-20 21:39:02 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1299 | 2023-09-19 20:50:32 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1298 | 2023-08-24 13:20:35 | pear | 2 | 29872 | 320 | 0.876 | 34100.5 |
1297 | 2023-08-17 04:07:49 | pear | 1 | 13983 | 28 | 0.206 | 67878.6 |
1296 | 2023-08-16 01:22:39 | pear | 1 | 13983 | 28 | 0.280 | 49939.3 |
1295 | 2023-08-15 22:09:28 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1294 | 2023-05-18 12:08:36 | pear | 2 | 29872 | 320 | 0.736 | 40587.0 |
1293 | 2023-05-18 07:29:45 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1292 | 2023-05-09 21:40:02 | pear | 2 | 29872 | 320 | 0.780 | 38297.4 |
1291 | 2023-05-08 23:41:45 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1290 | 2023-04-02 13:36:57 | pear | 2 | 29872 | 320 | 0.843 | 35435.3 |
1289 | 2023-03-31 13:39:57 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1288 | 2023-03-13 22:25:21 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1287 | 2023-02-15 01:30:30 | pear | 2 | 29872 | 320 | 0.856 | 34897.2 |
1286 | 2023-02-02 15:47:05 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1285 | 2023-01-02 22:10:23 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1284 | 2022-11-26 02:47:56 | pear | 2 | 29872 | 320 | 0.750 | 39829.3 |
1283 | 2022-10-19 18:29:36 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1282 | 2022-09-22 13:56:55 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1281 | 2022-06-25 20:10:39 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1280 | 2022-05-04 10:49:30 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1279 | 2022-04-14 12:37:11 | pear | 2 | 29872 | 320 | 0.843 | 35435.3 |
1278 | 2022-03-22 01:41:25 | pear | 1 | 13983 | 28 | 0.203 | 68881.8 |
1277 | 2022-03-21 13:24:05 | pear | 1 | 13983 | 28 | 0.280 | 49939.3 |
1276 | 2022-03-20 13:24:10 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1275 | 2022-03-16 08:45:37 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1274 | 2022-03-12 21:47:58 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1273 | 2022-02-10 13:56:35 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1272 | 2022-02-09 22:50:41 | pear | 1 | 13983 | 28 | 0.533 | 26234.5 |
1271 | 2022-02-08 22:50:17 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1270 | 2022-02-07 07:43:49 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1269 | 2022-02-06 15:30:15 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1268 | 2022-02-05 17:32:57 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1267 | 2022-02-05 00:46:20 | pear | 1 | 13983 | 28 | 0.203 | 68881.8 |
1266 | 2022-02-04 15:37:56 | pear | 1 | 13983 | 28 | 0.266 | 52567.7 |
1265 | 2022-02-04 02:25:20 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1264 | 2022-02-03 15:17:55 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1263 | 2022-02-03 05:40:49 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1262 | 2022-02-02 20:48:38 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1261 | 2022-02-02 04:40:03 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1260 | 2022-02-01 17:23:07 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1259 | 2022-02-01 09:03:29 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1258 | 2022-01-31 23:49:48 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1257 | 2022-01-31 08:11:46 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1256 | 2022-01-31 00:39:12 | pear | 1 | 13983 | 28 | 0.390 | 35853.8 |
1255 | 2022-01-30 13:43:32 | pear | 1 | 13983 | 28 | 0.236 | 59250.0 |
1254 | 2022-01-30 05:05:40 | pear | 1 | 13983 | 28 | 0.216 | 64736.1 |
1253 | 2022-01-29 11:54:52 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1252 | 2022-01-28 21:56:13 | pear | 1 | 13983 | 28 | 0.236 | 59250.0 |
1251 | 2022-01-28 08:22:38 | pear | 1 | 13983 | 28 | 0.296 | 47239.9 |
1250 | 2022-01-27 19:27:33 | pear | 1 | 13983 | 28 | 0.203 | 68881.8 |
1249 | 2022-01-27 18:46:34 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1248 | 2022-01-27 02:09:03 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1247 | 2022-01-26 17:14:42 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1246 | 2022-01-26 07:25:17 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1245 | 2022-01-25 23:20:29 | pear | 1 | 13983 | 28 | 0.220 | 63559.1 |
1244 | 2022-01-25 08:17:33 | pear | 1 | 13983 | 28 | 0.280 | 49939.3 |
1243 | 2022-01-24 18:56:49 | pear | 1 | 13983 | 28 | 0.233 | 60012.9 |
1242 | 2022-01-24 07:05:11 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1241 | 2022-01-23 17:17:30 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |
1240 | 2022-01-13 01:19:33 | pear | 1 | 13983 | 28 | 0.250 | 55932.0 |