History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dogie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
577 | 2024-04-25 21:05:34 | dogie | 1 | 28756 | 10 | 0.516 | 55728.7 |
576 | 2024-04-21 10:29:56 | dogie | 2 | 53800 | 108 | 1.563 | 34421.0 |
575 | 2024-04-21 10:29:23 | dogie | 2 | 53800 | 108 | 2.936 | 18324.3 |
574 | 2024-04-13 07:32:22 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
573 | 2024-04-13 07:26:31 | dogie | 1 | 28756 | 10 | 0.580 | 49579.3 |
572 | 2024-04-13 07:18:56 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
571 | 2024-04-13 07:02:47 | dogie | 1 | 28756 | 10 | 0.530 | 54256.6 |
570 | 2024-04-11 12:55:54 | dogie | 1 | 28756 | 10 | 0.516 | 55728.7 |
569 | 2024-04-06 19:05:56 | dogie | 1 | 28756 | 10 | 1.500 | 19170.7 |
568 | 2024-04-03 04:51:55 | dogie | 1 | 28756 | 10 | 1.733 | 16593.2 |
567 | 2024-03-31 07:00:14 | dogie | 1 | 28756 | 10 | 1.750 | 16432.0 |
566 | 2024-03-29 02:47:23 | dogie | 1 | 28756 | 10 | 0.546 | 52666.7 |
565 | 2024-03-04 02:44:16 | dogie | 2 | 53800 | 108 | 1.593 | 33772.8 |
564 | 2024-03-04 02:44:15 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
563 | 2024-03-01 05:42:52 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
562 | 2024-02-27 20:58:45 | dogie | 1 | 28756 | 10 | 1.063 | 27051.7 |
561 | 2024-02-02 23:12:19 | dogie | 1 | 28756 | 10 | 0.516 | 55728.7 |
560 | 2024-01-28 20:59:17 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
559 | 2024-01-28 18:39:07 | dogie | 1 | 28756 | 10 | 0.470 | 61183.0 |
558 | 2024-01-14 18:47:23 | dogie | 2 | 53800 | 108 | 1.686 | 31909.8 |
557 | 2023-12-28 22:44:41 | dogie | 2 | 53800 | 108 | 1.513 | 35558.5 |
556 | 2023-12-27 22:27:22 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
555 | 2023-12-22 10:24:29 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
554 | 2023-12-06 21:57:38 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
553 | 2023-11-26 11:34:58 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
552 | 2023-11-17 14:26:55 | dogie | 1 | 28756 | 10 | 0.423 | 67981.1 |
551 | 2023-11-13 03:11:36 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
550 | 2023-11-04 03:48:13 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
549 | 2023-11-02 07:10:38 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
548 | 2023-11-01 06:59:27 | dogie | 2 | 53800 | 108 | 1.530 | 35163.4 |
547 | 2023-10-25 23:19:36 | dogie | 2 | 53800 | 108 | 1.626 | 33087.3 |
546 | 2023-10-22 13:38:10 | dogie | 1 | 28756 | 10 | 0.486 | 59168.7 |
545 | 2023-10-22 08:13:50 | dogie | 2 | 53800 | 108 | 1.470 | 36598.6 |
544 | 2023-10-19 19:17:19 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
543 | 2023-10-17 07:04:52 | dogie | 1 | 28756 | 10 | 0.640 | 44931.3 |
542 | 2023-10-17 00:34:30 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
541 | 2023-10-11 02:47:05 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
540 | 2023-10-05 00:26:37 | dogie | 1 | 28756 | 10 | 0.420 | 68466.7 |
539 | 2023-09-26 09:17:05 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
538 | 2023-09-22 11:59:14 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
537 | 2023-09-14 02:13:51 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
536 | 2023-08-14 01:27:18 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
535 | 2023-06-15 04:57:10 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
534 | 2023-06-11 21:44:32 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
533 | 2023-05-12 21:22:48 | dogie | 1 | 28756 | 10 | 0.420 | 68466.7 |
532 | 2023-03-09 12:54:55 | dogie | 1 | 28756 | 10 | 0.423 | 67981.1 |
531 | 2023-03-09 01:54:55 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
530 | 2022-12-30 15:11:24 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
529 | 2022-12-04 13:56:32 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
528 | 2022-09-18 17:47:03 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
527 | 2022-09-17 17:16:13 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
526 | 2022-08-24 10:11:10 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
525 | 2022-08-23 21:48:43 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
524 | 2022-08-07 10:41:05 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
523 | 2022-05-11 18:31:00 | dogie | 1 | 28756 | 10 | 0.486 | 59168.7 |
522 | 2022-05-11 04:31:43 | dogie | 1 | 28756 | 10 | 0.626 | 45936.1 |
521 | 2022-04-27 05:48:07 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
520 | 2022-02-07 01:22:33 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
519 | 2022-01-18 11:46:16 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
518 | 2021-11-22 11:04:18 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
517 | 2021-11-20 09:02:49 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
516 | 2021-11-06 04:01:24 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
515 | 2021-10-04 01:06:32 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
514 | 2021-09-03 22:25:56 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
513 | 2021-09-01 16:11:20 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
512 | 2021-08-17 09:02:25 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
511 | 2021-08-06 11:27:47 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
510 | 2021-07-27 04:15:10 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
509 | 2021-06-03 00:52:04 | dogie | 2 | 53800 | 108 | 3.140 | 17133.8 |
508 | 2021-05-17 22:11:57 | dogie | 1 | 28756 | 10 | 1.046 | 27491.4 |
507 | 2021-05-05 17:30:04 | dogie | 1 | 28756 | 10 | 0.530 | 54256.6 |
506 | 2021-04-28 16:33:45 | dogie | 2 | 53800 | 108 | 1.610 | 33416.1 |
505 | 2021-03-20 18:32:19 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
504 | 2021-02-23 10:49:10 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
503 | 2021-02-21 17:19:58 | dogie | 1 | 28756 | 10 | 0.500 | 57512.0 |
502 | 2021-02-03 10:23:25 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
501 | 2021-01-30 08:38:36 | dogie | 1 | 28756 | 10 | 0.593 | 48492.4 |
500 | 2021-01-28 17:01:46 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
499 | 2021-01-02 08:13:02 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
498 | 2020-11-01 15:07:02 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
497 | 2020-10-16 13:58:40 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
496 | 2020-09-28 11:48:39 | dogie | 1 | 28756 | 10 | 0.420 | 68466.7 |
495 | 2020-09-16 20:18:49 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
494 | 2020-08-27 07:20:18 | dogie | 1 | 28756 | 10 | 0.453 | 63479.0 |
493 | 2020-08-25 11:13:09 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |
492 | 2020-08-05 22:31:51 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
491 | 2020-08-02 04:32:14 | dogie | 1 | 28756 | 10 | 0.466 | 61708.2 |
490 | 2020-07-30 02:03:03 | dogie | 1 | 28756 | 10 | 1.033 | 27837.4 |
489 | 2020-07-27 08:57:20 | dogie | 1 | 28756 | 10 | 0.470 | 61183.0 |
488 | 2020-07-26 19:13:15 | dogie | 1 | 28756 | 10 | 0.470 | 61183.0 |
487 | 2020-06-21 09:41:41 | dogie | 1 | 28756 | 10 | 0.560 | 51350.0 |
486 | 2020-06-20 09:33:58 | dogie | 1 | 28756 | 10 | 0.450 | 63902.2 |
485 | 2020-06-17 12:55:26 | dogie | 1 | 28756 | 10 | 0.516 | 55728.7 |
484 | 2020-06-10 10:59:28 | dogie | 1 | 28756 | 10 | 0.470 | 61183.0 |
483 | 2020-06-09 11:33:18 | dogie | 1 | 28756 | 10 | 0.563 | 51076.4 |
482 | 2020-06-08 11:43:20 | dogie | 1 | 28756 | 10 | 0.470 | 61183.0 |
481 | 2020-06-02 02:41:19 | dogie | 1 | 28756 | 10 | 0.436 | 65954.1 |
480 | 2020-06-01 03:17:35 | dogie | 1 | 28756 | 10 | 0.483 | 59536.2 |
479 | 2020-05-16 12:32:16 | dogie | 1 | 28756 | 10 | 0.486 | 59168.7 |
478 | 2020-05-14 15:44:09 | dogie | 1 | 28756 | 10 | 0.440 | 65354.5 |