History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coliforms"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 360 | 2025-11-06 22:39:48 | coliforms | 4 | 165329 | 252 | 11.720 | 14106.6 |
| 359 | 2025-10-23 21:12:34 | coliforms | 1 | 81242 | 2 | 3.843 | 21140.3 |
| 358 | 2025-10-23 02:56:24 | coliforms | 1 | 81242 | 2 | 5.030 | 16151.5 |
| 357 | 2025-09-12 06:56:00 | coliforms | 4 | 165329 | 252 | 24.410 | 6773.0 |
| 356 | 2025-09-03 05:55:07 | coliforms | 3 | 148641 | 30 | 7.390 | 20113.8 |
| 355 | 2025-08-29 12:55:11 | coliforms | 3 | 148641 | 30 | 6.486 | 22917.2 |
| 354 | 2025-08-26 21:12:17 | coliforms | 1 | 81242 | 2 | 1.440 | 56418.1 |
| 353 | 2025-08-25 23:27:33 | coliforms | 2 | 121436 | 4 | 3.406 | 35653.6 |
| 352 | 2025-08-25 13:19:08 | coliforms | 3 | 148641 | 30 | 28.046 | 5299.9 |
| 351 | 2025-08-24 16:26:05 | coliforms | 4 | 165329 | 252 | 11.550 | 14314.2 |
| 350 | 2025-08-22 05:30:07 | coliforms | 4 | 165329 | 252 | 13.330 | 12402.8 |
| 349 | 2025-08-14 05:00:49 | coliforms | 1 | 81242 | 2 | 1.453 | 55913.3 |
| 348 | 2025-08-04 03:49:41 | coliforms | 2 | 121436 | 4 | 3.546 | 34245.9 |
| 347 | 2025-08-01 09:13:47 | coliforms | 3 | 148641 | 30 | 19.733 | 7532.6 |
| 346 | 2025-07-25 04:39:50 | coliforms | 1 | 81242 | 2 | 6.093 | 13333.7 |
| 345 | 2025-07-24 23:56:30 | coliforms | 1 | 81242 | 2 | 3.453 | 23527.9 |
| 344 | 2025-07-24 06:31:19 | coliforms | 1 | 81242 | 2 | 6.186 | 13133.2 |
| 343 | 2025-07-21 08:06:31 | coliforms | 1 | 81242 | 2 | 2.953 | 27511.7 |
| 342 | 2025-07-14 02:15:14 | coliforms | 4 | 165329 | 252 | 74.973 | 2205.2 |
| 341 | 2025-07-13 22:17:03 | coliforms | 4 | 165329 | 252 | 69.126 | 2391.7 |
| 340 | 2025-07-13 03:40:37 | coliforms | 4 | 165329 | 252 | 20.873 | 7920.7 |
| 339 | 2025-07-12 19:55:04 | coliforms | 1 | 81242 | 2 | 2.486 | 32679.8 |
| 338 | 2025-07-07 01:34:42 | coliforms | 1 | 81242 | 2 | 3.950 | 20567.6 |
| 337 | 2025-07-06 11:54:10 | coliforms | 1 | 81242 | 2 | 1.330 | 61084.2 |
| 336 | 2025-06-18 15:46:14 | coliforms | 1 | 81242 | 2 | 4.533 | 17922.3 |
| 335 | 2025-06-15 12:48:23 | coliforms | 1 | 81242 | 2 | 1.373 | 59171.2 |
| 334 | 2025-06-13 16:17:38 | coliforms | 1 | 81242 | 2 | 1.436 | 56575.2 |
| 333 | 2025-06-13 10:01:57 | coliforms | 1 | 81242 | 2 | 6.670 | 12180.2 |
| 332 | 2025-06-03 15:14:11 | coliforms | 4 | 165329 | 252 | 52.896 | 3125.5 |
| 331 | 2025-05-31 22:43:03 | coliforms | 1 | 81242 | 2 | 7.016 | 11579.5 |
| 330 | 2025-05-31 21:44:05 | coliforms | 1 | 81242 | 2 | 6.750 | 12035.9 |
| 329 | 2025-05-31 09:47:48 | coliforms | 4 | 165329 | 252 | 60.890 | 2715.2 |
| 328 | 2025-05-28 20:40:44 | coliforms | 4 | 165329 | 252 | 45.486 | 3634.7 |
| 327 | 2025-05-27 06:09:22 | coliforms | 4 | 165329 | 252 | 60.660 | 2725.5 |
| 326 | 2025-05-24 06:30:17 | coliforms | 4 | 165329 | 252 | 59.920 | 2759.2 |
| 325 | 2025-05-24 06:27:02 | coliforms | 2 | 121436 | 4 | 30.503 | 3981.1 |
| 324 | 2025-05-23 05:25:33 | coliforms | 1 | 81242 | 2 | 10.330 | 7864.7 |
| 323 | 2025-04-28 01:28:39 | coliforms | 1 | 81242 | 2 | 5.983 | 13578.8 |
| 322 | 2025-04-23 16:51:34 | coliforms | 1 | 81242 | 2 | 6.906 | 11764.0 |
| 321 | 2025-04-23 10:58:39 | coliforms | 1 | 81242 | 2 | 5.466 | 14863.2 |
| 320 | 2025-04-23 05:02:41 | coliforms | 1 | 81242 | 2 | 10.186 | 7975.8 |
| 319 | 2025-04-02 00:51:25 | coliforms | 1 | 81242 | 2 | 7.563 | 10742.0 |
| 318 | 2025-03-26 23:33:32 | coliforms | 1 | 81242 | 2 | 7.330 | 11083.5 |
| 317 | 2025-03-23 13:18:04 | coliforms | 1 | 81242 | 2 | 5.360 | 15157.1 |
| 316 | 2025-03-23 06:56:08 | coliforms | 1 | 81242 | 2 | 3.643 | 22300.9 |
| 315 | 2025-02-28 22:33:16 | coliforms | 3 | 148641 | 30 | 23.203 | 6406.1 |
| 314 | 2025-02-26 22:52:36 | coliforms | 3 | 148641 | 30 | 36.610 | 4060.1 |
| 313 | 2025-02-19 17:42:22 | coliforms | 1 | 81242 | 2 | 6.766 | 12007.4 |
| 312 | 2025-02-09 23:12:16 | coliforms | 2 | 121436 | 4 | 18.893 | 6427.6 |
| 311 | 2025-02-09 23:10:31 | coliforms | 1 | 81242 | 2 | 7.686 | 10570.1 |
| 310 | 2025-02-01 01:47:23 | coliforms | 1 | 81242 | 2 | 7.076 | 11481.3 |
| 309 | 2025-01-30 07:00:40 | coliforms | 3 | 148641 | 30 | 37.890 | 3923.0 |
| 308 | 2025-01-29 18:47:28 | coliforms | 1 | 81242 | 2 | 3.033 | 26786.0 |
| 307 | 2025-01-21 03:55:05 | coliforms | 3 | 148641 | 30 | 40.643 | 3657.2 |
| 306 | 2025-01-11 21:42:59 | coliforms | 3 | 148641 | 30 | 43.910 | 3385.1 |
| 305 | 2024-12-30 07:38:27 | coliforms | 3 | 148641 | 30 | 43.173 | 3442.9 |
| 304 | 2024-12-30 03:05:03 | coliforms | 1 | 81242 | 2 | 4.700 | 17285.5 |
| 303 | 2024-12-28 09:42:08 | coliforms | 3 | 148641 | 30 | 38.066 | 3904.8 |
| 302 | 2024-12-28 09:41:50 | coliforms | 3 | 148641 | 30 | 35.923 | 4137.8 |
| 301 | 2024-12-28 09:42:00 | coliforms | 2 | 121436 | 4 | 16.686 | 7277.7 |
| 300 | 2024-12-28 09:41:41 | coliforms | 1 | 81242 | 2 | 4.280 | 18981.8 |
| 299 | 2024-12-07 23:35:54 | coliforms | 3 | 148641 | 30 | 57.383 | 2590.3 |
| 298 | 2024-11-27 21:19:12 | coliforms | 1 | 81242 | 2 | 3.173 | 25604.2 |
| 297 | 2024-11-26 18:03:31 | coliforms | 1 | 81242 | 2 | 6.123 | 13268.3 |
| 296 | 2024-11-25 20:31:15 | coliforms | 1 | 81242 | 2 | 7.406 | 10969.8 |
| 295 | 2024-11-24 22:11:27 | coliforms | 3 | 148641 | 30 | 35.750 | 4157.8 |
| 294 | 2024-11-19 16:24:50 | coliforms | 3 | 148641 | 30 | 18.906 | 7862.1 |
| 293 | 2024-11-18 01:10:28 | coliforms | 3 | 148641 | 30 | 34.986 | 4248.6 |
| 292 | 2024-11-16 07:59:16 | coliforms | 3 | 148641 | 30 | 31.796 | 4674.8 |
| 291 | 2024-10-29 17:13:09 | coliforms | 1 | 81242 | 2 | 1.923 | 42247.5 |
| 290 | 2024-10-20 02:45:51 | coliforms | 2 | 121436 | 4 | 15.346 | 7913.2 |
| 289 | 2024-10-19 17:37:35 | coliforms | 3 | 148641 | 30 | 34.643 | 4290.7 |
| 288 | 2024-10-19 08:26:57 | coliforms | 3 | 148641 | 30 | 46.223 | 3215.7 |
| 287 | 2024-10-19 08:27:01 | coliforms | 2 | 121436 | 4 | 18.656 | 6509.2 |
| 286 | 2024-10-19 08:24:11 | coliforms | 1 | 81242 | 2 | 3.080 | 26377.3 |
| 285 | 2024-10-18 19:43:41 | coliforms | 3 | 148641 | 30 | 45.206 | 3288.1 |
| 284 | 2024-10-18 14:25:40 | coliforms | 1 | 81242 | 2 | 7.233 | 11232.1 |
| 283 | 2024-10-16 20:34:30 | coliforms | 3 | 148641 | 30 | 37.533 | 3960.3 |
| 282 | 2024-10-16 09:53:00 | coliforms | 3 | 148641 | 30 | 45.236 | 3285.9 |
| 281 | 2024-10-16 09:07:20 | coliforms | 3 | 148641 | 30 | 40.830 | 3640.5 |
| 280 | 2024-10-16 03:28:49 | coliforms | 4 | 165329 | 252 | 69.410 | 2381.9 |
| 279 | 2024-10-16 03:28:56 | coliforms | 3 | 148641 | 30 | 39.253 | 3786.7 |
| 278 | 2024-10-16 03:28:40 | coliforms | 2 | 121436 | 4 | 18.360 | 6614.2 |
| 277 | 2024-10-16 03:26:48 | coliforms | 1 | 81242 | 2 | 6.626 | 12261.1 |
| 276 | 2024-08-10 05:36:17 | coliforms | 3 | 148641 | 30 | 25.970 | 5723.6 |
| 275 | 2024-07-29 12:05:12 | coliforms | 1 | 81242 | 2 | 4.813 | 16879.7 |
| 274 | 2024-07-29 07:39:22 | coliforms | 3 | 148641 | 30 | 36.300 | 4094.8 |
| 273 | 2024-07-28 19:36:19 | coliforms | 3 | 148641 | 30 | 34.426 | 4317.7 |
| 272 | 2024-07-28 15:50:47 | coliforms | 4 | 165329 | 252 | 63.206 | 2615.7 |
| 271 | 2024-07-28 15:50:30 | coliforms | 3 | 148641 | 30 | 24.813 | 5990.4 |
| 270 | 2024-07-27 16:47:03 | coliforms | 4 | 165329 | 252 | 54.533 | 3031.7 |
| 269 | 2024-07-24 20:43:48 | coliforms | 4 | 165329 | 252 | 59.943 | 2758.1 |
| 268 | 2024-07-24 18:35:54 | coliforms | 3 | 148641 | 30 | 27.253 | 5454.1 |
| 267 | 2024-07-24 18:36:00 | coliforms | 2 | 121436 | 4 | 6.860 | 17702.0 |
| 266 | 2024-07-24 18:33:07 | coliforms | 1 | 81242 | 2 | 4.330 | 18762.6 |
| 265 | 2024-07-24 18:28:20 | coliforms | 3 | 148641 | 30 | 23.393 | 6354.1 |
| 264 | 2024-07-24 10:51:01 | coliforms | 4 | 165329 | 252 | 49.423 | 3345.2 |
| 263 | 2024-07-24 10:50:57 | coliforms | 3 | 148641 | 30 | 34.703 | 4283.2 |
| 262 | 2024-07-24 10:51:02 | coliforms | 2 | 121436 | 4 | 15.546 | 7811.4 |
| 261 | 2024-07-24 10:50:00 | coliforms | 1 | 81242 | 2 | 6.593 | 12322.5 |