History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hubby"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
504 | 2024-04-20 18:35:32 | hubby | 1 | 28756 | 9 | 1.860 | 15460.2 |
503 | 2024-04-05 03:47:28 | hubby | 2 | 53800 | 50 | 3.406 | 15795.7 |
502 | 2024-04-05 03:47:21 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
501 | 2024-04-05 03:47:16 | hubby | 2 | 53800 | 50 | 1.720 | 31279.1 |
500 | 2024-04-04 03:59:15 | hubby | 3 | 83667 | 515 | 9.033 | 9262.4 |
499 | 2024-04-03 10:33:59 | hubby | 2 | 53800 | 50 | 1.550 | 34709.7 |
498 | 2024-04-03 10:33:51 | hubby | 3 | 83667 | 515 | 6.186 | 13525.2 |
497 | 2024-04-03 10:33:47 | hubby | 1 | 28756 | 9 | 1.063 | 27051.7 |
496 | 2024-03-31 04:34:58 | hubby | 2 | 53800 | 50 | 5.516 | 9753.4 |
495 | 2024-03-31 04:34:49 | hubby | 3 | 83667 | 515 | 12.186 | 6865.8 |
494 | 2024-03-31 04:21:56 | hubby | 1 | 28756 | 9 | 1.626 | 17685.1 |
493 | 2024-03-30 09:39:55 | hubby | 1 | 28756 | 9 | 1.610 | 17860.9 |
492 | 2024-03-27 04:46:39 | hubby | 1 | 28756 | 9 | 0.470 | 61183.0 |
491 | 2024-03-05 19:51:15 | hubby | 2 | 53800 | 50 | 1.640 | 32804.9 |
490 | 2024-03-05 19:50:54 | hubby | 3 | 83667 | 515 | 6.440 | 12991.8 |
489 | 2024-03-04 20:19:28 | hubby | 1 | 28756 | 9 | 0.640 | 44931.3 |
488 | 2024-03-04 11:55:18 | hubby | 2 | 53800 | 50 | 2.313 | 23259.8 |
487 | 2024-03-04 11:55:16 | hubby | 1 | 28756 | 9 | 1.140 | 25224.6 |
486 | 2024-03-04 11:54:51 | hubby | 3 | 83667 | 515 | 5.343 | 15659.2 |
485 | 2024-03-04 08:17:40 | hubby | 3 | 83667 | 515 | 3.860 | 21675.4 |
484 | 2024-03-04 08:17:41 | hubby | 2 | 53800 | 50 | 1.720 | 31279.1 |
483 | 2024-03-04 08:17:25 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
482 | 2024-02-26 03:43:16 | hubby | 1 | 28756 | 9 | 0.486 | 59168.7 |
481 | 2024-02-21 05:29:34 | hubby | 1 | 28756 | 9 | 1.656 | 17364.7 |
480 | 2024-02-13 09:20:20 | hubby | 1 | 28756 | 9 | 1.640 | 17534.1 |
479 | 2024-02-03 04:27:31 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
478 | 2024-01-29 01:00:55 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
477 | 2024-01-27 02:37:57 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
476 | 2024-01-21 07:19:50 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
475 | 2024-01-11 03:32:19 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
474 | 2023-12-04 20:34:56 | hubby | 3 | 83667 | 515 | 3.546 | 23594.8 |
473 | 2023-12-02 04:41:05 | hubby | 2 | 53800 | 50 | 2.920 | 18424.7 |
472 | 2023-12-02 04:41:03 | hubby | 3 | 83667 | 515 | 3.716 | 22515.3 |
471 | 2023-11-17 16:51:56 | hubby | 1 | 28756 | 9 | 0.453 | 63479.0 |
470 | 2023-11-16 11:11:40 | hubby | 2 | 53800 | 50 | 1.343 | 40059.6 |
469 | 2023-11-13 00:26:05 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
468 | 2023-11-10 03:36:17 | hubby | 3 | 83667 | 515 | 3.563 | 23482.2 |
467 | 2023-11-09 04:39:28 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
466 | 2023-11-08 19:10:09 | hubby | 1 | 28756 | 9 | 0.486 | 59168.7 |
465 | 2023-11-06 04:29:14 | hubby | 3 | 83667 | 515 | 3.346 | 25005.1 |
464 | 2023-11-06 04:29:10 | hubby | 2 | 53800 | 50 | 1.390 | 38705.0 |
463 | 2023-10-29 19:12:22 | hubby | 3 | 83667 | 515 | 3.593 | 23286.1 |
462 | 2023-10-29 19:12:20 | hubby | 2 | 53800 | 50 | 1.593 | 33772.8 |
461 | 2023-10-26 11:56:13 | hubby | 1 | 28756 | 9 | 0.440 | 65354.5 |
460 | 2023-10-20 18:27:23 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
459 | 2023-10-17 14:06:22 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
458 | 2023-10-11 19:07:45 | hubby | 3 | 83667 | 515 | 3.686 | 22698.6 |
457 | 2023-10-11 19:07:44 | hubby | 2 | 53800 | 50 | 1.360 | 39558.8 |
456 | 2023-10-10 00:38:11 | hubby | 1 | 28756 | 9 | 0.563 | 51076.4 |
455 | 2023-10-05 11:56:02 | hubby | 2 | 53800 | 50 | 1.466 | 36698.5 |
454 | 2023-10-05 11:54:51 | hubby | 3 | 83667 | 515 | 3.326 | 25155.4 |
453 | 2023-10-03 09:51:32 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
452 | 2023-09-21 18:26:51 | hubby | 1 | 28756 | 9 | 0.423 | 67981.1 |
451 | 2023-09-21 08:21:32 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
450 | 2023-09-03 17:33:37 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
449 | 2023-07-18 04:19:35 | hubby | 1 | 28756 | 9 | 0.546 | 52666.7 |
448 | 2023-03-26 12:48:16 | hubby | 1 | 28756 | 9 | 0.470 | 61183.0 |
447 | 2023-03-23 01:21:08 | hubby | 1 | 28756 | 9 | 0.423 | 67981.1 |
446 | 2023-03-06 12:20:53 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
445 | 2022-12-30 01:22:00 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
444 | 2022-11-25 02:42:08 | hubby | 1 | 28756 | 9 | 0.470 | 61183.0 |
443 | 2022-09-19 12:01:10 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
442 | 2022-09-19 06:33:00 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
441 | 2022-09-03 21:49:59 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
440 | 2022-08-23 07:25:57 | hubby | 1 | 28756 | 9 | 0.440 | 65354.5 |
439 | 2022-08-14 15:35:32 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
438 | 2022-08-04 19:11:38 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
437 | 2022-07-28 23:47:59 | hubby | 1 | 28756 | 9 | 0.453 | 63479.0 |
436 | 2022-04-30 23:08:00 | hubby | 1 | 28756 | 9 | 0.483 | 59536.2 |
435 | 2022-04-10 05:56:55 | hubby | 1 | 28756 | 9 | 0.453 | 63479.0 |
434 | 2022-01-26 11:48:44 | hubby | 1 | 28756 | 9 | 0.533 | 53951.2 |
433 | 2021-12-22 21:14:04 | hubby | 1 | 28756 | 9 | 0.516 | 55728.7 |
432 | 2021-11-17 16:35:39 | hubby | 1 | 28756 | 9 | 0.466 | 61708.2 |
431 | 2021-10-07 14:34:28 | hubby | 1 | 28756 | 9 | 0.530 | 54256.6 |
430 | 2021-09-12 10:39:51 | hubby | 1 | 28756 | 9 | 0.440 | 65354.5 |
429 | 2021-09-05 12:28:39 | hubby | 1 | 28756 | 9 | 0.440 | 65354.5 |
428 | 2021-08-18 22:05:15 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
427 | 2021-06-18 02:11:36 | hubby | 1 | 28756 | 9 | 0.686 | 41918.4 |
426 | 2021-06-16 06:17:01 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
425 | 2021-06-12 05:11:49 | hubby | 1 | 28756 | 9 | 0.453 | 63479.0 |
424 | 2021-06-04 01:07:52 | hubby | 1 | 28756 | 9 | 0.423 | 67981.1 |
423 | 2021-06-03 01:51:28 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
422 | 2021-06-02 14:59:41 | hubby | 1 | 28756 | 9 | 0.953 | 30174.2 |
421 | 2021-06-02 04:14:04 | hubby | 1 | 28756 | 9 | 0.486 | 59168.7 |
420 | 2021-04-18 23:10:54 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
419 | 2021-04-17 21:26:53 | hubby | 1 | 28756 | 9 | 0.890 | 32310.1 |
418 | 2021-03-26 20:26:54 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
417 | 2021-03-09 03:45:22 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
416 | 2021-03-05 22:31:58 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
415 | 2021-02-25 02:31:27 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
414 | 2021-02-20 04:16:28 | hubby | 1 | 28756 | 9 | 0.436 | 65954.1 |
413 | 2021-02-19 06:38:48 | hubby | 3 | 83667 | 515 | 3.283 | 25484.9 |
412 | 2021-02-04 05:00:37 | hubby | 1 | 28756 | 9 | 0.453 | 63479.0 |
411 | 2021-01-10 03:07:57 | hubby | 1 | 28756 | 9 | 0.420 | 68466.7 |
410 | 2020-12-01 11:33:39 | hubby | 1 | 28756 | 9 | 0.486 | 59168.7 |
409 | 2020-11-17 12:28:36 | hubby | 3 | 83667 | 515 | 3.610 | 23176.5 |
408 | 2020-10-24 05:15:17 | hubby | 1 | 28756 | 9 | 0.440 | 65354.5 |
407 | 2020-10-23 14:56:17 | hubby | 3 | 83667 | 515 | 3.466 | 24139.4 |
406 | 2020-10-22 11:31:02 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |
405 | 2020-10-15 07:01:11 | hubby | 1 | 28756 | 9 | 0.500 | 57512.0 |