History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"novel"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
400 | 2024-04-18 09:10:41 | novel | 1 | 28756 | 5 | 1.810 | 15887.3 |
399 | 2024-04-05 03:03:14 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
398 | 2024-04-03 06:50:23 | novel | 1 | 28756 | 5 | 0.530 | 54256.6 |
397 | 2024-03-30 22:31:02 | novel | 2 | 53800 | 108 | 1.876 | 28678.0 |
396 | 2024-03-30 22:30:59 | novel | 1 | 28756 | 5 | 0.563 | 51076.4 |
395 | 2024-03-30 22:30:51 | novel | 2 | 53800 | 108 | 1.733 | 31044.4 |
394 | 2024-03-30 21:51:40 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
393 | 2024-03-29 08:40:53 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
392 | 2024-03-03 23:00:27 | novel | 1 | 28756 | 5 | 1.126 | 25538.2 |
391 | 2024-03-02 04:04:12 | novel | 1 | 28756 | 5 | 1.110 | 25906.3 |
390 | 2024-02-28 02:18:07 | novel | 1 | 28756 | 5 | 0.470 | 61183.0 |
389 | 2024-02-14 16:43:12 | novel | 2 | 53800 | 108 | 1.610 | 33416.1 |
388 | 2024-02-14 08:01:48 | novel | 2 | 53800 | 108 | 1.546 | 34799.5 |
387 | 2024-02-02 19:38:03 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
386 | 2024-01-28 23:38:05 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
385 | 2024-01-04 17:16:22 | novel | 2 | 53800 | 108 | 1.470 | 36598.6 |
384 | 2024-01-03 04:17:40 | novel | 2 | 53800 | 108 | 1.576 | 34137.1 |
383 | 2024-01-03 02:21:58 | novel | 1 | 28756 | 5 | 0.516 | 55728.7 |
382 | 2023-12-08 09:10:31 | novel | 1 | 28756 | 5 | 0.420 | 68466.7 |
381 | 2023-11-25 06:32:47 | novel | 2 | 53800 | 108 | 1.703 | 31591.3 |
380 | 2023-11-18 12:37:26 | novel | 1 | 28756 | 5 | 0.466 | 61708.2 |
379 | 2023-11-15 04:26:31 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
378 | 2023-11-14 09:25:55 | novel | 2 | 53800 | 108 | 1.406 | 38264.6 |
377 | 2023-11-03 19:37:50 | novel | 1 | 28756 | 5 | 0.486 | 59168.7 |
376 | 2023-10-21 21:34:22 | novel | 1 | 28756 | 5 | 0.516 | 55728.7 |
375 | 2023-10-19 06:31:33 | novel | 1 | 28756 | 5 | 0.466 | 61708.2 |
374 | 2023-10-11 16:41:18 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
373 | 2023-10-07 20:30:33 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
372 | 2023-09-28 22:50:22 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
371 | 2023-09-28 08:37:39 | novel | 2 | 53800 | 108 | 1.656 | 32487.9 |
370 | 2023-09-27 10:01:50 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
369 | 2023-09-22 11:04:44 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
368 | 2023-09-21 00:23:19 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
367 | 2023-08-17 13:08:21 | novel | 2 | 53800 | 108 | 1.376 | 39098.8 |
366 | 2023-07-14 19:58:17 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
365 | 2023-06-03 21:29:20 | novel | 1 | 28756 | 5 | 0.423 | 67981.1 |
364 | 2023-04-29 01:35:34 | novel | 2 | 53800 | 108 | 1.420 | 37887.3 |
363 | 2023-04-09 22:59:34 | novel | 1 | 28756 | 5 | 0.420 | 68466.7 |
362 | 2023-02-05 04:32:00 | novel | 2 | 53800 | 108 | 1.546 | 34799.5 |
361 | 2023-02-02 04:51:59 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
360 | 2023-01-29 02:12:36 | novel | 1 | 28756 | 5 | 0.420 | 68466.7 |
359 | 2022-11-29 02:37:52 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
358 | 2022-11-17 18:10:57 | novel | 2 | 53800 | 108 | 1.390 | 38705.0 |
357 | 2022-09-23 01:42:09 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
356 | 2022-07-29 11:36:03 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
355 | 2022-07-24 20:00:46 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
354 | 2022-06-20 19:44:13 | novel | 2 | 53800 | 108 | 1.390 | 38705.0 |
353 | 2022-06-17 04:44:16 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
352 | 2022-05-13 13:28:42 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
351 | 2022-03-21 22:35:25 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
350 | 2022-03-19 16:24:01 | novel | 1 | 28756 | 5 | 0.466 | 61708.2 |
349 | 2022-01-22 07:41:04 | novel | 1 | 28756 | 5 | 0.563 | 51076.4 |
348 | 2021-12-27 19:29:57 | novel | 1 | 28756 | 5 | 0.513 | 56054.6 |
347 | 2021-12-23 09:57:08 | novel | 1 | 28756 | 5 | 0.470 | 61183.0 |
346 | 2021-12-15 12:06:12 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
345 | 2021-11-26 20:03:42 | novel | 1 | 28756 | 5 | 0.596 | 48248.3 |
344 | 2021-10-30 11:15:28 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
343 | 2021-10-06 04:22:55 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
342 | 2021-09-16 16:46:48 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
341 | 2021-08-27 22:39:04 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
340 | 2021-07-07 08:58:33 | novel | 1 | 28756 | 5 | 0.423 | 67981.1 |
339 | 2021-07-03 19:35:47 | novel | 1 | 28756 | 5 | 1.046 | 27491.4 |
338 | 2021-05-24 23:13:15 | novel | 1 | 28756 | 5 | 0.530 | 54256.6 |
337 | 2021-04-28 09:18:28 | novel | 1 | 28756 | 5 | 1.063 | 27051.7 |
336 | 2021-03-30 03:58:21 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
335 | 2021-03-28 05:42:02 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
334 | 2021-03-25 19:33:51 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
333 | 2021-03-21 10:30:40 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
332 | 2021-01-11 12:17:47 | novel | 1 | 28756 | 5 | 0.470 | 61183.0 |
331 | 2020-12-11 06:09:04 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
330 | 2020-10-22 03:51:06 | novel | 1 | 28756 | 5 | 0.486 | 59168.7 |
329 | 2020-10-21 12:07:16 | novel | 1 | 28756 | 5 | 0.470 | 61183.0 |
328 | 2020-09-29 14:30:47 | novel | 1 | 28756 | 5 | 0.453 | 63479.0 |
327 | 2020-09-04 12:19:01 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
326 | 2020-08-23 11:40:04 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
325 | 2020-07-27 06:42:48 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |
324 | 2020-07-16 06:49:40 | novel | 1 | 28756 | 5 | 0.470 | 61183.0 |
323 | 2020-05-30 08:40:50 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
322 | 2020-05-18 00:15:10 | novel | 1 | 28756 | 5 | 0.423 | 67981.1 |
321 | 2020-03-29 05:37:33 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
320 | 2020-03-27 01:32:07 | novel | 1 | 28756 | 5 | 0.563 | 51076.4 |
319 | 2020-03-23 13:44:29 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |
318 | 2020-03-22 21:42:20 | novel | 1 | 28756 | 5 | 0.513 | 56054.6 |
317 | 2020-03-22 01:15:49 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
316 | 2020-03-18 16:26:02 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
315 | 2020-03-01 03:11:26 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |
314 | 2020-02-27 01:42:41 | novel | 1 | 28756 | 5 | 0.533 | 53951.2 |
313 | 2020-02-23 11:47:05 | novel | 1 | 28756 | 5 | 0.500 | 57512.0 |
312 | 2020-02-23 11:28:17 | novel | 1 | 28756 | 5 | 0.483 | 59536.2 |
311 | 2020-02-21 10:49:20 | novel | 1 | 28756 | 5 | 0.436 | 65954.1 |
310 | 2020-02-17 10:27:40 | novel | 1 | 28756 | 5 | 0.440 | 65354.5 |
309 | 2020-02-11 12:46:42 | novel | 1 | 28756 | 5 | 1.110 | 25906.3 |
308 | 2020-02-05 02:12:03 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |
307 | 2020-02-04 17:34:40 | novel | 1 | 28756 | 5 | 1.046 | 27491.4 |
306 | 2020-02-01 10:40:54 | novel | 1 | 28756 | 5 | 0.550 | 52283.6 |
305 | 2020-01-31 05:27:42 | novel | 1 | 28756 | 5 | 1.753 | 16403.9 |
304 | 2020-01-27 06:11:13 | novel | 1 | 28756 | 5 | 1.126 | 25538.2 |
303 | 2020-01-27 04:42:56 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |
302 | 2020-01-24 22:51:31 | novel | 1 | 28756 | 5 | 1.250 | 23004.8 |
301 | 2020-01-21 20:10:59 | novel | 1 | 28756 | 5 | 0.546 | 52666.7 |