History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"skatole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
183 | 2024-04-07 23:35:48 | skatole | 1 | 69583 | 4 | 1.390 | 50059.7 |
182 | 2024-03-28 17:27:58 | skatole | 1 | 69583 | 4 | 3.123 | 22280.8 |
181 | 2024-03-17 16:46:49 | skatole | 3 | 134027 | 142 | 7.233 | 18529.9 |
180 | 2024-03-09 07:08:46 | skatole | 3 | 134027 | 142 | 18.686 | 7172.6 |
179 | 2024-03-09 07:08:46 | skatole | 2 | 107671 | 9 | 7.690 | 14001.4 |
178 | 2024-03-07 23:35:44 | skatole | 2 | 107671 | 9 | 3.423 | 31455.2 |
177 | 2024-03-07 23:35:33 | skatole | 3 | 134027 | 142 | 7.626 | 17575.0 |
176 | 2024-03-07 18:27:53 | skatole | 3 | 134027 | 142 | 10.796 | 12414.5 |
175 | 2024-03-07 15:31:00 | skatole | 2 | 107671 | 9 | 6.390 | 16849.9 |
174 | 2024-03-07 15:30:12 | skatole | 3 | 134027 | 142 | 7.186 | 18651.1 |
173 | 2024-03-07 14:18:44 | skatole | 1 | 69583 | 4 | 1.233 | 56433.9 |
172 | 2024-02-05 19:19:17 | skatole | 3 | 134027 | 142 | 8.596 | 15591.8 |
171 | 2024-02-05 19:19:21 | skatole | 2 | 107671 | 9 | 4.313 | 24964.3 |
170 | 2024-02-05 19:19:13 | skatole | 1 | 69583 | 4 | 2.093 | 33245.6 |
169 | 2024-01-25 15:56:18 | skatole | 2 | 107671 | 9 | 2.860 | 37647.2 |
168 | 2024-01-20 06:56:54 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
167 | 2024-01-11 07:28:16 | skatole | 3 | 134027 | 142 | 5.716 | 23447.7 |
166 | 2024-01-11 07:28:12 | skatole | 2 | 107671 | 9 | 3.170 | 33965.6 |
165 | 2024-01-06 14:29:58 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
164 | 2023-11-26 08:20:12 | skatole | 3 | 134027 | 142 | 6.406 | 20922.1 |
163 | 2023-11-17 02:33:37 | skatole | 1 | 69583 | 4 | 1.126 | 61796.6 |
162 | 2023-11-16 22:08:31 | skatole | 1 | 69583 | 4 | 1.263 | 55093.4 |
161 | 2023-11-06 18:13:10 | skatole | 2 | 107671 | 9 | 3.030 | 35535.0 |
160 | 2023-09-29 03:27:28 | skatole | 1 | 69583 | 4 | 1.123 | 61961.7 |
159 | 2023-09-25 10:08:36 | skatole | 1 | 69583 | 4 | 1.203 | 57841.2 |
158 | 2023-09-20 14:41:24 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
157 | 2023-09-04 09:42:50 | skatole | 1 | 69583 | 4 | 1.190 | 58473.1 |
156 | 2023-08-25 15:20:41 | skatole | 3 | 134027 | 142 | 6.373 | 21030.4 |
155 | 2023-08-10 19:12:42 | skatole | 2 | 107671 | 9 | 2.843 | 37872.3 |
154 | 2023-05-10 18:21:58 | skatole | 1 | 69583 | 4 | 1.090 | 63837.6 |
153 | 2023-05-10 07:16:07 | skatole | 3 | 134027 | 142 | 5.780 | 23188.1 |
152 | 2023-04-23 06:44:49 | skatole | 2 | 107671 | 9 | 2.843 | 37872.3 |
151 | 2023-04-20 06:06:59 | skatole | 1 | 69583 | 4 | 1.233 | 56433.9 |
150 | 2023-03-22 13:07:45 | skatole | 1 | 69583 | 4 | 1.186 | 58670.3 |
149 | 2023-02-17 10:34:17 | skatole | 3 | 134027 | 142 | 5.530 | 24236.3 |
148 | 2023-02-01 09:17:01 | skatole | 1 | 69583 | 4 | 1.186 | 58670.3 |
147 | 2023-01-29 19:32:29 | skatole | 2 | 107671 | 9 | 2.736 | 39353.4 |
146 | 2023-01-06 07:28:35 | skatole | 1 | 69583 | 4 | 1.046 | 66522.9 |
145 | 2022-11-29 22:37:11 | skatole | 1 | 69583 | 4 | 1.046 | 66522.9 |
144 | 2022-11-27 20:41:22 | skatole | 3 | 134027 | 142 | 5.560 | 24105.6 |
143 | 2022-11-11 07:26:53 | skatole | 2 | 107671 | 9 | 2.766 | 38926.6 |
142 | 2022-08-28 21:22:13 | skatole | 1 | 69583 | 4 | 1.080 | 64428.7 |
141 | 2022-08-25 22:55:58 | skatole | 1 | 69583 | 4 | 1.060 | 65644.3 |
140 | 2022-08-18 14:03:40 | skatole | 1 | 69583 | 4 | 1.060 | 65644.3 |
139 | 2022-07-26 07:37:51 | skatole | 1 | 69583 | 4 | 1.236 | 56296.9 |
138 | 2022-07-25 01:38:45 | skatole | 1 | 69583 | 4 | 1.076 | 64668.2 |
137 | 2022-07-05 12:58:56 | skatole | 3 | 134027 | 142 | 5.923 | 22628.2 |
136 | 2022-05-28 13:35:42 | skatole | 2 | 107671 | 9 | 3.110 | 34620.9 |
135 | 2022-04-01 19:41:21 | skatole | 1 | 69583 | 4 | 1.266 | 54962.9 |
134 | 2022-03-25 00:55:04 | skatole | 1 | 69583 | 4 | 1.263 | 55093.4 |
133 | 2021-11-14 06:10:57 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
132 | 2021-07-21 20:24:23 | skatole | 1 | 69583 | 4 | 1.046 | 66522.9 |
131 | 2021-05-29 10:14:47 | skatole | 1 | 69583 | 4 | 1.263 | 55093.4 |
130 | 2021-04-28 13:58:02 | skatole | 1 | 69583 | 4 | 1.310 | 53116.8 |
129 | 2021-04-19 01:01:10 | skatole | 1 | 69583 | 4 | 1.076 | 64668.2 |
128 | 2021-02-19 16:05:31 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
127 | 2021-01-11 15:48:46 | skatole | 1 | 69583 | 4 | 1.140 | 61037.7 |
126 | 2021-01-10 00:01:34 | skatole | 1 | 69583 | 4 | 1.063 | 65459.1 |
125 | 2021-01-05 13:44:41 | skatole | 1 | 69583 | 4 | 1.093 | 63662.4 |
124 | 2020-11-07 03:08:12 | skatole | 1 | 69583 | 4 | 1.593 | 43680.5 |
123 | 2020-10-29 18:26:35 | skatole | 1 | 69583 | 4 | 1.250 | 55666.4 |
122 | 2020-09-29 19:08:21 | skatole | 1 | 69583 | 4 | 1.203 | 57841.2 |
121 | 2020-09-08 12:13:01 | skatole | 1 | 69583 | 4 | 1.203 | 57841.2 |
120 | 2020-08-03 17:19:14 | skatole | 1 | 69583 | 4 | 1.096 | 63488.1 |
119 | 2020-06-07 23:50:25 | skatole | 1 | 69583 | 4 | 1.076 | 64668.2 |
118 | 2020-03-27 07:48:06 | skatole | 1 | 69583 | 4 | 1.296 | 53690.6 |
117 | 2020-03-26 12:19:25 | skatole | 1 | 69583 | 4 | 1.203 | 57841.2 |
116 | 2020-03-21 22:54:59 | skatole | 1 | 69583 | 4 | 1.263 | 55093.4 |
115 | 2020-02-26 16:37:34 | skatole | 1 | 69583 | 4 | 1.516 | 45899.1 |
114 | 2020-02-23 23:08:35 | skatole | 1 | 69583 | 4 | 2.126 | 32729.5 |
113 | 2020-02-23 15:55:51 | skatole | 1 | 69583 | 4 | 1.330 | 52318.0 |
112 | 2020-02-22 11:09:57 | skatole | 1 | 69583 | 4 | 1.313 | 52995.4 |
111 | 2020-02-12 12:04:14 | skatole | 1 | 69583 | 4 | 1.250 | 55666.4 |
110 | 2020-02-07 03:00:33 | skatole | 1 | 69583 | 4 | 1.263 | 55093.4 |
109 | 2020-01-29 05:22:37 | skatole | 1 | 69583 | 4 | 3.280 | 21214.3 |
108 | 2020-01-26 17:22:24 | skatole | 1 | 69583 | 4 | 1.673 | 41591.8 |
107 | 2020-01-26 13:26:40 | skatole | 1 | 69583 | 4 | 4.093 | 17000.5 |
106 | 2020-01-20 14:22:47 | skatole | 1 | 69583 | 4 | 1.406 | 49490.0 |
105 | 2020-01-15 23:17:12 | skatole | 1 | 69583 | 4 | 3.923 | 17737.2 |
104 | 2020-01-07 02:31:29 | skatole | 1 | 69583 | 4 | 2.766 | 25156.5 |
103 | 2020-01-07 00:32:50 | skatole | 1 | 69583 | 4 | 2.733 | 25460.3 |
102 | 2020-01-06 18:16:09 | skatole | 1 | 69583 | 4 | 2.266 | 30707.4 |
101 | 2019-12-29 20:54:55 | skatole | 1 | 69583 | 4 | 1.143 | 60877.5 |
100 | 2019-11-24 19:02:10 | skatole | 1 | 69583 | 4 | 1.063 | 65459.1 |
99 | 2019-08-26 00:32:22 | skatole | 1 | 69583 | 4 | 1.163 | 59830.6 |
98 | 2019-05-13 19:00:05 | skatole | 1 | 69583 | 4 | 1.203 | 57841.2 |
97 | 2019-01-19 11:34:29 | skatole | 1 | 69583 | 4 | 1.143 | 60877.5 |
96 | 2019-01-17 04:08:05 | skatole | 1 | 69583 | 4 | 1.060 | 65644.3 |
95 | 2018-10-03 15:14:27 | skatole | 1 | 69583 | 4 | 2.450 | 28401.2 |
94 | 2018-09-17 01:21:51 | skatole | 1 | 69583 | 4 | 1.206 | 57697.3 |
93 | 2018-07-30 04:31:16 | skatole | 1 | 69583 | 4 | 1.210 | 57506.6 |
92 | 2018-06-16 04:18:48 | skatole | 1 | 69583 | 4 | 1.180 | 58968.6 |
91 | 2018-06-07 13:04:13 | skatole | 1 | 69583 | 4 | 1.083 | 64250.2 |
90 | 2018-03-16 11:04:43 | skatole | 1 | 69583 | 4 | 2.020 | 34447.0 |
89 | 2017-12-01 19:21:41 | skatole | 1 | 69583 | 4 | 1.920 | 36241.1 |
88 | 2017-10-02 22:21:23 | skatole | 1 | 69583 | 4 | 1.393 | 49951.9 |
87 | 2017-09-30 21:46:18 | skatole | 1 | 69583 | 4 | 1.443 | 48221.1 |
86 | 2017-08-02 22:22:45 | skatole | 1 | 69583 | 4 | 1.450 | 47988.3 |
85 | 2017-06-12 23:59:15 | skatole | 1 | 69583 | 4 | 1.413 | 49244.9 |
84 | 2017-05-30 16:44:32 | skatole | 1 | 69583 | 4 | 1.416 | 49140.5 |