History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aspirins"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
283 | 2024-04-29 17:58:05 | aspirins | 1 | 82945 | 3 | 1.516 | 54713.1 |
282 | 2024-04-06 00:04:57 | aspirins | 1 | 82945 | 3 | 3.500 | 23698.6 |
281 | 2024-04-01 02:13:06 | aspirins | 3 | 146162 | 113 | 13.093 | 11163.4 |
280 | 2024-04-01 02:13:07 | aspirins | 2 | 121059 | 9 | 8.673 | 13958.1 |
279 | 2024-04-01 02:13:07 | aspirins | 1 | 82945 | 3 | 3.686 | 22502.7 |
278 | 2024-03-30 02:10:26 | aspirins | 2 | 121059 | 9 | 16.330 | 7413.3 |
277 | 2024-03-30 02:08:40 | aspirins | 1 | 82945 | 3 | 3.110 | 26670.4 |
276 | 2024-03-29 22:52:03 | aspirins | 3 | 146162 | 113 | 27.173 | 5378.9 |
275 | 2024-03-29 11:01:00 | aspirins | 3 | 146162 | 113 | 14.893 | 9814.1 |
274 | 2024-03-29 08:42:36 | aspirins | 3 | 146162 | 113 | 7.483 | 19532.5 |
273 | 2024-03-29 08:42:34 | aspirins | 2 | 121059 | 9 | 4.250 | 28484.5 |
272 | 2024-03-29 08:42:32 | aspirins | 1 | 82945 | 3 | 1.733 | 47862.1 |
271 | 2024-03-07 11:18:03 | aspirins | 1 | 82945 | 3 | 1.670 | 49667.7 |
270 | 2024-03-07 02:17:45 | aspirins | 3 | 146162 | 113 | 13.250 | 11031.1 |
269 | 2024-03-06 13:56:32 | aspirins | 2 | 121059 | 9 | 13.406 | 9030.2 |
268 | 2024-03-06 13:56:30 | aspirins | 3 | 146162 | 113 | 13.470 | 10850.9 |
267 | 2024-03-06 13:55:50 | aspirins | 1 | 82945 | 3 | 4.533 | 18298.0 |
266 | 2024-03-05 16:45:50 | aspirins | 2 | 121059 | 9 | 5.780 | 20944.5 |
265 | 2024-03-05 16:45:46 | aspirins | 1 | 82945 | 3 | 1.580 | 52496.8 |
264 | 2024-02-28 03:11:48 | aspirins | 1 | 82945 | 3 | 1.563 | 53067.8 |
263 | 2024-02-28 03:10:51 | aspirins | 3 | 146162 | 113 | 12.516 | 11678.0 |
262 | 2024-02-28 03:10:52 | aspirins | 2 | 121059 | 9 | 4.063 | 29795.5 |
261 | 2024-01-28 20:11:16 | aspirins | 2 | 121059 | 9 | 4.046 | 29920.7 |
260 | 2024-01-28 20:07:51 | aspirins | 3 | 146162 | 113 | 7.236 | 20199.3 |
259 | 2024-01-26 12:10:35 | aspirins | 3 | 146162 | 113 | 7.063 | 20694.0 |
258 | 2024-01-03 19:12:24 | aspirins | 3 | 146162 | 113 | 6.736 | 21698.6 |
257 | 2023-12-24 22:35:36 | aspirins | 1 | 82945 | 3 | 1.563 | 53067.8 |
256 | 2023-11-18 16:13:32 | aspirins | 1 | 82945 | 3 | 1.236 | 67107.6 |
255 | 2023-11-11 06:39:57 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
254 | 2023-10-24 17:35:13 | aspirins | 1 | 82945 | 3 | 1.266 | 65517.4 |
253 | 2023-10-18 23:57:35 | aspirins | 1 | 82945 | 3 | 1.453 | 57085.3 |
252 | 2023-10-17 11:58:26 | aspirins | 1 | 82945 | 3 | 1.546 | 53651.4 |
251 | 2023-10-14 17:41:02 | aspirins | 3 | 146162 | 113 | 7.906 | 18487.5 |
250 | 2023-10-09 17:41:13 | aspirins | 3 | 146162 | 113 | 6.250 | 23385.9 |
249 | 2023-10-04 19:20:39 | aspirins | 1 | 82945 | 3 | 1.296 | 64000.8 |
248 | 2023-09-26 21:44:05 | aspirins | 1 | 82945 | 3 | 1.563 | 53067.8 |
247 | 2023-09-15 23:30:22 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
246 | 2023-08-29 08:28:56 | aspirins | 1 | 82945 | 3 | 1.250 | 66356.0 |
245 | 2023-07-20 03:39:32 | aspirins | 3 | 146162 | 113 | 7.160 | 20413.7 |
244 | 2023-05-15 17:55:26 | aspirins | 1 | 82945 | 3 | 1.280 | 64800.8 |
243 | 2023-04-03 19:45:09 | aspirins | 3 | 146162 | 113 | 6.720 | 21750.3 |
242 | 2023-02-09 12:29:52 | aspirins | 1 | 82945 | 3 | 1.390 | 59672.7 |
241 | 2023-02-05 19:21:42 | aspirins | 1 | 82945 | 3 | 1.593 | 52068.4 |
240 | 2023-01-13 16:45:06 | aspirins | 1 | 82945 | 3 | 1.423 | 58288.8 |
239 | 2022-12-30 11:27:47 | aspirins | 3 | 146162 | 113 | 6.953 | 21021.4 |
238 | 2022-10-19 10:22:48 | aspirins | 1 | 82945 | 3 | 1.326 | 62552.8 |
237 | 2022-09-02 03:05:59 | aspirins | 3 | 146162 | 113 | 6.596 | 22159.2 |
236 | 2022-07-11 21:50:48 | aspirins | 1 | 82945 | 3 | 1.343 | 61761.0 |
235 | 2022-07-09 17:35:53 | aspirins | 1 | 82945 | 3 | 1.280 | 64800.8 |
234 | 2022-06-29 06:48:04 | aspirins | 1 | 82945 | 3 | 1.250 | 66356.0 |
233 | 2022-04-26 11:01:50 | aspirins | 1 | 82945 | 3 | 1.580 | 52496.8 |
232 | 2022-03-09 05:25:49 | aspirins | 1 | 82945 | 3 | 1.436 | 57761.1 |
231 | 2022-03-05 20:31:13 | aspirins | 1 | 82945 | 3 | 1.266 | 65517.4 |
230 | 2022-03-03 17:10:37 | aspirins | 1 | 82945 | 3 | 1.593 | 52068.4 |
229 | 2022-02-26 01:53:21 | aspirins | 1 | 82945 | 3 | 1.296 | 64000.8 |
228 | 2022-01-09 14:42:33 | aspirins | 1 | 82945 | 3 | 1.470 | 56425.2 |
227 | 2021-12-31 04:07:03 | aspirins | 1 | 82945 | 3 | 1.373 | 60411.5 |
226 | 2021-12-27 14:13:47 | aspirins | 1 | 82945 | 3 | 1.280 | 64800.8 |
225 | 2021-11-27 19:14:33 | aspirins | 1 | 82945 | 3 | 1.500 | 55296.7 |
224 | 2021-11-25 13:43:06 | aspirins | 1 | 82945 | 3 | 1.436 | 57761.1 |
223 | 2021-08-19 05:49:50 | aspirins | 1 | 82945 | 3 | 1.410 | 58826.2 |
222 | 2021-05-18 12:58:51 | aspirins | 1 | 82945 | 3 | 1.500 | 55296.7 |
221 | 2021-05-04 08:23:56 | aspirins | 1 | 82945 | 3 | 1.533 | 54106.3 |
220 | 2021-02-15 07:46:05 | aspirins | 1 | 82945 | 3 | 1.313 | 63172.1 |
219 | 2021-02-12 15:05:29 | aspirins | 1 | 82945 | 3 | 1.390 | 59672.7 |
218 | 2021-02-01 08:04:51 | aspirins | 1 | 82945 | 3 | 1.906 | 43517.8 |
217 | 2021-01-04 18:50:26 | aspirins | 1 | 82945 | 3 | 1.326 | 62552.8 |
216 | 2020-11-17 13:51:15 | aspirins | 1 | 82945 | 3 | 1.420 | 58412.0 |
215 | 2020-11-10 22:39:20 | aspirins | 1 | 82945 | 3 | 1.486 | 55817.6 |
214 | 2020-11-01 10:43:52 | aspirins | 1 | 82945 | 3 | 1.266 | 65517.4 |
213 | 2020-10-28 13:05:46 | aspirins | 1 | 82945 | 3 | 1.483 | 55930.5 |
212 | 2020-10-19 07:02:07 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
211 | 2020-10-03 09:13:58 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
210 | 2020-08-10 21:37:55 | aspirins | 1 | 82945 | 3 | 1.373 | 60411.5 |
209 | 2020-08-07 23:56:11 | aspirins | 1 | 82945 | 3 | 1.450 | 57203.4 |
208 | 2020-05-06 15:11:34 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
207 | 2020-04-07 15:58:08 | aspirins | 1 | 82945 | 3 | 1.406 | 58993.6 |
206 | 2020-03-29 01:19:16 | aspirins | 1 | 82945 | 3 | 1.500 | 55296.7 |
205 | 2020-03-27 02:57:40 | aspirins | 1 | 82945 | 3 | 1.376 | 60279.8 |
204 | 2020-03-22 03:55:27 | aspirins | 1 | 82945 | 3 | 1.393 | 59544.1 |
203 | 2020-03-06 06:29:55 | aspirins | 3 | 146162 | 113 | 8.656 | 16885.6 |
202 | 2020-02-27 20:37:59 | aspirins | 1 | 82945 | 3 | 1.856 | 44690.2 |
201 | 2020-02-26 04:39:38 | aspirins | 1 | 82945 | 3 | 1.466 | 56579.1 |
200 | 2020-02-22 09:54:16 | aspirins | 1 | 82945 | 3 | 3.233 | 25655.7 |
199 | 2020-02-17 02:50:40 | aspirins | 1 | 82945 | 3 | 2.983 | 27805.9 |
198 | 2020-02-12 20:37:53 | aspirins | 1 | 82945 | 3 | 5.016 | 16536.1 |
197 | 2020-02-04 04:31:49 | aspirins | 1 | 82945 | 3 | 1.450 | 57203.4 |
196 | 2020-02-03 01:21:19 | aspirins | 1 | 82945 | 3 | 2.013 | 41204.7 |
195 | 2020-02-02 01:21:54 | aspirins | 1 | 82945 | 3 | 2.423 | 34232.4 |
194 | 2020-02-01 05:58:31 | aspirins | 1 | 82945 | 3 | 1.610 | 51518.6 |
193 | 2020-01-29 02:59:27 | aspirins | 1 | 82945 | 3 | 2.966 | 27965.3 |
192 | 2020-01-23 23:29:54 | aspirins | 3 | 146162 | 113 | 16.143 | 9054.2 |
191 | 2020-01-23 17:59:13 | aspirins | 3 | 146162 | 113 | 27.330 | 5348.0 |
190 | 2020-01-22 09:38:48 | aspirins | 1 | 82945 | 3 | 3.110 | 26670.4 |
189 | 2020-01-22 08:24:09 | aspirins | 1 | 82945 | 3 | 1.470 | 56425.2 |
188 | 2020-01-20 00:56:29 | aspirins | 1 | 82945 | 3 | 1.576 | 52630.1 |
187 | 2020-01-17 18:43:58 | aspirins | 2 | 121059 | 9 | 3.576 | 33853.2 |
186 | 2020-01-17 15:21:27 | aspirins | 3 | 146162 | 113 | 15.576 | 9383.8 |
185 | 2020-01-17 14:07:39 | aspirins | 1 | 82945 | 3 | 1.610 | 51518.6 |
184 | 2020-01-08 05:26:21 | aspirins | 1 | 82945 | 3 | 1.516 | 54713.1 |