History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drainage"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 470 | 2026-02-15 07:26:51 | drainage | 1 | 82945 | 2 | 4.546 | 18245.7 |
| 469 | 2026-02-14 07:45:22 | drainage | 1 | 82945 | 2 | 6.470 | 12819.9 |
| 468 | 2026-02-09 17:11:18 | drainage | 1 | 82945 | 2 | 3.250 | 25521.5 |
| 467 | 2026-02-08 12:20:42 | drainage | 1 | 82945 | 2 | 6.750 | 12288.1 |
| 466 | 2026-02-08 06:29:26 | drainage | 1 | 82945 | 2 | 6.266 | 13237.3 |
| 465 | 2026-02-08 02:36:27 | drainage | 1 | 82945 | 2 | 10.673 | 7771.5 |
| 464 | 2026-02-08 00:29:43 | drainage | 1 | 82945 | 2 | 1.826 | 45424.4 |
| 463 | 2026-02-06 13:42:23 | drainage | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 462 | 2026-02-06 08:19:23 | drainage | 1 | 82945 | 2 | 1.533 | 54106.3 |
| 461 | 2026-02-05 07:39:11 | drainage | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 460 | 2026-02-05 07:34:28 | drainage | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 459 | 2026-02-04 11:51:46 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 458 | 2026-02-02 21:05:23 | drainage | 1 | 82945 | 2 | 2.763 | 30019.9 |
| 457 | 2026-01-31 09:02:15 | drainage | 1 | 82945 | 2 | 3.080 | 26930.2 |
| 456 | 2026-01-14 22:11:24 | drainage | 1 | 82945 | 2 | 2.796 | 29665.6 |
| 455 | 2026-01-14 11:48:38 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 454 | 2026-01-14 02:00:34 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 453 | 2026-01-13 03:53:03 | drainage | 1 | 82945 | 2 | 1.313 | 63172.1 |
| 452 | 2026-01-06 03:13:44 | drainage | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 451 | 2026-01-06 02:11:57 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 450 | 2026-01-04 13:36:43 | drainage | 1 | 82945 | 2 | 1.546 | 53651.4 |
| 449 | 2025-12-28 13:44:59 | drainage | 1 | 82945 | 2 | 1.376 | 60279.8 |
| 448 | 2025-12-27 14:15:11 | drainage | 1 | 82945 | 2 | 1.940 | 42755.2 |
| 447 | 2025-12-27 14:13:16 | drainage | 1 | 82945 | 2 | 3.046 | 27230.8 |
| 446 | 2025-12-25 10:47:59 | drainage | 1 | 82945 | 2 | 1.516 | 54713.1 |
| 445 | 2025-12-23 08:15:40 | drainage | 1 | 82945 | 2 | 1.486 | 55817.6 |
| 444 | 2025-12-19 11:21:56 | drainage | 3 | 146162 | 71 | 16.140 | 9055.9 |
| 443 | 2025-11-27 05:14:54 | drainage | 1 | 82945 | 2 | 1.720 | 48223.8 |
| 442 | 2025-11-04 04:44:16 | drainage | 3 | 146162 | 71 | 7.313 | 19986.6 |
| 441 | 2025-10-29 21:01:04 | drainage | 2 | 121059 | 4 | 6.453 | 18760.1 |
| 440 | 2025-10-29 05:13:20 | drainage | 2 | 121059 | 4 | 4.016 | 30144.2 |
| 439 | 2025-10-22 12:54:24 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 438 | 2025-10-15 08:01:30 | drainage | 1 | 82945 | 2 | 1.390 | 59672.7 |
| 437 | 2025-09-27 18:30:57 | drainage | 1 | 82945 | 2 | 1.470 | 56425.2 |
| 436 | 2025-09-19 11:51:18 | drainage | 1 | 82945 | 2 | 1.483 | 55930.5 |
| 435 | 2025-08-28 09:20:16 | drainage | 1 | 82945 | 2 | 4.373 | 18967.5 |
| 434 | 2025-08-27 21:41:11 | drainage | 1 | 82945 | 2 | 1.453 | 57085.3 |
| 433 | 2025-08-10 15:08:15 | drainage | 1 | 82945 | 2 | 3.110 | 26670.4 |
| 432 | 2025-08-09 07:23:40 | drainage | 1 | 82945 | 2 | 3.720 | 22297.0 |
| 431 | 2025-07-27 13:41:10 | drainage | 1 | 82945 | 2 | 3.500 | 23698.6 |
| 430 | 2025-07-25 02:06:42 | drainage | 1 | 82945 | 2 | 3.640 | 22787.1 |
| 429 | 2025-07-24 01:33:29 | drainage | 1 | 82945 | 2 | 5.856 | 14164.1 |
| 428 | 2025-07-23 01:12:00 | drainage | 1 | 82945 | 2 | 2.923 | 28376.7 |
| 427 | 2025-07-18 09:25:38 | drainage | 3 | 146162 | 71 | 22.516 | 6491.5 |
| 426 | 2025-07-16 06:50:20 | drainage | 3 | 146162 | 71 | 16.750 | 8726.1 |
| 425 | 2025-07-10 16:05:24 | drainage | 1 | 82945 | 2 | 3.046 | 27230.8 |
| 424 | 2025-07-07 10:24:24 | drainage | 1 | 82945 | 2 | 6.906 | 12010.6 |
| 423 | 2025-07-02 07:32:52 | drainage | 1 | 82945 | 2 | 6.653 | 12467.3 |
| 422 | 2025-06-25 12:49:41 | drainage | 1 | 82945 | 2 | 1.343 | 61761.0 |
| 421 | 2025-06-22 16:33:05 | drainage | 3 | 146162 | 71 | 35.296 | 4141.0 |
| 420 | 2025-06-18 23:38:28 | drainage | 3 | 146162 | 71 | 39.990 | 3655.0 |
| 419 | 2025-06-18 05:36:15 | drainage | 3 | 146162 | 71 | 34.503 | 4236.2 |
| 418 | 2025-06-15 23:10:17 | drainage | 3 | 146162 | 71 | 46.283 | 3158.0 |
| 417 | 2025-06-15 10:18:58 | drainage | 1 | 82945 | 2 | 1.500 | 55296.7 |
| 416 | 2025-06-14 05:09:09 | drainage | 1 | 82945 | 2 | 8.360 | 9921.7 |
| 415 | 2025-06-14 00:33:46 | drainage | 1 | 82945 | 2 | 10.300 | 8052.9 |
| 414 | 2025-06-10 13:19:36 | drainage | 1 | 82945 | 2 | 6.686 | 12405.8 |
| 413 | 2025-05-16 07:23:44 | drainage | 1 | 82945 | 2 | 6.990 | 11866.2 |
| 412 | 2025-05-10 20:22:06 | drainage | 2 | 121059 | 4 | 15.193 | 7968.1 |
| 411 | 2025-05-08 00:21:29 | drainage | 1 | 82945 | 2 | 4.843 | 17126.8 |
| 410 | 2025-05-07 05:36:54 | drainage | 1 | 82945 | 2 | 1.423 | 58288.8 |
| 409 | 2025-05-06 09:47:11 | drainage | 1 | 82945 | 2 | 3.376 | 24569.0 |
| 408 | 2025-05-02 13:15:02 | drainage | 1 | 82945 | 2 | 7.873 | 10535.4 |
| 407 | 2025-05-02 11:56:02 | drainage | 4 | 161609 | 844 | 56.733 | 2848.6 |
| 406 | 2025-05-01 12:33:11 | drainage | 4 | 161609 | 844 | 25.343 | 6376.9 |
| 405 | 2025-04-30 22:59:51 | drainage | 4 | 161609 | 844 | 47.953 | 3370.2 |
| 404 | 2025-04-30 20:49:34 | drainage | 4 | 161609 | 844 | 42.423 | 3809.5 |
| 403 | 2025-04-30 11:01:48 | drainage | 4 | 161609 | 844 | 38.376 | 4211.2 |
| 402 | 2025-04-29 15:14:09 | drainage | 4 | 161609 | 844 | 13.920 | 11609.8 |
| 401 | 2025-04-16 06:54:35 | drainage | 1 | 82945 | 2 | 5.640 | 14706.6 |
| 400 | 2025-04-06 09:04:24 | drainage | 1 | 82945 | 2 | 4.406 | 18825.5 |
| 399 | 2025-04-04 05:56:37 | drainage | 1 | 82945 | 2 | 5.390 | 15388.7 |
| 398 | 2025-03-31 04:59:43 | drainage | 1 | 82945 | 2 | 7.186 | 11542.6 |
| 397 | 2025-03-30 12:42:34 | drainage | 4 | 161609 | 844 | 70.220 | 2301.5 |
| 396 | 2025-03-29 15:17:34 | drainage | 4 | 161609 | 844 | 70.710 | 2285.5 |
| 395 | 2025-03-29 00:43:42 | drainage | 1 | 82945 | 2 | 9.546 | 8689.0 |
| 394 | 2025-03-29 00:01:42 | drainage | 4 | 161609 | 844 | 43.033 | 3755.5 |
| 393 | 2025-03-28 14:50:59 | drainage | 4 | 161609 | 844 | 21.000 | 7695.7 |
| 392 | 2025-03-28 13:32:29 | drainage | 4 | 161609 | 844 | 28.233 | 5724.1 |
| 391 | 2025-03-25 21:28:32 | drainage | 4 | 161609 | 844 | 36.143 | 4471.4 |
| 390 | 2025-03-25 14:53:51 | drainage | 1 | 82945 | 2 | 6.576 | 12613.3 |
| 389 | 2025-03-21 02:05:34 | drainage | 4 | 161609 | 844 | 64.020 | 2524.4 |
| 388 | 2025-03-20 22:34:17 | drainage | 2 | 121059 | 4 | 9.406 | 12870.4 |
| 387 | 2025-03-20 21:25:10 | drainage | 3 | 146162 | 71 | 7.843 | 18636.0 |
| 386 | 2025-03-19 13:19:33 | drainage | 1 | 82945 | 2 | 1.236 | 67107.6 |
| 385 | 2025-03-17 05:46:22 | drainage | 1 | 82945 | 2 | 5.890 | 14082.3 |
| 384 | 2025-03-06 07:47:27 | drainage | 2 | 121059 | 4 | 18.440 | 6565.0 |
| 383 | 2025-03-05 19:48:59 | drainage | 2 | 121059 | 4 | 9.576 | 12641.9 |
| 382 | 2025-03-05 19:48:25 | drainage | 1 | 82945 | 2 | 6.203 | 13371.8 |
| 381 | 2025-03-05 13:31:13 | drainage | 3 | 146162 | 71 | 40.470 | 3611.6 |
| 380 | 2025-03-01 17:27:55 | drainage | 3 | 146162 | 71 | 38.143 | 3831.9 |
| 379 | 2025-02-28 18:24:55 | drainage | 2 | 121059 | 4 | 23.410 | 5171.3 |
| 378 | 2025-02-28 18:24:30 | drainage | 1 | 82945 | 2 | 6.500 | 12760.8 |
| 377 | 2025-02-28 12:40:20 | drainage | 3 | 146162 | 71 | 35.810 | 4081.6 |
| 376 | 2025-02-27 05:52:20 | drainage | 3 | 146162 | 71 | 27.733 | 5270.3 |
| 375 | 2025-02-26 22:37:10 | drainage | 4 | 161609 | 844 | 64.270 | 2514.5 |
| 374 | 2025-02-26 07:11:23 | drainage | 4 | 161609 | 844 | 72.910 | 2216.6 |
| 373 | 2025-02-26 06:13:47 | drainage | 4 | 161609 | 844 | 70.596 | 2289.2 |
| 372 | 2025-02-26 03:08:38 | drainage | 4 | 161609 | 844 | 71.853 | 2249.2 |
| 371 | 2025-02-26 00:38:31 | drainage | 4 | 161609 | 844 | 69.240 | 2334.0 |