History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
565 | 2024-04-19 17:09:41 | guest | 1 | 28756 | 7 | 0.560 | 51350.0 |
564 | 2024-04-10 14:58:21 | guest | 1 | 28756 | 7 | 0.546 | 52666.7 |
563 | 2024-04-06 16:35:54 | guest | 1 | 28756 | 7 | 1.046 | 27491.4 |
562 | 2024-04-02 21:40:43 | guest | 1 | 28756 | 7 | 1.016 | 28303.1 |
561 | 2024-04-02 21:30:42 | guest | 1 | 28756 | 7 | 0.516 | 55728.7 |
560 | 2024-04-02 21:30:35 | guest | 2 | 53800 | 113 | 1.656 | 32487.9 |
559 | 2024-04-02 19:00:39 | guest | 2 | 53800 | 113 | 3.813 | 14109.6 |
558 | 2024-04-01 17:25:41 | guest | 2 | 53800 | 113 | 5.686 | 9461.8 |
557 | 2024-03-31 14:53:17 | guest | 2 | 53800 | 113 | 3.720 | 14462.4 |
556 | 2024-03-31 14:38:15 | guest | 1 | 28756 | 7 | 1.686 | 17055.8 |
555 | 2024-03-27 16:41:55 | guest | 1 | 28756 | 7 | 0.516 | 55728.7 |
554 | 2024-03-01 12:04:17 | guest | 1 | 28756 | 7 | 0.546 | 52666.7 |
553 | 2024-02-25 21:37:03 | guest | 2 | 53800 | 113 | 3.280 | 16402.4 |
552 | 2024-02-25 19:31:19 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
551 | 2024-01-29 05:24:35 | guest | 1 | 28756 | 7 | 0.466 | 61708.2 |
550 | 2024-01-26 21:26:25 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
549 | 2023-12-31 04:02:54 | guest | 2 | 53800 | 113 | 1.546 | 34799.5 |
548 | 2023-12-24 04:08:55 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
547 | 2023-12-06 22:29:05 | guest | 2 | 53800 | 113 | 1.656 | 32487.9 |
546 | 2023-12-05 02:05:52 | guest | 2 | 53800 | 113 | 1.593 | 33772.8 |
545 | 2023-11-22 09:32:48 | guest | 1 | 28756 | 7 | 0.440 | 65354.5 |
544 | 2023-11-18 23:51:57 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
543 | 2023-11-13 14:15:26 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
542 | 2023-10-28 04:39:43 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |
541 | 2023-10-22 10:05:34 | guest | 1 | 28756 | 7 | 0.466 | 61708.2 |
540 | 2023-10-18 15:55:54 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |
539 | 2023-10-14 11:54:59 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
538 | 2023-10-11 03:18:00 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
537 | 2023-10-08 09:36:33 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
536 | 2023-09-26 02:07:47 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
535 | 2023-09-24 10:32:45 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
534 | 2023-08-09 16:56:00 | guest | 1 | 28756 | 7 | 0.440 | 65354.5 |
533 | 2023-08-07 01:00:28 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
532 | 2023-05-05 18:17:13 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
531 | 2023-05-02 04:16:36 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
530 | 2023-03-02 05:39:47 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
529 | 2023-01-23 15:07:06 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
528 | 2022-12-25 21:10:51 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
527 | 2022-12-22 19:13:17 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
526 | 2022-11-18 09:19:17 | guest | 1 | 28756 | 7 | 0.440 | 65354.5 |
525 | 2022-10-09 06:49:26 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
524 | 2022-10-05 17:20:57 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
523 | 2022-09-19 21:28:43 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
522 | 2022-09-18 15:55:52 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
521 | 2022-09-12 13:33:36 | guest | 1 | 28756 | 7 | 0.440 | 65354.5 |
520 | 2022-09-10 15:34:37 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
519 | 2022-09-09 12:05:06 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
518 | 2022-08-31 03:40:49 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
517 | 2022-07-19 12:33:14 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
516 | 2022-06-15 03:36:31 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
515 | 2022-03-27 15:58:46 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |
514 | 2022-03-03 07:53:45 | guest | 1 | 28756 | 7 | 1.033 | 27837.4 |
513 | 2021-12-31 10:12:24 | guest | 1 | 28756 | 7 | 0.513 | 56054.6 |
512 | 2021-11-26 09:34:17 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
511 | 2021-11-03 00:14:22 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
510 | 2021-10-31 22:01:15 | guest | 1 | 28756 | 7 | 0.440 | 65354.5 |
509 | 2021-09-16 02:00:42 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
508 | 2021-08-31 17:49:00 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
507 | 2021-08-23 12:40:17 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
506 | 2021-06-01 20:46:14 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
505 | 2021-05-22 19:38:53 | guest | 1 | 28756 | 7 | 0.533 | 53951.2 |
504 | 2021-04-11 20:06:38 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
503 | 2021-02-16 10:27:49 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
502 | 2021-02-14 00:21:26 | guest | 1 | 28756 | 7 | 0.640 | 44931.3 |
501 | 2021-01-25 23:18:08 | guest | 1 | 28756 | 7 | 0.483 | 59536.2 |
500 | 2020-11-26 03:47:20 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
499 | 2020-11-17 05:44:35 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
498 | 2020-10-30 15:52:38 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
497 | 2020-10-22 12:36:38 | guest | 1 | 28756 | 7 | 0.450 | 63902.2 |
496 | 2020-10-06 13:42:15 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
495 | 2020-09-30 08:28:16 | guest | 1 | 28756 | 7 | 0.423 | 67981.1 |
494 | 2020-09-30 06:22:52 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
493 | 2020-09-09 15:00:50 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
492 | 2020-09-04 13:28:13 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
491 | 2020-08-28 23:43:38 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
490 | 2020-08-26 06:39:31 | guest | 1 | 28756 | 7 | 0.466 | 61708.2 |
489 | 2020-08-05 17:33:45 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
488 | 2020-05-15 23:40:41 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
487 | 2020-05-04 05:47:35 | guest | 1 | 28756 | 7 | 0.453 | 63479.0 |
486 | 2020-03-25 10:21:20 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
485 | 2020-03-24 03:51:49 | guest | 1 | 28756 | 7 | 0.470 | 61183.0 |
484 | 2020-03-22 21:10:14 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |
483 | 2020-03-22 18:02:25 | guest | 1 | 28756 | 7 | 0.483 | 59536.2 |
482 | 2020-03-21 05:50:51 | guest | 1 | 28756 | 7 | 0.736 | 39070.7 |
481 | 2020-03-18 03:31:42 | guest | 1 | 28756 | 7 | 0.436 | 65954.1 |
480 | 2020-02-27 00:59:24 | guest | 1 | 28756 | 7 | 0.546 | 52666.7 |
479 | 2020-02-24 08:57:50 | guest | 1 | 28756 | 7 | 0.486 | 59168.7 |
478 | 2020-02-21 14:45:41 | guest | 1 | 28756 | 7 | 0.626 | 45936.1 |
477 | 2020-02-18 16:47:03 | guest | 1 | 28756 | 7 | 0.516 | 55728.7 |
476 | 2020-02-18 15:04:21 | guest | 1 | 28756 | 7 | 0.516 | 55728.7 |
475 | 2020-02-13 09:31:14 | guest | 1 | 28756 | 7 | 0.420 | 68466.7 |
474 | 2020-02-12 13:00:35 | guest | 1 | 28756 | 7 | 0.736 | 39070.7 |
473 | 2020-02-09 15:02:22 | guest | 1 | 28756 | 7 | 0.533 | 53951.2 |
472 | 2020-02-02 00:45:08 | guest | 1 | 28756 | 7 | 1.033 | 27837.4 |
471 | 2020-01-30 15:20:36 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |
470 | 2020-01-30 03:18:48 | guest | 1 | 28756 | 7 | 0.483 | 59536.2 |
469 | 2020-01-29 09:14:05 | guest | 1 | 28756 | 7 | 0.530 | 54256.6 |
468 | 2020-01-23 21:12:46 | guest | 1 | 28756 | 7 | 1.623 | 17717.8 |
467 | 2020-01-23 11:42:17 | guest | 1 | 28756 | 7 | 0.546 | 52666.7 |
466 | 2020-01-21 06:50:21 | guest | 1 | 28756 | 7 | 0.500 | 57512.0 |