History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sophy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
542 | 2024-04-21 01:14:38 | sophy | 1 | 28756 | 4 | 1.203 | 23903.6 |
541 | 2024-04-06 16:30:17 | sophy | 3 | 83667 | 941 | 9.576 | 8737.2 |
540 | 2024-04-06 06:37:05 | sophy | 2 | 53800 | 55 | 1.733 | 31044.4 |
539 | 2024-04-06 06:35:57 | sophy | 3 | 83667 | 941 | 6.313 | 13253.1 |
538 | 2024-04-05 18:06:59 | sophy | 2 | 53800 | 55 | 1.796 | 29955.5 |
537 | 2024-04-05 17:51:44 | sophy | 3 | 83667 | 941 | 4.250 | 19686.4 |
536 | 2024-04-05 17:26:40 | sophy | 3 | 83667 | 941 | 10.500 | 7968.3 |
535 | 2024-04-05 17:26:40 | sophy | 2 | 53800 | 55 | 3.530 | 15240.8 |
534 | 2024-04-05 17:15:52 | sophy | 1 | 28756 | 4 | 0.550 | 52283.6 |
533 | 2024-03-31 02:25:33 | sophy | 1 | 28756 | 4 | 1.063 | 27051.7 |
532 | 2024-03-29 02:12:22 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
531 | 2024-03-05 20:01:01 | sophy | 2 | 53800 | 55 | 3.686 | 14595.8 |
530 | 2024-03-05 18:51:03 | sophy | 3 | 83667 | 941 | 6.546 | 12781.4 |
529 | 2024-03-05 17:50:54 | sophy | 2 | 53800 | 55 | 2.000 | 26900.0 |
528 | 2024-03-04 18:39:35 | sophy | 3 | 83667 | 941 | 10.063 | 8314.3 |
527 | 2024-03-04 18:30:01 | sophy | 2 | 53800 | 55 | 3.843 | 13999.5 |
526 | 2024-03-04 18:19:51 | sophy | 1 | 28756 | 4 | 0.563 | 51076.4 |
525 | 2024-03-04 16:41:28 | sophy | 3 | 83667 | 941 | 5.953 | 14054.6 |
524 | 2024-02-28 16:50:46 | sophy | 1 | 28756 | 4 | 1.250 | 23004.8 |
523 | 2024-02-27 23:45:01 | sophy | 2 | 53800 | 55 | 1.953 | 27547.4 |
522 | 2024-02-27 22:37:32 | sophy | 3 | 83667 | 941 | 8.313 | 10064.6 |
521 | 2024-02-27 22:34:00 | sophy | 3 | 83667 | 941 | 4.580 | 18267.9 |
520 | 2024-02-27 22:34:01 | sophy | 2 | 53800 | 55 | 3.656 | 14715.5 |
519 | 2024-02-27 20:54:01 | sophy | 1 | 28756 | 4 | 0.530 | 54256.6 |
518 | 2024-02-08 12:44:38 | sophy | 2 | 53800 | 55 | 1.436 | 37465.2 |
517 | 2024-02-03 17:19:07 | sophy | 1 | 28756 | 4 | 0.533 | 53951.2 |
516 | 2024-01-09 08:37:09 | sophy | 3 | 83667 | 941 | 3.856 | 21697.9 |
515 | 2024-01-02 20:54:37 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
514 | 2024-01-01 14:24:10 | sophy | 2 | 53800 | 55 | 1.576 | 34137.1 |
513 | 2023-12-27 01:25:49 | sophy | 2 | 53800 | 55 | 1.436 | 37465.2 |
512 | 2023-12-22 19:31:28 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
511 | 2023-11-20 21:17:34 | sophy | 1 | 28756 | 4 | 0.483 | 59536.2 |
510 | 2023-11-15 12:46:01 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
509 | 2023-11-13 00:36:39 | sophy | 2 | 53800 | 55 | 1.390 | 38705.0 |
508 | 2023-11-04 03:37:31 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
507 | 2023-10-23 21:36:15 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
506 | 2023-10-23 02:39:12 | sophy | 1 | 28756 | 4 | 0.450 | 63902.2 |
505 | 2023-10-19 21:46:31 | sophy | 1 | 28756 | 4 | 0.436 | 65954.1 |
504 | 2023-10-13 17:49:51 | sophy | 1 | 28756 | 4 | 0.483 | 59536.2 |
503 | 2023-10-05 02:41:12 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
502 | 2023-09-29 12:03:53 | sophy | 1 | 28756 | 4 | 0.513 | 56054.6 |
501 | 2023-09-26 08:52:33 | sophy | 1 | 28756 | 4 | 0.560 | 51350.0 |
500 | 2023-08-20 10:42:56 | sophy | 1 | 28756 | 4 | 0.470 | 61183.0 |
499 | 2023-08-20 03:42:40 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
498 | 2023-08-16 19:05:22 | sophy | 1 | 28756 | 4 | 0.486 | 59168.7 |
497 | 2023-08-15 10:27:28 | sophy | 2 | 53800 | 55 | 1.576 | 34137.1 |
496 | 2023-06-17 22:38:15 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
495 | 2023-05-19 19:39:04 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
494 | 2023-05-04 00:42:58 | sophy | 2 | 53800 | 55 | 4.346 | 12379.2 |
493 | 2023-04-25 01:23:26 | sophy | 1 | 28756 | 4 | 0.466 | 61708.2 |
492 | 2023-03-15 15:53:19 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
491 | 2023-02-10 19:19:44 | sophy | 2 | 53800 | 55 | 1.376 | 39098.8 |
490 | 2023-01-10 09:02:55 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
489 | 2023-01-04 05:13:40 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
488 | 2022-12-25 01:46:31 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
487 | 2022-12-13 02:20:44 | sophy | 2 | 53800 | 55 | 1.563 | 34421.0 |
486 | 2022-11-22 06:58:41 | sophy | 2 | 53800 | 55 | 1.563 | 34421.0 |
485 | 2022-10-03 22:53:36 | sophy | 2 | 53800 | 55 | 1.393 | 38621.7 |
484 | 2022-09-26 13:44:44 | sophy | 1 | 28756 | 4 | 0.436 | 65954.1 |
483 | 2022-08-22 19:09:51 | sophy | 2 | 53800 | 55 | 1.420 | 37887.3 |
482 | 2022-08-21 05:34:56 | sophy | 1 | 28756 | 4 | 0.486 | 59168.7 |
481 | 2022-06-26 11:26:28 | sophy | 2 | 53800 | 55 | 1.390 | 38705.0 |
480 | 2022-05-10 04:38:52 | sophy | 1 | 28756 | 4 | 0.450 | 63902.2 |
479 | 2022-04-20 15:57:39 | sophy | 1 | 28756 | 4 | 0.686 | 41918.4 |
478 | 2022-02-27 12:58:43 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
477 | 2022-02-07 22:58:00 | sophy | 2 | 53800 | 55 | 1.453 | 37026.8 |
476 | 2022-01-26 23:51:06 | sophy | 1 | 28756 | 4 | 0.466 | 61708.2 |
475 | 2022-01-24 20:27:26 | sophy | 1 | 28756 | 4 | 0.563 | 51076.4 |
474 | 2021-12-26 01:45:19 | sophy | 1 | 28756 | 4 | 0.623 | 46157.3 |
473 | 2021-12-11 04:32:40 | sophy | 1 | 28756 | 4 | 0.530 | 54256.6 |
472 | 2021-11-22 08:27:26 | sophy | 1 | 28756 | 4 | 0.530 | 54256.6 |
471 | 2021-11-20 06:27:32 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
470 | 2021-11-15 00:54:25 | sophy | 2 | 53800 | 55 | 1.456 | 36950.5 |
469 | 2021-09-29 15:54:47 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |
468 | 2021-09-12 11:03:53 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
467 | 2021-08-25 22:52:03 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
466 | 2021-08-23 19:30:17 | sophy | 1 | 28756 | 4 | 0.533 | 53951.2 |
465 | 2021-06-12 05:14:17 | sophy | 1 | 28756 | 4 | 0.563 | 51076.4 |
464 | 2021-03-21 12:51:50 | sophy | 1 | 28756 | 4 | 0.486 | 59168.7 |
463 | 2021-03-05 22:33:07 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
462 | 2021-03-02 16:45:57 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
461 | 2021-02-22 07:27:58 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
460 | 2021-01-03 10:15:52 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
459 | 2020-12-06 08:13:18 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
458 | 2020-11-27 00:27:33 | sophy | 1 | 28756 | 4 | 0.470 | 61183.0 |
457 | 2020-10-23 09:09:49 | sophy | 1 | 28756 | 4 | 0.500 | 57512.0 |
456 | 2020-09-01 22:38:49 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
455 | 2020-08-27 16:08:10 | sophy | 1 | 28756 | 4 | 0.513 | 56054.6 |
454 | 2020-08-08 22:54:30 | sophy | 1 | 28756 | 4 | 0.483 | 59536.2 |
453 | 2020-08-06 14:13:41 | sophy | 1 | 28756 | 4 | 0.470 | 61183.0 |
452 | 2020-07-13 20:52:29 | sophy | 1 | 28756 | 4 | 0.470 | 61183.0 |
451 | 2020-04-28 01:13:20 | sophy | 1 | 28756 | 4 | 0.486 | 59168.7 |
450 | 2020-04-23 06:52:49 | sophy | 1 | 28756 | 4 | 0.470 | 61183.0 |
449 | 2020-04-14 01:48:28 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
448 | 2020-04-13 01:07:33 | sophy | 1 | 28756 | 4 | 0.483 | 59536.2 |
447 | 2020-04-12 01:15:59 | sophy | 1 | 28756 | 4 | 0.513 | 56054.6 |
446 | 2020-04-11 00:37:32 | sophy | 1 | 28756 | 4 | 0.530 | 54256.6 |
445 | 2020-03-30 04:38:55 | sophy | 1 | 28756 | 4 | 0.450 | 63902.2 |
444 | 2020-03-25 16:13:10 | sophy | 1 | 28756 | 4 | 0.453 | 63479.0 |
443 | 2020-03-23 21:46:08 | sophy | 1 | 28756 | 4 | 0.516 | 55728.7 |