History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"drought"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
394 | 2025-05-22 03:16:10 | drought | 1 | 69583 | 7 | 5.703 | 12201.1 |
393 | 2025-05-17 02:16:02 | drought | 1 | 69583 | 7 | 1.186 | 58670.3 |
392 | 2025-05-05 09:02:16 | drought | 1 | 69583 | 7 | 1.266 | 54962.9 |
391 | 2025-05-02 01:54:07 | drought | 1 | 69583 | 7 | 2.940 | 23667.7 |
390 | 2025-05-01 08:47:00 | drought | 1 | 69583 | 7 | 1.190 | 58473.1 |
389 | 2025-05-01 02:39:52 | drought | 1 | 69583 | 7 | 5.783 | 12032.3 |
388 | 2025-04-20 02:29:05 | drought | 1 | 69583 | 7 | 3.000 | 23194.3 |
387 | 2025-04-11 00:34:21 | drought | 3 | 134027 | 136 | 32.983 | 4063.5 |
386 | 2025-04-09 18:31:04 | drought | 1 | 69583 | 7 | 5.686 | 12237.6 |
385 | 2025-04-09 17:04:17 | drought | 3 | 134027 | 136 | 49.363 | 2715.1 |
384 | 2025-04-08 00:30:37 | drought | 3 | 134027 | 136 | 35.190 | 3808.7 |
383 | 2025-04-05 20:30:04 | drought | 3 | 134027 | 136 | 34.453 | 3890.1 |
382 | 2025-04-04 08:13:15 | drought | 1 | 69583 | 7 | 5.703 | 12201.1 |
381 | 2025-04-04 00:22:27 | drought | 1 | 69583 | 7 | 2.873 | 24219.6 |
380 | 2025-03-31 03:57:14 | drought | 1 | 69583 | 7 | 5.936 | 11722.2 |
379 | 2025-03-20 04:00:57 | drought | 1 | 69583 | 7 | 3.623 | 19205.9 |
378 | 2025-03-18 06:57:43 | drought | 1 | 69583 | 7 | 8.000 | 8697.9 |
377 | 2025-03-18 04:12:53 | drought | 3 | 134027 | 136 | 28.110 | 4767.9 |
376 | 2025-03-15 18:21:18 | drought | 3 | 134027 | 136 | 25.486 | 5258.8 |
375 | 2025-03-15 14:56:49 | drought | 3 | 134027 | 136 | 46.113 | 2906.5 |
374 | 2025-03-14 03:55:00 | drought | 3 | 134027 | 136 | 46.643 | 2873.5 |
373 | 2025-03-09 23:47:07 | drought | 1 | 69583 | 7 | 7.810 | 8909.5 |
372 | 2025-03-05 22:06:14 | drought | 2 | 107671 | 29 | 22.376 | 4811.9 |
371 | 2025-03-05 01:38:33 | drought | 2 | 107671 | 29 | 14.196 | 7584.6 |
370 | 2025-03-05 01:38:22 | drought | 1 | 69583 | 7 | 4.370 | 15922.9 |
369 | 2025-03-01 07:43:32 | drought | 1 | 69583 | 7 | 5.826 | 11943.5 |
368 | 2025-02-25 19:43:32 | drought | 1 | 69583 | 7 | 9.110 | 7638.1 |
367 | 2025-02-12 19:23:16 | drought | 3 | 134027 | 136 | 35.660 | 3758.5 |
366 | 2025-02-07 19:47:05 | drought | 3 | 134027 | 136 | 10.910 | 12284.8 |
365 | 2025-02-07 16:04:00 | drought | 3 | 134027 | 136 | 21.203 | 6321.1 |
364 | 2025-02-05 07:25:00 | drought | 1 | 69583 | 7 | 1.063 | 65459.1 |
363 | 2025-02-04 11:25:58 | drought | 1 | 69583 | 7 | 3.033 | 22942.0 |
362 | 2025-01-23 06:03:28 | drought | 2 | 107671 | 29 | 16.186 | 6652.1 |
361 | 2025-01-21 23:48:19 | drought | 2 | 107671 | 29 | 13.530 | 7957.9 |
360 | 2025-01-20 20:14:01 | drought | 2 | 107671 | 29 | 16.080 | 6696.0 |
359 | 2025-01-20 14:39:44 | drought | 2 | 107671 | 29 | 8.203 | 13125.8 |
358 | 2025-01-20 14:38:47 | drought | 1 | 69583 | 7 | 2.940 | 23667.7 |
357 | 2025-01-14 05:47:21 | drought | 3 | 134027 | 136 | 49.243 | 2721.7 |
356 | 2025-01-09 22:45:48 | drought | 3 | 134027 | 136 | 45.906 | 2919.6 |
355 | 2025-01-08 08:53:20 | drought | 3 | 134027 | 136 | 35.036 | 3825.4 |
354 | 2025-01-07 19:56:28 | drought | 3 | 134027 | 136 | 15.060 | 8899.5 |
353 | 2024-12-29 14:15:21 | drought | 1 | 69583 | 7 | 8.253 | 8431.2 |
352 | 2024-12-10 18:31:36 | drought | 2 | 107671 | 29 | 9.126 | 11798.3 |
351 | 2024-12-09 01:17:01 | drought | 3 | 134027 | 136 | 37.580 | 3566.4 |
350 | 2024-12-08 02:31:50 | drought | 3 | 134027 | 136 | 29.093 | 4606.8 |
349 | 2024-12-07 09:57:14 | drought | 2 | 107671 | 29 | 18.563 | 5800.3 |
348 | 2024-12-07 09:56:57 | drought | 3 | 134027 | 136 | 34.146 | 3925.1 |
347 | 2024-12-07 03:08:27 | drought | 3 | 134027 | 136 | 8.640 | 15512.4 |
346 | 2024-12-07 03:08:17 | drought | 2 | 107671 | 29 | 3.876 | 27778.9 |
345 | 2024-12-02 06:32:12 | drought | 2 | 107671 | 29 | 11.046 | 9747.5 |
344 | 2024-11-27 10:14:50 | drought | 1 | 69583 | 7 | 3.296 | 21111.3 |
343 | 2024-11-24 05:44:40 | drought | 1 | 69583 | 7 | 5.656 | 12302.5 |
342 | 2024-11-07 00:07:02 | drought | 2 | 107671 | 29 | 3.390 | 31761.4 |
341 | 2024-11-07 00:06:50 | drought | 3 | 134027 | 136 | 6.593 | 20328.7 |
340 | 2024-11-05 05:34:20 | drought | 2 | 107671 | 29 | 10.546 | 10209.7 |
339 | 2024-11-04 01:37:32 | drought | 2 | 107671 | 29 | 19.940 | 5399.7 |
338 | 2024-11-04 01:33:15 | drought | 3 | 134027 | 136 | 7.093 | 18895.7 |
337 | 2024-11-02 23:11:58 | drought | 3 | 134027 | 136 | 28.330 | 4730.9 |
336 | 2024-11-02 03:42:50 | drought | 3 | 134027 | 136 | 41.863 | 3201.6 |
335 | 2024-11-02 03:42:55 | drought | 2 | 107671 | 29 | 15.936 | 6756.5 |
334 | 2024-11-02 03:40:08 | drought | 1 | 69583 | 7 | 8.330 | 8353.3 |
333 | 2024-10-27 09:33:10 | drought | 1 | 69583 | 7 | 4.326 | 16084.8 |
332 | 2024-10-27 09:22:08 | drought | 1 | 69583 | 7 | 1.236 | 56296.9 |
331 | 2024-10-24 23:25:50 | drought | 1 | 69583 | 7 | 4.920 | 14142.9 |
330 | 2024-10-09 18:11:33 | drought | 1 | 69583 | 7 | 1.186 | 58670.3 |
329 | 2024-09-28 12:19:29 | drought | 1 | 69583 | 7 | 8.813 | 7895.5 |
328 | 2024-09-14 14:07:21 | drought | 1 | 69583 | 7 | 8.550 | 8138.4 |
327 | 2024-08-30 23:54:11 | drought | 1 | 69583 | 7 | 9.610 | 7240.7 |
326 | 2024-08-27 20:29:04 | drought | 1 | 69583 | 7 | 8.780 | 7925.2 |
325 | 2024-08-12 22:02:05 | drought | 2 | 107671 | 29 | 18.626 | 5780.7 |
324 | 2024-08-11 21:44:03 | drought | 1 | 69583 | 7 | 5.610 | 12403.4 |
323 | 2024-08-11 14:21:47 | drought | 2 | 107671 | 29 | 12.113 | 8888.9 |
322 | 2024-08-11 14:20:58 | drought | 1 | 69583 | 7 | 2.250 | 30925.8 |
321 | 2024-08-09 14:55:45 | drought | 1 | 69583 | 7 | 4.406 | 15792.8 |
320 | 2024-08-03 12:52:47 | drought | 3 | 134027 | 136 | 26.033 | 5148.4 |
319 | 2024-08-02 10:37:17 | drought | 3 | 134027 | 136 | 27.690 | 4840.3 |
318 | 2024-08-01 23:23:05 | drought | 3 | 134027 | 136 | 30.220 | 4435.0 |
317 | 2024-08-01 14:46:40 | drought | 3 | 134027 | 136 | 30.330 | 4419.0 |
316 | 2024-07-31 23:28:20 | drought | 3 | 134027 | 136 | 31.576 | 4244.6 |
315 | 2024-07-31 23:28:19 | drought | 2 | 107671 | 29 | 6.700 | 16070.3 |
314 | 2024-07-31 23:27:53 | drought | 1 | 69583 | 7 | 2.390 | 29114.2 |
313 | 2024-07-22 02:16:45 | drought | 1 | 69583 | 7 | 3.390 | 20526.0 |
312 | 2024-07-19 21:01:23 | drought | 1 | 69583 | 7 | 2.766 | 25156.5 |
311 | 2024-07-06 09:58:42 | drought | 1 | 69583 | 7 | 6.423 | 10833.4 |
310 | 2024-06-29 22:43:36 | drought | 1 | 69583 | 7 | 3.093 | 22496.9 |
309 | 2024-06-18 08:30:26 | drought | 1 | 69583 | 7 | 4.266 | 16311.1 |
308 | 2024-06-15 07:45:29 | drought | 1 | 69583 | 7 | 2.156 | 32274.1 |
307 | 2024-05-30 12:51:05 | drought | 1 | 69583 | 7 | 6.076 | 11452.1 |
306 | 2024-05-28 05:40:56 | drought | 1 | 69583 | 7 | 4.796 | 14508.5 |
305 | 2024-05-10 05:33:45 | drought | 1 | 69583 | 7 | 1.173 | 59320.5 |
304 | 2024-05-06 23:07:15 | drought | 1 | 69583 | 7 | 2.343 | 29698.3 |
303 | 2024-04-30 13:03:34 | drought | 1 | 69583 | 7 | 1.453 | 47889.2 |
302 | 2024-03-28 10:16:30 | drought | 1 | 69583 | 7 | 1.233 | 56433.9 |
301 | 2024-02-25 22:27:33 | drought | 1 | 69583 | 7 | 1.296 | 53690.6 |
300 | 2024-01-29 05:18:02 | drought | 3 | 134027 | 136 | 6.393 | 20964.6 |
299 | 2024-01-21 09:36:48 | drought | 1 | 69583 | 7 | 1.216 | 57222.9 |
298 | 2023-12-10 04:35:39 | drought | 3 | 134027 | 136 | 6.626 | 20227.4 |
297 | 2023-12-10 04:35:36 | drought | 2 | 107671 | 29 | 3.330 | 32333.6 |
296 | 2023-12-02 03:28:22 | drought | 2 | 107671 | 29 | 3.140 | 34290.1 |
295 | 2023-12-02 03:28:18 | drought | 3 | 134027 | 136 | 6.546 | 20474.6 |