History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"devonian"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
305 | 2024-04-13 05:09:52 | devonian | 1 | 82945 | 2 | 1.343 | 61761.0 |
304 | 2024-04-12 18:48:12 | devonian | 1 | 82945 | 2 | 1.500 | 55296.7 |
303 | 2024-04-12 18:48:08 | devonian | 2 | 121059 | 7 | 4.160 | 29100.7 |
302 | 2024-04-12 18:46:20 | devonian | 3 | 146162 | 40 | 9.000 | 16240.2 |
301 | 2024-04-10 09:51:48 | devonian | 3 | 146162 | 40 | 13.280 | 11006.2 |
300 | 2024-04-10 09:51:49 | devonian | 2 | 121059 | 7 | 8.703 | 13910.0 |
299 | 2024-04-10 09:51:46 | devonian | 1 | 82945 | 2 | 1.563 | 53067.8 |
298 | 2024-04-09 21:06:20 | devonian | 4 | 161609 | 418 | 14.686 | 11004.3 |
297 | 2024-04-09 21:06:01 | devonian | 4 | 161609 | 418 | 33.453 | 4830.9 |
296 | 2024-04-05 23:41:00 | devonian | 4 | 161609 | 418 | 40.583 | 3982.2 |
295 | 2024-04-05 18:33:12 | devonian | 4 | 161609 | 418 | 22.783 | 7093.4 |
294 | 2024-04-04 13:57:19 | devonian | 1 | 82945 | 2 | 1.500 | 55296.7 |
293 | 2024-03-29 11:40:29 | devonian | 1 | 82945 | 2 | 4.110 | 20181.3 |
292 | 2024-03-29 11:19:50 | devonian | 4 | 161609 | 418 | 41.236 | 3919.1 |
291 | 2024-03-29 03:44:12 | devonian | 4 | 161609 | 418 | 19.783 | 8169.1 |
290 | 2024-03-05 09:48:45 | devonian | 2 | 121059 | 7 | 16.110 | 7514.5 |
289 | 2024-03-05 09:48:11 | devonian | 3 | 146162 | 40 | 18.800 | 7774.6 |
288 | 2024-03-05 09:45:41 | devonian | 1 | 82945 | 2 | 4.123 | 20117.6 |
287 | 2024-03-01 19:20:16 | devonian | 2 | 121059 | 7 | 5.593 | 21644.7 |
286 | 2024-03-01 19:19:50 | devonian | 1 | 82945 | 2 | 1.623 | 51106.0 |
285 | 2024-03-01 14:01:52 | devonian | 4 | 161609 | 418 | 23.423 | 6899.6 |
284 | 2024-03-01 09:01:06 | devonian | 2 | 121059 | 7 | 3.330 | 36354.1 |
283 | 2024-03-01 09:00:54 | devonian | 3 | 146162 | 40 | 6.516 | 22431.2 |
282 | 2024-03-01 05:56:39 | devonian | 1 | 82945 | 2 | 1.530 | 54212.4 |
281 | 2024-03-01 05:56:35 | devonian | 2 | 121059 | 7 | 3.733 | 32429.4 |
280 | 2024-03-01 05:56:07 | devonian | 3 | 146162 | 40 | 8.750 | 16704.2 |
279 | 2024-02-29 01:23:28 | devonian | 3 | 146162 | 40 | 15.313 | 9545.0 |
278 | 2024-02-28 08:57:36 | devonian | 4 | 161609 | 418 | 14.830 | 10897.4 |
277 | 2024-02-28 07:53:29 | devonian | 4 | 161609 | 418 | 13.423 | 12039.7 |
276 | 2024-02-28 07:52:52 | devonian | 3 | 146162 | 40 | 14.970 | 9763.7 |
275 | 2024-02-28 07:52:53 | devonian | 2 | 121059 | 7 | 10.173 | 11900.0 |
274 | 2024-02-28 07:52:44 | devonian | 1 | 82945 | 2 | 1.796 | 46183.2 |
273 | 2024-02-08 07:49:37 | devonian | 4 | 161609 | 418 | 20.580 | 7852.7 |
272 | 2024-02-06 03:14:42 | devonian | 4 | 161609 | 418 | 13.283 | 12166.6 |
271 | 2024-02-04 06:38:21 | devonian | 1 | 82945 | 2 | 1.530 | 54212.4 |
270 | 2024-01-27 16:54:33 | devonian | 1 | 82945 | 2 | 1.420 | 58412.0 |
269 | 2024-01-27 03:19:45 | devonian | 2 | 121059 | 7 | 3.486 | 34727.2 |
268 | 2024-01-26 13:51:59 | devonian | 2 | 121059 | 7 | 3.220 | 37596.0 |
267 | 2024-01-26 13:51:55 | devonian | 1 | 82945 | 2 | 1.266 | 65517.4 |
266 | 2024-01-26 01:49:20 | devonian | 3 | 146162 | 40 | 10.110 | 14457.2 |
265 | 2024-01-26 01:49:03 | devonian | 3 | 146162 | 40 | 12.483 | 11708.9 |
264 | 2024-01-25 18:39:55 | devonian | 4 | 161609 | 418 | 13.016 | 12416.2 |
263 | 2024-01-25 18:38:39 | devonian | 4 | 161609 | 418 | 13.923 | 11607.3 |
262 | 2024-01-22 01:27:26 | devonian | 3 | 146162 | 40 | 6.250 | 23385.9 |
261 | 2023-12-25 18:31:45 | devonian | 1 | 82945 | 2 | 1.313 | 63172.1 |
260 | 2023-12-25 05:38:30 | devonian | 4 | 161609 | 418 | 11.016 | 14670.4 |
259 | 2023-12-10 16:53:34 | devonian | 4 | 161609 | 418 | 11.216 | 14408.8 |
258 | 2023-12-09 08:19:40 | devonian | 1 | 82945 | 2 | 1.483 | 55930.5 |
257 | 2023-12-03 13:14:33 | devonian | 1 | 82945 | 2 | 1.326 | 62552.8 |
256 | 2023-11-03 14:31:01 | devonian | 3 | 146162 | 40 | 6.440 | 22696.0 |
255 | 2023-10-14 23:47:48 | devonian | 1 | 82945 | 2 | 1.343 | 61761.0 |
254 | 2023-10-05 16:26:30 | devonian | 1 | 82945 | 2 | 1.343 | 61761.0 |
253 | 2023-09-29 00:07:32 | devonian | 1 | 82945 | 2 | 1.483 | 55930.5 |
252 | 2023-09-23 00:27:21 | devonian | 1 | 82945 | 2 | 1.703 | 48705.2 |
251 | 2023-09-11 06:59:13 | devonian | 4 | 161609 | 418 | 29.203 | 5534.0 |
250 | 2023-09-08 22:52:49 | devonian | 4 | 161609 | 418 | 11.096 | 14564.6 |
249 | 2023-08-11 16:14:49 | devonian | 1 | 82945 | 2 | 2.140 | 38759.3 |
248 | 2023-08-10 00:05:57 | devonian | 3 | 146162 | 40 | 6.143 | 23793.3 |
247 | 2023-05-28 11:33:22 | devonian | 4 | 161609 | 418 | 11.953 | 13520.4 |
246 | 2023-05-27 07:49:20 | devonian | 4 | 161609 | 418 | 10.530 | 15347.5 |
245 | 2023-05-27 02:10:12 | devonian | 1 | 82945 | 2 | 1.266 | 65517.4 |
244 | 2023-05-19 02:11:04 | devonian | 4 | 161609 | 418 | 10.453 | 15460.5 |
243 | 2023-05-10 16:19:06 | devonian | 1 | 82945 | 2 | 1.250 | 66356.0 |
242 | 2023-04-24 14:36:05 | devonian | 3 | 146162 | 40 | 6.640 | 22012.3 |
241 | 2023-04-23 15:51:05 | devonian | 4 | 161609 | 418 | 12.000 | 13467.4 |
240 | 2023-03-12 11:06:05 | devonian | 4 | 161609 | 418 | 12.033 | 13430.5 |
239 | 2023-03-06 23:40:39 | devonian | 1 | 82945 | 2 | 1.406 | 58993.6 |
238 | 2023-02-26 08:02:08 | devonian | 4 | 161609 | 418 | 11.453 | 14110.6 |
237 | 2023-01-31 04:35:17 | devonian | 1 | 82945 | 2 | 1.233 | 67270.9 |
236 | 2023-01-28 18:52:54 | devonian | 3 | 146162 | 40 | 6.046 | 24175.0 |
235 | 2023-01-27 15:43:24 | devonian | 1 | 82945 | 2 | 1.250 | 66356.0 |
234 | 2022-12-28 16:11:47 | devonian | 1 | 82945 | 2 | 1.250 | 66356.0 |
233 | 2022-12-08 08:41:49 | devonian | 4 | 161609 | 418 | 10.610 | 15231.8 |
232 | 2022-12-05 00:16:23 | devonian | 4 | 161609 | 418 | 11.610 | 13919.8 |
231 | 2022-11-10 13:24:14 | devonian | 3 | 146162 | 40 | 6.360 | 22981.4 |
230 | 2022-10-24 11:22:43 | devonian | 4 | 161609 | 418 | 10.656 | 15166.0 |
229 | 2022-09-28 21:51:58 | devonian | 1 | 82945 | 2 | 1.250 | 66356.0 |
228 | 2022-09-25 22:58:05 | devonian | 4 | 161609 | 418 | 10.503 | 15386.9 |
227 | 2022-09-17 18:07:13 | devonian | 1 | 82945 | 2 | 1.466 | 56579.1 |
226 | 2022-08-27 04:32:04 | devonian | 4 | 161609 | 418 | 11.110 | 14546.3 |
225 | 2022-07-28 02:55:26 | devonian | 4 | 161609 | 418 | 11.126 | 14525.3 |
224 | 2022-07-21 05:35:21 | devonian | 4 | 161609 | 418 | 10.593 | 15256.2 |
223 | 2022-06-30 20:10:56 | devonian | 1 | 82945 | 2 | 1.266 | 65517.4 |
222 | 2022-06-05 13:02:34 | devonian | 3 | 146162 | 40 | 6.220 | 23498.7 |
221 | 2022-06-03 08:20:13 | devonian | 3 | 146162 | 40 | 6.236 | 23438.4 |
220 | 2022-06-01 02:34:58 | devonian | 3 | 146162 | 40 | 6.203 | 23563.1 |
219 | 2022-05-29 07:28:58 | devonian | 1 | 82945 | 2 | 1.283 | 64649.3 |
218 | 2022-05-19 21:24:50 | devonian | 1 | 82945 | 2 | 1.330 | 62364.7 |
217 | 2022-03-05 17:52:54 | devonian | 1 | 82945 | 2 | 1.486 | 55817.6 |
216 | 2022-01-31 12:18:05 | devonian | 1 | 82945 | 2 | 1.440 | 57600.7 |
215 | 2022-01-18 05:46:05 | devonian | 3 | 146162 | 40 | 7.876 | 18557.9 |
214 | 2022-01-16 01:28:19 | devonian | 3 | 146162 | 40 | 6.546 | 22328.4 |
213 | 2021-12-16 05:53:47 | devonian | 1 | 82945 | 2 | 1.393 | 59544.1 |
212 | 2021-10-26 10:39:36 | devonian | 3 | 146162 | 40 | 11.643 | 12553.6 |
211 | 2021-10-21 08:55:15 | devonian | 1 | 82945 | 2 | 1.266 | 65517.4 |
210 | 2021-10-19 07:01:40 | devonian | 1 | 82945 | 2 | 1.360 | 60989.0 |
209 | 2021-10-14 15:14:11 | devonian | 1 | 82945 | 2 | 1.530 | 54212.4 |
208 | 2021-09-11 09:51:22 | devonian | 1 | 82945 | 2 | 1.296 | 64000.8 |
207 | 2021-09-09 05:04:23 | devonian | 1 | 82945 | 2 | 1.453 | 57085.3 |
206 | 2021-08-28 00:55:48 | devonian | 3 | 146162 | 40 | 6.343 | 23043.0 |