History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gemmy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
547 | 2024-04-03 05:48:51 | gemmy | 1 | 28756 | 8 | 0.563 | 51076.4 |
546 | 2024-03-31 09:05:00 | gemmy | 3 | 83667 | 619 | 4.653 | 17981.3 |
545 | 2024-03-31 09:05:00 | gemmy | 2 | 53800 | 54 | 3.686 | 14595.8 |
544 | 2024-03-31 03:54:04 | gemmy | 1 | 28756 | 8 | 1.000 | 28756.0 |
543 | 2024-03-30 20:06:19 | gemmy | 3 | 83667 | 619 | 4.810 | 17394.4 |
542 | 2024-03-30 20:01:08 | gemmy | 2 | 53800 | 54 | 5.186 | 10374.1 |
541 | 2024-03-29 19:04:09 | gemmy | 2 | 53800 | 54 | 1.716 | 31352.0 |
540 | 2024-03-29 19:03:47 | gemmy | 3 | 83667 | 619 | 4.470 | 18717.4 |
539 | 2024-03-29 08:25:35 | gemmy | 3 | 83667 | 619 | 10.470 | 7991.1 |
538 | 2024-03-29 08:25:36 | gemmy | 2 | 53800 | 54 | 1.860 | 28924.7 |
537 | 2024-03-29 08:19:50 | gemmy | 1 | 28756 | 8 | 1.110 | 25906.3 |
536 | 2024-03-05 20:53:39 | gemmy | 1 | 28756 | 8 | 1.000 | 28756.0 |
535 | 2024-03-03 21:07:41 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
534 | 2024-02-28 02:18:27 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
533 | 2024-01-29 17:09:52 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
532 | 2024-01-29 06:50:08 | gemmy | 2 | 53800 | 54 | 1.610 | 33416.1 |
531 | 2024-01-29 06:48:43 | gemmy | 3 | 83667 | 619 | 3.593 | 23286.1 |
530 | 2024-01-29 00:48:21 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
529 | 2024-01-28 20:38:11 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
528 | 2024-01-26 16:20:49 | gemmy | 3 | 83667 | 619 | 12.360 | 6769.2 |
527 | 2024-01-26 14:34:43 | gemmy | 3 | 83667 | 619 | 4.940 | 16936.6 |
526 | 2024-01-11 01:42:40 | gemmy | 2 | 53800 | 54 | 1.576 | 34137.1 |
525 | 2024-01-04 12:48:22 | gemmy | 2 | 53800 | 54 | 1.580 | 34050.6 |
524 | 2023-12-25 04:40:21 | gemmy | 3 | 83667 | 619 | 3.580 | 23370.7 |
523 | 2023-12-12 08:35:43 | gemmy | 2 | 53800 | 54 | 1.500 | 35866.7 |
522 | 2023-12-12 07:56:15 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
521 | 2023-12-08 16:30:32 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
520 | 2023-11-30 06:38:12 | gemmy | 2 | 53800 | 54 | 1.530 | 35163.4 |
519 | 2023-11-30 06:38:05 | gemmy | 3 | 83667 | 619 | 3.516 | 23796.1 |
518 | 2023-11-25 17:34:57 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
517 | 2023-11-14 05:38:27 | gemmy | 1 | 28756 | 8 | 0.486 | 59168.7 |
516 | 2023-11-12 16:06:34 | gemmy | 3 | 83667 | 619 | 3.516 | 23796.1 |
515 | 2023-11-12 09:58:53 | gemmy | 3 | 83667 | 619 | 3.796 | 22040.8 |
514 | 2023-11-11 09:51:13 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
513 | 2023-11-06 04:03:41 | gemmy | 3 | 83667 | 619 | 3.953 | 21165.4 |
512 | 2023-11-04 02:13:29 | gemmy | 1 | 28756 | 8 | 0.470 | 61183.0 |
511 | 2023-10-23 08:59:36 | gemmy | 2 | 53800 | 54 | 1.843 | 29191.5 |
510 | 2023-10-22 05:04:45 | gemmy | 1 | 28756 | 8 | 0.513 | 56054.6 |
509 | 2023-10-19 04:22:22 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
508 | 2023-10-18 18:08:00 | gemmy | 2 | 53800 | 54 | 1.580 | 34050.6 |
507 | 2023-10-13 18:08:25 | gemmy | 1 | 28756 | 8 | 0.486 | 59168.7 |
506 | 2023-10-05 00:56:10 | gemmy | 1 | 28756 | 8 | 0.466 | 61708.2 |
505 | 2023-09-29 04:35:02 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
504 | 2023-09-12 20:26:57 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
503 | 2023-09-11 01:05:30 | gemmy | 1 | 28756 | 8 | 0.483 | 59536.2 |
502 | 2023-08-19 11:55:59 | gemmy | 1 | 28756 | 8 | 0.420 | 68466.7 |
501 | 2023-08-10 12:32:55 | gemmy | 3 | 83667 | 619 | 3.466 | 24139.4 |
500 | 2023-07-30 05:57:08 | gemmy | 2 | 53800 | 54 | 1.360 | 39558.8 |
499 | 2023-06-25 08:33:37 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
498 | 2023-05-05 10:57:12 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
497 | 2023-04-21 09:24:00 | gemmy | 3 | 83667 | 619 | 3.703 | 22594.4 |
496 | 2023-04-07 08:08:48 | gemmy | 2 | 53800 | 54 | 1.310 | 41068.7 |
495 | 2023-04-06 18:34:35 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
494 | 2023-02-05 17:58:01 | gemmy | 3 | 83667 | 619 | 3.140 | 26645.5 |
493 | 2023-01-26 18:27:23 | gemmy | 3 | 83667 | 619 | 3.203 | 26121.4 |
492 | 2023-01-23 04:15:46 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
491 | 2023-01-21 19:40:56 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
490 | 2023-01-05 04:51:58 | gemmy | 2 | 53800 | 54 | 1.326 | 40573.2 |
489 | 2022-12-26 15:34:23 | gemmy | 3 | 83667 | 619 | 3.876 | 21585.9 |
488 | 2022-11-28 01:43:57 | gemmy | 3 | 83667 | 619 | 3.673 | 22778.9 |
487 | 2022-11-22 11:18:43 | gemmy | 3 | 83667 | 619 | 3.250 | 25743.7 |
486 | 2022-11-19 03:18:50 | gemmy | 1 | 28756 | 8 | 0.420 | 68466.7 |
485 | 2022-11-09 23:55:44 | gemmy | 3 | 83667 | 619 | 3.233 | 25879.1 |
484 | 2022-11-09 04:40:59 | gemmy | 3 | 83667 | 619 | 7.733 | 10819.5 |
483 | 2022-11-02 17:49:46 | gemmy | 3 | 83667 | 619 | 3.420 | 24464.0 |
482 | 2022-10-23 08:55:24 | gemmy | 3 | 83667 | 619 | 3.250 | 25743.7 |
481 | 2022-10-05 06:25:29 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
480 | 2022-09-19 19:54:29 | gemmy | 3 | 83667 | 619 | 3.546 | 23594.8 |
479 | 2022-09-18 18:30:42 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
478 | 2022-09-11 01:16:36 | gemmy | 2 | 53800 | 54 | 1.360 | 39558.8 |
477 | 2022-08-17 20:25:36 | gemmy | 3 | 83667 | 619 | 3.643 | 22966.5 |
476 | 2022-08-07 02:43:45 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
475 | 2022-07-18 00:46:04 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
474 | 2022-07-10 16:01:32 | gemmy | 1 | 28756 | 8 | 0.440 | 65354.5 |
473 | 2022-07-10 04:55:48 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
472 | 2022-07-04 03:10:15 | gemmy | 1 | 28756 | 8 | 0.486 | 59168.7 |
471 | 2022-06-25 09:59:13 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
470 | 2022-06-10 16:41:06 | gemmy | 3 | 83667 | 619 | 3.266 | 25617.6 |
469 | 2022-06-07 10:18:27 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
468 | 2022-06-01 21:31:43 | gemmy | 1 | 28756 | 8 | 0.453 | 63479.0 |
467 | 2022-06-01 15:52:40 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
466 | 2022-03-26 00:13:04 | gemmy | 2 | 53800 | 54 | 1.436 | 37465.2 |
465 | 2022-03-11 02:39:03 | gemmy | 1 | 28756 | 8 | 0.736 | 39070.7 |
464 | 2022-02-17 06:08:15 | gemmy | 1 | 28756 | 8 | 0.436 | 65954.1 |
463 | 2021-12-21 09:39:47 | gemmy | 1 | 28756 | 8 | 0.500 | 57512.0 |
462 | 2021-11-09 06:04:53 | gemmy | 1 | 28756 | 8 | 0.423 | 67981.1 |
461 | 2021-10-30 17:58:25 | gemmy | 3 | 83667 | 619 | 3.860 | 21675.4 |
460 | 2021-10-30 06:14:34 | gemmy | 3 | 83667 | 619 | 3.343 | 25027.5 |
459 | 2021-10-29 11:05:36 | gemmy | 3 | 83667 | 619 | 3.203 | 26121.4 |
458 | 2021-10-28 02:28:34 | gemmy | 3 | 83667 | 619 | 3.326 | 25155.4 |
457 | 2021-10-27 07:04:16 | gemmy | 3 | 83667 | 619 | 3.250 | 25743.7 |
456 | 2021-10-26 17:35:57 | gemmy | 3 | 83667 | 619 | 3.720 | 22491.1 |
455 | 2021-10-26 16:08:36 | gemmy | 3 | 83667 | 619 | 3.313 | 25254.2 |
454 | 2021-10-26 08:52:09 | gemmy | 1 | 28756 | 8 | 0.486 | 59168.7 |
453 | 2021-10-26 08:05:55 | gemmy | 3 | 83667 | 619 | 3.533 | 23681.6 |
452 | 2021-10-25 14:41:35 | gemmy | 3 | 83667 | 619 | 3.580 | 23370.7 |
451 | 2021-10-25 05:59:42 | gemmy | 3 | 83667 | 619 | 3.296 | 25384.4 |
450 | 2021-10-24 20:55:54 | gemmy | 3 | 83667 | 619 | 4.033 | 20745.6 |
449 | 2021-10-24 13:00:15 | gemmy | 3 | 83667 | 619 | 3.736 | 22394.8 |
448 | 2021-10-24 02:27:28 | gemmy | 3 | 83667 | 619 | 3.623 | 23093.3 |