History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"triptan"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
243 | 2024-05-14 01:16:30 | triptan | 2 | 107671 | 11 | 10.093 | 10667.9 |
242 | 2024-05-14 01:16:13 | triptan | 3 | 134027 | 127 | 7.596 | 17644.4 |
241 | 2024-05-11 15:24:37 | triptan | 3 | 134027 | 127 | 17.846 | 7510.2 |
240 | 2024-05-11 05:44:10 | triptan | 3 | 134027 | 127 | 23.346 | 5740.9 |
239 | 2024-05-09 10:15:05 | triptan | 3 | 134027 | 127 | 7.610 | 17612.0 |
238 | 2024-05-09 10:15:06 | triptan | 2 | 107671 | 11 | 3.670 | 29338.1 |
237 | 2024-05-09 10:15:02 | triptan | 1 | 69583 | 3 | 1.440 | 48321.5 |
236 | 2024-04-30 13:56:48 | triptan | 2 | 107671 | 11 | 4.060 | 26520.0 |
235 | 2024-04-30 02:50:04 | triptan | 3 | 134027 | 127 | 11.673 | 11481.8 |
234 | 2024-04-27 04:00:53 | triptan | 1 | 69583 | 3 | 1.296 | 53690.6 |
233 | 2024-04-17 06:47:00 | triptan | 1 | 69583 | 3 | 1.313 | 52995.4 |
232 | 2024-04-13 16:16:32 | triptan | 3 | 134027 | 127 | 7.423 | 18055.6 |
231 | 2024-04-12 19:38:08 | triptan | 3 | 134027 | 127 | 8.873 | 15105.0 |
230 | 2024-04-11 02:34:32 | triptan | 3 | 134027 | 127 | 6.906 | 19407.3 |
229 | 2024-04-10 21:26:08 | triptan | 2 | 107671 | 11 | 8.826 | 12199.3 |
228 | 2024-04-10 13:30:50 | triptan | 2 | 107671 | 11 | 8.203 | 13125.8 |
227 | 2024-04-10 13:28:44 | triptan | 2 | 107671 | 11 | 9.453 | 11390.1 |
226 | 2024-04-10 03:45:47 | triptan | 3 | 134027 | 127 | 15.330 | 8742.8 |
225 | 2024-04-08 22:02:45 | triptan | 3 | 134027 | 127 | 18.470 | 7256.5 |
224 | 2024-04-08 22:02:48 | triptan | 2 | 107671 | 11 | 5.326 | 20216.1 |
223 | 2024-04-08 21:51:35 | triptan | 1 | 69583 | 3 | 1.546 | 45008.4 |
222 | 2024-03-14 14:12:26 | triptan | 3 | 134027 | 127 | 25.080 | 5344.0 |
221 | 2024-03-11 22:27:43 | triptan | 3 | 134027 | 127 | 14.050 | 9539.3 |
220 | 2024-03-11 02:03:50 | triptan | 2 | 107671 | 11 | 3.670 | 29338.1 |
219 | 2024-03-11 02:02:52 | triptan | 3 | 134027 | 127 | 8.313 | 16122.6 |
218 | 2024-03-08 17:47:50 | triptan | 3 | 134027 | 127 | 19.483 | 6879.2 |
217 | 2024-03-08 17:47:47 | triptan | 2 | 107671 | 11 | 14.813 | 7268.7 |
216 | 2024-03-08 17:33:21 | triptan | 1 | 69583 | 3 | 2.606 | 26701.1 |
215 | 2024-02-18 12:23:03 | triptan | 1 | 69583 | 3 | 2.440 | 28517.6 |
214 | 2024-02-08 09:09:44 | triptan | 3 | 134027 | 127 | 17.690 | 7576.4 |
213 | 2024-02-07 01:55:52 | triptan | 2 | 107671 | 11 | 7.250 | 14851.2 |
212 | 2024-02-07 01:55:38 | triptan | 3 | 134027 | 127 | 8.343 | 16064.6 |
211 | 2024-02-06 01:18:37 | triptan | 2 | 107671 | 11 | 6.690 | 16094.3 |
210 | 2024-02-06 00:44:46 | triptan | 3 | 134027 | 127 | 7.050 | 19010.9 |
209 | 2024-02-05 19:02:25 | triptan | 3 | 134027 | 127 | 8.236 | 16273.3 |
208 | 2024-02-05 19:02:29 | triptan | 2 | 107671 | 11 | 3.563 | 30219.2 |
207 | 2024-02-05 13:44:47 | triptan | 2 | 107671 | 11 | 5.516 | 19519.8 |
206 | 2024-02-05 13:44:41 | triptan | 3 | 134027 | 127 | 8.093 | 16560.9 |
205 | 2024-02-05 13:35:34 | triptan | 1 | 69583 | 3 | 1.296 | 53690.6 |
204 | 2024-02-03 06:38:32 | triptan | 2 | 107671 | 11 | 3.170 | 33965.6 |
203 | 2024-01-05 16:36:52 | triptan | 1 | 69583 | 3 | 1.296 | 53690.6 |
202 | 2024-01-02 05:03:22 | triptan | 1 | 69583 | 3 | 1.080 | 64428.7 |
201 | 2023-12-14 18:48:43 | triptan | 2 | 107671 | 11 | 3.046 | 35348.3 |
200 | 2023-11-10 17:34:56 | triptan | 2 | 107671 | 11 | 3.186 | 33795.0 |
199 | 2023-10-24 21:02:26 | triptan | 1 | 69583 | 3 | 1.143 | 60877.5 |
198 | 2023-10-17 19:34:15 | triptan | 1 | 69583 | 3 | 1.313 | 52995.4 |
197 | 2023-10-09 18:10:27 | triptan | 1 | 69583 | 3 | 1.076 | 64668.2 |
196 | 2023-09-28 13:16:02 | triptan | 1 | 69583 | 3 | 1.063 | 65459.1 |
195 | 2023-08-19 22:09:45 | triptan | 1 | 69583 | 3 | 1.046 | 66522.9 |
194 | 2023-08-14 03:26:11 | triptan | 2 | 107671 | 11 | 2.750 | 39153.1 |
193 | 2023-05-22 00:24:00 | triptan | 1 | 69583 | 3 | 1.093 | 63662.4 |
192 | 2023-04-24 05:28:24 | triptan | 2 | 107671 | 11 | 2.750 | 39153.1 |
191 | 2023-03-19 17:07:01 | triptan | 1 | 69583 | 3 | 1.250 | 55666.4 |
190 | 2023-01-30 17:56:10 | triptan | 2 | 107671 | 11 | 2.780 | 38730.6 |
189 | 2023-01-07 04:33:13 | triptan | 1 | 69583 | 3 | 1.093 | 63662.4 |
188 | 2022-11-11 14:02:16 | triptan | 2 | 107671 | 11 | 3.453 | 31181.9 |
187 | 2022-10-02 14:31:25 | triptan | 1 | 69583 | 3 | 1.173 | 59320.5 |
186 | 2022-08-26 22:06:38 | triptan | 1 | 69583 | 3 | 1.063 | 65459.1 |
185 | 2022-08-24 17:13:48 | triptan | 1 | 69583 | 3 | 1.236 | 56296.9 |
184 | 2022-06-10 13:12:51 | triptan | 2 | 107671 | 11 | 3.296 | 32667.2 |
183 | 2022-05-26 20:23:47 | triptan | 1 | 69583 | 3 | 1.046 | 66522.9 |
182 | 2022-05-18 21:44:52 | triptan | 1 | 69583 | 3 | 1.093 | 63662.4 |
181 | 2022-04-30 02:11:42 | triptan | 1 | 69583 | 3 | 1.050 | 66269.5 |
180 | 2021-09-22 09:17:34 | triptan | 1 | 69583 | 3 | 1.170 | 59472.6 |
179 | 2021-09-21 06:02:11 | triptan | 1 | 69583 | 3 | 1.203 | 57841.2 |
178 | 2021-09-15 01:47:07 | triptan | 1 | 69583 | 3 | 1.216 | 57222.9 |
177 | 2021-02-16 03:20:02 | triptan | 1 | 69583 | 3 | 1.076 | 64668.2 |
176 | 2020-12-24 18:02:45 | triptan | 1 | 69583 | 3 | 1.186 | 58670.3 |
175 | 2020-11-01 20:10:59 | triptan | 1 | 69583 | 3 | 1.173 | 59320.5 |
174 | 2020-03-26 14:43:48 | triptan | 1 | 69583 | 3 | 2.530 | 27503.2 |
173 | 2020-03-24 01:42:24 | triptan | 1 | 69583 | 3 | 1.233 | 56433.9 |
172 | 2020-03-21 11:55:04 | triptan | 1 | 69583 | 3 | 1.170 | 59472.6 |
171 | 2020-03-18 15:20:09 | triptan | 1 | 69583 | 3 | 1.110 | 62687.4 |
170 | 2020-03-15 20:21:51 | triptan | 1 | 69583 | 3 | 1.106 | 62914.1 |
169 | 2020-03-01 00:15:12 | triptan | 1 | 69583 | 3 | 2.593 | 26834.9 |
168 | 2020-02-28 20:09:42 | triptan | 1 | 69583 | 3 | 1.283 | 54234.6 |
167 | 2020-02-22 07:51:08 | triptan | 1 | 69583 | 3 | 1.330 | 52318.0 |
166 | 2020-02-18 13:42:42 | triptan | 1 | 69583 | 3 | 2.470 | 28171.3 |
165 | 2020-02-12 12:11:03 | triptan | 1 | 69583 | 3 | 2.203 | 31585.6 |
164 | 2020-02-03 13:04:11 | triptan | 1 | 69583 | 3 | 1.266 | 54962.9 |
163 | 2020-02-02 01:03:28 | triptan | 1 | 69583 | 3 | 1.343 | 51811.6 |
162 | 2020-01-29 10:12:42 | triptan | 1 | 69583 | 3 | 2.626 | 26497.7 |
161 | 2020-01-21 20:07:43 | triptan | 1 | 69583 | 3 | 1.326 | 52475.9 |
160 | 2020-01-20 18:50:29 | triptan | 1 | 69583 | 3 | 1.670 | 41666.5 |
159 | 2020-01-16 01:07:29 | triptan | 2 | 107671 | 11 | 3.423 | 31455.2 |
158 | 2020-01-15 22:37:04 | triptan | 1 | 69583 | 3 | 1.436 | 48456.1 |
157 | 2020-01-09 19:58:44 | triptan | 1 | 69583 | 3 | 2.183 | 31874.9 |
156 | 2020-01-08 09:58:34 | triptan | 1 | 69583 | 3 | 2.203 | 31585.6 |
155 | 2020-01-02 14:14:11 | triptan | 1 | 69583 | 3 | 1.360 | 51164.0 |
154 | 2019-12-30 04:34:13 | triptan | 1 | 69583 | 3 | 2.093 | 33245.6 |
153 | 2019-12-29 19:41:03 | triptan | 1 | 69583 | 3 | 1.236 | 56296.9 |
152 | 2019-12-10 03:31:56 | triptan | 1 | 69583 | 3 | 1.080 | 64428.7 |
151 | 2019-09-08 06:46:41 | triptan | 1 | 69583 | 3 | 1.143 | 60877.5 |
150 | 2019-06-12 05:56:05 | triptan | 1 | 69583 | 3 | 1.053 | 66080.7 |
149 | 2019-06-02 10:41:16 | triptan | 1 | 69583 | 3 | 1.183 | 58819.1 |
148 | 2019-05-30 08:31:26 | triptan | 1 | 69583 | 3 | 1.110 | 62687.4 |
147 | 2019-05-27 06:06:35 | triptan | 1 | 69583 | 3 | 1.206 | 57697.3 |
146 | 2019-02-27 21:50:25 | triptan | 1 | 69583 | 3 | 1.010 | 68894.1 |
145 | 2019-02-22 17:33:22 | triptan | 1 | 69583 | 3 | 1.106 | 62914.1 |
144 | 2019-02-17 15:39:55 | triptan | 1 | 69583 | 3 | 1.066 | 65274.9 |