History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"facts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
558 | 2024-05-02 08:43:54 | facts | 1 | 28756 | 10 | 0.533 | 53951.2 |
557 | 2024-05-01 22:37:46 | facts | 2 | 53800 | 200 | 1.766 | 30464.3 |
556 | 2024-05-01 22:37:42 | facts | 1 | 28756 | 10 | 1.046 | 27491.4 |
555 | 2024-05-01 22:37:32 | facts | 2 | 53800 | 200 | 6.076 | 8854.5 |
554 | 2024-05-01 22:37:36 | facts | 1 | 28756 | 10 | 0.610 | 47141.0 |
553 | 2024-04-30 20:29:03 | facts | 1 | 28756 | 10 | 1.063 | 27051.7 |
552 | 2024-04-03 06:37:40 | facts | 1 | 28756 | 10 | 1.156 | 24875.4 |
551 | 2024-04-01 17:40:23 | facts | 1 | 28756 | 10 | 1.766 | 16283.1 |
550 | 2024-03-31 15:39:03 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
549 | 2024-03-28 20:03:51 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
548 | 2024-03-04 03:06:09 | facts | 2 | 53800 | 200 | 1.610 | 33416.1 |
547 | 2024-03-04 03:06:04 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
546 | 2024-03-02 14:17:21 | facts | 1 | 28756 | 10 | 0.890 | 32310.1 |
545 | 2024-03-01 11:46:42 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
544 | 2024-02-28 16:51:37 | facts | 1 | 28756 | 10 | 1.110 | 25906.3 |
543 | 2024-02-25 17:33:39 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
542 | 2024-02-02 23:27:15 | facts | 1 | 28756 | 10 | 0.546 | 52666.7 |
541 | 2024-01-31 04:40:48 | facts | 2 | 53800 | 200 | 1.576 | 34137.1 |
540 | 2024-01-29 01:55:23 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
539 | 2024-01-26 07:50:11 | facts | 1 | 28756 | 10 | 0.516 | 55728.7 |
538 | 2024-01-25 22:29:09 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
537 | 2024-01-10 06:22:28 | facts | 1 | 28756 | 10 | 0.470 | 61183.0 |
536 | 2023-11-27 02:08:14 | facts | 2 | 53800 | 200 | 1.346 | 39970.3 |
535 | 2023-11-25 14:42:55 | facts | 2 | 53800 | 200 | 1.533 | 35094.6 |
534 | 2023-11-25 13:18:27 | facts | 2 | 53800 | 200 | 1.390 | 38705.0 |
533 | 2023-11-24 15:44:41 | facts | 2 | 53800 | 200 | 1.376 | 39098.8 |
532 | 2023-11-11 22:53:19 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
531 | 2023-11-10 12:52:07 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
530 | 2023-11-09 15:49:38 | facts | 2 | 53800 | 200 | 1.360 | 39558.8 |
529 | 2023-11-02 23:31:59 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
528 | 2023-11-02 07:13:47 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
527 | 2023-11-01 04:11:44 | facts | 2 | 53800 | 200 | 1.503 | 35795.1 |
526 | 2023-10-27 09:31:36 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
525 | 2023-10-22 01:44:38 | facts | 2 | 53800 | 200 | 1.393 | 38621.7 |
524 | 2023-10-20 20:55:43 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
523 | 2023-10-17 21:06:56 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
522 | 2023-10-17 00:09:53 | facts | 2 | 53800 | 200 | 1.360 | 39558.8 |
521 | 2023-10-11 11:41:49 | facts | 1 | 28756 | 10 | 0.516 | 55728.7 |
520 | 2023-10-11 01:02:21 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
519 | 2023-10-04 10:25:04 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
518 | 2023-10-03 23:23:22 | facts | 1 | 28756 | 10 | 0.546 | 52666.7 |
517 | 2023-09-22 16:21:12 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
516 | 2023-09-12 11:30:42 | facts | 1 | 28756 | 10 | 0.560 | 51350.0 |
515 | 2023-08-27 05:46:43 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
514 | 2023-08-12 10:08:31 | facts | 2 | 53800 | 200 | 1.376 | 39098.8 |
513 | 2023-07-01 19:13:43 | facts | 1 | 28756 | 10 | 0.546 | 52666.7 |
512 | 2023-05-29 04:54:08 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
511 | 2023-04-26 19:23:14 | facts | 2 | 53800 | 200 | 1.406 | 38264.6 |
510 | 2023-03-31 14:28:07 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
509 | 2023-03-29 01:10:42 | facts | 1 | 28756 | 10 | 0.420 | 68466.7 |
508 | 2023-03-25 22:12:37 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
507 | 2023-02-01 12:36:40 | facts | 2 | 53800 | 200 | 1.346 | 39970.3 |
506 | 2023-01-09 18:42:04 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
505 | 2022-12-23 21:19:02 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
504 | 2022-11-12 06:33:00 | facts | 2 | 53800 | 200 | 1.440 | 37361.1 |
503 | 2022-10-10 13:51:38 | facts | 1 | 28756 | 10 | 0.516 | 55728.7 |
502 | 2022-09-13 05:23:34 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
501 | 2022-09-04 17:33:08 | facts | 1 | 28756 | 10 | 0.440 | 65354.5 |
500 | 2022-09-01 21:48:51 | facts | 1 | 28756 | 10 | 0.576 | 49923.6 |
499 | 2022-09-01 21:46:06 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
498 | 2022-08-15 01:56:37 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
497 | 2022-07-29 09:59:28 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
496 | 2022-05-31 09:03:08 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
495 | 2022-05-28 01:34:51 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
494 | 2022-05-25 19:53:59 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
493 | 2022-04-27 21:49:07 | facts | 2 | 53800 | 200 | 1.546 | 34799.5 |
492 | 2022-02-23 15:33:32 | facts | 1 | 28756 | 10 | 0.640 | 44931.3 |
491 | 2022-02-04 23:22:32 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
490 | 2021-11-30 23:00:06 | facts | 1 | 28756 | 10 | 0.513 | 56054.6 |
489 | 2021-11-22 03:39:37 | facts | 1 | 28756 | 10 | 1.000 | 28756.0 |
488 | 2021-10-12 12:19:39 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
487 | 2021-09-10 16:29:20 | facts | 1 | 28756 | 10 | 0.440 | 65354.5 |
486 | 2021-09-08 12:19:28 | facts | 1 | 28756 | 10 | 0.440 | 65354.5 |
485 | 2021-08-21 20:55:36 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
484 | 2021-08-19 06:35:29 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
483 | 2021-05-24 09:51:22 | facts | 1 | 28756 | 10 | 0.673 | 42728.1 |
482 | 2021-05-18 13:42:36 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
481 | 2021-04-27 14:16:31 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
480 | 2021-03-27 15:16:25 | facts | 1 | 28756 | 10 | 0.470 | 61183.0 |
479 | 2021-02-19 19:52:46 | facts | 1 | 28756 | 10 | 0.440 | 65354.5 |
478 | 2021-02-15 08:40:05 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
477 | 2021-02-11 07:19:31 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
476 | 2021-01-10 22:19:53 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
475 | 2020-11-10 23:52:03 | facts | 1 | 28756 | 10 | 0.423 | 67981.1 |
474 | 2020-11-01 19:36:01 | facts | 1 | 28756 | 10 | 1.403 | 20496.1 |
473 | 2020-09-29 02:40:08 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
472 | 2020-08-10 22:10:07 | facts | 1 | 28756 | 10 | 0.436 | 65954.1 |
471 | 2020-08-08 00:29:09 | facts | 1 | 28756 | 10 | 0.483 | 59536.2 |
470 | 2020-08-04 23:51:27 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
469 | 2020-07-30 14:18:22 | facts | 1 | 28756 | 10 | 0.516 | 55728.7 |
468 | 2020-07-27 02:36:51 | facts | 1 | 28756 | 10 | 0.440 | 65354.5 |
467 | 2020-07-24 16:54:06 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |
466 | 2020-07-24 15:09:28 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
465 | 2020-05-06 15:58:50 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
464 | 2020-04-24 02:05:55 | facts | 1 | 28756 | 10 | 0.453 | 63479.0 |
463 | 2020-03-25 14:18:36 | facts | 1 | 28756 | 10 | 1.030 | 27918.4 |
462 | 2020-03-24 23:21:23 | facts | 1 | 28756 | 10 | 0.530 | 54256.6 |
461 | 2020-03-23 11:47:05 | facts | 1 | 28756 | 10 | 1.563 | 18398.0 |
460 | 2020-03-23 02:46:19 | facts | 1 | 28756 | 10 | 0.516 | 55728.7 |
459 | 2020-03-22 05:32:43 | facts | 1 | 28756 | 10 | 0.500 | 57512.0 |