History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"randy"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
525 | 2024-05-03 22:39:12 | randy | 1 | 28756 | 12 | 0.563 | 51076.4 |
524 | 2024-04-28 07:28:04 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
523 | 2024-04-18 12:00:45 | randy | 1 | 28756 | 12 | 1.140 | 25224.6 |
522 | 2024-04-13 20:15:32 | randy | 1 | 28756 | 12 | 0.610 | 47141.0 |
521 | 2024-04-10 04:53:20 | randy | 1 | 28756 | 12 | 1.016 | 28303.1 |
520 | 2024-04-03 02:47:32 | randy | 1 | 28756 | 12 | 1.326 | 21686.3 |
519 | 2024-03-28 23:11:43 | randy | 1 | 28756 | 12 | 0.593 | 48492.4 |
518 | 2024-03-17 19:58:55 | randy | 2 | 53800 | 126 | 1.983 | 27130.6 |
517 | 2024-03-17 19:34:28 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
516 | 2024-03-05 17:20:24 | randy | 2 | 53800 | 126 | 1.986 | 27089.6 |
515 | 2024-03-03 23:29:30 | randy | 2 | 53800 | 126 | 5.733 | 9384.3 |
514 | 2024-03-03 22:15:27 | randy | 1 | 28756 | 12 | 0.450 | 63902.2 |
513 | 2024-02-27 19:47:37 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
512 | 2024-02-18 10:35:34 | randy | 1 | 28756 | 12 | 0.703 | 40904.7 |
511 | 2024-02-14 18:02:54 | randy | 2 | 53800 | 126 | 1.530 | 35163.4 |
510 | 2024-02-14 18:02:46 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
509 | 2024-02-02 18:59:07 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
508 | 2024-01-29 00:05:13 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
507 | 2024-01-15 13:15:11 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
506 | 2024-01-08 09:46:35 | randy | 2 | 53800 | 126 | 1.780 | 30224.7 |
505 | 2024-01-08 04:02:29 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
504 | 2023-12-30 19:12:57 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
503 | 2023-11-28 09:31:52 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
502 | 2023-11-27 00:12:09 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
501 | 2023-11-17 20:19:04 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
500 | 2023-11-14 19:03:10 | randy | 1 | 28756 | 12 | 0.436 | 65954.1 |
499 | 2023-11-03 19:21:27 | randy | 1 | 28756 | 12 | 0.543 | 52957.6 |
498 | 2023-10-25 00:18:42 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
497 | 2023-10-21 15:09:07 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
496 | 2023-10-20 10:41:28 | randy | 1 | 28756 | 12 | 1.000 | 28756.0 |
495 | 2023-10-14 01:19:08 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
494 | 2023-10-05 02:37:14 | randy | 1 | 28756 | 12 | 0.533 | 53951.2 |
493 | 2023-09-28 07:36:16 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
492 | 2023-09-24 01:44:52 | randy | 1 | 28756 | 12 | 0.576 | 49923.6 |
491 | 2023-09-11 22:59:06 | randy | 1 | 28756 | 12 | 0.513 | 56054.6 |
490 | 2023-09-02 02:06:07 | randy | 1 | 28756 | 12 | 1.076 | 26724.9 |
489 | 2023-08-18 05:01:26 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
488 | 2023-08-01 22:40:33 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
487 | 2023-05-18 20:52:38 | randy | 1 | 28756 | 12 | 0.436 | 65954.1 |
486 | 2023-05-05 11:40:43 | randy | 1 | 28756 | 12 | 0.483 | 59536.2 |
485 | 2023-03-13 22:08:04 | randy | 1 | 28756 | 12 | 0.436 | 65954.1 |
484 | 2023-01-11 23:47:47 | randy | 1 | 28756 | 12 | 0.440 | 65354.5 |
483 | 2023-01-02 23:29:52 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
482 | 2022-11-25 10:05:06 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
481 | 2022-09-22 07:57:16 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
480 | 2022-09-06 12:56:06 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
479 | 2022-09-01 18:08:54 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
478 | 2022-08-16 02:09:00 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
477 | 2022-07-18 15:25:12 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
476 | 2022-07-10 04:57:37 | randy | 1 | 28756 | 12 | 0.486 | 59168.7 |
475 | 2022-06-25 10:01:43 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
474 | 2022-06-17 00:09:29 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
473 | 2022-06-01 19:46:59 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
472 | 2022-06-01 15:53:32 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
471 | 2022-05-04 01:27:16 | randy | 1 | 28756 | 12 | 0.626 | 45936.1 |
470 | 2022-05-01 21:39:26 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
469 | 2022-04-23 10:36:58 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
468 | 2022-04-19 23:45:26 | randy | 1 | 28756 | 12 | 0.533 | 53951.2 |
467 | 2022-01-23 02:09:56 | randy | 1 | 28756 | 12 | 0.593 | 48492.4 |
466 | 2021-12-28 14:37:57 | randy | 1 | 28756 | 12 | 0.513 | 56054.6 |
465 | 2021-11-22 18:34:55 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
464 | 2021-10-10 13:42:05 | randy | 1 | 28756 | 12 | 0.533 | 53951.2 |
463 | 2021-09-28 00:17:53 | randy | 1 | 28756 | 12 | 1.013 | 28387.0 |
462 | 2021-09-23 15:10:36 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
461 | 2021-09-18 06:42:29 | randy | 1 | 28756 | 12 | 0.483 | 59536.2 |
460 | 2021-09-08 16:00:34 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
459 | 2021-08-24 05:01:53 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
458 | 2021-08-22 00:30:20 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
457 | 2021-06-18 10:45:55 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
456 | 2021-05-31 07:08:59 | randy | 1 | 28756 | 12 | 0.466 | 61708.2 |
455 | 2021-05-01 11:47:06 | randy | 1 | 28756 | 12 | 0.546 | 52666.7 |
454 | 2021-03-15 15:58:11 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
453 | 2021-02-04 07:45:50 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
452 | 2021-01-19 15:32:09 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
451 | 2020-11-30 15:28:53 | randy | 1 | 28756 | 12 | 0.450 | 63902.2 |
450 | 2020-11-24 16:41:29 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
449 | 2020-10-31 12:18:52 | randy | 1 | 28756 | 12 | 0.533 | 53951.2 |
448 | 2020-10-29 22:05:32 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
447 | 2020-10-11 12:08:40 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
446 | 2020-10-04 22:55:52 | randy | 1 | 28756 | 12 | 0.436 | 65954.1 |
445 | 2020-08-14 17:58:38 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
444 | 2020-08-11 07:44:51 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
443 | 2020-08-01 12:14:45 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
442 | 2020-07-28 21:35:49 | randy | 1 | 28756 | 12 | 0.563 | 51076.4 |
441 | 2020-06-09 06:24:09 | randy | 1 | 28756 | 12 | 0.530 | 54256.6 |
440 | 2020-06-02 07:03:47 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
439 | 2020-06-01 07:25:04 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |
438 | 2020-05-28 07:14:34 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
437 | 2020-05-27 06:34:58 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
436 | 2020-05-24 11:30:58 | randy | 1 | 28756 | 12 | 0.593 | 48492.4 |
435 | 2020-05-23 12:03:33 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
434 | 2020-05-20 05:26:02 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
433 | 2020-05-19 04:19:55 | randy | 1 | 28756 | 12 | 0.453 | 63479.0 |
432 | 2020-05-16 15:56:33 | randy | 1 | 28756 | 12 | 0.466 | 61708.2 |
431 | 2020-05-14 01:09:01 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
430 | 2020-05-13 10:44:00 | randy | 1 | 28756 | 12 | 0.466 | 61708.2 |
429 | 2020-05-12 11:27:02 | randy | 1 | 28756 | 12 | 0.483 | 59536.2 |
428 | 2020-05-10 11:27:07 | randy | 1 | 28756 | 12 | 0.470 | 61183.0 |
427 | 2020-05-09 11:24:03 | randy | 1 | 28756 | 12 | 0.500 | 57512.0 |
426 | 2020-05-08 11:24:47 | randy | 1 | 28756 | 12 | 0.516 | 55728.7 |