History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trails"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
517 | 2024-04-30 01:39:29 | trails | 1 | 48755 | 13 | 3.716 | 13120.3 |
516 | 2024-04-13 21:19:17 | trails | 2 | 82551 | 124 | 6.420 | 12858.4 |
515 | 2024-04-10 22:24:21 | trails | 2 | 82551 | 124 | 2.610 | 31628.7 |
514 | 2024-04-09 10:06:21 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
513 | 2024-04-09 10:06:06 | trails | 2 | 82551 | 124 | 2.906 | 28407.1 |
512 | 2024-04-08 22:21:21 | trails | 2 | 82551 | 124 | 9.673 | 8534.2 |
511 | 2024-04-08 17:43:57 | trails | 2 | 82551 | 124 | 7.626 | 10824.9 |
510 | 2024-03-04 03:38:04 | trails | 2 | 82551 | 124 | 3.326 | 24819.9 |
509 | 2024-03-04 03:38:01 | trails | 1 | 48755 | 13 | 0.876 | 55656.4 |
508 | 2024-02-28 05:24:42 | trails | 2 | 82551 | 124 | 8.753 | 9431.2 |
507 | 2024-02-28 00:54:32 | trails | 2 | 82551 | 124 | 2.483 | 33246.5 |
506 | 2024-02-27 21:54:56 | trails | 2 | 82551 | 124 | 2.873 | 28733.4 |
505 | 2024-02-27 21:54:56 | trails | 1 | 48755 | 13 | 1.983 | 24586.5 |
504 | 2024-02-07 22:48:51 | trails | 1 | 48755 | 13 | 0.920 | 52994.6 |
503 | 2024-02-03 05:15:52 | trails | 1 | 48755 | 13 | 2.780 | 17537.8 |
502 | 2024-01-29 17:57:07 | trails | 1 | 48755 | 13 | 0.876 | 55656.4 |
501 | 2024-01-11 23:12:33 | trails | 2 | 82551 | 124 | 5.326 | 15499.6 |
500 | 2023-12-29 10:34:03 | trails | 1 | 48755 | 13 | 0.813 | 59969.2 |
499 | 2023-12-23 02:51:05 | trails | 2 | 82551 | 124 | 2.203 | 37472.1 |
498 | 2023-12-21 09:35:31 | trails | 2 | 82551 | 124 | 2.656 | 31080.9 |
497 | 2023-12-09 23:02:06 | trails | 1 | 48755 | 13 | 0.830 | 58741.0 |
496 | 2023-11-29 16:49:23 | trails | 1 | 48755 | 13 | 0.843 | 57835.1 |
495 | 2023-11-18 14:23:50 | trails | 1 | 48755 | 13 | 0.766 | 63648.8 |
494 | 2023-11-15 11:45:36 | trails | 1 | 48755 | 13 | 0.890 | 54780.9 |
493 | 2023-11-14 07:02:58 | trails | 1 | 48755 | 13 | 0.813 | 59969.2 |
492 | 2023-11-12 06:59:55 | trails | 2 | 82551 | 124 | 2.173 | 37989.4 |
491 | 2023-11-04 16:49:23 | trails | 1 | 48755 | 13 | 0.843 | 57835.1 |
490 | 2023-11-03 18:46:12 | trails | 2 | 82551 | 124 | 2.360 | 34979.2 |
489 | 2023-11-03 18:46:10 | trails | 1 | 48755 | 13 | 0.813 | 59969.2 |
488 | 2023-11-02 07:44:35 | trails | 1 | 48755 | 13 | 0.830 | 58741.0 |
487 | 2023-10-30 05:04:21 | trails | 1 | 48755 | 13 | 0.893 | 54596.9 |
486 | 2023-10-26 06:45:26 | trails | 2 | 82551 | 124 | 2.296 | 35954.3 |
485 | 2023-10-23 06:25:15 | trails | 2 | 82551 | 124 | 2.626 | 31436.0 |
484 | 2023-10-18 04:28:16 | trails | 2 | 82551 | 124 | 2.220 | 37185.1 |
483 | 2023-10-17 01:24:23 | trails | 1 | 48755 | 13 | 0.903 | 53992.2 |
482 | 2023-10-12 03:41:43 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
481 | 2023-10-07 18:29:16 | trails | 1 | 48755 | 13 | 1.500 | 32503.3 |
480 | 2023-10-03 16:16:07 | trails | 1 | 48755 | 13 | 0.813 | 59969.2 |
479 | 2023-09-26 12:43:46 | trails | 1 | 48755 | 13 | 0.733 | 66514.3 |
478 | 2023-09-14 09:29:31 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
477 | 2023-09-14 04:06:44 | trails | 1 | 48755 | 13 | 0.860 | 56691.9 |
476 | 2023-07-28 00:29:09 | trails | 2 | 82551 | 124 | 2.140 | 38575.2 |
475 | 2023-07-08 16:34:53 | trails | 2 | 82551 | 124 | 2.203 | 37472.1 |
474 | 2023-07-07 20:38:31 | trails | 2 | 82551 | 124 | 2.250 | 36689.3 |
473 | 2023-07-06 22:46:14 | trails | 2 | 82551 | 124 | 2.280 | 36206.6 |
472 | 2023-07-06 02:07:43 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
471 | 2023-07-02 00:01:48 | trails | 2 | 82551 | 124 | 2.126 | 38829.3 |
470 | 2023-06-23 00:29:31 | trails | 2 | 82551 | 124 | 2.170 | 38041.9 |
469 | 2023-06-17 12:49:57 | trails | 1 | 48755 | 13 | 0.733 | 66514.3 |
468 | 2023-06-15 12:35:34 | trails | 2 | 82551 | 124 | 2.156 | 38289.0 |
467 | 2023-06-14 15:30:54 | trails | 2 | 82551 | 124 | 2.453 | 33653.1 |
466 | 2023-06-13 11:23:37 | trails | 2 | 82551 | 124 | 2.343 | 35233.0 |
465 | 2023-06-11 15:54:51 | trails | 2 | 82551 | 124 | 2.126 | 38829.3 |
464 | 2023-05-05 08:09:37 | trails | 1 | 48755 | 13 | 0.733 | 66514.3 |
463 | 2023-04-13 03:11:04 | trails | 1 | 48755 | 13 | 0.830 | 58741.0 |
462 | 2023-04-05 20:29:40 | trails | 2 | 82551 | 124 | 2.470 | 33421.5 |
461 | 2023-03-20 14:58:24 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
460 | 2023-03-05 06:51:23 | trails | 1 | 48755 | 13 | 0.873 | 55847.7 |
459 | 2023-03-01 19:58:13 | trails | 1 | 48755 | 13 | 0.736 | 66243.2 |
458 | 2023-02-06 02:23:09 | trails | 1 | 48755 | 13 | 0.736 | 66243.2 |
457 | 2023-01-05 22:02:10 | trails | 2 | 82551 | 124 | 2.593 | 31836.1 |
456 | 2023-01-04 16:02:02 | trails | 2 | 82551 | 124 | 2.453 | 33653.1 |
455 | 2023-01-04 03:40:51 | trails | 2 | 82551 | 124 | 2.093 | 39441.5 |
454 | 2023-01-03 19:48:16 | trails | 2 | 82551 | 124 | 2.156 | 38289.0 |
453 | 2023-01-02 22:59:20 | trails | 2 | 82551 | 124 | 2.673 | 30883.3 |
452 | 2023-01-01 15:36:58 | trails | 2 | 82551 | 124 | 2.390 | 34540.2 |
451 | 2022-11-09 10:28:14 | trails | 1 | 48755 | 13 | 0.843 | 57835.1 |
450 | 2022-11-06 01:25:54 | trails | 1 | 48755 | 13 | 0.796 | 61250.0 |
449 | 2022-09-29 04:07:58 | trails | 2 | 82551 | 124 | 2.170 | 38041.9 |
448 | 2022-09-08 08:09:43 | trails | 2 | 82551 | 124 | 2.140 | 38575.2 |
447 | 2022-09-02 04:03:29 | trails | 2 | 82551 | 124 | 2.266 | 36430.3 |
446 | 2022-09-01 05:44:40 | trails | 1 | 48755 | 13 | 0.810 | 60191.4 |
445 | 2022-08-15 03:55:56 | trails | 1 | 48755 | 13 | 1.266 | 38511.1 |
444 | 2022-07-29 11:21:12 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
443 | 2022-07-16 10:59:30 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
442 | 2022-07-10 11:27:50 | trails | 1 | 48755 | 13 | 0.733 | 66514.3 |
441 | 2022-07-02 20:33:35 | trails | 1 | 48755 | 13 | 0.796 | 61250.0 |
440 | 2022-06-15 22:21:33 | trails | 1 | 48755 | 13 | 0.736 | 66243.2 |
439 | 2022-05-07 18:06:33 | trails | 1 | 48755 | 13 | 0.843 | 57835.1 |
438 | 2022-03-19 04:34:26 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
437 | 2022-03-15 18:19:15 | trails | 1 | 48755 | 13 | 1.143 | 42655.3 |
436 | 2022-02-08 18:01:47 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
435 | 2021-12-02 02:15:04 | trails | 1 | 48755 | 13 | 0.970 | 50262.9 |
434 | 2021-11-09 16:22:24 | trails | 1 | 48755 | 13 | 0.826 | 59025.4 |
433 | 2021-09-29 09:00:24 | trails | 1 | 48755 | 13 | 0.813 | 59969.2 |
432 | 2021-08-25 16:15:22 | trails | 1 | 48755 | 13 | 0.766 | 63648.8 |
431 | 2021-08-23 12:29:27 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
430 | 2021-08-22 10:35:41 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
429 | 2021-06-07 23:55:15 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
428 | 2021-05-18 06:49:06 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
427 | 2021-04-16 02:44:45 | trails | 2 | 82551 | 124 | 2.186 | 37763.5 |
426 | 2021-02-22 01:25:02 | trails | 2 | 82551 | 124 | 2.140 | 38575.2 |
425 | 2021-02-19 21:00:05 | trails | 1 | 48755 | 13 | 0.763 | 63899.1 |
424 | 2021-02-15 00:59:21 | trails | 1 | 48755 | 13 | 0.750 | 65006.7 |
423 | 2021-02-14 05:01:38 | trails | 2 | 82551 | 124 | 2.576 | 32046.2 |
422 | 2020-12-31 11:29:53 | trails | 2 | 82551 | 124 | 2.190 | 37694.5 |
421 | 2020-12-04 12:03:33 | trails | 2 | 82551 | 124 | 2.346 | 35188.0 |
420 | 2020-11-17 06:13:26 | trails | 1 | 48755 | 13 | 0.733 | 66514.3 |
419 | 2020-11-10 12:20:49 | trails | 1 | 48755 | 13 | 0.766 | 63648.8 |
418 | 2020-11-02 08:04:22 | trails | 1 | 48755 | 13 | 0.796 | 61250.0 |