History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preach"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
392 | 2024-05-02 23:07:16 | preach | 1 | 48755 | 8 | 0.860 | 56691.9 |
391 | 2024-04-07 17:22:56 | preach | 2 | 82551 | 45 | 6.346 | 13008.4 |
390 | 2024-04-07 06:46:31 | preach | 3 | 112716 | 499 | 11.766 | 9579.8 |
389 | 2024-04-06 11:59:43 | preach | 3 | 112716 | 499 | 8.860 | 12721.9 |
388 | 2024-04-06 07:56:45 | preach | 2 | 82551 | 45 | 8.046 | 10259.9 |
387 | 2024-04-06 05:05:16 | preach | 3 | 112716 | 499 | 7.143 | 15779.9 |
386 | 2024-04-05 05:46:42 | preach | 3 | 112716 | 499 | 12.876 | 8754.0 |
385 | 2024-04-05 05:46:43 | preach | 2 | 82551 | 45 | 3.830 | 21553.8 |
384 | 2024-04-05 05:46:22 | preach | 3 | 112716 | 499 | 18.346 | 6143.9 |
383 | 2024-04-05 05:46:33 | preach | 1 | 48755 | 8 | 3.423 | 14243.4 |
382 | 2024-04-05 05:46:23 | preach | 2 | 82551 | 45 | 3.966 | 20814.7 |
381 | 2024-04-05 05:46:20 | preach | 1 | 48755 | 8 | 2.140 | 22782.7 |
380 | 2024-03-28 19:47:45 | preach | 1 | 48755 | 8 | 2.890 | 16870.2 |
379 | 2024-03-07 10:57:46 | preach | 2 | 82551 | 45 | 11.516 | 7168.4 |
378 | 2024-03-07 08:40:23 | preach | 3 | 112716 | 499 | 18.156 | 6208.2 |
377 | 2024-03-06 04:30:21 | preach | 1 | 48755 | 8 | 1.936 | 25183.4 |
376 | 2024-03-06 04:29:21 | preach | 3 | 112716 | 499 | 13.160 | 8565.0 |
375 | 2024-03-06 04:29:19 | preach | 2 | 82551 | 45 | 7.173 | 11508.6 |
374 | 2024-03-06 04:28:55 | preach | 3 | 112716 | 499 | 17.406 | 6475.7 |
373 | 2024-03-06 04:29:08 | preach | 1 | 48755 | 8 | 1.906 | 25579.7 |
372 | 2024-03-06 04:28:54 | preach | 2 | 82551 | 45 | 6.826 | 12093.6 |
371 | 2024-02-26 08:39:03 | preach | 1 | 48755 | 8 | 1.220 | 39963.1 |
370 | 2024-01-27 03:48:21 | preach | 1 | 48755 | 8 | 1.720 | 28345.9 |
369 | 2024-01-13 17:55:03 | preach | 1 | 48755 | 8 | 0.906 | 53813.5 |
368 | 2024-01-04 13:54:50 | preach | 3 | 112716 | 499 | 4.876 | 23116.5 |
367 | 2023-12-30 19:40:07 | preach | 2 | 82551 | 45 | 4.393 | 18791.5 |
366 | 2023-12-27 22:40:20 | preach | 1 | 48755 | 8 | 1.780 | 27390.4 |
365 | 2023-12-07 21:14:44 | preach | 3 | 112716 | 499 | 5.453 | 20670.5 |
364 | 2023-12-07 21:14:38 | preach | 3 | 112716 | 499 | 5.783 | 19490.9 |
363 | 2023-12-05 07:23:26 | preach | 3 | 112716 | 499 | 5.236 | 21527.1 |
362 | 2023-12-05 07:23:22 | preach | 2 | 82551 | 45 | 2.436 | 33887.9 |
361 | 2023-11-28 12:20:37 | preach | 1 | 48755 | 8 | 0.826 | 59025.4 |
360 | 2023-11-14 15:15:16 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
359 | 2023-11-09 20:11:54 | preach | 1 | 48755 | 8 | 0.826 | 59025.4 |
358 | 2023-11-03 06:30:45 | preach | 1 | 48755 | 8 | 0.766 | 63648.8 |
357 | 2023-10-28 02:32:58 | preach | 1 | 48755 | 8 | 0.843 | 57835.1 |
356 | 2023-10-18 16:53:27 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
355 | 2023-10-11 06:41:27 | preach | 1 | 48755 | 8 | 0.826 | 59025.4 |
354 | 2023-10-07 11:21:46 | preach | 1 | 48755 | 8 | 0.843 | 57835.1 |
353 | 2023-09-29 02:51:28 | preach | 1 | 48755 | 8 | 1.763 | 27654.6 |
352 | 2023-09-14 02:51:37 | preach | 1 | 48755 | 8 | 0.826 | 59025.4 |
351 | 2023-08-29 05:21:29 | preach | 1 | 48755 | 8 | 0.830 | 58741.0 |
350 | 2023-08-22 04:14:35 | preach | 1 | 48755 | 8 | 0.953 | 51159.5 |
349 | 2023-06-01 16:28:50 | preach | 1 | 48755 | 8 | 0.796 | 61250.0 |
348 | 2023-04-30 23:16:37 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
347 | 2023-03-26 01:04:18 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
346 | 2023-03-02 23:33:25 | preach | 1 | 48755 | 8 | 0.876 | 55656.4 |
345 | 2023-01-14 22:55:10 | preach | 1 | 48755 | 8 | 0.733 | 66514.3 |
344 | 2023-01-09 14:07:12 | preach | 1 | 48755 | 8 | 0.766 | 63648.8 |
343 | 2022-10-13 03:59:41 | preach | 1 | 48755 | 8 | 0.830 | 58741.0 |
342 | 2022-09-16 14:00:09 | preach | 1 | 48755 | 8 | 0.830 | 58741.0 |
341 | 2022-06-02 04:28:19 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
340 | 2022-05-14 06:47:03 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
339 | 2022-05-10 21:21:53 | preach | 1 | 48755 | 8 | 0.953 | 51159.5 |
338 | 2022-02-12 02:05:21 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
337 | 2022-01-23 00:48:25 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
336 | 2021-12-03 15:24:31 | preach | 1 | 48755 | 8 | 0.860 | 56691.9 |
335 | 2021-10-13 03:28:33 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
334 | 2021-10-11 01:26:43 | preach | 1 | 48755 | 8 | 0.796 | 61250.0 |
333 | 2021-10-09 23:52:58 | preach | 1 | 48755 | 8 | 0.843 | 57835.1 |
332 | 2021-09-19 22:59:59 | preach | 1 | 48755 | 8 | 0.936 | 52088.7 |
331 | 2021-07-28 04:22:16 | preach | 1 | 48755 | 8 | 0.736 | 66243.2 |
330 | 2021-05-19 06:48:56 | preach | 1 | 48755 | 8 | 0.826 | 59025.4 |
329 | 2021-04-08 07:21:06 | preach | 1 | 48755 | 8 | 0.843 | 57835.1 |
328 | 2021-04-04 03:30:27 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
327 | 2021-03-21 23:14:28 | preach | 1 | 48755 | 8 | 1.170 | 41670.9 |
326 | 2021-02-22 10:57:17 | preach | 1 | 48755 | 8 | 0.736 | 66243.2 |
325 | 2021-01-31 13:04:52 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
324 | 2020-12-30 03:06:39 | preach | 1 | 48755 | 8 | 0.830 | 58741.0 |
323 | 2020-11-09 21:22:48 | preach | 1 | 48755 | 8 | 0.796 | 61250.0 |
322 | 2020-11-09 03:00:35 | preach | 1 | 48755 | 8 | 1.030 | 47335.0 |
321 | 2020-11-03 09:54:22 | preach | 1 | 48755 | 8 | 0.873 | 55847.7 |
320 | 2020-10-18 15:49:28 | preach | 1 | 48755 | 8 | 0.750 | 65006.7 |
319 | 2020-10-15 21:40:22 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
318 | 2020-09-26 20:16:58 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
317 | 2020-07-19 04:47:00 | preach | 1 | 48755 | 8 | 0.936 | 52088.7 |
316 | 2020-06-21 03:39:40 | preach | 1 | 48755 | 8 | 0.813 | 59969.2 |
315 | 2020-06-20 08:32:40 | preach | 1 | 48755 | 8 | 0.766 | 63648.8 |
314 | 2020-06-17 05:52:44 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
313 | 2020-06-14 21:45:11 | preach | 1 | 48755 | 8 | 0.780 | 62506.4 |
312 | 2020-06-14 11:56:56 | preach | 1 | 48755 | 8 | 0.766 | 63648.8 |
311 | 2020-06-12 12:53:13 | preach | 1 | 48755 | 8 | 0.763 | 63899.1 |
310 | 2020-06-11 22:14:20 | preach | 1 | 48755 | 8 | 0.780 | 62506.4 |
309 | 2020-04-20 02:47:40 | preach | 1 | 48755 | 8 | 0.860 | 56691.9 |
308 | 2020-03-27 21:02:07 | preach | 1 | 48755 | 8 | 0.796 | 61250.0 |
307 | 2020-03-27 01:05:21 | preach | 1 | 48755 | 8 | 0.813 | 59969.2 |
306 | 2020-03-25 14:50:35 | preach | 1 | 48755 | 8 | 0.860 | 56691.9 |
305 | 2020-03-23 03:58:58 | preach | 1 | 48755 | 8 | 1.486 | 32809.6 |
304 | 2020-03-22 20:33:57 | preach | 1 | 48755 | 8 | 0.830 | 58741.0 |
303 | 2020-03-20 02:07:51 | preach | 1 | 48755 | 8 | 1.190 | 40970.6 |
302 | 2020-03-07 09:12:43 | preach | 1 | 48755 | 8 | 0.843 | 57835.1 |
301 | 2020-02-25 12:46:18 | preach | 1 | 48755 | 8 | 0.936 | 52088.7 |
300 | 2020-02-22 23:20:42 | preach | 1 | 48755 | 8 | 1.843 | 26454.2 |
299 | 2020-02-19 10:00:40 | preach | 1 | 48755 | 8 | 0.890 | 54780.9 |
298 | 2020-02-16 02:16:23 | preach | 1 | 48755 | 8 | 1.046 | 46610.9 |
297 | 2020-02-14 14:30:40 | preach | 1 | 48755 | 8 | 1.656 | 29441.4 |
296 | 2020-02-13 01:22:47 | preach | 1 | 48755 | 8 | 2.796 | 17437.4 |
295 | 2020-02-12 01:52:02 | preach | 1 | 48755 | 8 | 0.970 | 50262.9 |
294 | 2020-02-11 03:45:48 | preach | 1 | 48755 | 8 | 0.876 | 55656.4 |
293 | 2020-02-09 08:44:21 | preach | 1 | 48755 | 8 | 0.953 | 51159.5 |