History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hydrants"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 511 | 2025-10-10 14:44:49 | hydrants | 4 | 161609 | 579 | 12.623 | 12802.7 |
| 510 | 2025-10-03 09:21:51 | hydrants | 3 | 146162 | 66 | 6.300 | 23200.3 |
| 509 | 2025-09-28 02:07:46 | hydrants | 1 | 82945 | 4 | 1.403 | 59119.7 |
| 508 | 2025-09-19 20:11:47 | hydrants | 1 | 82945 | 4 | 1.233 | 67270.9 |
| 507 | 2025-09-13 03:57:19 | hydrants | 4 | 161609 | 579 | 10.890 | 14840.1 |
| 506 | 2025-09-11 12:39:25 | hydrants | 3 | 146162 | 66 | 8.360 | 17483.5 |
| 505 | 2025-09-11 12:35:11 | hydrants | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 504 | 2025-08-17 12:40:48 | hydrants | 1 | 82945 | 4 | 3.483 | 23814.2 |
| 503 | 2025-08-13 13:59:59 | hydrants | 1 | 82945 | 4 | 1.406 | 58993.6 |
| 502 | 2025-08-12 22:49:03 | hydrants | 1 | 82945 | 4 | 6.153 | 13480.4 |
| 501 | 2025-08-12 06:31:57 | hydrants | 4 | 161609 | 579 | 31.500 | 5130.4 |
| 500 | 2025-08-11 22:01:17 | hydrants | 1 | 82945 | 4 | 3.000 | 27648.3 |
| 499 | 2025-08-11 19:59:49 | hydrants | 3 | 146162 | 66 | 17.330 | 8434.0 |
| 498 | 2025-08-11 14:35:14 | hydrants | 1 | 82945 | 4 | 2.670 | 31065.5 |
| 497 | 2025-08-05 11:40:04 | hydrants | 3 | 146162 | 66 | 17.970 | 8133.7 |
| 496 | 2025-08-01 13:00:42 | hydrants | 3 | 146162 | 66 | 35.440 | 4124.2 |
| 495 | 2025-08-01 08:51:13 | hydrants | 2 | 121059 | 10 | 9.346 | 12953.0 |
| 494 | 2025-07-30 21:23:00 | hydrants | 1 | 82945 | 4 | 1.376 | 60279.8 |
| 493 | 2025-07-29 04:49:22 | hydrants | 1 | 82945 | 4 | 6.686 | 12405.8 |
| 492 | 2025-07-27 08:11:35 | hydrants | 1 | 82945 | 4 | 3.063 | 27079.7 |
| 491 | 2025-07-27 07:20:22 | hydrants | 1 | 82945 | 4 | 8.826 | 9397.8 |
| 490 | 2025-07-25 14:33:01 | hydrants | 4 | 161609 | 579 | 35.846 | 4508.4 |
| 489 | 2025-07-24 23:12:33 | hydrants | 4 | 161609 | 579 | 32.126 | 5030.5 |
| 488 | 2025-07-24 02:06:57 | hydrants | 4 | 161609 | 579 | 70.926 | 2278.6 |
| 487 | 2025-07-23 18:22:18 | hydrants | 4 | 161609 | 579 | 59.580 | 2712.5 |
| 486 | 2025-07-23 16:46:32 | hydrants | 1 | 82945 | 4 | 5.233 | 15850.4 |
| 485 | 2025-07-21 14:08:15 | hydrants | 4 | 161609 | 579 | 32.660 | 4948.2 |
| 484 | 2025-07-20 21:59:03 | hydrants | 1 | 82945 | 4 | 1.310 | 63316.8 |
| 483 | 2025-07-19 13:46:52 | hydrants | 4 | 161609 | 579 | 21.453 | 7533.2 |
| 482 | 2025-07-17 08:07:40 | hydrants | 4 | 161609 | 579 | 32.446 | 4980.9 |
| 481 | 2025-07-06 14:23:27 | hydrants | 1 | 82945 | 4 | 1.343 | 61761.0 |
| 480 | 2025-07-02 11:23:15 | hydrants | 2 | 121059 | 10 | 17.593 | 6881.1 |
| 479 | 2025-07-01 03:04:57 | hydrants | 1 | 82945 | 4 | 6.483 | 12794.2 |
| 478 | 2025-06-30 14:18:28 | hydrants | 1 | 82945 | 4 | 9.983 | 8308.6 |
| 477 | 2025-06-29 21:20:54 | hydrants | 1 | 82945 | 4 | 4.250 | 19516.5 |
| 476 | 2025-06-29 17:05:27 | hydrants | 4 | 161609 | 579 | 11.360 | 14226.1 |
| 475 | 2025-06-29 14:46:54 | hydrants | 4 | 161609 | 579 | 48.863 | 3307.4 |
| 474 | 2025-06-28 23:34:24 | hydrants | 4 | 161609 | 579 | 11.530 | 14016.4 |
| 473 | 2025-06-26 14:35:35 | hydrants | 4 | 161609 | 579 | 75.006 | 2154.6 |
| 472 | 2025-06-25 05:25:01 | hydrants | 4 | 161609 | 579 | 59.826 | 2701.3 |
| 471 | 2025-06-24 07:43:50 | hydrants | 1 | 82945 | 4 | 3.393 | 24445.9 |
| 470 | 2025-06-22 21:52:50 | hydrants | 1 | 82945 | 4 | 2.953 | 28088.4 |
| 469 | 2025-06-22 12:08:30 | hydrants | 4 | 161609 | 579 | 71.833 | 2249.8 |
| 468 | 2025-06-17 14:58:16 | hydrants | 4 | 161609 | 579 | 13.860 | 11660.1 |
| 467 | 2025-06-15 16:42:11 | hydrants | 4 | 161609 | 579 | 11.843 | 13646.0 |
| 466 | 2025-06-02 17:55:38 | hydrants | 3 | 146162 | 66 | 6.173 | 23677.6 |
| 465 | 2025-05-31 03:00:30 | hydrants | 1 | 82945 | 4 | 3.423 | 24231.7 |
| 464 | 2025-05-29 12:54:58 | hydrants | 1 | 82945 | 4 | 3.343 | 24811.5 |
| 463 | 2025-05-29 02:46:45 | hydrants | 1 | 82945 | 4 | 4.830 | 17172.9 |
| 462 | 2025-05-26 15:01:44 | hydrants | 4 | 161609 | 579 | 53.503 | 3020.6 |
| 461 | 2025-05-23 16:23:42 | hydrants | 4 | 161609 | 579 | 60.393 | 2676.0 |
| 460 | 2025-05-23 08:05:28 | hydrants | 2 | 121059 | 10 | 13.970 | 8665.6 |
| 459 | 2025-05-23 07:52:53 | hydrants | 3 | 146162 | 66 | 27.656 | 5285.0 |
| 458 | 2025-05-20 07:08:54 | hydrants | 1 | 82945 | 4 | 10.096 | 8215.6 |
| 457 | 2025-05-20 02:56:57 | hydrants | 1 | 82945 | 4 | 7.373 | 11249.8 |
| 456 | 2025-05-17 15:11:47 | hydrants | 1 | 82945 | 4 | 1.453 | 57085.3 |
| 455 | 2025-05-14 05:10:44 | hydrants | 3 | 146162 | 66 | 31.130 | 4695.2 |
| 454 | 2025-05-12 14:56:46 | hydrants | 3 | 146162 | 66 | 31.563 | 4630.8 |
| 453 | 2025-05-12 06:56:38 | hydrants | 3 | 146162 | 66 | 33.470 | 4367.0 |
| 452 | 2025-05-12 05:47:42 | hydrants | 2 | 121059 | 10 | 18.780 | 6446.2 |
| 451 | 2025-05-11 03:04:21 | hydrants | 3 | 146162 | 66 | 7.530 | 19410.6 |
| 450 | 2025-05-10 01:19:02 | hydrants | 3 | 146162 | 66 | 34.003 | 4298.5 |
| 449 | 2025-05-09 07:34:34 | hydrants | 1 | 82945 | 4 | 1.330 | 62364.7 |
| 448 | 2025-05-02 20:58:50 | hydrants | 3 | 146162 | 66 | 38.966 | 3751.0 |
| 447 | 2025-04-30 09:59:20 | hydrants | 3 | 146162 | 66 | 28.033 | 5213.9 |
| 446 | 2025-04-20 20:46:59 | hydrants | 1 | 82945 | 4 | 2.780 | 29836.3 |
| 445 | 2025-04-20 18:17:11 | hydrants | 1 | 82945 | 4 | 1.466 | 56579.1 |
| 444 | 2025-04-20 06:23:32 | hydrants | 1 | 82945 | 4 | 6.766 | 12259.1 |
| 443 | 2025-04-02 07:18:48 | hydrants | 1 | 82945 | 4 | 3.953 | 20982.8 |
| 442 | 2025-03-25 09:02:23 | hydrants | 2 | 121059 | 10 | 15.236 | 7945.6 |
| 441 | 2025-03-24 13:31:47 | hydrants | 2 | 121059 | 10 | 22.156 | 5463.9 |
| 440 | 2025-03-22 04:19:08 | hydrants | 1 | 82945 | 4 | 3.953 | 20982.8 |
| 439 | 2025-03-17 20:15:24 | hydrants | 3 | 146162 | 66 | 34.720 | 4209.7 |
| 438 | 2025-03-16 08:56:32 | hydrants | 3 | 146162 | 66 | 19.450 | 7514.8 |
| 437 | 2025-03-16 08:10:08 | hydrants | 2 | 121059 | 10 | 14.910 | 8119.3 |
| 436 | 2025-03-15 08:32:03 | hydrants | 3 | 146162 | 66 | 34.050 | 4292.6 |
| 435 | 2025-03-14 23:59:27 | hydrants | 3 | 146162 | 66 | 28.033 | 5213.9 |
| 434 | 2025-03-14 22:41:15 | hydrants | 3 | 146162 | 66 | 36.146 | 4043.7 |
| 433 | 2025-03-14 16:53:30 | hydrants | 3 | 146162 | 66 | 35.186 | 4154.0 |
| 432 | 2025-03-14 16:53:28 | hydrants | 3 | 146162 | 66 | 33.173 | 4406.1 |
| 431 | 2025-03-14 16:53:24 | hydrants | 2 | 121059 | 10 | 8.843 | 13689.8 |
| 430 | 2025-03-14 15:59:17 | hydrants | 1 | 82945 | 4 | 1.263 | 65673.0 |
| 429 | 2025-02-26 19:17:22 | hydrants | 1 | 82945 | 4 | 8.703 | 9530.6 |
| 428 | 2025-02-22 19:06:42 | hydrants | 2 | 121059 | 10 | 16.406 | 7378.9 |
| 427 | 2025-02-22 19:05:56 | hydrants | 1 | 82945 | 4 | 5.610 | 14785.2 |
| 426 | 2025-02-05 17:31:49 | hydrants | 1 | 82945 | 4 | 5.686 | 14587.6 |
| 425 | 2025-02-01 10:37:22 | hydrants | 3 | 146162 | 66 | 32.846 | 4449.9 |
| 424 | 2025-01-30 01:42:45 | hydrants | 3 | 146162 | 66 | 32.593 | 4484.5 |
| 423 | 2025-01-29 01:59:47 | hydrants | 3 | 146162 | 66 | 30.673 | 4765.2 |
| 422 | 2025-01-28 20:18:26 | hydrants | 3 | 146162 | 66 | 40.203 | 3635.6 |
| 421 | 2025-01-28 20:18:37 | hydrants | 3 | 146162 | 66 | 23.143 | 6315.6 |
| 420 | 2025-01-28 20:18:29 | hydrants | 2 | 121059 | 10 | 17.563 | 6892.8 |
| 419 | 2025-01-26 18:46:27 | hydrants | 1 | 82945 | 4 | 6.640 | 12491.7 |
| 418 | 2025-01-16 18:51:10 | hydrants | 1 | 82945 | 4 | 6.453 | 12853.7 |
| 417 | 2025-01-05 23:39:35 | hydrants | 1 | 82945 | 4 | 9.253 | 8964.1 |
| 416 | 2025-01-04 14:24:25 | hydrants | 1 | 82945 | 4 | 4.593 | 18059.0 |
| 415 | 2024-12-19 12:58:52 | hydrants | 3 | 146162 | 66 | 37.503 | 3897.3 |
| 414 | 2024-12-15 19:17:49 | hydrants | 3 | 146162 | 66 | 31.910 | 4580.4 |
| 413 | 2024-12-11 01:59:29 | hydrants | 1 | 82945 | 4 | 9.873 | 8401.2 |
| 412 | 2024-12-06 14:30:09 | hydrants | 1 | 82945 | 4 | 6.076 | 13651.3 |