History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spritsail"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
89 | 2024-05-14 19:23:57 | spritsail | 2 | 121436 | 3 | 13.376 | 9078.6 |
88 | 2024-05-14 19:23:57 | spritsail | 3 | 148641 | 11 | 8.986 | 16541.4 |
87 | 2024-05-14 19:16:31 | spritsail | 1 | 81242 | 2 | 1.360 | 59736.8 |
86 | 2024-04-26 00:51:19 | spritsail | 3 | 148641 | 11 | 25.190 | 5900.8 |
85 | 2024-04-20 16:51:19 | spritsail | 3 | 148641 | 11 | 30.406 | 4888.5 |
84 | 2024-04-20 16:51:17 | spritsail | 4 | 165329 | 102 | 20.326 | 8133.9 |
83 | 2024-04-16 08:43:41 | spritsail | 3 | 148641 | 11 | 27.423 | 5420.3 |
82 | 2024-04-15 04:36:02 | spritsail | 4 | 165329 | 102 | 38.440 | 4301.0 |
81 | 2024-04-15 04:35:55 | spritsail | 3 | 148641 | 11 | 32.096 | 4631.1 |
80 | 2024-04-15 04:35:57 | spritsail | 2 | 121436 | 3 | 7.326 | 16576.0 |
79 | 2024-04-15 04:34:36 | spritsail | 1 | 81242 | 2 | 2.093 | 38816.1 |
78 | 2024-04-11 00:45:09 | spritsail | 1 | 81242 | 2 | 1.483 | 54782.2 |
77 | 2024-04-08 08:37:37 | spritsail | 1 | 81242 | 2 | 3.046 | 26671.7 |
76 | 2024-04-06 16:11:45 | spritsail | 1 | 81242 | 2 | 4.483 | 18122.2 |
75 | 2024-03-11 19:42:45 | spritsail | 4 | 165329 | 102 | 37.113 | 4454.7 |
74 | 2024-03-11 19:42:51 | spritsail | 2 | 121436 | 3 | 12.800 | 9487.2 |
73 | 2024-03-11 19:42:45 | spritsail | 3 | 148641 | 11 | 15.063 | 9868.0 |
72 | 2024-03-11 18:38:12 | spritsail | 1 | 81242 | 2 | 1.373 | 59171.2 |
71 | 2024-03-07 22:56:41 | spritsail | 1 | 81242 | 2 | 1.626 | 49964.3 |
70 | 2024-03-07 16:00:13 | spritsail | 1 | 81242 | 2 | 1.296 | 62686.7 |
69 | 2024-03-05 10:09:01 | spritsail | 1 | 81242 | 2 | 1.563 | 51978.2 |
68 | 2024-02-28 19:49:12 | spritsail | 1 | 81242 | 2 | 1.516 | 53589.7 |
67 | 2024-02-28 19:48:51 | spritsail | 1 | 81242 | 2 | 1.440 | 56418.1 |
66 | 2024-01-29 15:45:10 | spritsail | 1 | 81242 | 2 | 1.313 | 61875.1 |
65 | 2024-01-29 15:44:55 | spritsail | 1 | 81242 | 2 | 1.420 | 57212.7 |
64 | 2024-01-21 21:04:08 | spritsail | 1 | 81242 | 2 | 1.296 | 62686.7 |
63 | 2023-12-26 21:24:25 | spritsail | 1 | 81242 | 2 | 1.500 | 54161.3 |
62 | 2023-11-22 18:39:10 | spritsail | 1 | 81242 | 2 | 1.610 | 50460.9 |
61 | 2023-10-17 11:58:14 | spritsail | 1 | 81242 | 2 | 1.296 | 62686.7 |
60 | 2023-10-15 11:21:33 | spritsail | 1 | 81242 | 2 | 1.656 | 49059.2 |
59 | 2023-09-27 22:24:29 | spritsail | 1 | 81242 | 2 | 1.453 | 55913.3 |
58 | 2023-08-11 10:40:06 | spritsail | 1 | 81242 | 2 | 1.420 | 57212.7 |
57 | 2023-05-08 20:01:45 | spritsail | 1 | 81242 | 2 | 1.233 | 65889.7 |
56 | 2023-03-01 21:19:41 | spritsail | 1 | 81242 | 2 | 1.280 | 63470.3 |
55 | 2022-12-26 08:36:09 | spritsail | 1 | 81242 | 2 | 2.810 | 28911.7 |
54 | 2022-09-14 17:47:06 | spritsail | 1 | 81242 | 2 | 1.250 | 64993.6 |
53 | 2021-02-23 13:52:02 | spritsail | 1 | 81242 | 2 | 1.283 | 63321.9 |
52 | 2020-11-19 11:55:08 | spritsail | 1 | 81242 | 2 | 1.450 | 56029.0 |
51 | 2020-10-24 18:45:50 | spritsail | 1 | 81242 | 2 | 1.390 | 58447.5 |
50 | 2020-03-26 20:14:55 | spritsail | 1 | 81242 | 2 | 1.530 | 53099.3 |
49 | 2020-03-05 01:04:32 | spritsail | 1 | 81242 | 2 | 1.280 | 63470.3 |
48 | 2020-02-19 20:49:17 | spritsail | 1 | 81242 | 2 | 1.436 | 56575.2 |
47 | 2020-02-17 22:13:09 | spritsail | 1 | 81242 | 2 | 1.643 | 49447.4 |
46 | 2020-02-11 17:43:51 | spritsail | 1 | 81242 | 2 | 1.560 | 52078.2 |
45 | 2020-02-10 09:54:42 | spritsail | 1 | 81242 | 2 | 3.076 | 26411.6 |
44 | 2020-01-19 05:35:41 | spritsail | 1 | 81242 | 2 | 1.580 | 51419.0 |
43 | 2020-01-10 09:59:15 | spritsail | 1 | 81242 | 2 | 1.516 | 53589.7 |
42 | 2020-01-07 00:52:45 | spritsail | 1 | 81242 | 2 | 2.283 | 35585.6 |
41 | 2019-11-28 07:08:41 | spritsail | 1 | 81242 | 2 | 1.373 | 59171.2 |
40 | 2018-11-27 09:20:56 | spritsail | 1 | 81242 | 2 | 1.200 | 67701.7 |
39 | 2018-10-19 07:09:26 | spritsail | 1 | 81242 | 2 | 1.196 | 67928.1 |
38 | 2017-04-05 07:49:42 | spritsail | 1 | 81242 | 2 | 2.056 | 39514.6 |
37 | 2016-12-03 15:53:41 | spritsail | 1 | 81242 | 2 | 2.230 | 36431.4 |
36 | 2016-10-27 12:21:21 | spritsail | 1 | 81242 | 2 | 1.773 | 45821.8 |
35 | 2016-10-25 18:55:34 | spritsail | 1 | 81242 | 2 | 1.703 | 47705.2 |
34 | 2016-10-19 10:10:04 | spritsail | 1 | 81242 | 2 | 2.063 | 39380.5 |
33 | 2016-09-25 12:05:22 | spritsail | 1 | 81242 | 2 | 1.916 | 42401.9 |
32 | 2016-08-28 11:48:00 | spritsail | 2 | 121436 | 3 | 5.993 | 20263.0 |
31 | 2016-08-27 12:09:01 | spritsail | 3 | 148641 | 11 | 9.133 | 16275.2 |
30 | 2016-08-23 21:08:47 | spritsail | 4 | 165329 | 102 | 19.476 | 8488.9 |
29 | 2016-08-19 12:58:32 | spritsail | 1 | 81242 | 2 | 2.076 | 39133.9 |
28 | 2016-07-10 00:03:09 | spritsail | 1 | 81242 | 2 | 2.380 | 34135.3 |
27 | 2016-04-13 03:01:15 | spritsail | 1 | 81242 | 2 | 1.936 | 41963.8 |
26 | 2016-02-28 06:50:23 | spritsail | 1 | 81242 | 2 | 2.283 | 35585.6 |
25 | 2016-02-21 07:45:15 | spritsail | 1 | 81242 | 2 | 5.936 | 13686.3 |
24 | 2015-12-18 20:53:23 | spritsail | 1 | 81242 | 2 | 1.350 | 60179.3 |
23 | 2015-11-28 03:37:36 | spritsail | 2 | 121436 | 3 | 3.843 | 31599.3 |
22 | 2015-11-11 19:51:54 | spritsail | 1 | 81242 | 2 | 1.400 | 58030.0 |
21 | 2015-10-26 19:38:21 | spritsail | 3 | 148641 | 11 | 11.790 | 12607.4 |
20 | 2015-10-26 19:37:46 | spritsail | 2 | 121436 | 3 | 3.946 | 30774.5 |
19 | 2015-10-22 19:57:01 | spritsail | 1 | 81242 | 2 | 1.443 | 56300.8 |
18 | 2015-10-20 11:43:02 | spritsail | 1 | 81242 | 2 | 2.830 | 28707.4 |
17 | 2015-10-20 09:06:34 | spritsail | 4 | 165329 | 102 | 14.316 | 11548.5 |
16 | 2015-10-20 08:57:05 | spritsail | 3 | 148641 | 11 | 8.420 | 17653.3 |
15 | 2015-10-20 08:55:43 | spritsail | 2 | 121436 | 3 | 3.800 | 31956.8 |
14 | 2015-10-13 00:55:26 | spritsail | 1 | 81242 | 2 | 2.893 | 28082.3 |
13 | 2015-09-17 11:52:35 | spritsail | 1 | 81242 | 2 | 2.253 | 36059.5 |
12 | 2015-06-25 14:56:47 | spritsail | 1 | 81242 | 2 | 1.723 | 47151.5 |
11 | 2015-05-31 11:30:16 | spritsail | 1 | 81242 | 2 | 3.463 | 23460.0 |
10 | 2015-05-15 08:01:56 | spritsail | 2 | 121436 | 3 | 13.430 | 9042.1 |
9 | 2015-04-27 09:03:57 | spritsail | 4 | 165329 | 102 | 49.136 | 3364.7 |
8 | 2015-04-26 17:07:56 | spritsail | 2 | 121436 | 3 | 4.423 | 27455.6 |
7 | 2015-03-17 18:37:28 | spritsail | 3 | 148641 | 11 | 17.036 | 8725.1 |
6 | 2015-03-17 18:35:59 | spritsail | 3 | 148641 | 11 | 9.983 | 14889.4 |
5 | 2015-03-12 17:23:29 | spritsail | 2 | 121436 | 3 | 5.486 | 22135.6 |
4 | 2015-03-12 02:33:22 | spritsail | 1 | 81242 | 2 | 2.000 | 40621.0 |
3 | 2015-02-25 14:39:02 | spritsail | 1 | 81242 | 2 | 1.696 | 47902.1 |
2 | 2015-01-22 09:25:48 | spritsail | 1 | 81242 | 2 | 1.663 | 48852.7 |
1 | 2014-02-12 15:40:22 | spritsail | 1 | 81242 | 2 | 2.186 | 37164.7 |