History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spook"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
514 | 2024-04-22 22:23:37 | spook | 1 | 28756 | 11 | 0.486 | 59168.7 |
513 | 2024-04-09 16:00:29 | spook | 1 | 28756 | 11 | 1.733 | 16593.2 |
512 | 2024-04-03 03:04:29 | spook | 1 | 28756 | 11 | 2.250 | 12780.4 |
511 | 2024-03-31 05:53:51 | spook | 2 | 53800 | 90 | 3.780 | 14232.8 |
510 | 2024-03-31 03:46:34 | spook | 1 | 28756 | 11 | 0.546 | 52666.7 |
509 | 2024-03-29 02:09:56 | spook | 1 | 28756 | 11 | 0.530 | 54256.6 |
508 | 2024-03-04 00:31:07 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
507 | 2024-02-28 16:50:42 | spook | 1 | 28756 | 11 | 0.920 | 31256.5 |
506 | 2024-02-27 20:28:13 | spook | 1 | 28756 | 11 | 0.700 | 41080.0 |
505 | 2024-02-03 00:30:59 | spook | 1 | 28756 | 11 | 1.046 | 27491.4 |
504 | 2024-01-28 19:32:49 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
503 | 2024-01-19 02:21:34 | spook | 3 | 83667 | 889 | 3.593 | 23286.1 |
502 | 2024-01-19 02:21:35 | spook | 2 | 53800 | 90 | 1.576 | 34137.1 |
501 | 2024-01-05 11:26:24 | spook | 2 | 53800 | 90 | 1.453 | 37026.8 |
500 | 2024-01-02 13:17:01 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
499 | 2024-01-02 05:39:51 | spook | 3 | 83667 | 889 | 3.373 | 24804.9 |
498 | 2024-01-01 19:31:33 | spook | 2 | 53800 | 90 | 1.393 | 38621.7 |
497 | 2024-01-01 19:29:30 | spook | 3 | 83667 | 889 | 3.296 | 25384.4 |
496 | 2023-11-29 18:30:51 | spook | 3 | 83667 | 889 | 3.656 | 22884.8 |
495 | 2023-11-29 18:30:36 | spook | 2 | 53800 | 90 | 1.576 | 34137.1 |
494 | 2023-11-18 13:19:29 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
493 | 2023-11-13 21:15:20 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
492 | 2023-10-30 23:13:23 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
491 | 2023-10-24 12:25:33 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
490 | 2023-10-22 02:28:45 | spook | 1 | 28756 | 11 | 0.533 | 53951.2 |
489 | 2023-10-18 22:41:44 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
488 | 2023-10-12 08:25:43 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
487 | 2023-10-07 04:17:14 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
486 | 2023-09-26 19:32:03 | spook | 1 | 28756 | 11 | 0.530 | 54256.6 |
485 | 2023-09-22 22:33:21 | spook | 1 | 28756 | 11 | 0.483 | 59536.2 |
484 | 2023-08-19 07:59:43 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
483 | 2023-05-27 20:35:09 | spook | 1 | 28756 | 11 | 0.860 | 33437.2 |
482 | 2023-05-27 17:56:11 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
481 | 2023-05-18 18:05:31 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
480 | 2023-03-12 04:39:16 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
479 | 2022-12-31 09:54:28 | spook | 1 | 28756 | 11 | 0.486 | 59168.7 |
478 | 2022-09-20 11:02:21 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
477 | 2022-07-29 09:01:23 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
476 | 2022-04-30 18:11:16 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
475 | 2022-01-15 11:11:44 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
474 | 2021-11-11 08:35:43 | spook | 1 | 28756 | 11 | 0.513 | 56054.6 |
473 | 2021-11-09 07:21:59 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
472 | 2021-09-26 19:40:29 | spook | 1 | 28756 | 11 | 0.610 | 47141.0 |
471 | 2021-09-24 17:32:49 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
470 | 2021-09-11 03:12:52 | spook | 1 | 28756 | 11 | 0.440 | 65354.5 |
469 | 2021-08-20 21:29:18 | spook | 1 | 28756 | 11 | 0.513 | 56054.6 |
468 | 2021-08-18 17:31:16 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
467 | 2021-07-23 21:40:51 | spook | 1 | 28756 | 11 | 0.486 | 59168.7 |
466 | 2021-05-13 17:27:44 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
465 | 2021-04-12 15:51:00 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
464 | 2021-03-26 14:37:25 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
463 | 2020-12-28 15:40:53 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
462 | 2020-12-19 00:42:59 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
461 | 2020-12-16 15:14:59 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
460 | 2020-12-14 14:36:06 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
459 | 2020-11-18 08:06:29 | spook | 3 | 83667 | 889 | 3.576 | 23396.8 |
458 | 2020-11-13 02:33:44 | spook | 3 | 83667 | 889 | 3.280 | 25508.2 |
457 | 2020-11-08 00:38:48 | spook | 1 | 28756 | 11 | 0.486 | 59168.7 |
456 | 2020-11-07 03:00:50 | spook | 1 | 28756 | 11 | 0.466 | 61708.2 |
455 | 2020-11-03 03:16:15 | spook | 3 | 83667 | 889 | 3.796 | 22040.8 |
454 | 2020-10-31 02:59:49 | spook | 1 | 28756 | 11 | 1.033 | 27837.4 |
453 | 2020-10-27 14:56:17 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
452 | 2020-10-18 04:13:55 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
451 | 2020-10-13 14:43:40 | spook | 1 | 28756 | 11 | 0.470 | 61183.0 |
450 | 2020-09-04 08:08:54 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
449 | 2020-08-23 14:28:15 | spook | 3 | 83667 | 889 | 3.593 | 23286.1 |
448 | 2020-08-19 12:39:36 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
447 | 2020-07-27 12:14:12 | spook | 1 | 28756 | 11 | 0.516 | 55728.7 |
446 | 2020-05-30 08:41:58 | spook | 1 | 28756 | 11 | 0.470 | 61183.0 |
445 | 2020-05-17 01:34:26 | spook | 3 | 83667 | 889 | 3.516 | 23796.1 |
444 | 2020-04-09 03:31:49 | spook | 3 | 83667 | 889 | 3.330 | 25125.2 |
443 | 2020-03-26 03:33:33 | spook | 3 | 83667 | 889 | 3.936 | 21256.9 |
442 | 2020-03-26 00:20:30 | spook | 1 | 28756 | 11 | 0.516 | 55728.7 |
441 | 2020-03-25 19:23:26 | spook | 3 | 83667 | 889 | 3.783 | 22116.6 |
440 | 2020-03-25 15:25:47 | spook | 3 | 83667 | 889 | 4.080 | 20506.6 |
439 | 2020-03-24 19:10:03 | spook | 1 | 28756 | 11 | 0.763 | 37688.1 |
438 | 2020-03-23 19:19:21 | spook | 1 | 28756 | 11 | 1.126 | 25538.2 |
437 | 2020-03-22 16:53:57 | spook | 1 | 28756 | 11 | 0.436 | 65954.1 |
436 | 2020-03-22 02:59:04 | spook | 1 | 28756 | 11 | 0.546 | 52666.7 |
435 | 2020-03-18 16:00:28 | spook | 1 | 28756 | 11 | 0.500 | 57512.0 |
434 | 2020-03-07 19:30:57 | spook | 1 | 28756 | 11 | 0.453 | 63479.0 |
433 | 2020-03-05 17:14:17 | spook | 3 | 83667 | 889 | 4.330 | 19322.6 |
432 | 2020-02-28 12:08:50 | spook | 3 | 83667 | 889 | 3.483 | 24021.5 |
431 | 2020-02-27 04:32:22 | spook | 3 | 83667 | 889 | 5.140 | 16277.6 |
430 | 2020-02-27 03:01:37 | spook | 1 | 28756 | 11 | 1.106 | 26000.0 |
429 | 2020-02-27 01:35:50 | spook | 3 | 83667 | 889 | 7.563 | 11062.7 |
428 | 2020-02-27 00:08:24 | spook | 1 | 28756 | 11 | 0.516 | 55728.7 |
427 | 2020-02-24 19:18:24 | spook | 1 | 28756 | 11 | 1.093 | 26309.2 |
426 | 2020-02-24 18:29:30 | spook | 1 | 28756 | 11 | 0.530 | 54256.6 |
425 | 2020-02-24 10:23:30 | spook | 3 | 83667 | 889 | 4.393 | 19045.5 |
424 | 2020-02-23 12:06:31 | spook | 3 | 83667 | 889 | 4.593 | 18216.2 |
423 | 2020-02-18 18:35:44 | spook | 3 | 83667 | 889 | 5.310 | 15756.5 |
422 | 2020-02-18 17:41:14 | spook | 3 | 83667 | 889 | 4.156 | 20131.6 |
421 | 2020-02-17 19:15:08 | spook | 1 | 28756 | 11 | 0.560 | 51350.0 |
420 | 2020-02-17 16:22:16 | spook | 3 | 83667 | 889 | 7.906 | 10582.7 |
419 | 2020-02-12 15:00:16 | spook | 1 | 28756 | 11 | 1.153 | 24940.2 |
418 | 2020-02-12 07:18:15 | spook | 3 | 83667 | 889 | 8.576 | 9755.9 |
417 | 2020-02-09 17:32:48 | spook | 3 | 83667 | 889 | 8.953 | 9345.1 |
416 | 2020-02-02 05:47:40 | spook | 1 | 28756 | 11 | 0.563 | 51076.4 |
415 | 2020-01-31 10:28:25 | spook | 1 | 28756 | 11 | 0.546 | 52666.7 |