History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"airfield"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
405 | 2024-04-28 08:55:13 | airfield | 1 | 82945 | 2 | 4.186 | 19814.9 |
404 | 2024-04-26 17:13:56 | airfield | 3 | 146162 | 40 | 7.906 | 18487.5 |
403 | 2024-04-20 03:41:39 | airfield | 3 | 146162 | 40 | 16.170 | 9039.1 |
402 | 2024-04-18 23:53:40 | airfield | 3 | 146162 | 40 | 17.470 | 8366.5 |
401 | 2024-04-18 23:53:32 | airfield | 2 | 121059 | 6 | 4.310 | 28087.9 |
400 | 2024-04-18 21:44:40 | airfield | 1 | 82945 | 2 | 1.453 | 57085.3 |
399 | 2024-04-18 20:56:50 | airfield | 1 | 82945 | 2 | 1.423 | 58288.8 |
398 | 2024-04-11 06:41:53 | airfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
397 | 2024-04-11 06:34:19 | airfield | 3 | 146162 | 40 | 8.580 | 17035.2 |
396 | 2024-04-11 06:33:55 | airfield | 2 | 121059 | 6 | 3.906 | 30993.1 |
395 | 2024-04-10 14:21:03 | airfield | 2 | 121059 | 6 | 8.110 | 14927.1 |
394 | 2024-04-10 13:08:58 | airfield | 4 | 161609 | 421 | 13.096 | 12340.3 |
393 | 2024-04-07 09:56:04 | airfield | 4 | 161609 | 421 | 51.473 | 3139.7 |
392 | 2024-04-06 14:31:29 | airfield | 2 | 121059 | 6 | 4.190 | 28892.4 |
391 | 2024-04-06 14:31:26 | airfield | 1 | 82945 | 2 | 2.720 | 30494.5 |
390 | 2024-04-04 16:29:05 | airfield | 2 | 121059 | 6 | 7.563 | 16006.7 |
389 | 2024-04-04 16:29:05 | airfield | 1 | 82945 | 2 | 3.156 | 26281.7 |
388 | 2024-04-04 16:13:11 | airfield | 4 | 161609 | 421 | 14.096 | 11464.9 |
387 | 2024-04-04 09:42:55 | airfield | 4 | 161609 | 421 | 13.656 | 11834.3 |
386 | 2024-04-04 09:42:56 | airfield | 3 | 146162 | 40 | 11.546 | 12659.1 |
385 | 2024-04-04 09:43:04 | airfield | 1 | 82945 | 2 | 1.983 | 41828.0 |
384 | 2024-04-04 09:42:58 | airfield | 2 | 121059 | 6 | 3.873 | 31257.2 |
383 | 2024-04-04 09:42:36 | airfield | 1 | 82945 | 2 | 1.673 | 49578.6 |
382 | 2024-03-29 06:04:06 | airfield | 1 | 82945 | 2 | 4.970 | 16689.1 |
381 | 2024-03-21 19:26:37 | airfield | 3 | 146162 | 40 | 14.173 | 10312.7 |
380 | 2024-03-16 00:37:19 | airfield | 2 | 121059 | 6 | 4.280 | 28284.8 |
379 | 2024-03-16 00:37:02 | airfield | 1 | 82945 | 2 | 1.500 | 55296.7 |
378 | 2024-03-15 21:21:05 | airfield | 3 | 146162 | 40 | 26.160 | 5587.2 |
377 | 2024-03-15 21:13:07 | airfield | 3 | 146162 | 40 | 17.500 | 8352.1 |
376 | 2024-03-12 01:37:54 | airfield | 2 | 121059 | 6 | 4.470 | 27082.6 |
375 | 2024-03-12 01:34:38 | airfield | 3 | 146162 | 40 | 7.486 | 19524.7 |
374 | 2024-03-11 22:34:15 | airfield | 4 | 161609 | 421 | 35.800 | 4514.2 |
373 | 2024-03-11 13:15:31 | airfield | 3 | 146162 | 40 | 9.890 | 14778.8 |
372 | 2024-03-11 08:50:19 | airfield | 4 | 161609 | 421 | 54.740 | 2952.3 |
371 | 2024-03-04 10:57:02 | airfield | 1 | 82945 | 2 | 1.546 | 53651.4 |
370 | 2024-03-04 10:56:32 | airfield | 3 | 146162 | 40 | 8.576 | 17043.1 |
369 | 2024-03-04 10:56:33 | airfield | 2 | 121059 | 6 | 4.326 | 27984.0 |
368 | 2024-03-04 10:56:02 | airfield | 1 | 82945 | 2 | 2.470 | 33581.0 |
367 | 2024-03-03 10:45:04 | airfield | 1 | 82945 | 2 | 3.423 | 24231.7 |
366 | 2024-03-01 17:10:28 | airfield | 4 | 161609 | 421 | 26.753 | 6040.8 |
365 | 2024-02-27 22:50:48 | airfield | 4 | 161609 | 421 | 24.330 | 6642.4 |
364 | 2024-02-27 22:50:44 | airfield | 4 | 161609 | 421 | 15.080 | 10716.8 |
363 | 2024-02-27 22:50:42 | airfield | 1 | 82945 | 2 | 1.626 | 51011.7 |
362 | 2024-02-08 17:44:55 | airfield | 3 | 146162 | 40 | 7.300 | 20022.2 |
361 | 2024-02-07 05:09:31 | airfield | 2 | 121059 | 6 | 3.670 | 32986.1 |
360 | 2024-02-07 05:09:19 | airfield | 3 | 146162 | 40 | 7.436 | 19656.0 |
359 | 2024-02-05 09:28:38 | airfield | 3 | 146162 | 40 | 7.830 | 18666.9 |
358 | 2024-02-02 19:31:08 | airfield | 3 | 146162 | 40 | 7.593 | 19249.6 |
357 | 2024-02-02 19:31:04 | airfield | 2 | 121059 | 6 | 3.690 | 32807.3 |
356 | 2024-02-02 19:31:00 | airfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
355 | 2024-01-31 02:03:48 | airfield | 1 | 82945 | 2 | 1.406 | 58993.6 |
354 | 2024-01-30 10:45:23 | airfield | 2 | 121059 | 6 | 4.013 | 30166.7 |
353 | 2024-01-30 03:33:27 | airfield | 4 | 161609 | 421 | 11.220 | 14403.7 |
352 | 2024-01-27 01:18:27 | airfield | 4 | 161609 | 421 | 13.203 | 12240.3 |
351 | 2024-01-26 12:30:21 | airfield | 4 | 161609 | 421 | 13.376 | 12082.0 |
350 | 2024-01-25 22:31:12 | airfield | 4 | 161609 | 421 | 21.343 | 7572.0 |
349 | 2024-01-10 23:26:50 | airfield | 4 | 161609 | 421 | 27.546 | 5866.9 |
348 | 2024-01-03 14:09:50 | airfield | 1 | 82945 | 2 | 1.310 | 63316.8 |
347 | 2024-01-02 15:59:09 | airfield | 1 | 82945 | 2 | 1.593 | 52068.4 |
346 | 2023-12-29 08:59:18 | airfield | 3 | 146162 | 40 | 7.326 | 19951.1 |
345 | 2023-12-13 22:37:28 | airfield | 4 | 161609 | 421 | 27.410 | 5896.0 |
344 | 2023-12-13 04:26:57 | airfield | 3 | 146162 | 40 | 8.393 | 17414.8 |
343 | 2023-12-13 00:13:18 | airfield | 1 | 82945 | 2 | 1.486 | 55817.6 |
342 | 2023-12-05 02:36:29 | airfield | 2 | 121059 | 6 | 3.796 | 31891.2 |
341 | 2023-11-19 09:53:41 | airfield | 4 | 161609 | 421 | 14.500 | 11145.4 |
340 | 2023-11-14 16:46:36 | airfield | 4 | 161609 | 421 | 12.283 | 13157.1 |
339 | 2023-11-12 13:25:37 | airfield | 3 | 146162 | 40 | 6.393 | 22862.8 |
338 | 2023-11-08 14:21:41 | airfield | 4 | 161609 | 421 | 11.203 | 14425.5 |
337 | 2023-10-31 01:11:30 | airfield | 4 | 161609 | 421 | 28.266 | 5717.4 |
336 | 2023-10-31 01:11:41 | airfield | 3 | 146162 | 40 | 9.096 | 16068.8 |
335 | 2023-10-31 01:09:36 | airfield | 1 | 82945 | 2 | 1.313 | 63172.1 |
334 | 2023-10-27 16:56:36 | airfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
333 | 2023-10-24 16:46:55 | airfield | 1 | 82945 | 2 | 1.330 | 62364.7 |
332 | 2023-09-29 15:13:06 | airfield | 1 | 82945 | 2 | 2.000 | 41472.5 |
331 | 2023-09-03 00:55:30 | airfield | 2 | 121059 | 6 | 3.420 | 35397.4 |
330 | 2023-08-19 12:56:39 | airfield | 1 | 82945 | 2 | 1.376 | 60279.8 |
329 | 2023-08-14 13:57:20 | airfield | 3 | 146162 | 40 | 7.076 | 20656.0 |
328 | 2023-08-12 08:42:31 | airfield | 4 | 161609 | 421 | 11.220 | 14403.7 |
327 | 2023-06-26 06:26:59 | airfield | 1 | 82945 | 2 | 1.330 | 62364.7 |
326 | 2023-05-23 20:28:24 | airfield | 2 | 121059 | 6 | 3.186 | 37997.2 |
325 | 2023-05-20 02:41:49 | airfield | 1 | 82945 | 2 | 1.283 | 64649.3 |
324 | 2023-04-26 18:14:05 | airfield | 4 | 161609 | 421 | 10.700 | 15103.6 |
323 | 2023-04-26 05:00:46 | airfield | 3 | 146162 | 40 | 6.500 | 22486.5 |
322 | 2023-03-15 17:38:40 | airfield | 1 | 82945 | 2 | 1.263 | 65673.0 |
321 | 2023-03-03 14:06:45 | airfield | 2 | 121059 | 6 | 3.330 | 36354.1 |
320 | 2023-02-25 00:06:22 | airfield | 1 | 82945 | 2 | 1.390 | 59672.7 |
319 | 2023-02-01 12:12:15 | airfield | 4 | 161609 | 421 | 11.643 | 13880.4 |
318 | 2023-01-30 03:42:09 | airfield | 3 | 146162 | 40 | 7.033 | 20782.3 |
317 | 2023-01-05 16:51:23 | airfield | 1 | 82945 | 2 | 1.280 | 64800.8 |
316 | 2023-01-03 11:08:23 | airfield | 4 | 161609 | 421 | 12.783 | 12642.5 |
315 | 2022-12-10 19:25:54 | airfield | 4 | 161609 | 421 | 11.376 | 14206.1 |
314 | 2022-12-08 13:11:24 | airfield | 2 | 121059 | 6 | 3.360 | 36029.5 |
313 | 2022-11-13 14:36:34 | airfield | 4 | 161609 | 421 | 10.923 | 14795.3 |
312 | 2022-11-11 20:08:22 | airfield | 3 | 146162 | 40 | 6.656 | 21959.4 |
311 | 2022-10-21 07:54:22 | airfield | 1 | 82945 | 2 | 1.283 | 64649.3 |
310 | 2022-10-17 17:47:39 | airfield | 1 | 82945 | 2 | 1.296 | 64000.8 |
309 | 2022-09-29 12:34:45 | airfield | 1 | 82945 | 2 | 1.250 | 66356.0 |
308 | 2022-07-23 21:34:34 | airfield | 2 | 121059 | 6 | 3.153 | 38394.9 |
307 | 2022-06-17 23:50:33 | airfield | 4 | 161609 | 421 | 10.780 | 14991.6 |
306 | 2022-06-16 04:21:56 | airfield | 1 | 82945 | 2 | 1.280 | 64800.8 |