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 |
363 | 2024-05-05 06:47:15 | legislator | 1 | 67641 | 2 | 1.170 | 57812.8 |
362 | 2024-04-30 19:42:33 | legislator | 1 | 67641 | 2 | 1.186 | 57032.9 |
361 | 2024-04-24 15:41:02 | legislator | 3 | 140603 | 18 | 24.020 | 5853.6 |
360 | 2024-04-24 15:41:00 | legislator | 4 | 161450 | 78 | 13.673 | 11807.9 |
359 | 2024-04-24 15:40:24 | legislator | 2 | 108824 | 7 | 11.813 | 9212.2 |
358 | 2024-04-22 21:56:26 | legislator | 3 | 140603 | 18 | 5.830 | 24117.2 |
357 | 2024-04-22 21:56:17 | legislator | 3 | 140603 | 18 | 5.233 | 26868.5 |
356 | 2024-04-22 00:06:08 | legislator | 4 | 161450 | 78 | 49.580 | 3256.4 |
355 | 2024-04-22 00:06:12 | legislator | 4 | 161450 | 78 | 37.313 | 4326.9 |
354 | 2024-04-22 00:06:11 | legislator | 3 | 140603 | 18 | 30.220 | 4652.6 |
353 | 2024-04-22 00:00:04 | legislator | 1 | 67641 | 2 | 3.453 | 19589.1 |
352 | 2024-04-21 21:22:36 | legislator | 4 | 161450 | 78 | 54.220 | 2977.7 |
351 | 2024-04-21 02:07:36 | legislator | 4 | 161450 | 78 | 54.503 | 2962.2 |
350 | 2024-04-21 02:08:01 | legislator | 2 | 108824 | 7 | 12.170 | 8942.0 |
349 | 2024-04-21 02:07:57 | legislator | 3 | 140603 | 18 | 13.830 | 10166.5 |
348 | 2024-04-21 02:07:17 | legislator | 1 | 67641 | 2 | 4.406 | 15352.0 |
347 | 2024-04-21 02:04:41 | legislator | 4 | 161450 | 78 | 41.690 | 3872.6 |
346 | 2024-04-19 22:53:16 | legislator | 4 | 161450 | 78 | 28.003 | 5765.5 |
345 | 2024-04-19 22:53:22 | legislator | 2 | 108824 | 7 | 8.170 | 13320.0 |
344 | 2024-04-19 22:53:18 | legislator | 3 | 140603 | 18 | 10.576 | 13294.5 |
343 | 2024-04-19 22:52:24 | legislator | 4 | 161450 | 78 | 36.876 | 4378.2 |
342 | 2024-04-19 22:52:01 | legislator | 1 | 67641 | 2 | 2.956 | 22882.6 |
341 | 2024-04-11 18:36:00 | legislator | 2 | 108824 | 7 | 8.986 | 12110.4 |
340 | 2024-03-23 12:10:08 | legislator | 2 | 108824 | 7 | 11.033 | 9863.5 |
339 | 2024-03-21 02:41:23 | legislator | 3 | 140603 | 18 | 17.703 | 7942.3 |
338 | 2024-03-21 02:40:43 | legislator | 2 | 108824 | 7 | 9.110 | 11945.6 |
337 | 2024-03-18 07:00:53 | legislator | 1 | 67641 | 2 | 1.000 | 67641.0 |
336 | 2024-03-16 01:03:39 | legislator | 3 | 140603 | 18 | 13.000 | 10815.6 |
335 | 2024-03-15 02:16:30 | legislator | 3 | 140603 | 18 | 22.220 | 6327.8 |
334 | 2024-03-15 02:16:22 | legislator | 2 | 108824 | 7 | 3.546 | 30689.2 |
333 | 2024-03-15 02:11:19 | legislator | 1 | 67641 | 2 | 1.280 | 52844.5 |
332 | 2024-03-14 18:47:15 | legislator | 4 | 161450 | 78 | 41.846 | 3858.2 |
331 | 2024-03-13 18:58:15 | legislator | 4 | 161450 | 78 | 36.843 | 4382.1 |
330 | 2024-03-13 14:35:07 | legislator | 4 | 161450 | 78 | 37.003 | 4363.2 |
329 | 2024-03-10 19:27:12 | legislator | 4 | 161450 | 78 | 36.176 | 4462.9 |
328 | 2024-03-10 10:06:14 | legislator | 5 | 173545 | 438 | 43.203 | 4017.0 |
327 | 2024-03-10 09:00:46 | legislator | 4 | 161450 | 78 | 22.736 | 7101.1 |
326 | 2024-03-10 01:30:15 | legislator | 4 | 161450 | 78 | 32.546 | 4960.7 |
325 | 2024-03-10 01:30:18 | legislator | 3 | 140603 | 18 | 15.780 | 8910.2 |
324 | 2024-03-10 01:30:18 | legislator | 2 | 108824 | 7 | 6.906 | 15757.9 |
323 | 2024-03-10 01:28:10 | legislator | 3 | 140603 | 18 | 29.343 | 4791.7 |
322 | 2024-03-10 01:28:31 | legislator | 2 | 108824 | 7 | 5.376 | 20242.6 |
321 | 2024-03-10 01:27:58 | legislator | 4 | 161450 | 78 | 18.410 | 8769.7 |
320 | 2024-03-10 01:26:53 | legislator | 1 | 67641 | 2 | 1.750 | 38652.0 |
319 | 2024-03-10 01:26:46 | legislator | 1 | 67641 | 2 | 2.643 | 25592.5 |
318 | 2024-03-10 01:25:17 | legislator | 5 | 173545 | 438 | 49.206 | 3526.9 |
317 | 2024-03-09 18:08:32 | legislator | 5 | 173545 | 438 | 42.440 | 4089.2 |
316 | 2024-03-09 16:22:33 | legislator | 5 | 173545 | 438 | 51.783 | 3351.4 |
315 | 2024-02-21 05:42:47 | legislator | 5 | 173545 | 438 | 39.503 | 4393.2 |
314 | 2024-02-16 22:48:30 | legislator | 1 | 67641 | 2 | 1.173 | 57665.0 |
313 | 2024-02-13 13:14:38 | legislator | 1 | 67641 | 2 | 5.920 | 11425.8 |
312 | 2024-02-12 15:43:51 | legislator | 3 | 140603 | 18 | 8.126 | 17302.9 |
311 | 2024-02-12 15:43:48 | legislator | 2 | 108824 | 7 | 4.203 | 25892.0 |
310 | 2024-02-12 14:13:15 | legislator | 4 | 161450 | 78 | 14.940 | 10806.6 |
309 | 2024-02-12 13:49:38 | legislator | 1 | 67641 | 2 | 0.983 | 68810.8 |
308 | 2024-02-12 10:29:51 | legislator | 4 | 161450 | 78 | 13.206 | 12225.5 |
307 | 2024-02-08 11:05:55 | legislator | 3 | 140603 | 18 | 9.003 | 15617.3 |
306 | 2024-02-08 11:05:55 | legislator | 2 | 108824 | 7 | 7.360 | 14785.9 |
305 | 2024-02-08 07:13:52 | legislator | 1 | 67641 | 2 | 2.486 | 27208.8 |
304 | 2024-02-08 00:30:09 | legislator | 4 | 161450 | 78 | 35.910 | 4496.0 |
303 | 2024-02-06 17:00:44 | legislator | 4 | 161450 | 78 | 32.643 | 4945.9 |
302 | 2024-02-06 17:00:35 | legislator | 5 | 173545 | 438 | 26.800 | 6475.6 |
301 | 2024-02-06 17:00:49 | legislator | 2 | 108824 | 7 | 3.733 | 29151.9 |
300 | 2024-02-06 17:00:37 | legislator | 3 | 140603 | 18 | 15.003 | 9371.7 |
299 | 2024-02-06 16:25:40 | legislator | 5 | 173545 | 438 | 39.176 | 4429.9 |
298 | 2024-02-06 16:25:38 | legislator | 4 | 161450 | 78 | 26.410 | 6113.2 |
297 | 2024-02-06 16:25:35 | legislator | 3 | 140603 | 18 | 17.546 | 8013.4 |
296 | 2024-02-06 16:25:31 | legislator | 2 | 108824 | 7 | 3.533 | 30802.2 |
295 | 2024-02-06 15:24:21 | legislator | 1 | 67641 | 2 | 1.140 | 59334.2 |
294 | 2024-02-06 15:24:11 | legislator | 1 | 67641 | 2 | 1.203 | 56226.9 |
293 | 2024-01-02 18:07:19 | legislator | 2 | 108824 | 7 | 2.843 | 38277.9 |
292 | 2023-12-19 14:06:50 | legislator | 1 | 67641 | 2 | 1.016 | 66575.8 |
291 | 2023-12-17 12:13:35 | legislator | 4 | 161450 | 78 | 10.360 | 15584.0 |
290 | 2023-12-16 02:24:04 | legislator | 1 | 67641 | 2 | 1.140 | 59334.2 |
289 | 2023-12-15 09:02:07 | legislator | 1 | 67641 | 2 | 1.563 | 43276.4 |
288 | 2023-12-03 06:32:13 | legislator | 1 | 67641 | 2 | 1.123 | 60232.4 |
287 | 2023-11-26 01:58:26 | legislator | 1 | 67641 | 2 | 1.000 | 67641.0 |
286 | 2023-10-10 16:08:46 | legislator | 2 | 108824 | 7 | 2.596 | 41919.9 |
285 | 2023-10-06 14:49:15 | legislator | 4 | 161450 | 78 | 13.156 | 12272.0 |
284 | 2023-10-06 14:48:46 | legislator | 1 | 67641 | 2 | 1.000 | 67641.0 |
283 | 2023-09-18 11:53:07 | legislator | 4 | 161450 | 78 | 14.783 | 10921.3 |
282 | 2023-09-17 06:58:04 | legislator | 1 | 67641 | 2 | 1.016 | 66575.8 |
281 | 2023-07-25 20:13:43 | legislator | 1 | 67641 | 2 | 0.986 | 68601.4 |
280 | 2023-07-20 03:05:29 | legislator | 2 | 108824 | 7 | 2.610 | 41695.0 |
279 | 2023-07-03 15:41:45 | legislator | 1 | 67641 | 2 | 1.110 | 60937.8 |
278 | 2023-06-25 20:43:37 | legislator | 4 | 161450 | 78 | 10.216 | 15803.6 |
277 | 2023-04-09 08:18:06 | legislator | 1 | 67641 | 2 | 0.986 | 68601.4 |
276 | 2023-04-03 06:46:39 | legislator | 2 | 108824 | 7 | 2.563 | 42459.6 |
275 | 2023-03-24 02:13:45 | legislator | 4 | 161450 | 78 | 10.170 | 15875.1 |
274 | 2023-03-16 11:00:03 | legislator | 1 | 67641 | 2 | 1.046 | 64666.3 |
273 | 2023-01-30 19:56:20 | legislator | 1 | 67641 | 2 | 0.986 | 68601.4 |
272 | 2022-12-31 21:57:32 | legislator | 2 | 108824 | 7 | 2.580 | 42179.8 |
271 | 2022-12-23 05:22:31 | legislator | 4 | 161450 | 78 | 9.423 | 17133.6 |
270 | 2022-11-26 01:06:38 | legislator | 1 | 67641 | 2 | 1.096 | 61716.2 |
269 | 2022-10-20 13:30:27 | legislator | 1 | 67641 | 2 | 1.250 | 54112.8 |
268 | 2022-09-04 22:01:40 | legislator | 2 | 108824 | 7 | 2.580 | 42179.8 |
267 | 2022-08-25 12:51:50 | legislator | 4 | 161450 | 78 | 9.376 | 17219.5 |
266 | 2022-07-21 13:09:47 | legislator | 1 | 67641 | 2 | 1.033 | 65480.2 |
265 | 2022-05-29 04:04:36 | legislator | 1 | 67641 | 2 | 2.296 | 29460.4 |
264 | 2022-01-07 18:29:52 | legislator | 1 | 67641 | 2 | 1.186 | 57032.9 |