History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"legislator"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
523 | 2025-09-07 14:28:22 | legislator | 1 | 67641 | 2 | 1.170 | 57812.8 |
522 | 2025-08-31 06:23:22 | legislator | 1 | 67641 | 2 | 1.173 | 57665.0 |
521 | 2025-08-10 09:26:59 | legislator | 1 | 67641 | 2 | 4.000 | 16910.3 |
520 | 2025-08-05 07:18:15 | legislator | 1 | 67641 | 2 | 2.470 | 27385.0 |
519 | 2025-08-01 03:52:02 | legislator | 1 | 67641 | 2 | 2.846 | 23767.0 |
518 | 2025-07-25 07:03:52 | legislator | 1 | 67641 | 2 | 2.783 | 24305.1 |
517 | 2025-07-15 21:33:55 | legislator | 2 | 108824 | 7 | 3.160 | 34438.0 |
516 | 2025-07-11 06:27:24 | legislator | 3 | 140603 | 18 | 23.546 | 5971.4 |
515 | 2025-07-09 12:01:52 | legislator | 4 | 161450 | 78 | 44.520 | 3626.5 |
514 | 2025-07-09 05:08:47 | legislator | 4 | 161450 | 78 | 25.346 | 6369.8 |
513 | 2025-07-05 15:50:10 | legislator | 4 | 161450 | 78 | 56.083 | 2878.8 |
512 | 2025-07-05 06:58:19 | legislator | 2 | 108824 | 7 | 15.346 | 7091.4 |
511 | 2025-07-04 21:29:55 | legislator | 3 | 140603 | 18 | 25.656 | 5480.3 |
510 | 2025-07-03 23:41:23 | legislator | 1 | 67641 | 2 | 1.030 | 65670.9 |
509 | 2025-07-03 16:43:08 | legislator | 3 | 140603 | 18 | 6.576 | 21381.2 |
508 | 2025-06-23 09:03:06 | legislator | 1 | 67641 | 2 | 5.546 | 12196.4 |
507 | 2025-06-22 16:54:55 | legislator | 1 | 67641 | 2 | 5.156 | 13118.9 |
506 | 2025-06-21 19:52:06 | legislator | 1 | 67641 | 2 | 5.800 | 11662.2 |
505 | 2025-06-19 02:12:10 | legislator | 1 | 67641 | 2 | 1.046 | 64666.3 |
504 | 2025-06-12 02:44:56 | legislator | 1 | 67641 | 2 | 5.343 | 12659.7 |
503 | 2025-06-10 01:41:19 | legislator | 1 | 67641 | 2 | 5.783 | 11696.5 |
502 | 2025-06-08 10:53:34 | legislator | 3 | 140603 | 18 | 20.546 | 6843.3 |
501 | 2025-06-04 03:36:42 | legislator | 3 | 140603 | 18 | 33.893 | 4148.4 |
500 | 2025-05-31 15:03:03 | legislator | 3 | 140603 | 18 | 28.740 | 4892.2 |
499 | 2025-05-30 21:22:27 | legislator | 3 | 140603 | 18 | 30.796 | 4565.6 |
498 | 2025-05-29 23:15:36 | legislator | 1 | 67641 | 2 | 1.173 | 57665.0 |
497 | 2025-05-29 09:26:30 | legislator | 1 | 67641 | 2 | 3.766 | 17961.0 |
496 | 2025-05-28 14:14:36 | legislator | 3 | 140603 | 18 | 5.546 | 25352.1 |
495 | 2025-05-25 08:58:25 | legislator | 1 | 67641 | 2 | 4.720 | 14330.7 |
494 | 2025-05-18 16:35:51 | legislator | 1 | 67641 | 2 | 3.986 | 16969.6 |
493 | 2025-05-08 23:06:09 | legislator | 1 | 67641 | 2 | 5.140 | 13159.7 |
492 | 2025-04-08 23:52:36 | legislator | 1 | 67641 | 2 | 4.096 | 16513.9 |
491 | 2025-03-25 18:49:11 | legislator | 1 | 67641 | 2 | 4.530 | 14931.8 |
490 | 2025-03-24 07:09:27 | legislator | 3 | 140603 | 18 | 22.253 | 6318.4 |
489 | 2025-03-23 04:05:39 | legislator | 1 | 67641 | 2 | 2.906 | 23276.3 |
488 | 2025-03-20 11:32:53 | legislator | 1 | 67641 | 2 | 2.250 | 30062.7 |
487 | 2025-03-14 13:23:49 | legislator | 3 | 140603 | 18 | 5.593 | 25139.1 |
486 | 2025-03-10 17:19:09 | legislator | 1 | 67641 | 2 | 6.296 | 10743.5 |
485 | 2025-02-21 13:06:50 | legislator | 3 | 140603 | 18 | 40.563 | 3466.3 |
484 | 2025-02-21 13:06:46 | legislator | 2 | 108824 | 7 | 13.200 | 8244.2 |
483 | 2025-02-19 18:44:01 | legislator | 3 | 140603 | 18 | 33.783 | 4161.9 |
482 | 2025-02-19 18:43:57 | legislator | 2 | 108824 | 7 | 13.986 | 7780.9 |
481 | 2025-02-13 12:43:10 | legislator | 4 | 161450 | 78 | 61.443 | 2627.6 |
480 | 2025-02-09 06:43:05 | legislator | 3 | 140603 | 18 | 19.656 | 7153.2 |
479 | 2025-02-09 00:28:46 | legislator | 3 | 140603 | 18 | 34.643 | 4058.6 |
478 | 2025-02-09 00:28:41 | legislator | 3 | 140603 | 18 | 27.906 | 5038.5 |
477 | 2025-02-09 00:28:38 | legislator | 2 | 108824 | 7 | 22.613 | 4812.5 |
476 | 2025-02-08 22:27:49 | legislator | 4 | 161450 | 78 | 68.643 | 2352.0 |
475 | 2025-02-08 22:27:07 | legislator | 4 | 161450 | 78 | 72.066 | 2240.3 |
474 | 2025-02-08 22:27:47 | legislator | 3 | 140603 | 18 | 30.016 | 4684.3 |
473 | 2025-02-08 22:27:43 | legislator | 2 | 108824 | 7 | 11.796 | 9225.5 |
472 | 2025-02-08 22:24:27 | legislator | 1 | 67641 | 2 | 3.673 | 18415.7 |
471 | 2025-01-18 13:28:19 | legislator | 4 | 161450 | 78 | 80.550 | 2004.3 |
470 | 2025-01-15 18:25:53 | legislator | 4 | 161450 | 78 | 73.800 | 2187.7 |
469 | 2025-01-15 18:25:52 | legislator | 2 | 108824 | 7 | 7.486 | 14537.0 |
468 | 2025-01-15 18:25:25 | legislator | 1 | 67641 | 2 | 3.876 | 17451.2 |
467 | 2025-01-15 17:52:05 | legislator | 3 | 140603 | 18 | 25.316 | 5553.9 |
466 | 2025-01-13 22:16:13 | legislator | 4 | 161450 | 78 | 59.786 | 2700.5 |
465 | 2025-01-13 22:16:21 | legislator | 2 | 108824 | 7 | 17.530 | 6207.9 |
464 | 2025-01-13 22:16:15 | legislator | 3 | 140603 | 18 | 22.783 | 6171.4 |
463 | 2025-01-13 22:15:54 | legislator | 1 | 67641 | 2 | 2.796 | 24192.1 |
462 | 2025-01-09 12:15:07 | legislator | 4 | 161450 | 78 | 50.520 | 3195.8 |
461 | 2025-01-09 00:07:05 | legislator | 4 | 161450 | 78 | 53.970 | 2991.5 |
460 | 2025-01-09 00:06:57 | legislator | 4 | 161450 | 78 | 57.176 | 2823.7 |
459 | 2025-01-09 00:07:04 | legislator | 2 | 108824 | 7 | 14.343 | 7587.3 |
458 | 2025-01-09 00:04:19 | legislator | 1 | 67641 | 2 | 4.686 | 14434.7 |
457 | 2025-01-08 06:27:56 | legislator | 4 | 161450 | 78 | 46.923 | 3440.7 |
456 | 2025-01-07 16:08:07 | legislator | 4 | 161450 | 78 | 11.546 | 13983.2 |
455 | 2024-12-25 19:41:11 | legislator | 3 | 140603 | 18 | 29.140 | 4825.1 |
454 | 2024-12-25 19:41:10 | legislator | 2 | 108824 | 7 | 15.203 | 7158.1 |
453 | 2024-12-14 18:46:07 | legislator | 3 | 140603 | 18 | 31.566 | 4454.3 |
452 | 2024-12-14 18:46:06 | legislator | 3 | 140603 | 18 | 30.580 | 4597.9 |
451 | 2024-12-14 18:46:09 | legislator | 2 | 108824 | 7 | 19.706 | 5522.4 |
450 | 2024-12-14 18:45:47 | legislator | 1 | 67641 | 2 | 3.140 | 21541.7 |
449 | 2024-12-14 18:10:18 | legislator | 3 | 140603 | 18 | 32.253 | 4359.4 |
448 | 2024-12-14 18:09:55 | legislator | 4 | 161450 | 78 | 52.753 | 3060.5 |
447 | 2024-12-14 18:10:18 | legislator | 2 | 108824 | 7 | 15.063 | 7224.6 |
446 | 2024-12-14 18:09:37 | legislator | 1 | 67641 | 2 | 3.313 | 20416.8 |
445 | 2024-12-03 16:31:29 | legislator | 4 | 161450 | 78 | 58.333 | 2767.7 |
444 | 2024-12-02 21:33:50 | legislator | 4 | 161450 | 78 | 73.926 | 2183.9 |
443 | 2024-12-02 10:34:15 | legislator | 4 | 161450 | 78 | 51.940 | 3108.4 |
442 | 2024-12-02 10:34:08 | legislator | 4 | 161450 | 78 | 50.033 | 3226.9 |
441 | 2024-12-02 10:32:42 | legislator | 1 | 67641 | 2 | 2.686 | 25182.8 |
440 | 2024-11-25 19:56:39 | legislator | 1 | 67641 | 2 | 6.156 | 10987.8 |
439 | 2024-11-13 13:14:08 | legislator | 2 | 108824 | 7 | 18.750 | 5803.9 |
438 | 2024-11-11 02:11:36 | legislator | 3 | 140603 | 18 | 27.363 | 5138.4 |
437 | 2024-11-10 05:55:48 | legislator | 3 | 140603 | 18 | 36.783 | 3822.5 |
436 | 2024-11-10 05:55:50 | legislator | 2 | 108824 | 7 | 15.296 | 7114.5 |
435 | 2024-11-09 20:11:45 | legislator | 1 | 67641 | 2 | 1.236 | 54725.7 |
434 | 2024-10-20 05:26:02 | legislator | 3 | 140603 | 18 | 30.046 | 4679.6 |
433 | 2024-10-16 02:11:51 | legislator | 3 | 140603 | 18 | 27.250 | 5159.7 |
432 | 2024-10-16 02:11:52 | legislator | 2 | 108824 | 7 | 10.186 | 10683.7 |
431 | 2024-10-16 02:11:20 | legislator | 3 | 140603 | 18 | 38.520 | 3650.1 |
430 | 2024-10-16 02:06:19 | legislator | 1 | 67641 | 2 | 5.156 | 13118.9 |
429 | 2024-10-14 14:54:00 | legislator | 3 | 140603 | 18 | 32.330 | 4349.0 |
428 | 2024-10-12 22:51:59 | legislator | 3 | 140603 | 18 | 31.650 | 4442.4 |
427 | 2024-10-10 18:05:45 | legislator | 4 | 161450 | 78 | 46.706 | 3456.7 |
426 | 2024-10-10 18:05:28 | legislator | 4 | 161450 | 78 | 53.630 | 3010.4 |
425 | 2024-10-10 18:05:50 | legislator | 3 | 140603 | 18 | 31.203 | 4506.1 |
424 | 2024-10-10 18:05:48 | legislator | 2 | 108824 | 7 | 15.190 | 7164.2 |