History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sermon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
434 | 2024-04-30 01:34:21 | sermon | 1 | 48755 | 2 | 3.266 | 14928.0 |
433 | 2024-04-27 01:16:25 | sermon | 1 | 48755 | 2 | 2.330 | 20924.9 |
432 | 2024-04-14 19:30:00 | sermon | 1 | 48755 | 2 | 1.360 | 35849.3 |
431 | 2024-04-13 07:15:36 | sermon | 1 | 48755 | 2 | 0.893 | 54596.9 |
430 | 2024-04-13 06:43:06 | sermon | 1 | 48755 | 2 | 0.906 | 53813.5 |
429 | 2024-04-13 06:42:05 | sermon | 1 | 48755 | 2 | 0.783 | 62266.9 |
428 | 2024-04-01 14:03:30 | sermon | 3 | 112716 | 493 | 13.516 | 8339.4 |
427 | 2024-03-31 18:07:31 | sermon | 3 | 112716 | 493 | 17.033 | 6617.5 |
426 | 2024-03-31 16:20:54 | sermon | 1 | 48755 | 2 | 3.593 | 13569.4 |
425 | 2024-03-31 16:20:34 | sermon | 3 | 112716 | 493 | 17.266 | 6528.2 |
424 | 2024-03-31 16:20:31 | sermon | 2 | 82551 | 31 | 6.486 | 12727.6 |
423 | 2024-03-31 16:20:29 | sermon | 1 | 48755 | 2 | 1.873 | 26030.4 |
422 | 2024-01-23 23:48:34 | sermon | 1 | 48755 | 2 | 0.936 | 52088.7 |
421 | 2024-01-22 18:32:23 | sermon | 3 | 112716 | 493 | 7.986 | 14114.2 |
420 | 2024-01-21 15:08:24 | sermon | 3 | 112716 | 493 | 5.516 | 20434.4 |
419 | 2024-01-21 15:08:26 | sermon | 2 | 82551 | 31 | 2.546 | 32423.8 |
418 | 2024-01-16 14:58:24 | sermon | 2 | 82551 | 31 | 2.296 | 35954.3 |
417 | 2024-01-14 19:26:53 | sermon | 3 | 112716 | 493 | 4.953 | 22757.1 |
416 | 2024-01-13 14:55:37 | sermon | 1 | 48755 | 2 | 0.763 | 63899.1 |
415 | 2023-12-03 17:18:44 | sermon | 1 | 48755 | 2 | 0.890 | 54780.9 |
414 | 2023-12-03 17:18:43 | sermon | 1 | 48755 | 2 | 0.923 | 52822.3 |
413 | 2023-12-03 02:09:37 | sermon | 3 | 112716 | 493 | 5.220 | 21593.1 |
412 | 2023-12-03 00:21:38 | sermon | 2 | 82551 | 31 | 2.500 | 33020.4 |
411 | 2023-11-25 02:31:09 | sermon | 1 | 48755 | 2 | 0.936 | 52088.7 |
410 | 2023-11-21 00:46:51 | sermon | 1 | 48755 | 2 | 0.920 | 52994.6 |
409 | 2023-11-18 22:19:53 | sermon | 1 | 48755 | 2 | 0.860 | 56691.9 |
408 | 2023-11-07 20:48:06 | sermon | 1 | 48755 | 2 | 0.813 | 59969.2 |
407 | 2023-10-27 18:13:43 | sermon | 2 | 82551 | 31 | 2.233 | 36968.7 |
406 | 2023-10-24 17:47:57 | sermon | 3 | 112716 | 493 | 4.843 | 23274.0 |
405 | 2023-10-24 07:24:02 | sermon | 1 | 48755 | 2 | 1.813 | 26891.9 |
404 | 2023-10-19 04:26:47 | sermon | 1 | 48755 | 2 | 0.750 | 65006.7 |
403 | 2023-10-13 17:08:10 | sermon | 1 | 48755 | 2 | 0.860 | 56691.9 |
402 | 2023-10-07 05:44:13 | sermon | 1 | 48755 | 2 | 1.640 | 29728.7 |
401 | 2023-09-26 19:01:58 | sermon | 1 | 48755 | 2 | 0.873 | 55847.7 |
400 | 2023-09-17 06:06:52 | sermon | 1 | 48755 | 2 | 0.843 | 57835.1 |
399 | 2023-09-14 07:13:43 | sermon | 1 | 48755 | 2 | 0.796 | 61250.0 |
398 | 2023-09-06 19:15:09 | sermon | 1 | 48755 | 2 | 0.750 | 65006.7 |
397 | 2023-08-22 12:23:51 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
396 | 2023-08-04 13:15:02 | sermon | 2 | 82551 | 31 | 2.186 | 37763.5 |
395 | 2023-08-03 16:21:25 | sermon | 3 | 112716 | 493 | 5.440 | 20719.9 |
394 | 2023-06-29 10:56:12 | sermon | 3 | 112716 | 493 | 4.843 | 23274.0 |
393 | 2023-06-10 12:02:32 | sermon | 1 | 48755 | 2 | 0.843 | 57835.1 |
392 | 2023-05-21 05:13:20 | sermon | 1 | 48755 | 2 | 0.750 | 65006.7 |
391 | 2023-04-19 03:20:48 | sermon | 2 | 82551 | 31 | 2.250 | 36689.3 |
390 | 2023-04-12 12:38:42 | sermon | 3 | 112716 | 493 | 4.763 | 23664.9 |
389 | 2023-03-29 19:50:37 | sermon | 1 | 48755 | 2 | 0.750 | 65006.7 |
388 | 2023-03-11 18:49:02 | sermon | 3 | 112716 | 493 | 5.470 | 20606.2 |
387 | 2023-01-29 04:53:41 | sermon | 3 | 112716 | 493 | 7.440 | 15150.0 |
386 | 2023-01-28 12:37:46 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
385 | 2023-01-20 10:38:43 | sermon | 2 | 82551 | 31 | 2.216 | 37252.3 |
384 | 2023-01-19 03:20:40 | sermon | 3 | 112716 | 493 | 5.313 | 21215.1 |
383 | 2023-01-17 18:25:28 | sermon | 3 | 112716 | 493 | 5.170 | 21801.9 |
382 | 2023-01-12 06:23:02 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
381 | 2023-01-04 06:01:45 | sermon | 3 | 112716 | 493 | 5.143 | 21916.4 |
380 | 2022-12-14 09:13:14 | sermon | 3 | 112716 | 493 | 5.546 | 20323.8 |
379 | 2022-12-03 21:19:34 | sermon | 3 | 112716 | 493 | 4.830 | 23336.6 |
378 | 2022-11-20 12:23:39 | sermon | 3 | 112716 | 493 | 5.390 | 20912.1 |
377 | 2022-11-13 22:16:49 | sermon | 3 | 112716 | 493 | 5.063 | 22262.7 |
376 | 2022-11-08 20:56:23 | sermon | 3 | 112716 | 493 | 5.733 | 19660.9 |
375 | 2022-11-03 12:47:35 | sermon | 3 | 112716 | 493 | 5.063 | 22262.7 |
374 | 2022-11-01 12:32:50 | sermon | 2 | 82551 | 31 | 2.406 | 34310.5 |
373 | 2022-10-29 04:09:34 | sermon | 3 | 112716 | 493 | 4.780 | 23580.8 |
372 | 2022-10-26 09:11:25 | sermon | 1 | 48755 | 2 | 0.810 | 60191.4 |
371 | 2022-10-09 18:17:25 | sermon | 3 | 112716 | 493 | 5.533 | 20371.6 |
370 | 2022-10-05 06:30:15 | sermon | 3 | 112716 | 493 | 4.766 | 23650.0 |
369 | 2022-09-26 03:21:21 | sermon | 1 | 48755 | 2 | 0.860 | 56691.9 |
368 | 2022-09-24 22:50:21 | sermon | 3 | 112716 | 493 | 5.530 | 20382.6 |
367 | 2022-09-13 15:02:13 | sermon | 3 | 112716 | 493 | 4.876 | 23116.5 |
366 | 2022-09-10 22:14:44 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
365 | 2022-09-09 04:27:59 | sermon | 2 | 82551 | 31 | 2.220 | 37185.1 |
364 | 2022-08-11 22:27:53 | sermon | 2 | 82551 | 31 | 2.656 | 31080.9 |
363 | 2022-08-08 03:48:22 | sermon | 3 | 112716 | 493 | 4.890 | 23050.3 |
362 | 2022-07-29 09:22:51 | sermon | 1 | 48755 | 2 | 0.903 | 53992.2 |
361 | 2022-07-27 10:22:46 | sermon | 3 | 112716 | 493 | 4.936 | 22835.5 |
360 | 2022-07-18 20:25:04 | sermon | 1 | 48755 | 2 | 0.780 | 62506.4 |
359 | 2022-07-18 01:24:56 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
358 | 2022-07-04 06:54:23 | sermon | 2 | 82551 | 31 | 2.170 | 38041.9 |
357 | 2022-07-03 05:58:44 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
356 | 2022-06-24 20:42:59 | sermon | 3 | 112716 | 493 | 4.890 | 23050.3 |
355 | 2022-06-16 22:20:43 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
354 | 2022-06-14 19:53:52 | sermon | 1 | 48755 | 2 | 0.780 | 62506.4 |
353 | 2022-06-09 02:08:40 | sermon | 1 | 48755 | 2 | 0.766 | 63648.8 |
352 | 2022-06-03 10:34:24 | sermon | 2 | 82551 | 31 | 2.220 | 37185.1 |
351 | 2022-06-01 13:16:35 | sermon | 3 | 112716 | 493 | 4.796 | 23502.1 |
350 | 2022-05-26 20:32:35 | sermon | 1 | 48755 | 2 | 0.873 | 55847.7 |
349 | 2022-05-25 04:17:56 | sermon | 3 | 112716 | 493 | 4.953 | 22757.1 |
348 | 2022-02-17 22:32:49 | sermon | 1 | 48755 | 2 | 0.780 | 62506.4 |
347 | 2022-02-11 02:38:29 | sermon | 2 | 82551 | 31 | 2.513 | 32849.6 |
346 | 2022-01-28 20:42:03 | sermon | 1 | 48755 | 2 | 0.763 | 63899.1 |
345 | 2022-01-22 07:47:18 | sermon | 3 | 112716 | 493 | 6.030 | 18692.5 |
344 | 2021-12-27 08:11:33 | sermon | 1 | 48755 | 2 | 0.796 | 61250.0 |
343 | 2021-12-10 22:24:51 | sermon | 1 | 48755 | 2 | 0.856 | 56956.8 |
342 | 2021-12-09 08:21:00 | sermon | 1 | 48755 | 2 | 0.890 | 54780.9 |
341 | 2021-12-07 04:54:24 | sermon | 1 | 48755 | 2 | 0.906 | 53813.5 |
340 | 2021-11-11 23:59:38 | sermon | 1 | 48755 | 2 | 0.780 | 62506.4 |
339 | 2021-11-04 01:19:24 | sermon | 1 | 48755 | 2 | 0.906 | 53813.5 |
338 | 2021-10-12 02:51:56 | sermon | 1 | 48755 | 2 | 0.810 | 60191.4 |
337 | 2021-07-26 23:50:42 | sermon | 2 | 82551 | 31 | 2.580 | 31996.5 |
336 | 2021-07-10 19:33:15 | sermon | 1 | 48755 | 2 | 1.766 | 27607.6 |
335 | 2021-06-02 01:23:04 | sermon | 3 | 112716 | 493 | 5.626 | 20034.8 |