History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pileated"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
279 | 2024-03-25 01:55:21 | pileated | 2 | 121059 | 30 | 3.893 | 31096.6 |
278 | 2024-03-25 01:53:03 | pileated | 3 | 146162 | 299 | 7.983 | 18309.2 |
277 | 2024-03-23 08:13:18 | pileated | 3 | 146162 | 299 | 17.530 | 8337.8 |
276 | 2024-03-19 19:24:22 | pileated | 3 | 146162 | 299 | 15.983 | 9144.8 |
275 | 2024-03-18 22:07:51 | pileated | 3 | 146162 | 299 | 14.266 | 10245.5 |
274 | 2024-03-18 21:57:54 | pileated | 2 | 121059 | 30 | 12.970 | 9333.8 |
273 | 2024-03-18 09:28:20 | pileated | 3 | 146162 | 299 | 7.923 | 18447.8 |
272 | 2024-03-18 09:28:11 | pileated | 2 | 121059 | 30 | 4.233 | 28598.9 |
271 | 2024-03-16 19:00:38 | pileated | 2 | 121059 | 30 | 9.110 | 13288.6 |
270 | 2024-03-16 19:00:30 | pileated | 1 | 82945 | 3 | 4.890 | 16962.2 |
269 | 2024-01-31 15:50:56 | pileated | 1 | 82945 | 3 | 1.376 | 60279.8 |
268 | 2024-01-05 18:53:16 | pileated | 1 | 82945 | 3 | 1.343 | 61761.0 |
267 | 2023-12-28 22:23:51 | pileated | 1 | 82945 | 3 | 1.440 | 57600.7 |
266 | 2023-12-15 05:39:37 | pileated | 1 | 82945 | 3 | 1.580 | 52496.8 |
265 | 2023-12-13 22:02:42 | pileated | 1 | 82945 | 3 | 1.390 | 59672.7 |
264 | 2023-12-01 09:10:59 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
263 | 2023-11-03 20:37:31 | pileated | 1 | 82945 | 3 | 1.483 | 55930.5 |
262 | 2023-10-28 11:33:33 | pileated | 1 | 82945 | 3 | 1.326 | 62552.8 |
261 | 2023-10-06 18:42:14 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
260 | 2023-08-26 18:55:26 | pileated | 1 | 82945 | 3 | 1.470 | 56425.2 |
259 | 2023-08-22 14:35:42 | pileated | 1 | 82945 | 3 | 1.420 | 58412.0 |
258 | 2023-05-22 05:24:06 | pileated | 1 | 82945 | 3 | 1.483 | 55930.5 |
257 | 2023-05-02 04:16:45 | pileated | 1 | 82945 | 3 | 1.236 | 67107.6 |
256 | 2023-03-17 11:58:36 | pileated | 1 | 82945 | 3 | 1.266 | 65517.4 |
255 | 2023-01-08 17:00:37 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
254 | 2023-01-05 10:43:08 | pileated | 1 | 82945 | 3 | 1.266 | 65517.4 |
253 | 2022-11-20 14:40:49 | pileated | 1 | 82945 | 3 | 1.250 | 66356.0 |
252 | 2022-09-30 22:33:48 | pileated | 1 | 82945 | 3 | 1.546 | 53651.4 |
251 | 2022-09-06 22:28:29 | pileated | 1 | 82945 | 3 | 1.250 | 66356.0 |
250 | 2022-07-30 07:20:35 | pileated | 1 | 82945 | 3 | 1.393 | 59544.1 |
249 | 2022-07-12 11:04:22 | pileated | 2 | 121059 | 30 | 3.156 | 38358.4 |
248 | 2022-06-08 09:19:50 | pileated | 1 | 82945 | 3 | 1.440 | 57600.7 |
247 | 2022-05-16 01:15:02 | pileated | 1 | 82945 | 3 | 1.436 | 57761.1 |
246 | 2022-05-13 20:29:04 | pileated | 1 | 82945 | 3 | 1.313 | 63172.1 |
245 | 2022-04-30 14:13:04 | pileated | 1 | 82945 | 3 | 1.470 | 56425.2 |
244 | 2022-04-27 14:03:06 | pileated | 1 | 82945 | 3 | 1.796 | 46183.2 |
243 | 2022-01-24 03:51:32 | pileated | 1 | 82945 | 3 | 1.283 | 64649.3 |
242 | 2022-01-21 23:10:02 | pileated | 1 | 82945 | 3 | 1.310 | 63316.8 |
241 | 2022-01-14 05:50:58 | pileated | 1 | 82945 | 3 | 1.280 | 64800.8 |
240 | 2022-01-01 04:07:53 | pileated | 1 | 82945 | 3 | 1.313 | 63172.1 |
239 | 2021-12-11 12:52:26 | pileated | 1 | 82945 | 3 | 1.343 | 61761.0 |
238 | 2021-11-17 07:54:01 | pileated | 1 | 82945 | 3 | 1.393 | 59544.1 |
237 | 2021-11-13 10:20:27 | pileated | 1 | 82945 | 3 | 1.533 | 54106.3 |
236 | 2021-10-03 05:24:38 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
235 | 2021-09-15 10:24:41 | pileated | 1 | 82945 | 3 | 1.516 | 54713.1 |
234 | 2021-09-05 08:30:29 | pileated | 1 | 82945 | 3 | 1.283 | 64649.3 |
233 | 2021-09-03 01:57:55 | pileated | 1 | 82945 | 3 | 2.563 | 32362.5 |
232 | 2021-08-18 18:17:16 | pileated | 1 | 82945 | 3 | 1.266 | 65517.4 |
231 | 2021-08-16 13:56:16 | pileated | 1 | 82945 | 3 | 1.453 | 57085.3 |
230 | 2021-06-17 04:32:14 | pileated | 1 | 82945 | 3 | 1.263 | 65673.0 |
229 | 2021-06-15 11:17:33 | pileated | 1 | 82945 | 3 | 1.436 | 57761.1 |
228 | 2021-05-08 18:20:24 | pileated | 1 | 82945 | 3 | 1.530 | 54212.4 |
227 | 2021-04-28 01:16:20 | pileated | 1 | 82945 | 3 | 1.436 | 57761.1 |
226 | 2021-03-27 23:28:22 | pileated | 1 | 82945 | 3 | 1.516 | 54713.1 |
225 | 2021-03-16 02:38:59 | pileated | 1 | 82945 | 3 | 1.470 | 56425.2 |
224 | 2021-01-11 06:46:42 | pileated | 1 | 82945 | 3 | 1.330 | 62364.7 |
223 | 2020-12-09 09:05:53 | pileated | 1 | 82945 | 3 | 1.516 | 54713.1 |
222 | 2020-10-30 22:51:11 | pileated | 1 | 82945 | 3 | 1.406 | 58993.6 |
221 | 2020-10-29 02:27:27 | pileated | 1 | 82945 | 3 | 1.530 | 54212.4 |
220 | 2020-10-23 11:45:05 | pileated | 1 | 82945 | 3 | 1.296 | 64000.8 |
219 | 2020-10-20 21:02:05 | pileated | 1 | 82945 | 3 | 1.406 | 58993.6 |
218 | 2020-09-22 05:13:32 | pileated | 1 | 82945 | 3 | 1.563 | 53067.8 |
217 | 2020-09-04 14:16:15 | pileated | 1 | 82945 | 3 | 1.283 | 64649.3 |
216 | 2020-08-27 07:06:37 | pileated | 1 | 82945 | 3 | 1.486 | 55817.6 |
215 | 2020-05-30 12:31:33 | pileated | 1 | 82945 | 3 | 1.436 | 57761.1 |
214 | 2020-05-19 16:39:11 | pileated | 1 | 82945 | 3 | 1.296 | 64000.8 |
213 | 2020-04-06 13:58:12 | pileated | 1 | 82945 | 3 | 1.640 | 50576.2 |
212 | 2020-03-28 19:06:55 | pileated | 1 | 82945 | 3 | 1.500 | 55296.7 |
211 | 2020-03-21 01:00:23 | pileated | 1 | 82945 | 3 | 1.266 | 65517.4 |
210 | 2020-02-24 10:49:49 | pileated | 1 | 82945 | 3 | 3.126 | 26533.9 |
209 | 2020-02-20 13:49:43 | pileated | 1 | 82945 | 3 | 1.513 | 54821.5 |
208 | 2020-02-19 15:08:34 | pileated | 1 | 82945 | 3 | 1.513 | 54821.5 |
207 | 2020-02-12 11:19:25 | pileated | 1 | 82945 | 3 | 3.046 | 27230.8 |
206 | 2020-02-11 09:04:08 | pileated | 1 | 82945 | 3 | 1.970 | 42104.1 |
205 | 2020-02-06 23:47:06 | pileated | 1 | 82945 | 3 | 1.813 | 45750.1 |
204 | 2020-02-06 22:08:33 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
203 | 2020-02-06 21:14:17 | pileated | 1 | 82945 | 3 | 1.343 | 61761.0 |
202 | 2020-01-28 01:23:15 | pileated | 1 | 82945 | 3 | 4.920 | 16858.7 |
201 | 2020-01-25 14:42:20 | pileated | 1 | 82945 | 3 | 1.890 | 43886.2 |
200 | 2020-01-20 21:24:00 | pileated | 1 | 82945 | 3 | 3.313 | 25036.2 |
199 | 2020-01-19 04:38:59 | pileated | 1 | 82945 | 3 | 3.050 | 27195.1 |
198 | 2020-01-14 19:49:38 | pileated | 1 | 82945 | 3 | 1.500 | 55296.7 |
197 | 2020-01-09 00:01:38 | pileated | 1 | 82945 | 3 | 3.170 | 26165.6 |
196 | 2020-01-08 22:24:47 | pileated | 1 | 82945 | 3 | 1.326 | 62552.8 |
195 | 2019-12-29 02:29:06 | pileated | 1 | 82945 | 3 | 1.606 | 51646.9 |
194 | 2019-12-29 02:27:24 | pileated | 1 | 82945 | 3 | 3.156 | 26281.7 |
193 | 2019-11-23 12:13:10 | pileated | 1 | 82945 | 3 | 1.516 | 54713.1 |
192 | 2019-11-20 11:07:52 | pileated | 1 | 82945 | 3 | 1.250 | 66356.0 |
191 | 2019-09-01 12:30:00 | pileated | 1 | 82945 | 3 | 1.416 | 58577.0 |
190 | 2019-08-18 16:50:51 | pileated | 1 | 82945 | 3 | 1.250 | 66356.0 |
189 | 2019-06-05 23:23:14 | pileated | 1 | 82945 | 3 | 1.320 | 62837.1 |
188 | 2019-05-18 23:08:53 | pileated | 1 | 82945 | 3 | 1.423 | 58288.8 |
187 | 2019-04-02 04:06:24 | pileated | 1 | 82945 | 3 | 1.413 | 58701.3 |
186 | 2019-03-06 12:31:44 | pileated | 1 | 82945 | 3 | 2.910 | 28503.4 |
185 | 2019-02-15 13:09:36 | pileated | 1 | 82945 | 3 | 1.450 | 57203.4 |
184 | 2019-02-10 10:08:16 | pileated | 1 | 82945 | 3 | 1.203 | 68948.5 |
183 | 2019-02-09 14:36:56 | pileated | 1 | 82945 | 3 | 1.240 | 66891.1 |
182 | 2019-02-06 21:05:12 | pileated | 1 | 82945 | 3 | 1.270 | 65311.0 |
181 | 2019-02-05 03:23:06 | pileated | 1 | 82945 | 3 | 1.276 | 65003.9 |
180 | 2019-02-03 10:39:12 | pileated | 1 | 82945 | 3 | 1.506 | 55076.4 |