History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"catchments"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 386 | 2025-04-21 08:07:06 | catchments | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 385 | 2025-03-10 08:05:51 | catchments | 3 | 140603 | 23 | 32.236 | 4361.7 |
| 384 | 2025-03-10 08:05:49 | catchments | 2 | 108824 | 5 | 7.846 | 13870.0 |
| 383 | 2025-03-05 07:29:44 | catchments | 3 | 140603 | 23 | 31.626 | 4445.8 |
| 382 | 2025-02-26 00:37:30 | catchments | 1 | 67641 | 3 | 5.250 | 12884.0 |
| 381 | 2025-02-24 15:54:02 | catchments | 1 | 67641 | 3 | 1.123 | 60232.4 |
| 380 | 2025-02-21 08:47:29 | catchments | 3 | 140603 | 23 | 34.706 | 4051.3 |
| 379 | 2025-02-18 08:00:12 | catchments | 1 | 67641 | 3 | 5.393 | 12542.4 |
| 378 | 2025-02-17 11:07:05 | catchments | 3 | 140603 | 23 | 32.156 | 4372.5 |
| 377 | 2025-02-11 10:45:39 | catchments | 1 | 67641 | 3 | 6.033 | 11211.8 |
| 376 | 2025-02-05 22:57:19 | catchments | 1 | 67641 | 3 | 1.203 | 56226.9 |
| 375 | 2025-01-18 08:31:33 | catchments | 3 | 140603 | 23 | 46.426 | 3028.5 |
| 374 | 2025-01-15 03:11:30 | catchments | 1 | 67641 | 3 | 1.033 | 65480.2 |
| 373 | 2025-01-08 21:55:49 | catchments | 3 | 140603 | 23 | 37.270 | 3772.6 |
| 372 | 2025-01-07 14:46:13 | catchments | 4 | 161450 | 186 | 75.036 | 2151.6 |
| 371 | 2025-01-05 12:15:40 | catchments | 1 | 67641 | 3 | 2.483 | 27241.6 |
| 370 | 2025-01-04 21:09:24 | catchments | 4 | 161450 | 186 | 60.003 | 2690.7 |
| 369 | 2025-01-02 16:36:49 | catchments | 4 | 161450 | 186 | 49.763 | 3244.4 |
| 368 | 2025-01-01 22:45:29 | catchments | 4 | 161450 | 186 | 45.910 | 3516.7 |
| 367 | 2025-01-01 22:45:32 | catchments | 2 | 108824 | 5 | 15.656 | 6950.9 |
| 366 | 2024-12-21 00:40:26 | catchments | 1 | 67641 | 3 | 2.690 | 25145.4 |
| 365 | 2024-12-08 05:37:56 | catchments | 3 | 140603 | 23 | 27.610 | 5092.5 |
| 364 | 2024-12-08 05:34:02 | catchments | 1 | 67641 | 3 | 4.453 | 15190.0 |
| 363 | 2024-12-07 02:13:00 | catchments | 3 | 140603 | 23 | 32.503 | 4325.8 |
| 362 | 2024-12-05 16:50:55 | catchments | 3 | 140603 | 23 | 38.453 | 3656.5 |
| 361 | 2024-12-05 16:27:12 | catchments | 1 | 67641 | 3 | 8.453 | 8002.0 |
| 360 | 2024-12-04 01:13:06 | catchments | 3 | 140603 | 23 | 5.923 | 23738.5 |
| 359 | 2024-11-28 10:59:28 | catchments | 1 | 67641 | 3 | 2.296 | 29460.4 |
| 358 | 2024-11-19 07:50:38 | catchments | 2 | 108824 | 5 | 14.540 | 7484.5 |
| 357 | 2024-11-19 07:19:37 | catchments | 1 | 67641 | 3 | 1.110 | 60937.8 |
| 356 | 2024-11-04 03:01:06 | catchments | 1 | 67641 | 3 | 1.126 | 60071.9 |
| 355 | 2024-10-28 17:33:09 | catchments | 1 | 67641 | 3 | 1.266 | 53428.9 |
| 354 | 2024-10-28 13:10:15 | catchments | 3 | 140603 | 23 | 42.176 | 3333.7 |
| 353 | 2024-10-25 19:11:59 | catchments | 3 | 140603 | 23 | 29.203 | 4814.7 |
| 352 | 2024-10-25 19:11:50 | catchments | 2 | 108824 | 5 | 17.156 | 6343.2 |
| 351 | 2024-10-25 19:04:59 | catchments | 1 | 67641 | 3 | 3.280 | 20622.3 |
| 350 | 2024-10-10 06:39:25 | catchments | 2 | 108824 | 5 | 15.250 | 7136.0 |
| 349 | 2024-10-05 12:20:51 | catchments | 1 | 67641 | 3 | 9.546 | 7085.8 |
| 348 | 2024-09-30 20:37:02 | catchments | 2 | 108824 | 5 | 16.500 | 6595.4 |
| 347 | 2024-09-30 20:34:27 | catchments | 1 | 67641 | 3 | 7.860 | 8605.7 |
| 346 | 2024-09-18 05:00:44 | catchments | 3 | 140603 | 23 | 64.740 | 2171.8 |
| 345 | 2024-09-11 08:33:10 | catchments | 3 | 140603 | 23 | 52.563 | 2674.9 |
| 344 | 2024-08-23 02:42:17 | catchments | 1 | 67641 | 3 | 1.186 | 57032.9 |
| 343 | 2024-08-13 14:28:23 | catchments | 3 | 140603 | 23 | 44.503 | 3159.4 |
| 342 | 2024-08-13 14:27:20 | catchments | 3 | 140603 | 23 | 50.190 | 2801.4 |
| 341 | 2024-08-10 02:21:33 | catchments | 1 | 67641 | 3 | 3.626 | 18654.4 |
| 340 | 2024-07-31 02:35:54 | catchments | 3 | 140603 | 23 | 29.296 | 4799.4 |
| 339 | 2024-07-31 02:35:52 | catchments | 2 | 108824 | 5 | 12.546 | 8674.0 |
| 338 | 2024-07-31 02:35:47 | catchments | 3 | 140603 | 23 | 15.623 | 8999.7 |
| 337 | 2024-07-31 02:13:36 | catchments | 1 | 67641 | 3 | 1.233 | 54858.9 |
| 336 | 2024-07-22 23:58:33 | catchments | 3 | 140603 | 23 | 42.533 | 3305.7 |
| 335 | 2024-07-22 06:11:15 | catchments | 3 | 140603 | 23 | 20.546 | 6843.3 |
| 333 | 2024-07-22 06:11:12 | catchments | 3 | 140603 | 23 | 23.953 | 5870.0 |
| 332 | 2024-07-22 06:11:13 | catchments | 2 | 108824 | 5 | 12.500 | 8705.9 |
| 331 | 2024-07-22 06:07:20 | catchments | 1 | 67641 | 3 | 2.170 | 31171.0 |
| 330 | 2024-06-20 17:09:01 | catchments | 1 | 67641 | 3 | 4.280 | 15804.0 |
| 329 | 2024-06-16 03:40:28 | catchments | 3 | 140603 | 23 | 35.876 | 3919.1 |
| 328 | 2024-06-16 03:40:31 | catchments | 3 | 140603 | 23 | 22.143 | 6349.8 |
| 327 | 2024-06-15 16:39:51 | catchments | 2 | 108824 | 5 | 14.780 | 7362.9 |
| 326 | 2024-06-15 16:38:12 | catchments | 1 | 67641 | 3 | 5.953 | 11362.5 |
| 325 | 2024-06-15 13:37:49 | catchments | 3 | 140603 | 23 | 32.456 | 4332.1 |
| 324 | 2024-06-15 13:37:53 | catchments | 4 | 161450 | 186 | 28.050 | 5755.8 |
| 323 | 2024-06-15 13:37:47 | catchments | 2 | 108824 | 5 | 12.470 | 8726.9 |
| 322 | 2024-06-15 07:43:33 | catchments | 3 | 140603 | 23 | 22.940 | 6129.2 |
| 321 | 2024-06-15 03:30:07 | catchments | 4 | 161450 | 186 | 50.910 | 3171.3 |
| 320 | 2024-06-15 03:30:11 | catchments | 3 | 140603 | 23 | 26.580 | 5289.8 |
| 319 | 2024-06-15 03:30:11 | catchments | 2 | 108824 | 5 | 11.156 | 9754.8 |
| 318 | 2024-06-15 03:27:09 | catchments | 1 | 67641 | 3 | 5.360 | 12619.6 |
| 317 | 2024-06-04 14:03:45 | catchments | 1 | 67641 | 3 | 1.236 | 54725.7 |
| 316 | 2024-05-27 15:07:46 | catchments | 1 | 67641 | 3 | 2.750 | 24596.7 |
| 315 | 2024-05-24 00:07:39 | catchments | 4 | 161450 | 186 | 33.126 | 4873.8 |
| 314 | 2024-05-23 07:33:04 | catchments | 3 | 140603 | 23 | 20.660 | 6805.6 |
| 313 | 2024-05-22 23:56:08 | catchments | 4 | 161450 | 186 | 39.580 | 4079.1 |
| 312 | 2024-05-22 20:11:36 | catchments | 4 | 161450 | 186 | 26.173 | 6168.6 |
| 311 | 2024-05-22 20:11:38 | catchments | 3 | 140603 | 23 | 15.830 | 8882.1 |
| 310 | 2024-05-22 20:11:42 | catchments | 2 | 108824 | 5 | 6.576 | 16548.7 |
| 309 | 2024-05-22 20:07:21 | catchments | 1 | 67641 | 3 | 4.703 | 14382.5 |
| 308 | 2024-05-20 10:21:20 | catchments | 1 | 67641 | 3 | 2.970 | 22774.7 |
| 307 | 2024-05-16 15:38:03 | catchments | 1 | 67641 | 3 | 2.360 | 28661.4 |
| 306 | 2024-05-14 06:03:22 | catchments | 1 | 67641 | 3 | 1.173 | 57665.0 |
| 305 | 2024-05-05 03:17:39 | catchments | 1 | 67641 | 3 | 1.250 | 54112.8 |
| 304 | 2024-05-03 22:25:16 | catchments | 1 | 67641 | 3 | 1.750 | 38652.0 |
| 303 | 2024-04-27 18:11:15 | catchments | 2 | 108824 | 5 | 3.326 | 32719.2 |
| 302 | 2024-04-19 15:51:44 | catchments | 1 | 67641 | 3 | 1.296 | 52192.1 |
| 301 | 2024-04-12 14:48:13 | catchments | 3 | 140603 | 23 | 27.843 | 5049.9 |
| 300 | 2024-04-11 03:19:30 | catchments | 1 | 67641 | 3 | 1.220 | 55443.4 |
| 299 | 2024-04-10 19:34:55 | catchments | 1 | 67641 | 3 | 1.330 | 50857.9 |
| 298 | 2024-04-08 10:11:08 | catchments | 3 | 140603 | 23 | 20.720 | 6785.9 |
| 297 | 2024-04-07 23:07:42 | catchments | 1 | 67641 | 3 | 2.156 | 31373.4 |
| 296 | 2024-04-05 03:40:38 | catchments | 4 | 161450 | 186 | 13.753 | 11739.3 |
| 295 | 2024-04-04 19:23:04 | catchments | 3 | 140603 | 23 | 25.016 | 5620.5 |
| 294 | 2024-04-04 14:05:10 | catchments | 2 | 108824 | 5 | 3.750 | 29019.7 |
| 293 | 2024-04-04 14:04:48 | catchments | 4 | 161450 | 186 | 21.750 | 7423.0 |
| 292 | 2024-04-04 14:04:45 | catchments | 3 | 140603 | 23 | 17.690 | 7948.2 |
| 291 | 2024-04-04 13:55:40 | catchments | 1 | 67641 | 3 | 1.356 | 49882.7 |
| 290 | 2024-04-03 15:21:53 | catchments | 2 | 108824 | 5 | 3.686 | 29523.6 |
| 289 | 2024-04-02 19:42:02 | catchments | 1 | 67641 | 3 | 1.453 | 46552.6 |
| 288 | 2024-03-28 06:02:27 | catchments | 1 | 67641 | 3 | 1.160 | 58311.2 |
| 287 | 2024-03-16 09:26:22 | catchments | 3 | 140603 | 23 | 23.660 | 5942.6 |