History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potholes"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
500 | 2025-05-07 18:08:42 | potholes | 1 | 82945 | 5 | 1.453 | 57085.3 |
499 | 2025-05-04 01:00:44 | potholes | 1 | 82945 | 5 | 4.233 | 19594.8 |
498 | 2025-05-01 05:29:07 | potholes | 1 | 82945 | 5 | 5.110 | 16231.9 |
497 | 2025-04-30 14:57:35 | potholes | 2 | 121059 | 28 | 17.000 | 7121.1 |
496 | 2025-04-30 01:12:25 | potholes | 2 | 121059 | 28 | 9.686 | 12498.3 |
495 | 2025-04-29 00:11:00 | potholes | 2 | 121059 | 28 | 19.406 | 6238.2 |
494 | 2025-04-28 17:17:56 | potholes | 1 | 82945 | 5 | 9.186 | 9029.5 |
493 | 2025-04-28 09:21:03 | potholes | 1 | 82945 | 5 | 6.906 | 12010.6 |
492 | 2025-04-23 03:16:19 | potholes | 1 | 82945 | 5 | 6.783 | 12228.4 |
491 | 2025-04-14 06:05:30 | potholes | 2 | 121059 | 28 | 19.046 | 6356.1 |
490 | 2025-04-13 13:38:11 | potholes | 3 | 146162 | 170 | 6.486 | 22535.0 |
489 | 2025-04-12 02:13:41 | potholes | 2 | 121059 | 28 | 19.333 | 6261.8 |
488 | 2025-04-07 19:04:54 | potholes | 1 | 82945 | 5 | 1.453 | 57085.3 |
487 | 2025-04-07 04:16:06 | potholes | 3 | 146162 | 170 | 31.940 | 4576.1 |
486 | 2025-04-07 03:24:58 | potholes | 2 | 121059 | 28 | 19.830 | 6104.8 |
485 | 2025-04-06 13:18:38 | potholes | 1 | 82945 | 5 | 7.690 | 10786.1 |
484 | 2025-04-05 16:43:40 | potholes | 3 | 146162 | 170 | 7.766 | 18820.8 |
483 | 2025-03-28 01:10:58 | potholes | 3 | 146162 | 170 | 28.900 | 5057.5 |
482 | 2025-03-27 19:37:57 | potholes | 1 | 82945 | 5 | 7.063 | 11743.6 |
481 | 2025-03-23 13:20:55 | potholes | 3 | 146162 | 170 | 37.956 | 3850.8 |
480 | 2025-03-23 06:00:35 | potholes | 2 | 121059 | 28 | 13.876 | 8724.3 |
479 | 2025-03-22 10:38:09 | potholes | 1 | 82945 | 5 | 1.516 | 54713.1 |
478 | 2025-03-20 06:36:44 | potholes | 1 | 82945 | 5 | 9.860 | 8412.3 |
477 | 2025-03-20 04:45:41 | potholes | 1 | 82945 | 5 | 5.576 | 14875.4 |
476 | 2025-03-02 08:35:26 | potholes | 1 | 82945 | 5 | 4.533 | 18298.0 |
475 | 2025-02-17 03:06:12 | potholes | 3 | 146162 | 170 | 38.723 | 3774.6 |
474 | 2025-02-09 01:32:00 | potholes | 3 | 146162 | 170 | 19.126 | 7642.1 |
473 | 2025-02-09 01:31:50 | potholes | 2 | 121059 | 28 | 9.220 | 13130.0 |
472 | 2025-02-08 17:01:56 | potholes | 3 | 146162 | 170 | 31.610 | 4623.9 |
471 | 2025-02-07 12:46:28 | potholes | 1 | 82945 | 5 | 6.940 | 11951.7 |
470 | 2025-02-06 13:31:46 | potholes | 3 | 146162 | 170 | 19.420 | 7526.4 |
469 | 2025-02-05 18:13:49 | potholes | 3 | 146162 | 170 | 7.280 | 20077.2 |
468 | 2025-01-31 23:39:40 | potholes | 2 | 121059 | 28 | 18.983 | 6377.2 |
467 | 2025-01-31 09:43:24 | potholes | 2 | 121059 | 28 | 11.670 | 10373.5 |
466 | 2025-01-27 23:43:11 | potholes | 1 | 82945 | 5 | 7.123 | 11644.7 |
465 | 2025-01-26 21:03:35 | potholes | 1 | 82945 | 5 | 4.123 | 20117.6 |
464 | 2025-01-25 21:44:36 | potholes | 1 | 82945 | 5 | 6.890 | 12038.5 |
463 | 2025-01-03 23:39:10 | potholes | 2 | 121059 | 28 | 14.580 | 8303.1 |
462 | 2025-01-03 23:31:04 | potholes | 3 | 146162 | 170 | 6.876 | 21256.8 |
461 | 2024-12-29 15:31:54 | potholes | 1 | 82945 | 5 | 7.743 | 10712.3 |
460 | 2024-12-27 18:34:54 | potholes | 2 | 121059 | 28 | 3.606 | 33571.5 |
459 | 2024-12-27 18:34:50 | potholes | 1 | 82945 | 5 | 1.406 | 58993.6 |
458 | 2024-12-26 15:36:56 | potholes | 2 | 121059 | 28 | 4.060 | 29817.5 |
457 | 2024-12-26 07:31:12 | potholes | 3 | 146162 | 170 | 16.390 | 8917.8 |
456 | 2024-12-25 23:05:47 | potholes | 3 | 146162 | 170 | 36.783 | 3973.6 |
455 | 2024-12-25 12:38:26 | potholes | 2 | 121059 | 28 | 20.766 | 5829.7 |
454 | 2024-12-25 12:38:26 | potholes | 3 | 146162 | 170 | 19.970 | 7319.1 |
453 | 2024-12-25 12:37:06 | potholes | 1 | 82945 | 5 | 3.203 | 25896.0 |
452 | 2024-11-26 16:09:28 | potholes | 1 | 82945 | 5 | 7.080 | 11715.4 |
451 | 2024-11-21 20:14:15 | potholes | 1 | 82945 | 5 | 7.110 | 11666.0 |
450 | 2024-11-20 22:10:55 | potholes | 1 | 82945 | 5 | 1.576 | 52630.1 |
449 | 2024-11-11 07:53:42 | potholes | 2 | 121059 | 28 | 11.470 | 10554.4 |
448 | 2024-11-11 04:34:51 | potholes | 1 | 82945 | 5 | 1.420 | 58412.0 |
447 | 2024-11-04 03:40:01 | potholes | 2 | 121059 | 28 | 4.280 | 28284.8 |
446 | 2024-10-31 17:53:35 | potholes | 3 | 146162 | 170 | 16.156 | 9046.9 |
445 | 2024-10-30 22:02:03 | potholes | 3 | 146162 | 170 | 53.473 | 2733.4 |
444 | 2024-10-30 18:39:00 | potholes | 3 | 146162 | 170 | 40.253 | 3631.1 |
443 | 2024-10-30 15:51:07 | potholes | 3 | 146162 | 170 | 15.393 | 9495.4 |
442 | 2024-10-30 15:51:08 | potholes | 2 | 121059 | 28 | 10.970 | 11035.5 |
441 | 2024-10-22 07:24:44 | potholes | 1 | 82945 | 5 | 5.656 | 14665.0 |
440 | 2024-10-22 03:37:16 | potholes | 1 | 82945 | 5 | 3.640 | 22787.1 |
439 | 2024-10-21 13:40:26 | potholes | 1 | 82945 | 5 | 5.610 | 14785.2 |
438 | 2024-10-12 20:06:21 | potholes | 2 | 121059 | 28 | 18.706 | 6471.7 |
437 | 2024-10-11 13:53:27 | potholes | 1 | 82945 | 5 | 5.610 | 14785.2 |
436 | 2024-10-07 00:33:19 | potholes | 2 | 121059 | 28 | 26.733 | 4528.4 |
435 | 2024-10-03 02:17:47 | potholes | 2 | 121059 | 28 | 28.643 | 4226.5 |
434 | 2024-09-17 02:33:53 | potholes | 3 | 146162 | 170 | 52.800 | 2768.2 |
433 | 2024-09-16 22:23:22 | potholes | 3 | 146162 | 170 | 81.800 | 1786.8 |
432 | 2024-09-16 22:22:21 | potholes | 1 | 82945 | 5 | 5.640 | 14706.6 |
431 | 2024-09-13 01:23:23 | potholes | 1 | 82945 | 5 | 10.000 | 8294.5 |
430 | 2024-08-20 10:11:45 | potholes | 1 | 82945 | 5 | 10.686 | 7762.0 |
429 | 2024-08-17 09:31:18 | potholes | 1 | 82945 | 5 | 15.546 | 5335.5 |
428 | 2024-08-16 08:47:08 | potholes | 1 | 82945 | 5 | 6.626 | 12518.1 |
427 | 2024-08-15 06:25:17 | potholes | 1 | 82945 | 5 | 8.983 | 9233.6 |
426 | 2024-08-08 13:51:03 | potholes | 1 | 82945 | 5 | 1.580 | 52496.8 |
425 | 2024-07-24 05:36:00 | potholes | 2 | 121059 | 28 | 7.110 | 17026.6 |
424 | 2024-07-24 05:35:55 | potholes | 1 | 82945 | 5 | 3.763 | 22042.3 |
423 | 2024-07-23 19:48:27 | potholes | 3 | 146162 | 170 | 30.986 | 4717.0 |
422 | 2024-07-23 03:24:38 | potholes | 3 | 146162 | 170 | 34.143 | 4280.9 |
421 | 2024-07-22 19:47:06 | potholes | 3 | 146162 | 170 | 13.550 | 10786.9 |
420 | 2024-07-22 02:36:13 | potholes | 3 | 146162 | 170 | 20.236 | 7222.9 |
419 | 2024-07-21 22:36:42 | potholes | 3 | 146162 | 170 | 16.506 | 8855.1 |
418 | 2024-07-21 22:36:42 | potholes | 2 | 121059 | 28 | 15.580 | 7770.2 |
417 | 2024-07-21 22:36:43 | potholes | 1 | 82945 | 5 | 5.796 | 14310.7 |
416 | 2024-07-16 07:54:09 | potholes | 1 | 82945 | 5 | 7.736 | 10721.9 |
415 | 2024-07-13 17:31:01 | potholes | 1 | 82945 | 5 | 3.046 | 27230.8 |
414 | 2024-07-13 10:02:16 | potholes | 1 | 82945 | 5 | 8.346 | 9938.3 |
413 | 2024-07-07 16:35:32 | potholes | 1 | 82945 | 5 | 2.970 | 27927.6 |
412 | 2024-06-19 03:32:34 | potholes | 1 | 82945 | 5 | 2.936 | 28251.0 |
411 | 2024-06-18 21:54:11 | potholes | 1 | 82945 | 5 | 4.296 | 19307.5 |
410 | 2024-06-08 05:36:42 | potholes | 3 | 146162 | 170 | 20.130 | 7260.9 |
409 | 2024-06-07 11:10:04 | potholes | 2 | 121059 | 28 | 10.713 | 11300.2 |
408 | 2024-06-07 11:01:06 | potholes | 3 | 146162 | 170 | 7.690 | 19006.8 |
407 | 2024-06-02 10:39:10 | potholes | 1 | 82945 | 5 | 1.263 | 65673.0 |
406 | 2024-06-01 18:43:04 | potholes | 2 | 121059 | 28 | 4.406 | 27475.9 |
405 | 2024-06-01 02:52:14 | potholes | 3 | 146162 | 170 | 28.423 | 5142.4 |
404 | 2024-06-01 01:44:08 | potholes | 3 | 146162 | 170 | 38.296 | 3816.6 |
403 | 2024-06-01 01:44:12 | potholes | 2 | 121059 | 28 | 15.096 | 8019.3 |
402 | 2024-06-01 01:40:06 | potholes | 1 | 82945 | 5 | 7.126 | 11639.8 |
401 | 2024-05-11 14:16:24 | potholes | 1 | 82945 | 5 | 1.610 | 51518.6 |