History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfield"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
532 | 2025-08-26 05:19:18 | subfield | 1 | 82945 | 2 | 1.466 | 56579.1 |
531 | 2025-08-17 06:10:57 | subfield | 1 | 82945 | 2 | 3.646 | 22749.6 |
530 | 2025-08-17 03:34:29 | subfield | 1 | 82945 | 2 | 3.640 | 22787.1 |
529 | 2025-08-13 18:27:29 | subfield | 1 | 82945 | 2 | 7.626 | 10876.6 |
528 | 2025-08-12 21:58:29 | subfield | 1 | 82945 | 2 | 7.030 | 11798.7 |
527 | 2025-08-09 11:32:33 | subfield | 1 | 82945 | 2 | 5.110 | 16231.9 |
526 | 2025-08-05 03:34:09 | subfield | 2 | 121059 | 6 | 8.250 | 14673.8 |
525 | 2025-08-04 05:23:38 | subfield | 1 | 82945 | 2 | 3.563 | 23279.5 |
524 | 2025-08-03 05:29:44 | subfield | 1 | 82945 | 2 | 2.876 | 28840.4 |
523 | 2025-08-02 02:04:59 | subfield | 1 | 82945 | 2 | 3.343 | 24811.5 |
522 | 2025-07-24 11:52:43 | subfield | 1 | 82945 | 2 | 5.970 | 13893.6 |
521 | 2025-07-24 02:25:12 | subfield | 1 | 82945 | 2 | 7.893 | 10508.7 |
520 | 2025-07-17 19:15:47 | subfield | 1 | 82945 | 2 | 5.046 | 16437.8 |
519 | 2025-07-17 09:02:34 | subfield | 1 | 82945 | 2 | 3.843 | 21583.4 |
518 | 2025-07-08 14:29:11 | subfield | 1 | 82945 | 2 | 3.640 | 22787.1 |
517 | 2025-07-07 03:38:41 | subfield | 1 | 82945 | 2 | 6.686 | 12405.8 |
516 | 2025-06-26 11:28:56 | subfield | 1 | 82945 | 2 | 7.063 | 11743.6 |
515 | 2025-06-16 07:48:30 | subfield | 1 | 82945 | 2 | 6.376 | 13008.9 |
514 | 2025-06-10 23:55:27 | subfield | 3 | 146162 | 48 | 7.546 | 19369.5 |
513 | 2025-06-10 21:25:38 | subfield | 2 | 121059 | 6 | 21.266 | 5692.6 |
512 | 2025-06-05 03:46:52 | subfield | 1 | 82945 | 2 | 7.326 | 11322.0 |
511 | 2025-06-04 09:17:23 | subfield | 1 | 82945 | 2 | 6.423 | 12913.7 |
510 | 2025-05-26 11:12:50 | subfield | 1 | 82945 | 2 | 8.266 | 10034.5 |
509 | 2025-05-17 03:08:45 | subfield | 2 | 121059 | 6 | 17.050 | 7100.2 |
508 | 2025-05-15 08:08:01 | subfield | 1 | 82945 | 2 | 1.470 | 56425.2 |
507 | 2025-05-14 08:45:45 | subfield | 2 | 121059 | 6 | 21.033 | 5755.7 |
506 | 2025-05-13 22:02:15 | subfield | 3 | 146162 | 48 | 39.286 | 3720.5 |
505 | 2025-05-13 04:02:39 | subfield | 3 | 146162 | 48 | 18.876 | 7743.3 |
504 | 2025-05-08 14:09:50 | subfield | 1 | 82945 | 2 | 4.890 | 16962.2 |
503 | 2025-05-04 14:50:44 | subfield | 2 | 121059 | 6 | 35.423 | 3417.5 |
502 | 2025-05-04 10:29:24 | subfield | 4 | 161609 | 543 | 49.003 | 3297.9 |
501 | 2025-05-02 19:15:55 | subfield | 3 | 146162 | 48 | 7.283 | 20068.9 |
500 | 2025-05-02 00:23:04 | subfield | 1 | 82945 | 2 | 6.903 | 12015.8 |
499 | 2025-05-01 20:30:46 | subfield | 3 | 146162 | 48 | 43.470 | 3362.4 |
498 | 2025-04-30 21:42:51 | subfield | 3 | 146162 | 48 | 38.223 | 3823.9 |
497 | 2025-04-30 08:45:56 | subfield | 1 | 82945 | 2 | 8.796 | 9429.9 |
496 | 2025-04-30 03:55:13 | subfield | 3 | 146162 | 48 | 28.126 | 5196.7 |
495 | 2025-04-29 05:29:06 | subfield | 3 | 146162 | 48 | 36.280 | 4028.7 |
494 | 2025-04-27 23:24:44 | subfield | 3 | 146162 | 48 | 36.423 | 4012.9 |
493 | 2025-04-26 07:21:19 | subfield | 3 | 146162 | 48 | 37.906 | 3855.9 |
492 | 2025-04-25 21:03:44 | subfield | 4 | 161609 | 543 | 71.333 | 2265.6 |
491 | 2025-04-25 10:50:00 | subfield | 1 | 82945 | 2 | 6.923 | 11981.1 |
490 | 2025-04-14 07:34:46 | subfield | 1 | 82945 | 2 | 6.580 | 12605.6 |
489 | 2025-03-31 16:35:43 | subfield | 1 | 82945 | 2 | 10.546 | 7865.1 |
488 | 2025-03-27 10:55:08 | subfield | 1 | 82945 | 2 | 6.203 | 13371.8 |
487 | 2025-03-20 13:14:00 | subfield | 1 | 82945 | 2 | 6.093 | 13613.2 |
486 | 2025-03-11 15:32:45 | subfield | 1 | 82945 | 2 | 4.686 | 17700.6 |
485 | 2025-03-03 19:44:42 | subfield | 1 | 82945 | 2 | 6.563 | 12638.3 |
484 | 2025-02-03 22:35:15 | subfield | 1 | 82945 | 2 | 5.296 | 15661.8 |
483 | 2025-02-01 10:09:10 | subfield | 2 | 121059 | 6 | 18.966 | 6382.9 |
482 | 2025-01-29 18:48:09 | subfield | 4 | 161609 | 543 | 20.593 | 7847.8 |
481 | 2025-01-29 15:33:46 | subfield | 4 | 161609 | 543 | 51.643 | 3129.3 |
480 | 2025-01-29 02:32:58 | subfield | 4 | 161609 | 543 | 78.036 | 2071.0 |
479 | 2025-01-28 23:56:05 | subfield | 4 | 161609 | 543 | 52.050 | 3104.9 |
478 | 2025-01-28 23:56:04 | subfield | 2 | 121059 | 6 | 18.063 | 6702.0 |
477 | 2025-01-28 23:55:48 | subfield | 1 | 82945 | 2 | 7.466 | 11109.7 |
476 | 2025-01-25 02:40:15 | subfield | 1 | 82945 | 2 | 3.813 | 21753.2 |
475 | 2025-01-04 18:51:20 | subfield | 3 | 146162 | 48 | 6.406 | 22816.4 |
474 | 2024-12-29 15:57:39 | subfield | 3 | 146162 | 48 | 32.266 | 4529.9 |
473 | 2024-12-28 21:03:39 | subfield | 2 | 121059 | 6 | 3.640 | 33258.0 |
472 | 2024-12-28 21:03:34 | subfield | 1 | 82945 | 2 | 1.420 | 58412.0 |
471 | 2024-12-28 20:05:37 | subfield | 4 | 161609 | 543 | 77.803 | 2077.2 |
470 | 2024-12-28 16:27:28 | subfield | 4 | 161609 | 543 | 58.646 | 2755.7 |
469 | 2024-12-28 15:40:45 | subfield | 4 | 161609 | 543 | 31.270 | 5168.2 |
468 | 2024-12-28 15:40:49 | subfield | 2 | 121059 | 6 | 8.953 | 13521.6 |
467 | 2024-12-28 15:25:10 | subfield | 3 | 146162 | 48 | 6.373 | 22934.6 |
466 | 2024-12-27 21:32:42 | subfield | 3 | 146162 | 48 | 35.050 | 4170.1 |
465 | 2024-12-27 21:32:43 | subfield | 3 | 146162 | 48 | 30.846 | 4738.4 |
464 | 2024-12-27 21:32:44 | subfield | 2 | 121059 | 6 | 10.143 | 11935.2 |
463 | 2024-12-27 21:32:29 | subfield | 1 | 82945 | 2 | 9.453 | 8774.5 |
462 | 2024-12-24 22:22:09 | subfield | 1 | 82945 | 2 | 6.830 | 12144.2 |
461 | 2024-12-21 09:54:33 | subfield | 2 | 121059 | 6 | 3.716 | 32577.8 |
460 | 2024-12-21 09:54:25 | subfield | 1 | 82945 | 2 | 1.440 | 57600.7 |
459 | 2024-12-05 17:32:06 | subfield | 3 | 146162 | 48 | 30.563 | 4782.3 |
458 | 2024-11-29 22:40:24 | subfield | 3 | 146162 | 48 | 46.363 | 3152.6 |
457 | 2024-11-29 14:51:00 | subfield | 3 | 146162 | 48 | 44.626 | 3275.3 |
456 | 2024-11-27 22:46:41 | subfield | 2 | 121059 | 6 | 16.846 | 7186.2 |
455 | 2024-11-27 22:28:37 | subfield | 3 | 146162 | 48 | 8.063 | 18127.5 |
454 | 2024-11-27 18:38:52 | subfield | 3 | 146162 | 48 | 8.300 | 17609.9 |
453 | 2024-11-27 18:38:53 | subfield | 2 | 121059 | 6 | 4.560 | 26548.0 |
452 | 2024-11-27 18:38:51 | subfield | 1 | 82945 | 2 | 1.580 | 52496.8 |
451 | 2024-11-27 05:47:19 | subfield | 4 | 161609 | 543 | 48.613 | 3324.4 |
450 | 2024-11-27 05:09:48 | subfield | 4 | 161609 | 543 | 57.243 | 2823.2 |
449 | 2024-11-27 03:46:49 | subfield | 4 | 161609 | 543 | 87.460 | 1847.8 |
448 | 2024-11-27 02:55:27 | subfield | 4 | 161609 | 543 | 64.376 | 2510.4 |
447 | 2024-11-22 10:32:51 | subfield | 4 | 161609 | 543 | 64.346 | 2511.6 |
446 | 2024-11-19 03:13:28 | subfield | 1 | 82945 | 2 | 4.966 | 16702.6 |
445 | 2024-11-17 18:44:32 | subfield | 1 | 82945 | 2 | 3.376 | 24569.0 |
444 | 2024-11-10 05:56:32 | subfield | 1 | 82945 | 2 | 10.283 | 8066.2 |
443 | 2024-11-02 11:55:32 | subfield | 2 | 121059 | 6 | 14.780 | 8190.7 |
442 | 2024-10-30 15:54:46 | subfield | 3 | 146162 | 48 | 7.406 | 19735.6 |
441 | 2024-10-29 16:52:05 | subfield | 3 | 146162 | 48 | 47.676 | 3065.7 |
440 | 2024-10-28 03:42:54 | subfield | 4 | 161609 | 543 | 50.846 | 3178.4 |
439 | 2024-10-28 02:10:36 | subfield | 2 | 121059 | 6 | 11.220 | 10789.6 |
438 | 2024-10-28 02:09:35 | subfield | 3 | 146162 | 48 | 9.313 | 15694.4 |
437 | 2024-10-28 01:52:15 | subfield | 4 | 161609 | 543 | 11.263 | 14348.7 |
436 | 2024-10-28 00:46:31 | subfield | 4 | 161609 | 543 | 54.910 | 2943.2 |
435 | 2024-10-28 00:46:33 | subfield | 3 | 146162 | 48 | 24.970 | 5853.5 |
434 | 2024-10-28 00:46:31 | subfield | 2 | 121059 | 6 | 18.486 | 6548.7 |
433 | 2024-10-28 00:45:58 | subfield | 1 | 82945 | 2 | 4.283 | 19366.1 |