History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"medicants"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
248 | 2024-05-07 13:42:16 | medicants | 2 | 121436 | 17 | 3.796 | 31990.5 |
247 | 2024-05-06 23:43:10 | medicants | 4 | 165329 | 409 | 36.253 | 4560.4 |
246 | 2024-05-03 21:21:43 | medicants | 1 | 81242 | 4 | 3.156 | 25742.1 |
245 | 2024-04-30 16:02:53 | medicants | 4 | 165329 | 409 | 12.233 | 13515.0 |
244 | 2024-04-29 22:00:10 | medicants | 4 | 165329 | 409 | 15.533 | 10643.7 |
243 | 2024-04-29 19:41:37 | medicants | 4 | 165329 | 409 | 13.263 | 12465.4 |
242 | 2024-04-26 12:06:34 | medicants | 1 | 81242 | 4 | 1.406 | 57782.4 |
241 | 2024-04-13 05:01:36 | medicants | 1 | 81242 | 4 | 1.390 | 58447.5 |
240 | 2024-04-12 10:22:46 | medicants | 3 | 148641 | 79 | 10.483 | 14179.2 |
239 | 2024-04-12 02:54:15 | medicants | 3 | 148641 | 79 | 20.063 | 7408.7 |
238 | 2024-04-11 12:56:19 | medicants | 3 | 148641 | 79 | 7.156 | 20771.5 |
237 | 2024-04-08 05:38:56 | medicants | 1 | 81242 | 4 | 2.906 | 27956.6 |
236 | 2024-04-05 00:13:49 | medicants | 1 | 81242 | 4 | 1.403 | 57905.9 |
235 | 2024-03-31 02:46:47 | medicants | 1 | 81242 | 4 | 1.266 | 64172.2 |
234 | 2024-03-06 12:45:43 | medicants | 1 | 81242 | 4 | 1.500 | 54161.3 |
233 | 2024-03-05 16:44:32 | medicants | 1 | 81242 | 4 | 1.453 | 55913.3 |
232 | 2024-03-05 13:58:22 | medicants | 1 | 81242 | 4 | 1.390 | 58447.5 |
231 | 2024-03-01 00:26:25 | medicants | 1 | 81242 | 4 | 1.513 | 53696.0 |
230 | 2024-01-31 05:54:00 | medicants | 1 | 81242 | 4 | 2.860 | 28406.3 |
229 | 2024-01-29 14:43:23 | medicants | 1 | 81242 | 4 | 1.390 | 58447.5 |
228 | 2024-01-29 14:43:15 | medicants | 1 | 81242 | 4 | 1.390 | 58447.5 |
227 | 2023-12-25 18:00:46 | medicants | 1 | 81242 | 4 | 1.233 | 65889.7 |
226 | 2023-12-24 06:46:13 | medicants | 4 | 165329 | 409 | 11.830 | 13975.4 |
225 | 2023-12-10 05:45:08 | medicants | 3 | 148641 | 79 | 6.076 | 24463.6 |
224 | 2023-12-07 23:12:18 | medicants | 1 | 81242 | 4 | 1.483 | 54782.2 |
223 | 2023-11-25 20:34:45 | medicants | 1 | 81242 | 4 | 1.453 | 55913.3 |
222 | 2023-11-21 19:02:59 | medicants | 1 | 81242 | 4 | 1.376 | 59042.2 |
221 | 2023-11-20 04:49:32 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
220 | 2023-11-17 19:53:03 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |
219 | 2023-10-31 13:28:38 | medicants | 1 | 81242 | 4 | 1.233 | 65889.7 |
218 | 2023-10-15 17:15:34 | medicants | 1 | 81242 | 4 | 1.436 | 56575.2 |
217 | 2023-09-25 22:59:08 | medicants | 4 | 165329 | 409 | 13.343 | 12390.7 |
216 | 2023-09-06 20:01:56 | medicants | 3 | 148641 | 79 | 6.216 | 23912.6 |
215 | 2023-08-11 02:46:58 | medicants | 1 | 81242 | 4 | 1.330 | 61084.2 |
214 | 2023-07-20 08:21:46 | medicants | 1 | 81242 | 4 | 1.346 | 60358.1 |
213 | 2023-07-07 07:20:03 | medicants | 4 | 165329 | 409 | 10.513 | 15726.1 |
212 | 2023-05-22 15:18:52 | medicants | 3 | 148641 | 79 | 6.106 | 24343.4 |
211 | 2023-05-13 14:39:33 | medicants | 1 | 81242 | 4 | 1.406 | 57782.4 |
210 | 2023-04-01 07:30:14 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |
209 | 2023-03-31 01:41:42 | medicants | 4 | 165329 | 409 | 10.486 | 15766.6 |
208 | 2023-03-11 23:18:17 | medicants | 1 | 81242 | 4 | 1.326 | 61268.5 |
207 | 2023-03-02 13:47:19 | medicants | 3 | 148641 | 79 | 5.970 | 24898.0 |
206 | 2022-12-30 22:10:13 | medicants | 4 | 165329 | 409 | 10.330 | 16004.7 |
205 | 2022-12-29 15:22:26 | medicants | 1 | 81242 | 4 | 1.343 | 60492.9 |
204 | 2022-12-11 14:31:04 | medicants | 3 | 148641 | 79 | 6.033 | 24638.0 |
203 | 2022-12-10 02:46:35 | medicants | 1 | 81242 | 4 | 1.216 | 66810.9 |
202 | 2022-09-20 13:07:44 | medicants | 1 | 81242 | 4 | 1.220 | 66591.8 |
201 | 2022-09-05 06:13:55 | medicants | 4 | 165329 | 409 | 12.126 | 13634.3 |
200 | 2022-09-03 03:28:01 | medicants | 4 | 165329 | 409 | 12.110 | 13652.3 |
199 | 2022-08-06 14:37:00 | medicants | 1 | 81242 | 4 | 1.266 | 64172.2 |
198 | 2022-06-30 22:32:49 | medicants | 3 | 148641 | 79 | 6.156 | 24145.7 |
197 | 2022-06-28 18:18:22 | medicants | 3 | 148641 | 79 | 6.000 | 24773.5 |
196 | 2022-06-17 07:29:30 | medicants | 2 | 121436 | 17 | 3.796 | 31990.5 |
195 | 2022-06-15 02:19:14 | medicants | 2 | 121436 | 17 | 3.033 | 40038.2 |
194 | 2022-05-29 02:31:36 | medicants | 4 | 165329 | 409 | 11.080 | 14921.4 |
193 | 2022-05-14 04:55:22 | medicants | 3 | 148641 | 79 | 6.313 | 23545.2 |
192 | 2022-05-03 21:59:37 | medicants | 1 | 81242 | 4 | 1.580 | 51419.0 |
191 | 2022-04-24 03:48:23 | medicants | 4 | 165329 | 409 | 11.546 | 14319.2 |
190 | 2022-04-07 03:58:13 | medicants | 3 | 148641 | 79 | 6.266 | 23721.8 |
189 | 2022-04-05 06:51:09 | medicants | 1 | 81242 | 4 | 1.420 | 57212.7 |
188 | 2022-04-01 20:07:35 | medicants | 1 | 81242 | 4 | 1.406 | 57782.4 |
187 | 2022-03-28 15:52:56 | medicants | 4 | 165329 | 409 | 11.343 | 14575.4 |
186 | 2022-02-10 02:01:36 | medicants | 3 | 148641 | 79 | 6.203 | 23962.8 |
185 | 2022-01-29 21:14:50 | medicants | 2 | 121436 | 17 | 3.110 | 39046.9 |
184 | 2022-01-25 02:12:52 | medicants | 1 | 81242 | 4 | 1.470 | 55266.7 |
183 | 2022-01-22 22:12:13 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |
182 | 2021-12-18 05:17:48 | medicants | 1 | 81242 | 4 | 1.296 | 62686.7 |
181 | 2021-11-18 10:23:26 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |
180 | 2021-11-16 18:24:46 | medicants | 2 | 121436 | 17 | 3.110 | 39046.9 |
179 | 2021-11-16 09:29:29 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
178 | 2021-10-30 19:56:52 | medicants | 1 | 81242 | 4 | 1.420 | 57212.7 |
177 | 2021-10-29 18:36:02 | medicants | 1 | 81242 | 4 | 1.453 | 55913.3 |
176 | 2021-09-29 22:13:18 | medicants | 1 | 81242 | 4 | 1.470 | 55266.7 |
175 | 2021-09-21 00:53:53 | medicants | 1 | 81242 | 4 | 1.406 | 57782.4 |
174 | 2021-09-20 07:40:44 | medicants | 1 | 81242 | 4 | 1.313 | 61875.1 |
173 | 2021-09-14 05:52:01 | medicants | 1 | 81242 | 4 | 1.356 | 59913.0 |
172 | 2021-09-12 19:45:11 | medicants | 1 | 81242 | 4 | 1.283 | 63321.9 |
171 | 2021-09-04 12:14:00 | medicants | 1 | 81242 | 4 | 1.343 | 60492.9 |
170 | 2021-08-09 09:36:43 | medicants | 1 | 81242 | 4 | 1.266 | 64172.2 |
169 | 2021-08-08 15:07:32 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
168 | 2021-07-11 17:36:26 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
167 | 2021-05-31 11:22:32 | medicants | 1 | 81242 | 4 | 1.406 | 57782.4 |
166 | 2021-05-09 11:41:27 | medicants | 4 | 165329 | 409 | 13.376 | 12360.1 |
165 | 2021-04-11 08:00:56 | medicants | 4 | 165329 | 409 | 10.706 | 15442.6 |
164 | 2021-03-15 08:18:05 | medicants | 4 | 165329 | 409 | 11.423 | 14473.3 |
163 | 2021-02-25 01:57:26 | medicants | 1 | 81242 | 4 | 1.343 | 60492.9 |
162 | 2020-12-27 18:59:28 | medicants | 4 | 165329 | 409 | 10.640 | 15538.4 |
161 | 2020-11-20 11:11:22 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
160 | 2020-11-20 01:54:59 | medicants | 1 | 81242 | 4 | 1.326 | 61268.5 |
159 | 2020-11-18 22:41:24 | medicants | 1 | 81242 | 4 | 2.063 | 39380.5 |
158 | 2020-10-31 02:49:03 | medicants | 1 | 81242 | 4 | 1.266 | 64172.2 |
157 | 2020-10-26 17:10:18 | medicants | 1 | 81242 | 4 | 1.390 | 58447.5 |
156 | 2020-10-26 03:56:08 | medicants | 1 | 81242 | 4 | 1.266 | 64172.2 |
155 | 2020-09-14 04:05:26 | medicants | 1 | 81242 | 4 | 1.250 | 64993.6 |
154 | 2020-08-13 12:25:49 | medicants | 1 | 81242 | 4 | 1.326 | 61268.5 |
153 | 2020-07-13 11:34:49 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |
152 | 2020-05-12 09:52:33 | medicants | 1 | 81242 | 4 | 1.280 | 63470.3 |
151 | 2020-04-12 03:41:51 | medicants | 1 | 81242 | 4 | 1.343 | 60492.9 |
150 | 2020-03-28 12:37:26 | medicants | 1 | 81242 | 4 | 1.376 | 59042.2 |
149 | 2020-03-22 07:11:01 | medicants | 1 | 81242 | 4 | 1.360 | 59736.8 |