History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drake"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
575 | 2024-05-08 04:50:53 | drake | 1 | 28756 | 7 | 1.123 | 25606.4 |
574 | 2024-04-30 23:12:56 | drake | 1 | 28756 | 7 | 0.596 | 48248.3 |
573 | 2024-04-30 10:31:41 | drake | 1 | 28756 | 7 | 1.280 | 22465.6 |
572 | 2024-04-27 09:38:31 | drake | 1 | 28756 | 7 | 0.560 | 51350.0 |
571 | 2024-04-19 08:18:34 | drake | 1 | 28756 | 7 | 1.046 | 27491.4 |
570 | 2024-04-02 21:46:26 | drake | 1 | 28756 | 7 | 0.450 | 63902.2 |
569 | 2024-03-31 10:59:30 | drake | 1 | 28756 | 7 | 0.560 | 51350.0 |
568 | 2024-03-30 22:05:33 | drake | 2 | 53800 | 144 | 1.686 | 31909.8 |
567 | 2024-03-30 22:05:32 | drake | 1 | 28756 | 7 | 0.516 | 55728.7 |
566 | 2024-03-28 23:27:39 | drake | 2 | 53800 | 144 | 2.283 | 23565.5 |
565 | 2024-03-28 23:27:26 | drake | 1 | 28756 | 7 | 0.563 | 51076.4 |
564 | 2024-03-24 04:06:18 | drake | 1 | 28756 | 7 | 0.550 | 52283.6 |
563 | 2024-03-08 02:25:14 | drake | 1 | 28756 | 7 | 0.546 | 52666.7 |
562 | 2024-03-07 02:36:52 | drake | 2 | 53800 | 144 | 1.796 | 29955.5 |
561 | 2024-03-06 03:56:43 | drake | 2 | 53800 | 144 | 5.516 | 9753.4 |
560 | 2024-03-05 21:10:33 | drake | 2 | 53800 | 144 | 1.390 | 38705.0 |
559 | 2024-02-27 20:23:12 | drake | 1 | 28756 | 7 | 0.546 | 52666.7 |
558 | 2024-02-14 01:10:08 | drake | 2 | 53800 | 144 | 1.826 | 29463.3 |
557 | 2024-01-28 23:59:05 | drake | 1 | 28756 | 7 | 0.486 | 59168.7 |
556 | 2024-01-04 16:17:52 | drake | 2 | 53800 | 144 | 1.576 | 34137.1 |
555 | 2024-01-01 05:25:42 | drake | 2 | 53800 | 144 | 1.403 | 38346.4 |
554 | 2023-12-18 20:37:51 | drake | 2 | 53800 | 144 | 1.750 | 30742.9 |
553 | 2023-12-11 12:44:11 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
552 | 2023-11-25 20:38:33 | drake | 2 | 53800 | 144 | 1.623 | 33148.5 |
551 | 2023-11-14 09:43:35 | drake | 1 | 28756 | 7 | 0.423 | 67981.1 |
550 | 2023-11-13 11:43:39 | drake | 1 | 28756 | 7 | 0.420 | 68466.7 |
549 | 2023-11-12 05:39:17 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
548 | 2023-10-31 09:55:52 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
547 | 2023-10-21 22:13:41 | drake | 1 | 28756 | 7 | 0.453 | 63479.0 |
546 | 2023-10-18 22:36:51 | drake | 1 | 28756 | 7 | 0.423 | 67981.1 |
545 | 2023-10-15 14:15:41 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
544 | 2023-10-04 23:26:44 | drake | 1 | 28756 | 7 | 0.500 | 57512.0 |
543 | 2023-09-28 06:49:41 | drake | 1 | 28756 | 7 | 0.563 | 51076.4 |
542 | 2023-09-24 15:07:51 | drake | 1 | 28756 | 7 | 0.500 | 57512.0 |
541 | 2023-09-22 06:13:30 | drake | 1 | 28756 | 7 | 0.470 | 61183.0 |
540 | 2023-07-27 22:18:56 | drake | 1 | 28756 | 7 | 0.470 | 61183.0 |
539 | 2023-07-26 18:58:17 | drake | 1 | 28756 | 7 | 0.470 | 61183.0 |
538 | 2023-07-11 23:05:12 | drake | 2 | 53800 | 144 | 1.563 | 34421.0 |
537 | 2023-04-24 10:49:12 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
536 | 2023-04-19 15:23:46 | drake | 1 | 28756 | 7 | 0.423 | 67981.1 |
535 | 2023-03-31 14:44:51 | drake | 2 | 53800 | 144 | 1.750 | 30742.9 |
534 | 2023-03-27 15:22:41 | drake | 1 | 28756 | 7 | 0.483 | 59536.2 |
533 | 2023-02-14 11:41:59 | drake | 1 | 28756 | 7 | 0.440 | 65354.5 |
532 | 2023-01-14 16:26:25 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
531 | 2022-12-11 02:08:22 | drake | 1 | 28756 | 7 | 0.440 | 65354.5 |
530 | 2022-09-30 17:21:34 | drake | 1 | 28756 | 7 | 0.483 | 59536.2 |
529 | 2022-09-12 03:54:48 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
528 | 2022-08-16 17:32:21 | drake | 1 | 28756 | 7 | 0.763 | 37688.1 |
527 | 2022-08-14 23:23:11 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
526 | 2022-08-06 21:18:56 | drake | 1 | 28756 | 7 | 0.483 | 59536.2 |
525 | 2022-07-29 07:32:37 | drake | 1 | 28756 | 7 | 0.486 | 59168.7 |
524 | 2022-07-03 08:17:22 | drake | 1 | 28756 | 7 | 0.420 | 68466.7 |
523 | 2022-06-20 10:04:25 | drake | 2 | 53800 | 144 | 1.356 | 39675.5 |
522 | 2022-06-17 10:14:10 | drake | 1 | 28756 | 7 | 0.483 | 59536.2 |
521 | 2022-06-16 08:17:43 | drake | 1 | 28756 | 7 | 0.470 | 61183.0 |
520 | 2022-06-15 16:38:48 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
519 | 2022-06-13 17:26:37 | drake | 1 | 28756 | 7 | 0.453 | 63479.0 |
518 | 2022-06-11 20:39:30 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
517 | 2022-06-07 00:56:55 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
516 | 2022-04-13 08:26:46 | drake | 1 | 28756 | 7 | 0.846 | 33990.5 |
515 | 2022-03-02 00:18:12 | drake | 1 | 28756 | 7 | 0.626 | 45936.1 |
514 | 2022-01-07 00:18:12 | drake | 1 | 28756 | 7 | 0.500 | 57512.0 |
513 | 2021-11-25 02:45:49 | drake | 1 | 28756 | 7 | 0.453 | 63479.0 |
512 | 2021-11-21 16:21:01 | drake | 1 | 28756 | 7 | 0.453 | 63479.0 |
511 | 2021-11-08 17:02:57 | drake | 1 | 28756 | 7 | 0.420 | 68466.7 |
510 | 2021-11-05 04:50:40 | drake | 1 | 28756 | 7 | 0.486 | 59168.7 |
509 | 2021-09-22 16:23:08 | drake | 1 | 28756 | 7 | 0.516 | 55728.7 |
508 | 2021-09-20 13:21:31 | drake | 1 | 28756 | 7 | 0.470 | 61183.0 |
507 | 2021-09-03 03:31:52 | drake | 1 | 28756 | 7 | 0.483 | 59536.2 |
506 | 2021-08-18 19:33:22 | drake | 1 | 28756 | 7 | 0.450 | 63902.2 |
505 | 2021-07-07 02:17:13 | drake | 1 | 28756 | 7 | 0.440 | 65354.5 |
504 | 2021-07-03 07:29:10 | drake | 2 | 53800 | 144 | 1.606 | 33499.4 |
503 | 2021-06-24 03:00:13 | drake | 1 | 28756 | 7 | 0.440 | 65354.5 |
502 | 2021-06-15 04:26:27 | drake | 2 | 53800 | 144 | 1.640 | 32804.9 |
501 | 2021-06-13 22:18:46 | drake | 2 | 53800 | 144 | 1.530 | 35163.4 |
500 | 2021-06-11 07:18:07 | drake | 2 | 53800 | 144 | 1.343 | 40059.6 |
499 | 2021-06-09 00:26:29 | drake | 2 | 53800 | 144 | 1.356 | 39675.5 |
498 | 2021-05-30 11:00:46 | drake | 2 | 53800 | 144 | 1.546 | 34799.5 |
497 | 2021-05-29 15:47:46 | drake | 2 | 53800 | 144 | 1.813 | 29674.6 |
496 | 2021-05-29 04:01:08 | drake | 2 | 53800 | 144 | 1.563 | 34421.0 |
495 | 2021-05-28 05:51:05 | drake | 2 | 53800 | 144 | 1.576 | 34137.1 |
494 | 2021-05-27 04:24:46 | drake | 2 | 53800 | 144 | 1.360 | 39558.8 |
493 | 2021-05-26 06:57:19 | drake | 2 | 53800 | 144 | 1.516 | 35488.1 |
492 | 2021-05-25 20:23:00 | drake | 2 | 53800 | 144 | 1.640 | 32804.9 |
491 | 2021-05-25 09:28:09 | drake | 2 | 53800 | 144 | 1.563 | 34421.0 |
490 | 2021-05-25 00:17:58 | drake | 2 | 53800 | 144 | 1.500 | 35866.7 |
489 | 2021-05-24 14:27:02 | drake | 2 | 53800 | 144 | 1.656 | 32487.9 |
488 | 2021-05-23 21:03:55 | drake | 2 | 53800 | 144 | 1.563 | 34421.0 |
487 | 2021-05-23 16:37:54 | drake | 2 | 53800 | 144 | 3.250 | 16553.8 |
486 | 2021-05-22 12:40:48 | drake | 2 | 53800 | 144 | 1.546 | 34799.5 |
485 | 2021-05-18 02:55:21 | drake | 1 | 28756 | 7 | 0.436 | 65954.1 |
484 | 2021-05-17 08:48:21 | drake | 2 | 53800 | 144 | 1.516 | 35488.1 |
483 | 2021-05-06 19:32:59 | drake | 2 | 53800 | 144 | 1.560 | 34487.2 |
482 | 2021-05-06 11:07:22 | drake | 2 | 53800 | 144 | 1.656 | 32487.9 |
481 | 2021-05-05 14:25:42 | drake | 2 | 53800 | 144 | 1.686 | 31909.8 |
480 | 2021-05-04 15:01:39 | drake | 2 | 53800 | 144 | 1.703 | 31591.3 |
479 | 2021-05-04 03:39:42 | drake | 2 | 53800 | 144 | 1.470 | 36598.6 |
478 | 2021-05-02 19:26:02 | drake | 2 | 53800 | 144 | 1.703 | 31591.3 |
477 | 2021-04-29 16:56:32 | drake | 2 | 53800 | 144 | 1.703 | 31591.3 |
476 | 2021-04-28 17:38:45 | drake | 2 | 53800 | 144 | 1.580 | 34050.6 |