History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"roach"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
564 | 2024-05-09 14:10:53 | roach | 2 | 53800 | 78 | 2.546 | 21131.2 |
563 | 2024-05-04 08:23:12 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
562 | 2024-04-30 15:13:05 | roach | 1 | 28756 | 8 | 1.250 | 23004.8 |
561 | 2024-04-30 02:00:26 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
560 | 2024-04-29 13:50:57 | roach | 1 | 28756 | 8 | 1.096 | 26237.2 |
559 | 2024-04-27 08:14:22 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
558 | 2024-04-27 05:11:00 | roach | 1 | 28756 | 8 | 1.843 | 15602.8 |
557 | 2024-04-05 17:31:27 | roach | 3 | 83667 | 916 | 15.500 | 5397.9 |
556 | 2024-04-05 05:46:20 | roach | 3 | 83667 | 916 | 10.110 | 8275.7 |
555 | 2024-04-05 05:46:22 | roach | 2 | 53800 | 78 | 2.220 | 24234.2 |
554 | 2024-04-05 05:46:16 | roach | 1 | 28756 | 8 | 0.563 | 51076.4 |
553 | 2024-04-05 05:46:11 | roach | 3 | 83667 | 916 | 5.513 | 15176.3 |
552 | 2024-04-05 05:46:10 | roach | 2 | 53800 | 78 | 2.893 | 18596.6 |
551 | 2024-04-05 05:46:08 | roach | 1 | 28756 | 8 | 0.606 | 47452.1 |
550 | 2024-04-03 03:38:30 | roach | 1 | 28756 | 8 | 0.966 | 29768.1 |
549 | 2024-03-31 08:46:12 | roach | 1 | 28756 | 8 | 0.533 | 53951.2 |
548 | 2024-03-29 02:12:58 | roach | 1 | 28756 | 8 | 1.046 | 27491.4 |
547 | 2024-03-17 10:11:38 | roach | 1 | 28756 | 8 | 0.580 | 49579.3 |
546 | 2024-03-03 21:31:15 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
545 | 2024-03-01 04:03:00 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
544 | 2024-02-27 19:52:01 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
543 | 2024-02-02 20:40:15 | roach | 1 | 28756 | 8 | 0.436 | 65954.1 |
542 | 2024-01-28 22:32:23 | roach | 1 | 28756 | 8 | 0.436 | 65954.1 |
541 | 2024-01-28 22:10:29 | roach | 1 | 28756 | 8 | 0.533 | 53951.2 |
540 | 2024-01-09 20:05:42 | roach | 3 | 83667 | 916 | 3.500 | 23904.9 |
539 | 2024-01-09 20:05:39 | roach | 2 | 53800 | 78 | 1.546 | 34799.5 |
538 | 2023-12-14 16:36:39 | roach | 1 | 28756 | 8 | 0.450 | 63902.2 |
537 | 2023-12-08 10:54:05 | roach | 3 | 83667 | 916 | 4.033 | 20745.6 |
536 | 2023-12-08 10:54:00 | roach | 3 | 83667 | 916 | 3.983 | 21006.0 |
535 | 2023-11-21 02:33:27 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
534 | 2023-11-19 23:52:42 | roach | 3 | 83667 | 916 | 4.063 | 20592.4 |
533 | 2023-11-19 23:52:44 | roach | 2 | 53800 | 78 | 1.703 | 31591.3 |
532 | 2023-11-14 22:49:57 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
531 | 2023-11-04 16:06:08 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
530 | 2023-11-04 10:22:04 | roach | 1 | 28756 | 8 | 0.440 | 65354.5 |
529 | 2023-10-21 15:09:07 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
528 | 2023-10-18 13:32:44 | roach | 1 | 28756 | 8 | 0.576 | 49923.6 |
527 | 2023-10-13 17:52:32 | roach | 1 | 28756 | 8 | 0.483 | 59536.2 |
526 | 2023-10-11 23:33:44 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
525 | 2023-10-07 10:44:51 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
524 | 2023-09-29 14:46:32 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
523 | 2023-09-27 08:37:27 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
522 | 2023-07-27 02:59:28 | roach | 1 | 28756 | 8 | 0.470 | 61183.0 |
521 | 2023-06-08 10:18:37 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
520 | 2023-04-23 21:44:25 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
519 | 2023-02-16 21:46:37 | roach | 1 | 28756 | 8 | 0.440 | 65354.5 |
518 | 2023-02-15 02:48:49 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
517 | 2022-12-12 16:45:46 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
516 | 2022-11-25 08:48:49 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
515 | 2022-10-16 08:02:56 | roach | 1 | 28756 | 8 | 0.486 | 59168.7 |
514 | 2022-10-01 12:22:42 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
513 | 2022-09-19 15:41:36 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
512 | 2022-08-25 06:00:10 | roach | 1 | 28756 | 8 | 0.486 | 59168.7 |
511 | 2022-08-16 06:05:22 | roach | 1 | 28756 | 8 | 0.440 | 65354.5 |
510 | 2022-08-14 17:14:00 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
509 | 2022-07-29 01:27:14 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
508 | 2022-06-07 11:59:15 | roach | 1 | 28756 | 8 | 0.623 | 46157.3 |
507 | 2022-05-17 23:35:53 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
506 | 2022-04-21 12:42:37 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
505 | 2022-02-10 05:38:37 | roach | 1 | 28756 | 8 | 0.643 | 44721.6 |
504 | 2021-12-31 04:48:58 | roach | 1 | 28756 | 8 | 0.560 | 51350.0 |
503 | 2021-10-29 15:10:14 | roach | 1 | 28756 | 8 | 0.483 | 59536.2 |
502 | 2021-10-23 16:47:10 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
501 | 2021-10-21 03:37:45 | roach | 1 | 28756 | 8 | 0.486 | 59168.7 |
500 | 2021-10-02 20:15:35 | roach | 1 | 28756 | 8 | 1.000 | 28756.0 |
499 | 2021-07-28 05:14:57 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
498 | 2021-07-16 08:40:47 | roach | 1 | 28756 | 8 | 0.436 | 65954.1 |
497 | 2021-07-12 19:40:32 | roach | 1 | 28756 | 8 | 0.593 | 48492.4 |
496 | 2021-06-08 09:44:43 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
495 | 2021-05-19 07:13:20 | roach | 1 | 28756 | 8 | 0.470 | 61183.0 |
494 | 2021-04-19 07:20:54 | roach | 1 | 28756 | 8 | 0.466 | 61708.2 |
493 | 2021-04-09 04:15:10 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
492 | 2021-03-22 04:16:42 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
491 | 2021-01-31 17:17:47 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
490 | 2021-01-03 23:37:32 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
489 | 2020-12-31 00:05:16 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
488 | 2020-11-01 04:42:48 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
487 | 2020-10-23 04:11:37 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
486 | 2020-10-21 10:59:31 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
485 | 2020-09-29 02:02:45 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
484 | 2020-09-27 16:50:46 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
483 | 2020-09-07 01:04:41 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
482 | 2020-09-03 09:55:35 | roach | 1 | 28756 | 8 | 0.470 | 61183.0 |
481 | 2020-07-21 19:50:56 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
480 | 2020-06-18 14:56:12 | roach | 1 | 28756 | 8 | 0.513 | 56054.6 |
479 | 2020-06-17 15:57:56 | roach | 1 | 28756 | 8 | 0.563 | 51076.4 |
478 | 2020-03-25 18:59:28 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
477 | 2020-03-23 20:48:00 | roach | 1 | 28756 | 8 | 0.520 | 55300.0 |
476 | 2020-03-23 20:11:40 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |
475 | 2020-03-23 02:48:45 | roach | 1 | 28756 | 8 | 0.516 | 55728.7 |
474 | 2020-03-22 05:20:45 | roach | 1 | 28756 | 8 | 0.576 | 49923.6 |
473 | 2020-03-21 04:21:16 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
472 | 2020-03-18 09:30:05 | roach | 1 | 28756 | 8 | 0.453 | 63479.0 |
471 | 2020-03-10 21:08:21 | roach | 1 | 28756 | 8 | 0.470 | 61183.0 |
470 | 2020-02-28 18:23:56 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
469 | 2020-02-27 02:51:17 | roach | 1 | 28756 | 8 | 0.500 | 57512.0 |
468 | 2020-02-27 00:08:22 | roach | 1 | 28756 | 8 | 0.533 | 53951.2 |
467 | 2020-02-26 22:17:37 | roach | 1 | 28756 | 8 | 0.546 | 52666.7 |
466 | 2020-02-23 10:39:53 | roach | 1 | 28756 | 8 | 1.016 | 28303.1 |
465 | 2020-02-21 15:35:37 | roach | 1 | 28756 | 8 | 0.530 | 54256.6 |