History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shall"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
465 | 2024-04-24 23:20:31 | shall | 1 | 28756 | 14 | 0.530 | 54256.6 |
464 | 2024-04-03 11:02:49 | shall | 2 | 53800 | 159 | 3.873 | 13891.0 |
463 | 2024-04-03 10:21:09 | shall | 2 | 53800 | 159 | 5.123 | 10501.7 |
462 | 2024-04-03 04:24:43 | shall | 1 | 28756 | 14 | 2.343 | 12273.2 |
461 | 2024-03-31 03:40:05 | shall | 1 | 28756 | 14 | 0.826 | 34813.6 |
460 | 2024-03-29 00:09:46 | shall | 2 | 53800 | 159 | 5.843 | 9207.6 |
459 | 2024-03-28 22:58:19 | shall | 1 | 28756 | 14 | 0.763 | 37688.1 |
458 | 2024-03-03 21:21:38 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
457 | 2024-02-27 19:59:44 | shall | 1 | 28756 | 14 | 0.546 | 52666.7 |
456 | 2024-02-22 10:32:49 | shall | 2 | 53800 | 159 | 1.420 | 37887.3 |
455 | 2024-02-03 03:44:27 | shall | 1 | 28756 | 14 | 0.530 | 54256.6 |
454 | 2024-01-22 15:00:59 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
453 | 2023-12-22 13:26:23 | shall | 2 | 53800 | 159 | 1.393 | 38621.7 |
452 | 2023-12-03 01:44:48 | shall | 2 | 53800 | 159 | 1.623 | 33148.5 |
451 | 2023-11-19 10:57:39 | shall | 1 | 28756 | 14 | 0.486 | 59168.7 |
450 | 2023-11-12 08:29:25 | shall | 1 | 28756 | 14 | 0.513 | 56054.6 |
449 | 2023-11-03 10:12:20 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
448 | 2023-10-30 14:57:22 | shall | 1 | 28756 | 14 | 0.483 | 59536.2 |
447 | 2023-10-21 00:52:08 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
446 | 2023-10-20 15:47:18 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
445 | 2023-10-11 02:22:44 | shall | 1 | 28756 | 14 | 1.106 | 26000.0 |
444 | 2023-10-05 21:23:59 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
443 | 2023-09-26 17:09:49 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
442 | 2023-09-14 02:40:57 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
441 | 2023-08-31 14:58:50 | shall | 2 | 53800 | 159 | 1.390 | 38705.0 |
440 | 2023-07-04 03:52:09 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
439 | 2023-05-16 04:59:18 | shall | 2 | 53800 | 159 | 1.393 | 38621.7 |
438 | 2023-03-17 12:53:09 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
437 | 2023-02-20 23:41:49 | shall | 2 | 53800 | 159 | 1.376 | 39098.8 |
436 | 2022-12-06 06:20:22 | shall | 2 | 53800 | 159 | 1.483 | 36277.8 |
435 | 2022-12-02 14:11:46 | shall | 2 | 53800 | 159 | 3.080 | 17467.5 |
434 | 2022-11-26 02:29:06 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
433 | 2022-11-22 17:06:39 | shall | 1 | 28756 | 14 | 0.440 | 65354.5 |
432 | 2022-10-23 19:37:07 | shall | 2 | 53800 | 159 | 1.376 | 39098.8 |
431 | 2022-09-27 04:08:26 | shall | 2 | 53800 | 159 | 1.360 | 39558.8 |
430 | 2022-09-14 17:48:29 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
429 | 2022-09-13 09:45:12 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
428 | 2022-09-07 23:22:43 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
427 | 2022-09-05 21:21:42 | shall | 1 | 28756 | 14 | 0.440 | 65354.5 |
426 | 2022-08-27 06:11:21 | shall | 2 | 53800 | 159 | 1.500 | 35866.7 |
425 | 2022-08-15 18:12:04 | shall | 2 | 53800 | 159 | 1.720 | 31279.1 |
424 | 2022-07-29 22:03:39 | shall | 1 | 28756 | 14 | 0.563 | 51076.4 |
423 | 2022-07-29 03:25:24 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
422 | 2022-07-19 10:05:03 | shall | 2 | 53800 | 159 | 1.343 | 40059.6 |
421 | 2022-07-18 19:46:34 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
420 | 2022-07-17 23:21:38 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
419 | 2022-07-09 01:31:13 | shall | 2 | 53800 | 159 | 1.373 | 39184.3 |
418 | 2022-07-06 20:49:02 | shall | 2 | 53800 | 159 | 1.436 | 37465.2 |
417 | 2022-07-03 03:17:33 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
416 | 2022-06-08 23:13:59 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
415 | 2022-04-19 02:46:43 | shall | 1 | 28756 | 14 | 0.593 | 48492.4 |
414 | 2022-03-31 23:23:46 | shall | 1 | 28756 | 14 | 0.530 | 54256.6 |
413 | 2022-02-18 00:40:49 | shall | 2 | 53800 | 159 | 1.640 | 32804.9 |
412 | 2022-01-19 03:50:58 | shall | 1 | 28756 | 14 | 0.483 | 59536.2 |
411 | 2022-01-17 00:02:57 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
410 | 2021-12-17 10:28:37 | shall | 1 | 28756 | 14 | 0.546 | 52666.7 |
409 | 2021-11-12 18:36:03 | shall | 1 | 28756 | 14 | 0.983 | 29253.3 |
408 | 2021-09-30 10:37:46 | shall | 1 | 28756 | 14 | 0.486 | 59168.7 |
407 | 2021-09-10 04:51:55 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
406 | 2021-08-26 18:20:18 | shall | 1 | 28756 | 14 | 0.533 | 53951.2 |
405 | 2021-08-24 14:57:23 | shall | 1 | 28756 | 14 | 0.893 | 32201.6 |
404 | 2021-06-13 21:18:03 | shall | 1 | 28756 | 14 | 0.486 | 59168.7 |
403 | 2021-06-09 07:23:30 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
402 | 2021-03-23 23:58:20 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
401 | 2021-03-10 07:34:21 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
400 | 2021-01-06 13:05:41 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
399 | 2020-12-24 17:12:03 | shall | 1 | 28756 | 14 | 0.483 | 59536.2 |
398 | 2020-12-08 17:55:35 | shall | 1 | 28756 | 14 | 0.483 | 59536.2 |
397 | 2020-12-06 23:10:17 | shall | 1 | 28756 | 14 | 0.513 | 56054.6 |
396 | 2020-10-26 22:23:40 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
395 | 2020-10-19 13:17:15 | shall | 1 | 28756 | 14 | 0.533 | 53951.2 |
394 | 2020-10-17 04:03:07 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
393 | 2020-09-18 17:19:12 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
392 | 2020-09-05 01:03:14 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
391 | 2020-09-04 02:48:38 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
390 | 2020-09-01 21:07:33 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
389 | 2020-08-31 17:02:40 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
388 | 2020-07-22 13:47:35 | shall | 1 | 28756 | 14 | 0.470 | 61183.0 |
387 | 2020-06-21 01:16:21 | shall | 1 | 28756 | 14 | 0.453 | 63479.0 |
386 | 2020-06-21 00:10:37 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
385 | 2020-06-20 01:25:44 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
384 | 2020-06-20 00:44:25 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
383 | 2020-06-10 06:10:57 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
382 | 2020-05-29 23:42:28 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
381 | 2020-03-25 00:32:10 | shall | 1 | 28756 | 14 | 0.466 | 61708.2 |
380 | 2020-03-23 10:04:17 | shall | 1 | 28756 | 14 | 0.876 | 32826.5 |
379 | 2020-03-22 06:42:18 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
378 | 2020-03-21 02:53:31 | shall | 1 | 28756 | 14 | 0.516 | 55728.7 |
377 | 2020-03-20 22:37:49 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
376 | 2020-03-18 00:50:44 | shall | 1 | 28756 | 14 | 0.503 | 57169.0 |
375 | 2020-03-09 07:04:47 | shall | 1 | 28756 | 14 | 0.440 | 65354.5 |
374 | 2020-03-05 12:38:49 | shall | 1 | 28756 | 14 | 0.500 | 57512.0 |
373 | 2020-02-26 17:42:48 | shall | 1 | 28756 | 14 | 0.436 | 65954.1 |
372 | 2020-02-26 02:05:36 | shall | 1 | 28756 | 14 | 0.546 | 52666.7 |
371 | 2020-02-24 11:05:02 | shall | 1 | 28756 | 14 | 0.530 | 54256.6 |
370 | 2020-02-19 18:30:14 | shall | 1 | 28756 | 14 | 0.533 | 53951.2 |
369 | 2020-02-17 12:54:17 | shall | 1 | 28756 | 14 | 1.140 | 25224.6 |
368 | 2020-02-13 23:25:12 | shall | 1 | 28756 | 14 | 0.796 | 36125.6 |
367 | 2020-02-08 21:50:49 | shall | 1 | 28756 | 14 | 0.580 | 49579.3 |
366 | 2020-01-29 23:17:35 | shall | 1 | 28756 | 14 | 0.563 | 51076.4 |