History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"valved"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
401 | 2024-04-23 03:31:50 | valved | 1 | 48755 | 8 | 0.876 | 55656.4 |
400 | 2024-04-21 07:45:11 | valved | 3 | 112716 | 1059 | 11.500 | 9801.4 |
399 | 2024-04-20 21:21:04 | valved | 3 | 112716 | 1059 | 20.000 | 5635.8 |
398 | 2024-04-20 15:49:04 | valved | 3 | 112716 | 1059 | 13.143 | 8576.1 |
397 | 2024-04-18 20:38:12 | valved | 2 | 82551 | 84 | 2.516 | 32810.4 |
396 | 2024-04-18 20:37:00 | valved | 3 | 112716 | 1059 | 5.640 | 19985.1 |
395 | 2024-04-16 15:00:30 | valved | 2 | 82551 | 84 | 2.406 | 34310.5 |
394 | 2024-04-14 14:39:10 | valved | 3 | 112716 | 1059 | 14.686 | 7675.1 |
393 | 2024-04-14 14:38:08 | valved | 3 | 112716 | 1059 | 11.250 | 10019.2 |
392 | 2024-03-30 06:27:04 | valved | 1 | 48755 | 8 | 2.313 | 21078.7 |
391 | 2024-03-28 21:26:16 | valved | 2 | 82551 | 84 | 7.093 | 11638.4 |
390 | 2024-03-28 16:24:55 | valved | 2 | 82551 | 84 | 2.516 | 32810.4 |
389 | 2024-03-08 21:51:25 | valved | 2 | 82551 | 84 | 4.686 | 17616.5 |
388 | 2024-03-08 21:50:41 | valved | 3 | 112716 | 1059 | 5.610 | 20092.0 |
387 | 2024-03-08 17:40:51 | valved | 3 | 112716 | 1059 | 12.296 | 9166.9 |
386 | 2024-03-08 04:07:48 | valved | 3 | 112716 | 1059 | 16.313 | 6909.6 |
385 | 2024-03-07 21:54:57 | valved | 3 | 112716 | 1059 | 12.173 | 9259.5 |
384 | 2024-03-07 19:14:29 | valved | 2 | 82551 | 84 | 5.516 | 14965.7 |
383 | 2024-03-07 19:13:45 | valved | 3 | 112716 | 1059 | 6.126 | 18399.6 |
382 | 2024-03-07 06:17:45 | valved | 3 | 112716 | 1059 | 8.390 | 13434.6 |
381 | 2024-03-07 06:17:44 | valved | 2 | 82551 | 84 | 4.890 | 16881.6 |
380 | 2024-03-07 02:45:38 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
379 | 2024-03-01 09:40:04 | valved | 1 | 48755 | 8 | 1.030 | 47335.0 |
378 | 2024-01-21 18:35:01 | valved | 1 | 48755 | 8 | 0.720 | 67715.3 |
377 | 2024-01-17 18:17:45 | valved | 3 | 112716 | 1059 | 6.110 | 18447.8 |
376 | 2024-01-17 18:17:47 | valved | 2 | 82551 | 84 | 2.780 | 29694.6 |
375 | 2023-12-14 15:00:35 | valved | 2 | 82551 | 84 | 2.190 | 37694.5 |
374 | 2023-12-14 03:25:48 | valved | 3 | 112716 | 1059 | 4.856 | 23211.7 |
373 | 2023-11-18 22:53:51 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
372 | 2023-11-16 21:22:51 | valved | 1 | 48755 | 8 | 0.860 | 56691.9 |
371 | 2023-11-16 15:45:43 | valved | 1 | 48755 | 8 | 0.780 | 62506.4 |
370 | 2023-11-03 17:55:50 | valved | 1 | 48755 | 8 | 0.843 | 57835.1 |
369 | 2023-10-23 05:37:45 | valved | 1 | 48755 | 8 | 0.846 | 57630.0 |
368 | 2023-10-19 19:41:41 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
367 | 2023-10-14 05:35:38 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
366 | 2023-10-11 16:41:54 | valved | 3 | 112716 | 1059 | 5.656 | 19928.6 |
365 | 2023-10-09 01:18:21 | valved | 1 | 48755 | 8 | 0.830 | 58741.0 |
364 | 2023-10-09 01:15:56 | valved | 3 | 112716 | 1059 | 6.500 | 17340.9 |
363 | 2023-10-01 04:35:05 | valved | 3 | 112716 | 1059 | 5.936 | 18988.5 |
362 | 2023-09-29 13:07:35 | valved | 1 | 48755 | 8 | 0.826 | 59025.4 |
361 | 2023-09-27 14:57:28 | valved | 3 | 112716 | 1059 | 6.140 | 18357.7 |
360 | 2023-09-15 09:32:30 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
359 | 2023-09-15 06:22:43 | valved | 3 | 112716 | 1059 | 4.643 | 24276.5 |
358 | 2023-09-12 04:57:24 | valved | 2 | 82551 | 84 | 2.220 | 37185.1 |
357 | 2023-09-03 21:17:00 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
356 | 2023-06-18 02:25:21 | valved | 3 | 112716 | 1059 | 4.720 | 23880.5 |
355 | 2023-06-07 06:34:03 | valved | 1 | 48755 | 8 | 0.720 | 67715.3 |
354 | 2023-06-01 12:36:22 | valved | 2 | 82551 | 84 | 2.123 | 38884.1 |
353 | 2023-03-15 23:49:48 | valved | 3 | 112716 | 1059 | 5.220 | 21593.1 |
352 | 2023-03-09 13:39:51 | valved | 2 | 82551 | 84 | 2.093 | 39441.5 |
351 | 2023-02-11 22:28:12 | valved | 1 | 48755 | 8 | 0.720 | 67715.3 |
350 | 2023-02-08 12:03:19 | valved | 1 | 48755 | 8 | 0.720 | 67715.3 |
349 | 2023-01-25 14:06:35 | valved | 1 | 48755 | 8 | 0.703 | 69352.8 |
348 | 2022-12-24 03:59:00 | valved | 1 | 48755 | 8 | 1.610 | 30282.6 |
347 | 2022-12-17 14:47:07 | valved | 3 | 112716 | 1059 | 4.563 | 24702.2 |
346 | 2022-12-13 19:48:49 | valved | 2 | 82551 | 84 | 2.373 | 34787.6 |
345 | 2022-12-06 15:33:03 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
344 | 2022-11-15 10:48:30 | valved | 1 | 48755 | 8 | 0.810 | 60191.4 |
343 | 2022-09-18 13:14:05 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
342 | 2022-09-16 01:04:31 | valved | 1 | 48755 | 8 | 0.826 | 59025.4 |
341 | 2022-08-23 15:29:16 | valved | 1 | 48755 | 8 | 0.796 | 61250.0 |
340 | 2022-08-11 14:12:28 | valved | 3 | 112716 | 1059 | 4.593 | 24540.8 |
339 | 2022-08-02 15:17:47 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
338 | 2022-04-22 05:44:31 | valved | 1 | 48755 | 8 | 0.860 | 56691.9 |
337 | 2022-03-21 12:01:41 | valved | 1 | 48755 | 8 | 1.000 | 48755.0 |
336 | 2022-02-01 20:22:25 | valved | 2 | 82551 | 84 | 2.780 | 29694.6 |
335 | 2021-12-27 10:56:48 | valved | 1 | 48755 | 8 | 0.906 | 53813.5 |
334 | 2021-12-14 17:09:12 | valved | 1 | 48755 | 8 | 0.783 | 62266.9 |
333 | 2021-10-30 02:41:11 | valved | 1 | 48755 | 8 | 0.763 | 63899.1 |
332 | 2021-10-28 02:17:25 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
331 | 2021-09-16 07:47:42 | valved | 1 | 48755 | 8 | 0.736 | 66243.2 |
330 | 2021-09-14 04:33:34 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
329 | 2021-08-29 17:44:02 | valved | 1 | 48755 | 8 | 0.860 | 56691.9 |
328 | 2021-08-27 13:44:14 | valved | 1 | 48755 | 8 | 0.826 | 59025.4 |
327 | 2021-08-18 13:20:43 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |
326 | 2021-06-03 05:51:29 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
325 | 2021-05-19 01:39:40 | valved | 1 | 48755 | 8 | 0.826 | 59025.4 |
324 | 2021-05-09 00:59:16 | valved | 1 | 48755 | 8 | 1.673 | 29142.3 |
323 | 2021-05-07 17:01:07 | valved | 1 | 48755 | 8 | 0.920 | 52994.6 |
322 | 2021-04-07 13:27:57 | valved | 1 | 48755 | 8 | 0.763 | 63899.1 |
321 | 2021-01-22 15:21:01 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
320 | 2021-01-06 08:19:36 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
319 | 2020-11-27 10:11:37 | valved | 1 | 48755 | 8 | 0.750 | 65006.7 |
318 | 2020-10-04 01:14:42 | valved | 1 | 48755 | 8 | 1.580 | 30857.6 |
317 | 2020-09-26 06:30:04 | valved | 1 | 48755 | 8 | 0.813 | 59969.2 |
316 | 2020-08-26 12:15:46 | valved | 1 | 48755 | 8 | 0.860 | 56691.9 |
315 | 2020-08-18 11:26:36 | valved | 1 | 48755 | 8 | 0.766 | 63648.8 |
314 | 2020-07-28 23:02:32 | valved | 1 | 48755 | 8 | 0.830 | 58741.0 |
313 | 2020-07-23 16:41:30 | valved | 1 | 48755 | 8 | 1.530 | 31866.0 |
312 | 2020-07-20 03:24:25 | valved | 1 | 48755 | 8 | 0.796 | 61250.0 |
311 | 2020-07-16 17:24:48 | valved | 1 | 48755 | 8 | 0.830 | 58741.0 |
310 | 2020-06-17 14:23:29 | valved | 1 | 48755 | 8 | 0.783 | 62266.9 |
309 | 2020-06-14 03:38:54 | valved | 1 | 48755 | 8 | 0.810 | 60191.4 |
308 | 2020-06-13 03:41:14 | valved | 1 | 48755 | 8 | 0.766 | 63648.8 |
307 | 2020-06-05 13:31:13 | valved | 1 | 48755 | 8 | 0.736 | 66243.2 |
306 | 2020-03-28 05:42:51 | valved | 1 | 48755 | 8 | 1.173 | 41564.4 |
305 | 2020-03-24 12:24:45 | valved | 1 | 48755 | 8 | 0.876 | 55656.4 |
304 | 2020-03-23 09:02:41 | valved | 1 | 48755 | 8 | 0.893 | 54596.9 |
303 | 2020-03-18 20:38:00 | valved | 1 | 48755 | 8 | 0.830 | 58741.0 |
302 | 2020-03-17 21:45:54 | valved | 1 | 48755 | 8 | 0.733 | 66514.3 |