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 |
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 |
260 | 2024-07-04 07:46:13 | coliforms | 2 | 121436 | 4 | 7.390 | 16432.5 |
259 | 2024-07-04 07:45:17 | coliforms | 1 | 81242 | 2 | 5.580 | 14559.5 |
258 | 2024-06-25 07:45:55 | coliforms | 4 | 165329 | 252 | 40.770 | 4055.2 |
257 | 2024-06-24 18:13:09 | coliforms | 4 | 165329 | 252 | 62.050 | 2664.4 |