History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"novels"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
421 | 2024-04-13 14:09:14 | novels | 1 | 48755 | 5 | 0.856 | 56956.8 |
420 | 2024-04-13 14:05:31 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
419 | 2024-04-13 14:04:38 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
418 | 2024-04-01 09:14:49 | novels | 1 | 48755 | 5 | 0.826 | 59025.4 |
417 | 2024-03-29 23:17:51 | novels | 1 | 48755 | 5 | 2.483 | 19635.5 |
416 | 2024-03-04 03:19:52 | novels | 1 | 48755 | 5 | 0.813 | 59969.2 |
415 | 2024-03-01 03:51:00 | novels | 2 | 82551 | 80 | 2.403 | 34353.3 |
414 | 2024-03-01 03:50:40 | novels | 3 | 112716 | 856 | 5.953 | 18934.3 |
413 | 2024-02-28 21:39:32 | novels | 2 | 82551 | 80 | 2.970 | 27794.9 |
412 | 2024-02-28 21:38:30 | novels | 3 | 112716 | 856 | 8.283 | 13608.1 |
411 | 2024-02-28 14:43:15 | novels | 2 | 82551 | 80 | 2.423 | 34069.7 |
410 | 2024-02-28 14:34:13 | novels | 3 | 112716 | 856 | 15.266 | 7383.5 |
409 | 2024-02-28 06:16:20 | novels | 3 | 112716 | 856 | 9.470 | 11902.4 |
408 | 2024-02-28 05:14:48 | novels | 3 | 112716 | 856 | 11.673 | 9656.1 |
407 | 2024-02-28 05:14:44 | novels | 2 | 82551 | 80 | 3.000 | 27517.0 |
406 | 2024-02-25 21:39:20 | novels | 1 | 48755 | 5 | 2.140 | 22782.7 |
405 | 2024-02-03 05:51:15 | novels | 1 | 48755 | 5 | 0.953 | 51159.5 |
404 | 2023-12-28 00:44:52 | novels | 1 | 48755 | 5 | 0.830 | 58741.0 |
403 | 2023-12-23 00:18:06 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
402 | 2023-12-17 11:42:57 | novels | 3 | 112716 | 856 | 5.373 | 20978.2 |
401 | 2023-12-17 11:42:56 | novels | 2 | 82551 | 80 | 2.250 | 36689.3 |
400 | 2023-12-08 19:31:14 | novels | 1 | 48755 | 5 | 0.876 | 55656.4 |
399 | 2023-11-12 06:17:19 | novels | 1 | 48755 | 5 | 1.656 | 29441.4 |
398 | 2023-11-11 18:36:01 | novels | 1 | 48755 | 5 | 0.936 | 52088.7 |
397 | 2023-11-04 23:00:21 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
396 | 2023-10-25 10:37:14 | novels | 1 | 48755 | 5 | 0.810 | 60191.4 |
395 | 2023-10-13 15:26:33 | novels | 1 | 48755 | 5 | 0.813 | 59969.2 |
394 | 2023-10-12 18:16:27 | novels | 1 | 48755 | 5 | 0.720 | 67715.3 |
393 | 2023-09-26 01:49:54 | novels | 1 | 48755 | 5 | 0.796 | 61250.0 |
392 | 2023-09-25 01:32:06 | novels | 1 | 48755 | 5 | 1.563 | 31193.2 |
391 | 2023-08-18 23:24:17 | novels | 1 | 48755 | 5 | 0.830 | 58741.0 |
390 | 2023-08-10 15:50:53 | novels | 1 | 48755 | 5 | 0.830 | 58741.0 |
389 | 2023-05-18 06:39:35 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
388 | 2023-05-10 12:53:26 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
387 | 2023-04-27 09:38:47 | novels | 1 | 48755 | 5 | 0.813 | 59969.2 |
386 | 2023-03-25 09:54:34 | novels | 1 | 48755 | 5 | 0.720 | 67715.3 |
385 | 2023-03-07 02:28:28 | novels | 1 | 48755 | 5 | 0.736 | 66243.2 |
384 | 2023-01-03 21:06:57 | novels | 1 | 48755 | 5 | 0.780 | 62506.4 |
383 | 2022-12-30 08:57:17 | novels | 1 | 48755 | 5 | 0.796 | 61250.0 |
382 | 2022-09-18 11:38:51 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
381 | 2022-09-01 16:31:49 | novels | 1 | 48755 | 5 | 0.873 | 55847.7 |
380 | 2022-08-30 09:51:29 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
379 | 2022-08-23 07:12:40 | novels | 1 | 48755 | 5 | 0.716 | 68093.6 |
378 | 2022-08-16 03:46:11 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
377 | 2022-07-18 09:39:33 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
376 | 2022-07-11 16:04:03 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
375 | 2022-07-10 12:17:34 | novels | 1 | 48755 | 5 | 0.796 | 61250.0 |
374 | 2022-06-26 08:29:50 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
373 | 2022-06-25 17:25:14 | novels | 1 | 48755 | 5 | 0.736 | 66243.2 |
372 | 2022-05-25 20:11:14 | novels | 1 | 48755 | 5 | 0.766 | 63648.8 |
371 | 2022-04-27 11:23:18 | novels | 1 | 48755 | 5 | 1.110 | 43923.4 |
370 | 2022-04-22 23:26:01 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
369 | 2022-04-19 10:18:16 | novels | 1 | 48755 | 5 | 2.093 | 23294.3 |
368 | 2022-01-18 17:53:48 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
367 | 2022-01-16 13:25:27 | novels | 1 | 48755 | 5 | 0.826 | 59025.4 |
366 | 2021-12-31 04:36:08 | novels | 1 | 48755 | 5 | 0.796 | 61250.0 |
365 | 2021-12-28 00:33:44 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
364 | 2021-11-16 11:39:03 | novels | 1 | 48755 | 5 | 0.736 | 66243.2 |
363 | 2021-10-08 10:44:32 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
362 | 2021-10-06 09:17:57 | novels | 1 | 48755 | 5 | 0.813 | 59969.2 |
361 | 2021-09-17 06:04:20 | novels | 1 | 48755 | 5 | 0.783 | 62266.9 |
360 | 2021-09-11 06:48:05 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
359 | 2021-06-10 09:38:27 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
358 | 2021-06-01 03:49:28 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
357 | 2021-05-06 21:58:08 | novels | 1 | 48755 | 5 | 0.920 | 52994.6 |
356 | 2021-04-05 04:43:54 | novels | 1 | 48755 | 5 | 1.670 | 29194.6 |
355 | 2021-03-09 14:33:34 | novels | 1 | 48755 | 5 | 0.766 | 63648.8 |
354 | 2021-03-07 22:36:24 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
353 | 2021-02-19 18:12:41 | novels | 1 | 48755 | 5 | 0.873 | 55847.7 |
352 | 2021-01-29 13:02:44 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
351 | 2020-12-04 06:49:47 | novels | 1 | 48755 | 5 | 0.733 | 66514.3 |
350 | 2020-11-07 03:14:48 | novels | 1 | 48755 | 5 | 0.876 | 55656.4 |
349 | 2020-10-23 15:09:25 | novels | 1 | 48755 | 5 | 0.796 | 61250.0 |
348 | 2020-09-01 18:59:17 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
347 | 2020-07-21 14:19:10 | novels | 1 | 48755 | 5 | 0.780 | 62506.4 |
346 | 2020-05-21 22:04:12 | novels | 1 | 48755 | 5 | 0.830 | 58741.0 |
345 | 2020-05-18 18:33:37 | novels | 1 | 48755 | 5 | 0.720 | 67715.3 |
344 | 2020-04-12 16:19:25 | novels | 1 | 48755 | 5 | 0.953 | 51159.5 |
343 | 2020-03-28 12:07:36 | novels | 1 | 48755 | 5 | 1.733 | 28133.3 |
342 | 2020-03-24 11:40:41 | novels | 1 | 48755 | 5 | 0.923 | 52822.3 |
341 | 2020-03-23 08:56:55 | novels | 1 | 48755 | 5 | 1.860 | 26212.4 |
340 | 2020-03-20 01:28:55 | novels | 1 | 48755 | 5 | 0.830 | 58741.0 |
339 | 2020-02-24 20:32:19 | novels | 1 | 48755 | 5 | 0.906 | 53813.5 |
338 | 2020-02-23 23:43:26 | novels | 1 | 48755 | 5 | 1.046 | 46610.9 |
337 | 2020-02-19 14:44:58 | novels | 1 | 48755 | 5 | 0.953 | 51159.5 |
336 | 2020-02-12 22:16:30 | novels | 1 | 48755 | 5 | 0.923 | 52822.3 |
335 | 2020-02-07 15:44:42 | novels | 1 | 48755 | 5 | 0.750 | 65006.7 |
334 | 2020-02-04 22:57:34 | novels | 1 | 48755 | 5 | 2.030 | 24017.2 |
333 | 2020-02-03 20:47:28 | novels | 1 | 48755 | 5 | 1.830 | 26642.1 |
332 | 2020-02-03 16:30:43 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
331 | 2020-02-02 06:18:35 | novels | 1 | 48755 | 5 | 1.280 | 38089.8 |
330 | 2020-01-31 08:57:57 | novels | 1 | 48755 | 5 | 2.330 | 20924.9 |
329 | 2020-01-30 21:24:13 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
328 | 2020-01-27 00:30:12 | novels | 1 | 48755 | 5 | 0.923 | 52822.3 |
327 | 2020-01-17 14:06:19 | novels | 1 | 48755 | 5 | 0.890 | 54780.9 |
326 | 2020-01-15 01:39:28 | novels | 1 | 48755 | 5 | 1.703 | 28628.9 |
325 | 2020-01-14 12:44:17 | novels | 1 | 48755 | 5 | 0.843 | 57835.1 |
324 | 2020-01-11 20:36:49 | novels | 1 | 48755 | 5 | 0.813 | 59969.2 |
323 | 2020-01-06 20:21:25 | novels | 1 | 48755 | 5 | 0.860 | 56691.9 |
322 | 2020-01-04 12:08:06 | novels | 1 | 48755 | 5 | 1.780 | 27390.4 |