History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"piehole"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
273 | 2024-04-26 09:08:44 | piehole | 2 | 107671 | 12 | 4.903 | 21960.2 |
272 | 2024-04-10 22:01:47 | piehole | 3 | 134027 | 121 | 11.720 | 11435.8 |
271 | 2024-04-08 05:39:01 | piehole | 3 | 134027 | 121 | 14.390 | 9313.9 |
270 | 2024-04-07 22:48:32 | piehole | 3 | 134027 | 121 | 8.360 | 16031.9 |
269 | 2024-04-07 16:16:05 | piehole | 2 | 107671 | 12 | 7.516 | 14325.6 |
268 | 2024-04-07 16:16:04 | piehole | 3 | 134027 | 121 | 8.186 | 16372.7 |
267 | 2024-04-07 16:16:04 | piehole | 1 | 69583 | 3 | 2.826 | 24622.4 |
266 | 2024-03-31 00:40:10 | piehole | 1 | 69583 | 3 | 2.983 | 23326.5 |
265 | 2024-01-26 16:14:35 | piehole | 1 | 69583 | 3 | 1.063 | 65459.1 |
264 | 2024-01-13 00:09:16 | piehole | 1 | 69583 | 3 | 1.063 | 65459.1 |
263 | 2024-01-12 14:45:59 | piehole | 2 | 107671 | 12 | 2.953 | 36461.6 |
262 | 2023-12-19 06:05:33 | piehole | 2 | 107671 | 12 | 3.190 | 33752.7 |
261 | 2023-12-18 09:49:28 | piehole | 2 | 107671 | 12 | 2.876 | 37437.8 |
260 | 2023-12-17 16:42:26 | piehole | 3 | 134027 | 121 | 7.080 | 18930.4 |
259 | 2023-12-16 14:59:04 | piehole | 1 | 69583 | 3 | 1.110 | 62687.4 |
258 | 2023-11-20 19:05:04 | piehole | 1 | 69583 | 3 | 1.190 | 58473.1 |
257 | 2023-11-17 02:38:41 | piehole | 1 | 69583 | 3 | 1.283 | 54234.6 |
256 | 2023-11-11 18:32:24 | piehole | 3 | 134027 | 121 | 6.266 | 21389.6 |
255 | 2023-11-08 05:03:28 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
254 | 2023-10-31 08:49:54 | piehole | 3 | 134027 | 121 | 6.826 | 19634.8 |
253 | 2023-10-31 08:49:50 | piehole | 2 | 107671 | 12 | 4.486 | 24001.6 |
252 | 2023-10-20 20:13:23 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
251 | 2023-09-25 07:58:28 | piehole | 1 | 69583 | 3 | 1.170 | 59472.6 |
250 | 2023-09-24 17:04:36 | piehole | 1 | 69583 | 3 | 1.393 | 49951.9 |
249 | 2023-09-19 12:47:27 | piehole | 2 | 107671 | 12 | 3.233 | 33303.7 |
248 | 2023-08-29 06:47:16 | piehole | 1 | 69583 | 3 | 1.173 | 59320.5 |
247 | 2023-07-21 00:05:43 | piehole | 1 | 69583 | 3 | 1.156 | 60192.9 |
246 | 2023-06-24 05:22:50 | piehole | 2 | 107671 | 12 | 3.343 | 32207.9 |
245 | 2023-06-03 01:59:17 | piehole | 1 | 69583 | 3 | 1.046 | 66522.9 |
244 | 2023-05-29 12:07:35 | piehole | 1 | 69583 | 3 | 2.093 | 33245.6 |
243 | 2023-05-06 03:56:52 | piehole | 1 | 69583 | 3 | 1.170 | 59472.6 |
242 | 2023-04-03 19:06:35 | piehole | 1 | 69583 | 3 | 2.110 | 32977.7 |
241 | 2023-03-24 01:14:34 | piehole | 1 | 69583 | 3 | 1.063 | 65459.1 |
240 | 2023-03-19 18:45:40 | piehole | 2 | 107671 | 12 | 3.140 | 34290.1 |
239 | 2023-02-09 21:44:01 | piehole | 1 | 69583 | 3 | 1.173 | 59320.5 |
238 | 2023-01-21 14:02:14 | piehole | 1 | 69583 | 3 | 1.060 | 65644.3 |
237 | 2023-01-08 20:47:47 | piehole | 1 | 69583 | 3 | 1.110 | 62687.4 |
236 | 2022-12-21 14:57:41 | piehole | 2 | 107671 | 12 | 3.253 | 33099.0 |
235 | 2022-12-07 10:10:22 | piehole | 1 | 69583 | 3 | 1.046 | 66522.9 |
234 | 2022-11-27 04:22:42 | piehole | 1 | 69583 | 3 | 1.203 | 57841.2 |
233 | 2022-11-12 12:07:36 | piehole | 1 | 69583 | 3 | 1.250 | 55666.4 |
232 | 2022-10-12 08:55:16 | piehole | 1 | 69583 | 3 | 1.126 | 61796.6 |
231 | 2022-10-08 17:20:51 | piehole | 1 | 69583 | 3 | 1.173 | 59320.5 |
230 | 2022-10-08 15:09:09 | piehole | 1 | 69583 | 3 | 1.063 | 65459.1 |
229 | 2022-08-20 06:27:28 | piehole | 2 | 107671 | 12 | 3.140 | 34290.1 |
228 | 2022-05-31 17:37:11 | piehole | 1 | 69583 | 3 | 1.046 | 66522.9 |
227 | 2022-05-31 16:06:46 | piehole | 1 | 69583 | 3 | 1.060 | 65644.3 |
226 | 2022-05-22 17:54:28 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
225 | 2022-05-03 04:05:13 | piehole | 3 | 134027 | 121 | 6.750 | 19855.9 |
224 | 2022-04-23 14:01:47 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
223 | 2022-04-04 07:28:20 | piehole | 2 | 107671 | 12 | 3.000 | 35890.3 |
222 | 2022-02-10 13:36:06 | piehole | 1 | 69583 | 3 | 1.253 | 55533.1 |
221 | 2022-02-06 15:39:02 | piehole | 1 | 69583 | 3 | 1.216 | 57222.9 |
220 | 2021-12-16 20:50:06 | piehole | 1 | 69583 | 3 | 1.266 | 54962.9 |
219 | 2021-12-12 22:23:38 | piehole | 1 | 69583 | 3 | 1.216 | 57222.9 |
218 | 2021-11-18 04:29:33 | piehole | 1 | 69583 | 3 | 1.093 | 63662.4 |
217 | 2021-11-09 18:17:34 | piehole | 1 | 69583 | 3 | 1.170 | 59472.6 |
216 | 2021-10-13 17:22:24 | piehole | 1 | 69583 | 3 | 1.250 | 55666.4 |
215 | 2021-08-12 17:14:47 | piehole | 1 | 69583 | 3 | 1.266 | 54962.9 |
214 | 2021-07-12 15:24:08 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
213 | 2021-04-08 22:46:07 | piehole | 1 | 69583 | 3 | 1.280 | 54361.7 |
212 | 2021-04-04 18:03:45 | piehole | 1 | 69583 | 3 | 1.236 | 56296.9 |
211 | 2020-12-30 19:12:14 | piehole | 1 | 69583 | 3 | 1.093 | 63662.4 |
210 | 2020-12-04 01:47:56 | piehole | 1 | 69583 | 3 | 1.156 | 60192.9 |
209 | 2020-11-23 02:43:09 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
208 | 2020-11-06 14:12:04 | piehole | 1 | 69583 | 3 | 1.153 | 60349.5 |
207 | 2020-11-01 08:33:03 | piehole | 1 | 69583 | 3 | 1.233 | 56433.9 |
206 | 2020-09-27 11:29:30 | piehole | 1 | 69583 | 3 | 1.046 | 66522.9 |
205 | 2020-08-09 13:03:58 | piehole | 1 | 69583 | 3 | 1.266 | 54962.9 |
204 | 2020-08-09 04:51:21 | piehole | 1 | 69583 | 3 | 1.080 | 64428.7 |
203 | 2020-06-18 11:17:55 | piehole | 1 | 69583 | 3 | 1.203 | 57841.2 |
202 | 2020-04-16 08:14:45 | piehole | 1 | 69583 | 3 | 1.220 | 57035.2 |
201 | 2020-04-02 00:29:43 | piehole | 1 | 69583 | 3 | 1.110 | 62687.4 |
200 | 2020-04-01 00:55:57 | piehole | 1 | 69583 | 3 | 1.110 | 62687.4 |
199 | 2020-03-29 07:19:42 | piehole | 1 | 69583 | 3 | 1.703 | 40859.1 |
198 | 2020-03-28 21:38:30 | piehole | 1 | 69583 | 3 | 1.173 | 59320.5 |
197 | 2020-03-25 18:50:37 | piehole | 1 | 69583 | 3 | 1.220 | 57035.2 |
196 | 2020-03-20 23:42:06 | piehole | 1 | 69583 | 3 | 1.076 | 64668.2 |
195 | 2020-03-04 23:14:18 | piehole | 1 | 69583 | 3 | 1.250 | 55666.4 |
194 | 2020-02-22 16:26:43 | piehole | 1 | 69583 | 3 | 1.250 | 55666.4 |
193 | 2020-02-13 14:51:53 | piehole | 1 | 69583 | 3 | 1.800 | 38657.2 |
192 | 2020-02-12 14:15:49 | piehole | 1 | 69583 | 3 | 1.296 | 53690.6 |
191 | 2020-02-07 18:04:34 | piehole | 1 | 69583 | 3 | 1.423 | 48898.8 |
190 | 2020-02-02 20:57:57 | piehole | 1 | 69583 | 3 | 1.530 | 45479.1 |
189 | 2020-01-30 04:09:54 | piehole | 1 | 69583 | 3 | 1.310 | 53116.8 |
188 | 2020-01-25 18:31:23 | piehole | 1 | 69583 | 3 | 1.970 | 35321.3 |
187 | 2020-01-21 18:39:53 | piehole | 1 | 69583 | 3 | 3.673 | 18944.5 |
186 | 2020-01-19 20:24:27 | piehole | 1 | 69583 | 3 | 1.266 | 54962.9 |
185 | 2020-01-15 11:31:23 | piehole | 3 | 134027 | 121 | 9.376 | 14294.7 |
184 | 2020-01-15 06:00:00 | piehole | 3 | 134027 | 121 | 11.360 | 11798.2 |
183 | 2020-01-15 02:20:08 | piehole | 2 | 107671 | 12 | 3.500 | 30763.1 |
182 | 2020-01-15 02:19:31 | piehole | 3 | 134027 | 121 | 7.813 | 17154.4 |
181 | 2020-01-14 21:30:46 | piehole | 1 | 69583 | 3 | 2.733 | 25460.3 |
180 | 2020-01-11 03:06:21 | piehole | 1 | 69583 | 3 | 1.343 | 51811.6 |
179 | 2020-01-02 02:17:32 | piehole | 1 | 69583 | 3 | 5.203 | 13373.6 |
178 | 2019-12-29 11:46:28 | piehole | 1 | 69583 | 3 | 1.373 | 50679.5 |
177 | 2019-12-29 05:47:56 | piehole | 1 | 69583 | 3 | 1.373 | 50679.5 |
176 | 2019-12-04 21:27:20 | piehole | 1 | 69583 | 3 | 1.140 | 61037.7 |
175 | 2019-09-02 16:35:40 | piehole | 1 | 69583 | 3 | 1.000 | 69583.0 |
174 | 2019-06-03 00:55:09 | piehole | 1 | 69583 | 3 | 1.290 | 53940.3 |