History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prep"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
545 | 2024-04-18 01:25:35 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
544 | 2024-04-17 21:53:03 | prep | 1 | 13983 | 12 | 0.530 | 26383.0 |
543 | 2024-04-03 04:56:07 | prep | 1 | 13983 | 12 | 0.546 | 25609.9 |
542 | 2024-04-01 15:55:42 | prep | 1 | 13983 | 12 | 0.500 | 27966.0 |
541 | 2024-03-30 19:40:02 | prep | 2 | 29872 | 206 | 1.000 | 29872.0 |
540 | 2024-03-30 18:50:48 | prep | 1 | 13983 | 12 | 0.500 | 27966.0 |
539 | 2024-03-15 03:20:28 | prep | 2 | 29872 | 206 | 1.860 | 16060.2 |
538 | 2024-03-08 02:55:25 | prep | 1 | 13983 | 12 | 0.236 | 59250.0 |
537 | 2024-03-03 19:45:58 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
536 | 2024-03-02 15:42:10 | prep | 2 | 29872 | 206 | 1.516 | 19704.5 |
535 | 2024-03-02 14:27:29 | prep | 2 | 29872 | 206 | 2.313 | 12914.8 |
534 | 2024-03-02 13:50:02 | prep | 1 | 13983 | 12 | 0.533 | 26234.5 |
533 | 2024-02-07 22:06:23 | prep | 1 | 13983 | 12 | 0.263 | 53167.3 |
532 | 2024-02-01 10:50:23 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
531 | 2023-12-22 01:39:11 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
530 | 2023-12-13 21:14:25 | prep | 2 | 29872 | 206 | 0.780 | 38297.4 |
529 | 2023-12-11 21:20:21 | prep | 2 | 29872 | 206 | 0.953 | 31345.2 |
528 | 2023-12-07 12:35:25 | prep | 2 | 29872 | 206 | 0.826 | 36164.6 |
527 | 2023-11-28 00:29:16 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
526 | 2023-11-12 20:55:58 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
525 | 2023-11-11 07:13:11 | prep | 2 | 29872 | 206 | 0.733 | 40753.1 |
524 | 2023-11-11 03:11:55 | prep | 1 | 13983 | 12 | 0.470 | 29751.1 |
523 | 2023-10-27 01:57:13 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
522 | 2023-10-26 07:40:00 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
521 | 2023-10-21 06:23:17 | prep | 2 | 29872 | 206 | 1.626 | 18371.5 |
520 | 2023-10-20 17:02:02 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
519 | 2023-10-18 04:04:35 | prep | 1 | 13983 | 12 | 0.216 | 64736.1 |
518 | 2023-10-11 16:56:49 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
517 | 2023-10-04 09:41:01 | prep | 1 | 13983 | 12 | 0.203 | 68881.8 |
516 | 2023-09-28 23:56:36 | prep | 1 | 13983 | 12 | 0.500 | 27966.0 |
515 | 2023-09-23 03:08:47 | prep | 2 | 29872 | 206 | 0.890 | 33564.0 |
514 | 2023-09-12 19:24:31 | prep | 1 | 13983 | 12 | 0.216 | 64736.1 |
513 | 2023-09-05 11:47:21 | prep | 2 | 29872 | 206 | 0.736 | 40587.0 |
512 | 2023-07-09 15:51:39 | prep | 1 | 13983 | 12 | 0.423 | 33056.7 |
511 | 2023-06-28 15:14:03 | prep | 2 | 29872 | 206 | 0.953 | 31345.2 |
510 | 2023-06-27 03:30:01 | prep | 1 | 13983 | 12 | 0.236 | 59250.0 |
509 | 2023-06-04 09:14:44 | prep | 2 | 29872 | 206 | 0.736 | 40587.0 |
508 | 2023-04-26 10:27:51 | prep | 2 | 29872 | 206 | 0.763 | 39150.7 |
507 | 2023-04-06 02:37:15 | prep | 1 | 13983 | 12 | 0.216 | 64736.1 |
506 | 2023-03-22 07:50:53 | prep | 1 | 13983 | 12 | 0.266 | 52567.7 |
505 | 2023-03-19 20:51:25 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
504 | 2023-03-04 03:43:56 | prep | 2 | 29872 | 206 | 0.843 | 35435.3 |
503 | 2023-01-31 19:58:45 | prep | 2 | 29872 | 206 | 0.830 | 35990.4 |
502 | 2023-01-19 22:43:02 | prep | 1 | 13983 | 12 | 0.216 | 64736.1 |
501 | 2022-12-20 23:48:49 | prep | 2 | 29872 | 206 | 0.716 | 41720.7 |
500 | 2022-12-16 12:51:00 | prep | 2 | 29872 | 206 | 0.733 | 40753.1 |
499 | 2022-12-04 05:56:06 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
498 | 2022-11-30 15:29:00 | prep | 2 | 29872 | 206 | 0.830 | 35990.4 |
497 | 2022-11-27 08:41:56 | prep | 2 | 29872 | 206 | 0.733 | 40753.1 |
496 | 2022-11-23 04:32:23 | prep | 2 | 29872 | 206 | 0.920 | 32469.6 |
495 | 2022-11-17 06:21:34 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
494 | 2022-11-15 21:45:21 | prep | 2 | 29872 | 206 | 0.860 | 34734.9 |
493 | 2022-10-24 20:25:22 | prep | 2 | 29872 | 206 | 0.766 | 38997.4 |
492 | 2022-08-26 08:08:37 | prep | 2 | 29872 | 206 | 0.763 | 39150.7 |
491 | 2022-08-17 22:33:13 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
490 | 2022-08-10 13:44:01 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
489 | 2022-07-29 13:22:20 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
488 | 2022-07-07 17:03:56 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
487 | 2022-06-02 12:36:25 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
486 | 2022-05-25 12:19:45 | prep | 2 | 29872 | 206 | 0.860 | 34734.9 |
485 | 2022-04-09 11:53:08 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
484 | 2022-03-22 10:39:54 | prep | 2 | 29872 | 206 | 0.873 | 34217.6 |
483 | 2022-03-14 15:06:26 | prep | 1 | 13983 | 12 | 0.266 | 52567.7 |
482 | 2022-02-18 03:02:37 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
481 | 2021-12-27 00:28:27 | prep | 1 | 13983 | 12 | 0.533 | 26234.5 |
480 | 2021-12-25 08:37:31 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
479 | 2021-12-11 13:17:44 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
478 | 2021-11-19 13:20:36 | prep | 2 | 29872 | 206 | 0.736 | 40587.0 |
477 | 2021-10-31 18:37:03 | prep | 1 | 13983 | 12 | 0.216 | 64736.1 |
476 | 2021-10-02 05:15:19 | prep | 2 | 29872 | 206 | 0.873 | 34217.6 |
475 | 2021-09-26 09:10:20 | prep | 2 | 29872 | 206 | 0.810 | 36879.0 |
474 | 2021-09-23 06:10:39 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
473 | 2021-09-20 04:40:06 | prep | 1 | 13983 | 12 | 0.236 | 59250.0 |
472 | 2021-09-18 00:51:44 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
471 | 2021-09-14 22:39:42 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
470 | 2021-08-27 03:28:33 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
469 | 2021-08-16 13:53:44 | prep | 2 | 29872 | 206 | 0.890 | 33564.0 |
468 | 2021-06-14 22:07:09 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
467 | 2021-06-03 05:00:49 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
466 | 2021-05-27 13:33:23 | prep | 2 | 29872 | 206 | 0.856 | 34897.2 |
465 | 2021-05-17 13:43:51 | prep | 2 | 29872 | 206 | 0.906 | 32971.3 |
464 | 2021-05-09 00:37:10 | prep | 1 | 13983 | 12 | 0.500 | 27966.0 |
463 | 2021-03-29 13:35:49 | prep | 2 | 29872 | 206 | 0.750 | 39829.3 |
462 | 2021-03-12 00:03:39 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
461 | 2021-02-19 20:35:09 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
460 | 2021-02-13 07:58:20 | prep | 2 | 29872 | 206 | 0.860 | 34734.9 |
459 | 2021-01-22 15:34:03 | prep | 1 | 13983 | 12 | 0.203 | 68881.8 |
458 | 2021-01-14 14:03:51 | prep | 2 | 29872 | 206 | 0.783 | 38150.7 |
457 | 2021-01-13 07:55:45 | prep | 2 | 29872 | 206 | 0.813 | 36742.9 |
456 | 2020-12-08 20:32:13 | prep | 1 | 13983 | 12 | 0.360 | 38841.7 |
455 | 2020-11-27 22:01:58 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
454 | 2020-11-11 01:32:29 | prep | 2 | 29872 | 206 | 0.856 | 34897.2 |
453 | 2020-11-06 09:45:28 | prep | 2 | 29872 | 206 | 0.966 | 30923.4 |
452 | 2020-11-04 21:34:36 | prep | 1 | 13983 | 12 | 0.250 | 55932.0 |
451 | 2020-11-01 10:29:53 | prep | 1 | 13983 | 12 | 0.233 | 60012.9 |
450 | 2020-10-29 04:27:21 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |
449 | 2020-10-25 18:07:29 | prep | 2 | 29872 | 206 | 0.906 | 32971.3 |
448 | 2020-10-04 13:47:56 | prep | 2 | 29872 | 206 | 0.906 | 32971.3 |
447 | 2020-09-15 22:04:26 | prep | 1 | 13983 | 12 | 0.236 | 59250.0 |
446 | 2020-09-05 18:46:43 | prep | 1 | 13983 | 12 | 0.220 | 63559.1 |