History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pilots"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
452 | 2024-04-27 17:24:36 | pilots | 1 | 48755 | 7 | 0.940 | 51867.0 |
451 | 2024-04-03 04:45:54 | pilots | 1 | 48755 | 7 | 2.000 | 24377.5 |
450 | 2024-03-05 18:12:10 | pilots | 3 | 112716 | 961 | 30.393 | 3708.6 |
449 | 2024-03-05 03:24:34 | pilots | 3 | 112716 | 961 | 11.376 | 9908.2 |
448 | 2024-03-04 23:17:43 | pilots | 3 | 112716 | 961 | 12.093 | 9320.8 |
447 | 2024-03-04 14:12:49 | pilots | 3 | 112716 | 961 | 11.906 | 9467.2 |
446 | 2024-03-04 12:26:57 | pilots | 2 | 82551 | 81 | 2.640 | 31269.3 |
445 | 2024-03-04 12:26:57 | pilots | 1 | 48755 | 7 | 0.890 | 54780.9 |
444 | 2024-03-04 12:26:14 | pilots | 3 | 112716 | 961 | 7.563 | 14903.6 |
443 | 2024-03-04 03:26:54 | pilots | 3 | 112716 | 961 | 11.826 | 9531.2 |
442 | 2024-03-04 03:26:53 | pilots | 2 | 82551 | 81 | 2.626 | 31436.0 |
441 | 2024-03-04 03:26:51 | pilots | 1 | 48755 | 7 | 1.810 | 26936.5 |
440 | 2024-01-17 11:13:53 | pilots | 3 | 112716 | 961 | 6.563 | 17174.5 |
439 | 2024-01-17 11:13:52 | pilots | 2 | 82551 | 81 | 4.093 | 20168.8 |
438 | 2024-01-13 03:07:02 | pilots | 2 | 82551 | 81 | 2.143 | 38521.2 |
437 | 2024-01-07 08:50:53 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
436 | 2024-01-02 04:43:47 | pilots | 3 | 112716 | 961 | 5.110 | 22057.9 |
435 | 2024-01-02 04:43:44 | pilots | 2 | 82551 | 81 | 4.640 | 17791.2 |
434 | 2023-12-28 13:37:35 | pilots | 3 | 112716 | 961 | 4.923 | 22895.8 |
433 | 2023-12-28 13:37:34 | pilots | 2 | 82551 | 81 | 2.296 | 35954.3 |
432 | 2023-12-03 02:40:45 | pilots | 3 | 112716 | 961 | 5.156 | 21861.1 |
431 | 2023-12-03 02:40:44 | pilots | 2 | 82551 | 81 | 2.390 | 34540.2 |
430 | 2023-11-13 18:55:14 | pilots | 1 | 48755 | 7 | 0.766 | 63648.8 |
429 | 2023-11-13 16:48:57 | pilots | 1 | 48755 | 7 | 0.826 | 59025.4 |
428 | 2023-11-02 08:17:40 | pilots | 1 | 48755 | 7 | 1.873 | 26030.4 |
427 | 2023-10-31 03:11:20 | pilots | 1 | 48755 | 7 | 0.860 | 56691.9 |
426 | 2023-10-24 14:51:06 | pilots | 2 | 82551 | 81 | 2.156 | 38289.0 |
425 | 2023-10-22 06:38:10 | pilots | 1 | 48755 | 7 | 1.546 | 31536.2 |
424 | 2023-10-18 23:46:54 | pilots | 1 | 48755 | 7 | 0.780 | 62506.4 |
423 | 2023-10-13 23:04:38 | pilots | 1 | 48755 | 7 | 0.830 | 58741.0 |
422 | 2023-10-05 17:47:06 | pilots | 1 | 48755 | 7 | 0.830 | 58741.0 |
421 | 2023-09-27 05:53:05 | pilots | 3 | 112716 | 961 | 5.733 | 19660.9 |
420 | 2023-09-27 05:53:02 | pilots | 2 | 82551 | 81 | 2.533 | 32590.2 |
419 | 2023-09-24 21:20:19 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
418 | 2023-09-12 19:02:39 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
417 | 2023-08-25 09:35:39 | pilots | 1 | 48755 | 7 | 0.860 | 56691.9 |
416 | 2023-08-02 12:42:24 | pilots | 2 | 82551 | 81 | 2.190 | 37694.5 |
415 | 2023-07-31 13:14:20 | pilots | 1 | 48755 | 7 | 0.733 | 66514.3 |
414 | 2023-05-25 19:25:07 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
413 | 2023-04-30 12:23:12 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
412 | 2023-04-11 08:53:49 | pilots | 2 | 82551 | 81 | 2.376 | 34743.7 |
411 | 2023-03-19 20:37:35 | pilots | 1 | 48755 | 7 | 0.733 | 66514.3 |
410 | 2023-01-18 05:50:50 | pilots | 2 | 82551 | 81 | 2.093 | 39441.5 |
409 | 2023-01-18 05:50:36 | pilots | 1 | 48755 | 7 | 0.736 | 66243.2 |
408 | 2023-01-07 03:05:54 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
407 | 2022-10-30 03:28:50 | pilots | 2 | 82551 | 81 | 2.110 | 39123.7 |
406 | 2022-10-07 16:08:43 | pilots | 1 | 48755 | 7 | 0.733 | 66514.3 |
405 | 2022-10-04 03:44:12 | pilots | 1 | 48755 | 7 | 0.846 | 57630.0 |
404 | 2022-09-30 17:36:36 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
403 | 2022-07-18 18:36:41 | pilots | 1 | 48755 | 7 | 0.876 | 55656.4 |
402 | 2022-07-18 06:56:53 | pilots | 1 | 48755 | 7 | 0.826 | 59025.4 |
401 | 2022-07-10 09:38:36 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
400 | 2022-07-03 15:27:53 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
399 | 2022-06-25 14:44:36 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
398 | 2022-06-21 00:16:26 | pilots | 1 | 48755 | 7 | 0.783 | 62266.9 |
397 | 2022-06-01 18:52:54 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
396 | 2022-05-21 17:12:22 | pilots | 2 | 82551 | 81 | 2.233 | 36968.7 |
395 | 2022-05-13 11:12:35 | pilots | 1 | 48755 | 7 | 0.796 | 61250.0 |
394 | 2022-05-11 06:56:01 | pilots | 1 | 48755 | 7 | 0.903 | 53992.2 |
393 | 2022-03-11 23:46:14 | pilots | 1 | 48755 | 7 | 0.813 | 59969.2 |
392 | 2022-01-28 03:05:05 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
391 | 2022-01-12 12:07:48 | pilots | 2 | 82551 | 81 | 4.330 | 19064.9 |
390 | 2022-01-04 07:18:10 | pilots | 1 | 48755 | 7 | 0.810 | 60191.4 |
389 | 2021-12-08 08:34:41 | pilots | 1 | 48755 | 7 | 0.766 | 63648.8 |
388 | 2021-11-27 14:38:11 | pilots | 1 | 48755 | 7 | 1.046 | 46610.9 |
387 | 2021-11-25 20:45:31 | pilots | 1 | 48755 | 7 | 0.796 | 61250.0 |
386 | 2021-11-14 03:41:54 | pilots | 1 | 48755 | 7 | 0.766 | 63648.8 |
385 | 2021-10-23 00:38:40 | pilots | 2 | 82551 | 81 | 2.390 | 34540.2 |
384 | 2021-10-22 06:33:48 | pilots | 2 | 82551 | 81 | 2.126 | 38829.3 |
383 | 2021-10-09 03:31:16 | pilots | 1 | 48755 | 7 | 0.813 | 59969.2 |
382 | 2021-09-22 06:00:14 | pilots | 1 | 48755 | 7 | 0.783 | 62266.9 |
381 | 2021-09-07 12:40:29 | pilots | 1 | 48755 | 7 | 0.890 | 54780.9 |
380 | 2021-06-07 00:06:59 | pilots | 1 | 48755 | 7 | 0.876 | 55656.4 |
379 | 2021-06-06 15:01:07 | pilots | 1 | 48755 | 7 | 0.876 | 55656.4 |
378 | 2021-06-03 10:43:30 | pilots | 1 | 48755 | 7 | 0.766 | 63648.8 |
377 | 2021-05-13 00:45:36 | pilots | 1 | 48755 | 7 | 0.906 | 53813.5 |
376 | 2021-05-01 21:03:55 | pilots | 1 | 48755 | 7 | 0.876 | 55656.4 |
375 | 2021-04-11 19:14:30 | pilots | 1 | 48755 | 7 | 0.766 | 63648.8 |
374 | 2021-03-15 18:30:57 | pilots | 1 | 48755 | 7 | 0.953 | 51159.5 |
373 | 2021-02-28 23:59:17 | pilots | 1 | 48755 | 7 | 0.906 | 53813.5 |
372 | 2021-02-18 19:16:12 | pilots | 1 | 48755 | 7 | 0.860 | 56691.9 |
371 | 2020-11-30 15:46:18 | pilots | 1 | 48755 | 7 | 0.780 | 62506.4 |
370 | 2020-11-29 06:05:40 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
369 | 2020-10-05 04:55:57 | pilots | 1 | 48755 | 7 | 0.733 | 66514.3 |
368 | 2020-08-30 00:34:57 | pilots | 1 | 48755 | 7 | 0.813 | 59969.2 |
367 | 2020-08-29 02:07:49 | pilots | 1 | 48755 | 7 | 0.813 | 59969.2 |
366 | 2020-08-26 14:49:18 | pilots | 1 | 48755 | 7 | 0.780 | 62506.4 |
365 | 2020-08-25 21:30:22 | pilots | 1 | 48755 | 7 | 0.813 | 59969.2 |
364 | 2020-08-21 22:45:23 | pilots | 1 | 48755 | 7 | 0.780 | 62506.4 |
363 | 2020-08-21 15:59:14 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
362 | 2020-08-08 03:52:38 | pilots | 1 | 48755 | 7 | 0.796 | 61250.0 |
361 | 2020-08-01 12:25:14 | pilots | 1 | 48755 | 7 | 0.843 | 57835.1 |
360 | 2020-07-31 11:49:21 | pilots | 1 | 48755 | 7 | 0.780 | 62506.4 |
359 | 2020-07-23 14:04:09 | pilots | 1 | 48755 | 7 | 0.810 | 60191.4 |
358 | 2020-05-24 11:59:00 | pilots | 1 | 48755 | 7 | 0.733 | 66514.3 |
357 | 2020-03-31 13:09:24 | pilots | 1 | 48755 | 7 | 0.750 | 65006.7 |
356 | 2020-03-27 14:04:39 | pilots | 1 | 48755 | 7 | 0.890 | 54780.9 |
355 | 2020-03-27 05:19:45 | pilots | 1 | 48755 | 7 | 0.763 | 63899.1 |
354 | 2020-03-27 00:13:57 | pilots | 1 | 48755 | 7 | 0.890 | 54780.9 |
353 | 2020-03-23 11:16:50 | pilots | 1 | 48755 | 7 | 0.893 | 54596.9 |