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 |
416 | 2025-08-29 03:04:13 | drought | 1 | 69583 | 7 | 1.140 | 61037.7 |
415 | 2025-08-27 01:54:54 | drought | 1 | 69583 | 7 | 1.343 | 51811.6 |
414 | 2025-08-25 01:09:58 | drought | 1 | 69583 | 7 | 2.923 | 23805.3 |
413 | 2025-08-13 08:01:55 | drought | 1 | 69583 | 7 | 5.626 | 12368.1 |
412 | 2025-08-12 08:09:05 | drought | 1 | 69583 | 7 | 3.640 | 19116.2 |
411 | 2025-08-11 16:50:30 | drought | 3 | 134027 | 136 | 15.610 | 8586.0 |
410 | 2025-08-10 07:38:27 | drought | 3 | 134027 | 136 | 18.750 | 7148.1 |
409 | 2025-08-05 02:35:16 | drought | 3 | 134027 | 136 | 16.860 | 7949.4 |
408 | 2025-08-01 18:12:04 | drought | 3 | 134027 | 136 | 17.690 | 7576.4 |
407 | 2025-08-01 16:15:48 | drought | 3 | 134027 | 136 | 32.516 | 4121.9 |
406 | 2025-08-01 10:47:16 | drought | 1 | 69583 | 7 | 2.940 | 23667.7 |
405 | 2025-07-27 18:31:36 | drought | 3 | 134027 | 136 | 36.546 | 3667.4 |
404 | 2025-07-27 09:31:48 | drought | 2 | 107671 | 29 | 11.780 | 9140.2 |
403 | 2025-07-27 03:23:58 | drought | 1 | 69583 | 7 | 2.733 | 25460.3 |
402 | 2025-07-26 15:35:12 | drought | 1 | 69583 | 7 | 6.563 | 10602.3 |
401 | 2025-07-25 01:12:12 | drought | 1 | 69583 | 7 | 5.923 | 11747.9 |
400 | 2025-07-24 03:30:27 | drought | 1 | 69583 | 7 | 5.516 | 12614.8 |
399 | 2025-07-21 09:55:14 | drought | 1 | 69583 | 7 | 1.186 | 58670.3 |
398 | 2025-07-11 03:59:01 | drought | 1 | 69583 | 7 | 12.236 | 5686.7 |
397 | 2025-07-08 09:09:59 | drought | 1 | 69583 | 7 | 4.390 | 15850.3 |
396 | 2025-06-24 03:09:17 | drought | 1 | 69583 | 7 | 7.953 | 8749.3 |
395 | 2025-06-23 14:16:59 | drought | 1 | 69583 | 7 | 1.216 | 57222.9 |
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 |