History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"resident"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
517 | 2025-09-08 04:44:07 | resident | 1 | 82945 | 3 | 1.516 | 54713.1 |
516 | 2025-09-08 01:28:20 | resident | 3 | 146162 | 168 | 7.843 | 18636.0 |
515 | 2025-09-06 04:47:21 | resident | 1 | 82945 | 3 | 1.500 | 55296.7 |
514 | 2025-08-29 14:35:19 | resident | 1 | 82945 | 3 | 1.500 | 55296.7 |
513 | 2025-08-27 08:04:21 | resident | 1 | 82945 | 3 | 1.560 | 53169.9 |
512 | 2025-08-26 00:06:20 | resident | 3 | 146162 | 168 | 37.690 | 3878.0 |
511 | 2025-08-25 12:32:03 | resident | 1 | 82945 | 3 | 5.780 | 14350.3 |
510 | 2025-08-24 12:57:05 | resident | 3 | 146162 | 168 | 39.300 | 3719.1 |
509 | 2025-08-23 15:54:12 | resident | 3 | 146162 | 168 | 34.893 | 4188.9 |
508 | 2025-08-19 09:21:16 | resident | 3 | 146162 | 168 | 20.190 | 7239.3 |
507 | 2025-08-17 08:26:46 | resident | 3 | 146162 | 168 | 21.780 | 6710.8 |
506 | 2025-08-15 09:16:25 | resident | 3 | 146162 | 168 | 22.046 | 6629.9 |
505 | 2025-08-13 03:47:57 | resident | 3 | 146162 | 168 | 12.846 | 11378.0 |
504 | 2025-08-06 18:35:18 | resident | 1 | 82945 | 3 | 7.013 | 11827.3 |
503 | 2025-08-05 13:59:11 | resident | 1 | 82945 | 3 | 3.466 | 23931.0 |
502 | 2025-08-03 23:13:29 | resident | 1 | 82945 | 3 | 3.420 | 24252.9 |
501 | 2025-07-31 23:23:06 | resident | 1 | 82945 | 3 | 6.516 | 12729.4 |
500 | 2025-07-25 04:03:44 | resident | 1 | 82945 | 3 | 7.486 | 11080.0 |
499 | 2025-07-24 22:44:18 | resident | 1 | 82945 | 3 | 4.706 | 17625.4 |
498 | 2025-07-24 22:43:42 | resident | 1 | 82945 | 3 | 4.500 | 18432.2 |
497 | 2025-07-24 17:13:10 | resident | 1 | 82945 | 3 | 7.126 | 11639.8 |
496 | 2025-07-24 05:01:58 | resident | 1 | 82945 | 3 | 6.033 | 13748.5 |
495 | 2025-07-24 02:19:44 | resident | 1 | 82945 | 3 | 4.016 | 20653.6 |
494 | 2025-07-23 18:28:38 | resident | 1 | 82945 | 3 | 8.280 | 10017.5 |
493 | 2025-07-23 15:39:37 | resident | 1 | 82945 | 3 | 7.356 | 11275.8 |
492 | 2025-07-23 04:37:28 | resident | 1 | 82945 | 3 | 6.453 | 12853.7 |
491 | 2025-07-23 01:12:23 | resident | 1 | 82945 | 3 | 3.530 | 23497.2 |
490 | 2025-07-22 15:49:39 | resident | 1 | 82945 | 3 | 4.343 | 19098.5 |
489 | 2025-07-22 12:55:25 | resident | 3 | 146162 | 168 | 30.173 | 4844.1 |
488 | 2025-07-18 01:29:50 | resident | 2 | 121059 | 23 | 14.920 | 8113.9 |
487 | 2025-07-16 22:49:03 | resident | 2 | 121059 | 23 | 9.046 | 13382.6 |
486 | 2025-07-15 18:25:52 | resident | 3 | 146162 | 168 | 8.016 | 18233.8 |
485 | 2025-07-14 00:34:09 | resident | 2 | 121059 | 23 | 9.673 | 12515.1 |
484 | 2025-07-12 04:02:16 | resident | 1 | 82945 | 3 | 1.560 | 53169.9 |
483 | 2025-07-07 22:10:59 | resident | 3 | 146162 | 168 | 36.503 | 4004.1 |
482 | 2025-07-05 14:03:19 | resident | 2 | 121059 | 23 | 20.516 | 5900.7 |
481 | 2025-07-05 13:34:27 | resident | 1 | 82945 | 3 | 8.313 | 9977.7 |
480 | 2025-07-04 08:55:42 | resident | 1 | 82945 | 3 | 1.483 | 55930.5 |
479 | 2025-07-03 17:26:05 | resident | 1 | 82945 | 3 | 1.466 | 56579.1 |
478 | 2025-07-01 08:23:57 | resident | 3 | 146162 | 168 | 7.626 | 19166.3 |
477 | 2025-06-30 18:15:59 | resident | 2 | 121059 | 23 | 20.513 | 5901.6 |
476 | 2025-06-26 16:44:13 | resident | 3 | 146162 | 168 | 26.673 | 5479.8 |
475 | 2025-06-24 08:47:42 | resident | 3 | 146162 | 168 | 26.986 | 5416.2 |
474 | 2025-06-23 15:06:34 | resident | 2 | 121059 | 23 | 3.436 | 35232.5 |
473 | 2025-06-23 01:04:33 | resident | 3 | 146162 | 168 | 33.693 | 4338.1 |
472 | 2025-06-22 04:35:22 | resident | 1 | 82945 | 3 | 4.436 | 18698.2 |
471 | 2025-06-16 16:55:42 | resident | 1 | 82945 | 3 | 6.953 | 11929.4 |
470 | 2025-06-13 23:47:26 | resident | 1 | 82945 | 3 | 7.220 | 11488.2 |
469 | 2025-06-13 11:36:25 | resident | 1 | 82945 | 3 | 1.953 | 42470.6 |
468 | 2025-06-11 10:37:22 | resident | 1 | 82945 | 3 | 6.576 | 12613.3 |
467 | 2025-06-08 11:57:08 | resident | 1 | 82945 | 3 | 7.500 | 11059.3 |
466 | 2025-06-04 08:07:12 | resident | 1 | 82945 | 3 | 8.546 | 9705.7 |
465 | 2025-05-31 14:26:04 | resident | 1 | 82945 | 3 | 4.153 | 19972.3 |
464 | 2025-05-01 12:23:40 | resident | 1 | 82945 | 3 | 7.890 | 10512.7 |
463 | 2025-04-30 08:26:35 | resident | 1 | 82945 | 3 | 6.046 | 13719.0 |
462 | 2025-04-27 00:35:25 | resident | 1 | 82945 | 3 | 1.563 | 53067.8 |
461 | 2025-04-25 11:41:22 | resident | 1 | 82945 | 3 | 7.706 | 10763.7 |
460 | 2025-04-23 18:17:47 | resident | 2 | 121059 | 23 | 3.766 | 32145.2 |
459 | 2025-04-22 03:14:58 | resident | 1 | 82945 | 3 | 2.703 | 30686.3 |
458 | 2025-04-10 09:36:10 | resident | 1 | 82945 | 3 | 1.310 | 63316.8 |
457 | 2025-04-09 16:31:22 | resident | 1 | 82945 | 3 | 7.110 | 11666.0 |
456 | 2025-04-06 01:16:42 | resident | 1 | 82945 | 3 | 13.690 | 6058.8 |
455 | 2025-04-03 08:42:20 | resident | 3 | 146162 | 168 | 39.440 | 3705.9 |
454 | 2025-04-02 13:24:21 | resident | 3 | 146162 | 168 | 45.110 | 3240.1 |
453 | 2025-03-31 10:46:51 | resident | 3 | 146162 | 168 | 41.826 | 3494.5 |
452 | 2025-03-29 16:14:37 | resident | 2 | 121059 | 23 | 9.016 | 13427.1 |
451 | 2025-03-29 02:25:33 | resident | 3 | 146162 | 168 | 29.796 | 4905.4 |
450 | 2025-03-28 09:05:36 | resident | 1 | 82945 | 3 | 1.450 | 57203.4 |
449 | 2025-03-25 14:25:18 | resident | 1 | 82945 | 3 | 6.783 | 12228.4 |
448 | 2025-03-20 04:10:04 | resident | 1 | 82945 | 3 | 7.436 | 11154.5 |
447 | 2025-03-13 12:55:53 | resident | 1 | 82945 | 3 | 7.126 | 11639.8 |
446 | 2025-03-13 11:22:39 | resident | 1 | 82945 | 3 | 5.830 | 14227.3 |
445 | 2025-03-05 20:33:19 | resident | 2 | 121059 | 23 | 22.733 | 5325.3 |
444 | 2025-03-01 16:36:24 | resident | 1 | 82945 | 3 | 3.783 | 21925.7 |
443 | 2025-02-25 02:39:30 | resident | 1 | 82945 | 3 | 5.140 | 16137.2 |
442 | 2025-02-25 02:39:19 | resident | 2 | 121059 | 23 | 14.483 | 8358.7 |
441 | 2025-02-24 12:51:53 | resident | 1 | 82945 | 3 | 10.030 | 8269.7 |
440 | 2025-02-24 12:51:17 | resident | 2 | 121059 | 23 | 19.796 | 6115.3 |
439 | 2025-02-19 09:30:48 | resident | 3 | 146162 | 168 | 37.406 | 3907.4 |
438 | 2025-02-18 04:23:56 | resident | 3 | 146162 | 168 | 32.050 | 4560.4 |
437 | 2025-02-17 01:54:12 | resident | 3 | 146162 | 168 | 51.006 | 2865.6 |
436 | 2025-02-15 17:39:04 | resident | 3 | 146162 | 168 | 29.736 | 4915.3 |
435 | 2025-02-11 08:54:25 | resident | 3 | 146162 | 168 | 19.706 | 7417.1 |
434 | 2025-01-31 06:54:43 | resident | 2 | 121059 | 23 | 19.640 | 6163.9 |
433 | 2025-01-25 01:31:25 | resident | 1 | 82945 | 3 | 9.063 | 9152.0 |
432 | 2025-01-23 10:22:42 | resident | 1 | 82945 | 3 | 11.126 | 7455.1 |
431 | 2025-01-19 15:43:16 | resident | 1 | 82945 | 3 | 10.703 | 7749.7 |
430 | 2025-01-18 07:16:57 | resident | 3 | 146162 | 168 | 41.673 | 3507.4 |
429 | 2025-01-18 07:16:56 | resident | 2 | 121059 | 23 | 10.063 | 12030.1 |
428 | 2025-01-17 10:43:26 | resident | 3 | 146162 | 168 | 46.236 | 3161.2 |
427 | 2025-01-17 10:43:37 | resident | 2 | 121059 | 23 | 11.643 | 10397.6 |
426 | 2025-01-16 07:04:51 | resident | 3 | 146162 | 168 | 56.660 | 2579.6 |
425 | 2025-01-15 08:46:59 | resident | 3 | 146162 | 168 | 25.016 | 5842.7 |
424 | 2025-01-15 08:46:59 | resident | 2 | 121059 | 23 | 24.093 | 5024.7 |
423 | 2025-01-15 08:46:55 | resident | 1 | 82945 | 3 | 6.920 | 11986.3 |
422 | 2024-12-26 02:49:40 | resident | 1 | 82945 | 3 | 4.110 | 20181.3 |
421 | 2024-12-19 22:58:40 | resident | 1 | 82945 | 3 | 1.296 | 64000.8 |
420 | 2024-12-15 20:19:15 | resident | 1 | 82945 | 3 | 6.983 | 11878.1 |
419 | 2024-11-26 13:12:51 | resident | 2 | 121059 | 23 | 6.453 | 18760.1 |
418 | 2024-11-26 08:05:10 | resident | 3 | 146162 | 168 | 31.846 | 4589.7 |