History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"joists"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
491 | 2024-05-01 16:40:54 | joists | 2 | 82551 | 71 | 5.393 | 15307.1 |
490 | 2024-05-01 16:40:50 | joists | 1 | 48755 | 6 | 0.873 | 55847.7 |
489 | 2024-05-01 16:40:26 | joists | 3 | 112716 | 742 | 7.640 | 14753.4 |
488 | 2024-04-30 14:39:56 | joists | 3 | 112716 | 742 | 6.033 | 18683.2 |
487 | 2024-04-27 15:34:09 | joists | 1 | 48755 | 6 | 1.063 | 45865.5 |
486 | 2024-04-27 09:02:23 | joists | 1 | 48755 | 6 | 0.873 | 55847.7 |
485 | 2024-04-05 03:20:28 | joists | 2 | 82551 | 71 | 2.860 | 28864.0 |
484 | 2024-04-03 14:55:18 | joists | 2 | 82551 | 71 | 6.686 | 12346.8 |
483 | 2024-04-03 13:07:23 | joists | 3 | 112716 | 742 | 12.796 | 8808.7 |
482 | 2024-04-03 11:01:38 | joists | 2 | 82551 | 71 | 8.686 | 9503.9 |
481 | 2024-04-03 11:01:09 | joists | 1 | 48755 | 6 | 3.436 | 14189.5 |
480 | 2024-04-02 19:01:01 | joists | 3 | 112716 | 742 | 18.003 | 6261.0 |
479 | 2024-04-01 17:20:46 | joists | 3 | 112716 | 742 | 16.266 | 6929.5 |
478 | 2024-03-31 12:30:41 | joists | 3 | 112716 | 742 | 11.156 | 10103.6 |
477 | 2024-03-31 08:37:30 | joists | 3 | 112716 | 742 | 6.263 | 17997.1 |
476 | 2024-03-31 08:37:31 | joists | 2 | 82551 | 71 | 5.280 | 15634.7 |
475 | 2024-03-31 08:37:14 | joists | 3 | 112716 | 742 | 12.673 | 8894.2 |
474 | 2024-03-31 08:37:25 | joists | 1 | 48755 | 6 | 0.906 | 53813.5 |
473 | 2024-03-31 08:37:16 | joists | 2 | 82551 | 71 | 5.486 | 15047.6 |
472 | 2024-03-31 08:37:14 | joists | 1 | 48755 | 6 | 0.923 | 52822.3 |
471 | 2024-03-28 14:33:07 | joists | 1 | 48755 | 6 | 0.783 | 62266.9 |
470 | 2024-03-13 06:28:32 | joists | 1 | 48755 | 6 | 0.736 | 66243.2 |
469 | 2024-03-09 18:27:53 | joists | 2 | 82551 | 71 | 2.110 | 39123.7 |
468 | 2024-02-28 10:43:53 | joists | 2 | 82551 | 71 | 2.453 | 33653.1 |
467 | 2024-02-28 10:43:29 | joists | 3 | 112716 | 742 | 5.940 | 18975.8 |
466 | 2024-02-28 03:03:46 | joists | 2 | 82551 | 71 | 2.623 | 31472.0 |
465 | 2024-02-28 03:03:26 | joists | 3 | 112716 | 742 | 7.000 | 16102.3 |
464 | 2024-02-28 02:56:13 | joists | 2 | 82551 | 71 | 5.046 | 16359.7 |
463 | 2024-02-28 02:56:12 | joists | 3 | 112716 | 742 | 5.766 | 19548.4 |
462 | 2024-02-28 02:56:04 | joists | 1 | 48755 | 6 | 0.843 | 57835.1 |
461 | 2024-01-16 21:49:20 | joists | 3 | 112716 | 742 | 5.796 | 19447.2 |
460 | 2024-01-16 21:49:23 | joists | 2 | 82551 | 71 | 2.610 | 31628.7 |
459 | 2024-01-12 14:48:32 | joists | 3 | 112716 | 742 | 4.796 | 23502.1 |
458 | 2024-01-12 14:48:31 | joists | 2 | 82551 | 71 | 2.310 | 35736.4 |
457 | 2023-12-23 20:13:38 | joists | 1 | 48755 | 6 | 0.783 | 62266.9 |
456 | 2023-12-23 03:45:12 | joists | 3 | 112716 | 742 | 5.236 | 21527.1 |
455 | 2023-12-15 05:25:16 | joists | 1 | 48755 | 6 | 0.733 | 66514.3 |
454 | 2023-11-26 08:36:36 | joists | 2 | 82551 | 71 | 2.343 | 35233.0 |
453 | 2023-11-22 09:52:18 | joists | 1 | 48755 | 6 | 0.783 | 62266.9 |
452 | 2023-11-18 03:41:12 | joists | 1 | 48755 | 6 | 0.830 | 58741.0 |
451 | 2023-11-17 02:10:25 | joists | 1 | 48755 | 6 | 0.716 | 68093.6 |
450 | 2023-11-14 20:32:46 | joists | 1 | 48755 | 6 | 0.736 | 66243.2 |
449 | 2023-10-31 09:39:45 | joists | 1 | 48755 | 6 | 0.706 | 69058.1 |
448 | 2023-10-29 06:20:33 | joists | 1 | 48755 | 6 | 0.826 | 59025.4 |
447 | 2023-10-22 23:32:20 | joists | 1 | 48755 | 6 | 1.640 | 29728.7 |
446 | 2023-10-19 21:23:40 | joists | 1 | 48755 | 6 | 1.686 | 28917.6 |
445 | 2023-10-11 07:27:08 | joists | 1 | 48755 | 6 | 0.826 | 59025.4 |
444 | 2023-09-30 22:41:07 | joists | 1 | 48755 | 6 | 0.720 | 67715.3 |
443 | 2023-09-30 12:58:44 | joists | 3 | 112716 | 742 | 4.923 | 22895.8 |
442 | 2023-09-30 12:58:45 | joists | 2 | 82551 | 71 | 2.360 | 34979.2 |
441 | 2023-09-24 22:38:22 | joists | 3 | 112716 | 742 | 5.530 | 20382.6 |
440 | 2023-09-24 22:07:18 | joists | 1 | 48755 | 6 | 0.720 | 67715.3 |
439 | 2023-09-16 12:40:55 | joists | 1 | 48755 | 6 | 0.796 | 61250.0 |
438 | 2023-08-25 09:42:43 | joists | 2 | 82551 | 71 | 2.406 | 34310.5 |
437 | 2023-07-27 14:55:21 | joists | 1 | 48755 | 6 | 0.750 | 65006.7 |
436 | 2023-07-09 06:03:13 | joists | 1 | 48755 | 6 | 0.783 | 62266.9 |
435 | 2023-07-05 02:47:53 | joists | 3 | 112716 | 742 | 4.606 | 24471.6 |
434 | 2023-05-09 23:07:46 | joists | 2 | 82551 | 71 | 2.063 | 40015.0 |
433 | 2023-04-24 09:47:12 | joists | 1 | 48755 | 6 | 0.890 | 54780.9 |
432 | 2023-03-25 15:13:50 | joists | 3 | 112716 | 742 | 4.423 | 25484.1 |
431 | 2023-03-25 08:00:14 | joists | 1 | 48755 | 6 | 1.030 | 47335.0 |
430 | 2023-02-26 05:22:28 | joists | 2 | 82551 | 71 | 2.406 | 34310.5 |
429 | 2023-02-15 09:02:57 | joists | 1 | 48755 | 6 | 0.733 | 66514.3 |
428 | 2023-02-15 04:55:52 | joists | 2 | 82551 | 71 | 2.030 | 40665.5 |
427 | 2022-12-31 23:54:15 | joists | 2 | 82551 | 71 | 2.063 | 40015.0 |
426 | 2022-12-28 18:46:42 | joists | 3 | 112716 | 742 | 4.406 | 25582.4 |
425 | 2022-12-23 19:53:51 | joists | 3 | 112716 | 742 | 4.500 | 25048.0 |
424 | 2022-12-14 05:57:30 | joists | 1 | 48755 | 6 | 0.720 | 67715.3 |
423 | 2022-12-07 04:07:43 | joists | 1 | 48755 | 6 | 0.720 | 67715.3 |
422 | 2022-11-26 07:52:08 | joists | 2 | 82551 | 71 | 2.016 | 40947.9 |
421 | 2022-11-03 14:09:52 | joists | 3 | 112716 | 742 | 4.716 | 23900.8 |
420 | 2022-09-17 19:57:01 | joists | 1 | 48755 | 6 | 1.546 | 31536.2 |
419 | 2022-08-23 05:29:49 | joists | 3 | 112716 | 742 | 4.500 | 25048.0 |
418 | 2022-08-20 03:14:16 | joists | 1 | 48755 | 6 | 0.736 | 66243.2 |
417 | 2022-08-06 23:23:56 | joists | 1 | 48755 | 6 | 0.716 | 68093.6 |
416 | 2022-04-13 08:54:19 | joists | 2 | 82551 | 71 | 2.516 | 32810.4 |
415 | 2022-04-11 03:12:14 | joists | 2 | 82551 | 71 | 2.500 | 33020.4 |
414 | 2022-04-09 02:53:26 | joists | 1 | 48755 | 6 | 0.780 | 62506.4 |
413 | 2022-04-08 10:32:59 | joists | 1 | 48755 | 6 | 0.936 | 52088.7 |
412 | 2022-04-06 09:17:02 | joists | 1 | 48755 | 6 | 0.720 | 67715.3 |
411 | 2022-01-10 00:44:03 | joists | 1 | 48755 | 6 | 0.763 | 63899.1 |
410 | 2022-01-07 21:05:00 | joists | 1 | 48755 | 6 | 0.813 | 59969.2 |
409 | 2021-12-24 23:36:50 | joists | 1 | 48755 | 6 | 0.846 | 57630.0 |
408 | 2021-12-21 18:36:30 | joists | 1 | 48755 | 6 | 0.826 | 59025.4 |
407 | 2021-12-14 16:26:04 | joists | 2 | 82551 | 71 | 2.500 | 33020.4 |
406 | 2021-12-11 05:06:28 | joists | 1 | 48755 | 6 | 0.890 | 54780.9 |
405 | 2021-11-06 02:51:43 | joists | 1 | 48755 | 6 | 0.733 | 66514.3 |
404 | 2021-10-26 19:25:10 | joists | 1 | 48755 | 6 | 0.716 | 68093.6 |
403 | 2021-10-26 09:51:57 | joists | 1 | 48755 | 6 | 0.903 | 53992.2 |
402 | 2021-10-25 14:03:39 | joists | 1 | 48755 | 6 | 0.813 | 59969.2 |
401 | 2021-10-25 03:56:18 | joists | 1 | 48755 | 6 | 0.813 | 59969.2 |
400 | 2021-10-24 19:58:27 | joists | 1 | 48755 | 6 | 0.733 | 66514.3 |
399 | 2021-10-24 09:55:38 | joists | 1 | 48755 | 6 | 0.810 | 60191.4 |
398 | 2021-10-24 02:48:32 | joists | 1 | 48755 | 6 | 0.843 | 57835.1 |
397 | 2021-10-23 16:28:55 | joists | 1 | 48755 | 6 | 0.813 | 59969.2 |
396 | 2021-10-23 09:20:31 | joists | 1 | 48755 | 6 | 0.843 | 57835.1 |
395 | 2021-10-22 16:32:03 | joists | 1 | 48755 | 6 | 0.796 | 61250.0 |
394 | 2021-09-25 15:39:57 | joists | 1 | 48755 | 6 | 0.736 | 66243.2 |
393 | 2021-09-24 10:31:42 | joists | 1 | 48755 | 6 | 0.906 | 53813.5 |
392 | 2021-09-23 17:24:40 | joists | 1 | 48755 | 6 | 0.826 | 59025.4 |