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 |
| 529 | 2025-11-26 06:24:36 | legislator | 3 | 140603 | 18 | 6.626 | 21219.9 |
| 528 | 2025-11-08 22:10:14 | legislator | 3 | 140603 | 18 | 5.643 | 24916.4 |
| 527 | 2025-10-15 07:23:27 | legislator | 2 | 108824 | 7 | 3.016 | 36082.2 |
| 526 | 2025-10-04 10:19:38 | legislator | 3 | 140603 | 18 | 5.533 | 25411.7 |
| 525 | 2025-09-21 05:39:33 | legislator | 1 | 67641 | 2 | 1.016 | 66575.8 |
| 524 | 2025-09-18 02:20:01 | legislator | 3 | 140603 | 18 | 6.373 | 22062.3 |
| 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 |