History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"riparian"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 465 | 2025-11-19 23:01:27 | riparian | 2 | 121059 | 5 | 3.280 | 36908.2 |
| 464 | 2025-11-19 18:30:35 | riparian | 1 | 82945 | 1 | 1.453 | 57085.3 |
| 463 | 2025-10-23 21:02:45 | riparian | 1 | 82945 | 1 | 7.156 | 11591.0 |
| 462 | 2025-10-01 18:39:39 | riparian | 1 | 82945 | 1 | 1.343 | 61761.0 |
| 461 | 2025-08-30 18:24:50 | riparian | 1 | 82945 | 1 | 1.326 | 62552.8 |
| 460 | 2025-08-25 17:46:06 | riparian | 4 | 161609 | 464 | 86.083 | 1877.4 |
| 459 | 2025-08-23 07:55:09 | riparian | 4 | 161609 | 464 | 63.396 | 2549.2 |
| 458 | 2025-08-21 07:27:09 | riparian | 4 | 161609 | 464 | 34.890 | 4632.0 |
| 457 | 2025-08-19 15:42:25 | riparian | 4 | 161609 | 464 | 49.426 | 3269.7 |
| 456 | 2025-08-17 19:45:37 | riparian | 4 | 161609 | 464 | 48.706 | 3318.1 |
| 455 | 2025-08-15 04:31:26 | riparian | 4 | 161609 | 464 | 62.296 | 2594.2 |
| 454 | 2025-08-14 20:11:58 | riparian | 2 | 121059 | 5 | 8.876 | 13638.9 |
| 453 | 2025-08-13 23:09:15 | riparian | 1 | 82945 | 1 | 1.530 | 54212.4 |
| 452 | 2025-08-11 07:09:52 | riparian | 3 | 146162 | 40 | 19.516 | 7489.3 |
| 451 | 2025-08-09 12:48:21 | riparian | 3 | 146162 | 40 | 13.343 | 10954.2 |
| 450 | 2025-08-05 13:32:08 | riparian | 1 | 82945 | 1 | 4.406 | 18825.5 |
| 449 | 2025-08-05 10:22:26 | riparian | 1 | 82945 | 1 | 3.046 | 27230.8 |
| 448 | 2025-07-27 14:36:56 | riparian | 1 | 82945 | 1 | 3.343 | 24811.5 |
| 447 | 2025-07-25 11:37:43 | riparian | 1 | 82945 | 1 | 7.016 | 11822.3 |
| 446 | 2025-07-21 20:09:13 | riparian | 1 | 82945 | 1 | 1.360 | 60989.0 |
| 445 | 2025-07-11 05:27:02 | riparian | 1 | 82945 | 1 | 8.856 | 9366.0 |
| 444 | 2025-07-10 20:48:28 | riparian | 1 | 82945 | 1 | 3.560 | 23299.2 |
| 443 | 2025-06-24 16:04:17 | riparian | 1 | 82945 | 1 | 5.486 | 15119.4 |
| 442 | 2025-06-12 06:15:31 | riparian | 1 | 82945 | 1 | 8.546 | 9705.7 |
| 441 | 2025-06-06 16:31:12 | riparian | 1 | 82945 | 1 | 7.110 | 11666.0 |
| 440 | 2025-06-05 23:39:35 | riparian | 1 | 82945 | 1 | 6.330 | 13103.5 |
| 439 | 2025-05-22 16:15:30 | riparian | 1 | 82945 | 1 | 8.313 | 9977.7 |
| 438 | 2025-05-10 07:08:29 | riparian | 1 | 82945 | 1 | 6.876 | 12063.0 |
| 437 | 2025-05-06 06:38:33 | riparian | 1 | 82945 | 1 | 9.703 | 8548.4 |
| 436 | 2025-05-02 16:25:02 | riparian | 1 | 82945 | 1 | 6.390 | 12980.4 |
| 435 | 2025-05-02 14:57:25 | riparian | 3 | 146162 | 40 | 56.300 | 2596.1 |
| 434 | 2025-05-01 00:59:54 | riparian | 3 | 146162 | 40 | 49.110 | 2976.2 |
| 433 | 2025-04-27 00:29:10 | riparian | 3 | 146162 | 40 | 7.190 | 20328.5 |
| 432 | 2025-04-25 03:14:52 | riparian | 3 | 146162 | 40 | 36.986 | 3951.8 |
| 431 | 2025-04-21 16:39:23 | riparian | 1 | 82945 | 1 | 4.813 | 17233.5 |
| 430 | 2025-04-06 01:27:46 | riparian | 2 | 121059 | 5 | 10.250 | 11810.6 |
| 429 | 2025-04-06 00:05:32 | riparian | 3 | 146162 | 40 | 49.453 | 2955.6 |
| 428 | 2025-04-05 12:26:44 | riparian | 1 | 82945 | 1 | 1.406 | 58993.6 |
| 427 | 2025-03-30 14:15:33 | riparian | 4 | 161609 | 464 | 54.876 | 2945.0 |
| 426 | 2025-03-29 08:40:44 | riparian | 1 | 82945 | 1 | 5.453 | 15210.9 |
| 425 | 2025-03-28 16:43:54 | riparian | 4 | 161609 | 464 | 25.580 | 6317.8 |
| 424 | 2025-03-26 02:18:18 | riparian | 3 | 146162 | 40 | 7.576 | 19292.8 |
| 423 | 2025-03-14 07:06:19 | riparian | 3 | 146162 | 40 | 38.453 | 3801.1 |
| 422 | 2025-03-14 07:06:18 | riparian | 3 | 146162 | 40 | 21.936 | 6663.1 |
| 421 | 2025-03-13 08:48:05 | riparian | 3 | 146162 | 40 | 36.063 | 4053.0 |
| 420 | 2025-03-12 14:54:02 | riparian | 3 | 146162 | 40 | 36.516 | 4002.7 |
| 419 | 2025-03-12 14:54:07 | riparian | 2 | 121059 | 5 | 18.156 | 6667.7 |
| 418 | 2025-03-12 14:44:03 | riparian | 1 | 82945 | 1 | 2.123 | 39069.7 |
| 417 | 2025-03-12 03:20:56 | riparian | 4 | 161609 | 464 | 83.426 | 1937.2 |
| 416 | 2025-03-11 12:01:37 | riparian | 3 | 146162 | 40 | 23.846 | 6129.4 |
| 415 | 2025-03-11 12:01:35 | riparian | 2 | 121059 | 5 | 13.626 | 8884.4 |
| 414 | 2025-03-11 11:56:18 | riparian | 1 | 82945 | 1 | 1.483 | 55930.5 |
| 413 | 2025-03-09 04:24:26 | riparian | 3 | 146162 | 40 | 60.083 | 2432.7 |
| 412 | 2025-03-04 00:11:08 | riparian | 1 | 82945 | 1 | 6.046 | 13719.0 |
| 411 | 2025-02-27 08:10:55 | riparian | 4 | 161609 | 464 | 69.910 | 2311.7 |
| 410 | 2025-02-27 08:10:34 | riparian | 3 | 146162 | 40 | 32.593 | 4484.5 |
| 409 | 2025-02-24 15:04:02 | riparian | 1 | 82945 | 1 | 3.203 | 25896.0 |
| 408 | 2025-02-18 18:58:14 | riparian | 3 | 146162 | 40 | 23.296 | 6274.1 |
| 407 | 2025-02-11 03:51:45 | riparian | 4 | 161609 | 464 | 76.456 | 2113.8 |
| 406 | 2025-02-09 21:23:44 | riparian | 4 | 161609 | 464 | 37.706 | 4286.0 |
| 405 | 2025-02-08 13:55:19 | riparian | 2 | 121059 | 5 | 27.923 | 4335.5 |
| 404 | 2025-02-08 13:55:14 | riparian | 1 | 82945 | 1 | 9.860 | 8412.3 |
| 403 | 2025-02-08 13:53:10 | riparian | 3 | 146162 | 40 | 7.483 | 19532.5 |
| 402 | 2025-02-08 06:53:17 | riparian | 3 | 146162 | 40 | 10.170 | 14371.9 |
| 401 | 2025-02-05 13:45:35 | riparian | 2 | 121059 | 5 | 8.453 | 14321.4 |
| 400 | 2025-02-05 12:10:31 | riparian | 3 | 146162 | 40 | 38.413 | 3805.0 |
| 399 | 2025-02-05 06:40:03 | riparian | 3 | 146162 | 40 | 36.893 | 3961.8 |
| 398 | 2025-02-05 06:39:45 | riparian | 2 | 121059 | 5 | 18.703 | 6472.7 |
| 397 | 2025-02-05 06:23:55 | riparian | 1 | 82945 | 1 | 2.093 | 39629.7 |
| 396 | 2025-02-04 23:06:00 | riparian | 1 | 82945 | 1 | 11.063 | 7497.5 |
| 395 | 2025-02-04 18:27:24 | riparian | 3 | 146162 | 40 | 37.313 | 3917.2 |
| 394 | 2025-01-24 14:02:58 | riparian | 3 | 146162 | 40 | 44.680 | 3271.3 |
| 393 | 2025-01-13 23:17:51 | riparian | 3 | 146162 | 40 | 37.343 | 3914.0 |
| 392 | 2025-01-13 17:21:36 | riparian | 3 | 146162 | 40 | 41.326 | 3536.8 |
| 391 | 2025-01-11 06:02:27 | riparian | 3 | 146162 | 40 | 35.156 | 4157.5 |
| 390 | 2025-01-08 12:12:23 | riparian | 4 | 161609 | 464 | 73.363 | 2202.9 |
| 389 | 2025-01-08 12:12:50 | riparian | 3 | 146162 | 40 | 43.596 | 3352.6 |
| 388 | 2025-01-08 12:12:27 | riparian | 2 | 121059 | 5 | 19.000 | 6371.5 |
| 387 | 2025-01-08 12:12:01 | riparian | 1 | 82945 | 1 | 7.406 | 11199.7 |
| 386 | 2025-01-05 12:45:00 | riparian | 3 | 146162 | 40 | 17.266 | 8465.3 |
| 385 | 2025-01-05 12:45:01 | riparian | 2 | 121059 | 5 | 6.983 | 17336.2 |
| 384 | 2025-01-05 12:44:59 | riparian | 1 | 82945 | 1 | 2.016 | 41143.4 |
| 383 | 2024-12-29 15:18:08 | riparian | 1 | 82945 | 1 | 8.640 | 9600.1 |
| 382 | 2024-12-21 16:08:20 | riparian | 3 | 146162 | 40 | 33.720 | 4334.6 |
| 381 | 2024-12-16 17:50:42 | riparian | 3 | 146162 | 40 | 36.473 | 4007.4 |
| 380 | 2024-12-16 01:47:38 | riparian | 3 | 146162 | 40 | 45.970 | 3179.5 |
| 379 | 2024-12-10 04:51:09 | riparian | 3 | 146162 | 40 | 48.263 | 3028.4 |
| 378 | 2024-12-09 18:32:57 | riparian | 3 | 146162 | 40 | 7.733 | 18901.1 |
| 377 | 2024-12-09 18:33:00 | riparian | 2 | 121059 | 5 | 4.000 | 30264.8 |
| 376 | 2024-12-08 17:51:57 | riparian | 3 | 146162 | 40 | 42.766 | 3417.7 |
| 375 | 2024-12-08 17:51:59 | riparian | 3 | 146162 | 40 | 36.173 | 4040.6 |
| 374 | 2024-12-08 17:52:00 | riparian | 2 | 121059 | 5 | 23.863 | 5073.1 |
| 373 | 2024-12-08 17:51:57 | riparian | 1 | 82945 | 1 | 1.983 | 41828.0 |
| 372 | 2024-12-02 22:54:32 | riparian | 2 | 121059 | 5 | 18.860 | 6418.8 |
| 371 | 2024-12-02 22:53:28 | riparian | 1 | 82945 | 1 | 6.846 | 12115.8 |
| 370 | 2024-11-24 02:55:22 | riparian | 3 | 146162 | 40 | 37.846 | 3862.0 |
| 369 | 2024-11-19 23:27:44 | riparian | 1 | 82945 | 1 | 4.750 | 17462.1 |
| 368 | 2024-11-15 20:16:02 | riparian | 3 | 146162 | 40 | 33.923 | 4308.6 |
| 367 | 2024-11-15 08:40:17 | riparian | 3 | 146162 | 40 | 36.826 | 3969.0 |
| 366 | 2024-11-09 10:55:12 | riparian | 3 | 146162 | 40 | 25.970 | 5628.1 |