History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"harpist"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
303 | 2024-04-28 00:53:03 | harpist | 1 | 69583 | 2 | 4.016 | 17326.4 |
302 | 2024-04-26 22:09:41 | harpist | 3 | 134027 | 276 | 10.546 | 12708.8 |
301 | 2024-04-26 17:35:16 | harpist | 3 | 134027 | 276 | 7.283 | 18402.7 |
300 | 2024-04-25 10:27:11 | harpist | 3 | 134027 | 276 | 17.470 | 7671.8 |
299 | 2024-04-25 10:27:13 | harpist | 2 | 107671 | 18 | 12.906 | 8342.7 |
298 | 2024-04-25 10:27:01 | harpist | 1 | 69583 | 2 | 3.843 | 18106.4 |
297 | 2024-04-22 17:40:04 | harpist | 1 | 69583 | 2 | 3.283 | 21194.9 |
296 | 2024-04-21 03:24:09 | harpist | 1 | 69583 | 2 | 2.686 | 25905.8 |
295 | 2024-03-23 02:28:15 | harpist | 1 | 69583 | 2 | 2.673 | 26031.8 |
294 | 2024-03-22 07:32:07 | harpist | 1 | 69583 | 2 | 4.080 | 17054.7 |
293 | 2024-02-26 09:40:38 | harpist | 2 | 107671 | 18 | 3.876 | 27778.9 |
292 | 2024-02-26 09:39:43 | harpist | 3 | 134027 | 276 | 7.376 | 18170.7 |
291 | 2024-02-22 17:45:23 | harpist | 2 | 107671 | 18 | 3.516 | 30623.2 |
290 | 2024-02-22 17:44:55 | harpist | 3 | 134027 | 276 | 7.516 | 17832.2 |
289 | 2024-02-21 14:19:22 | harpist | 3 | 134027 | 276 | 30.003 | 4467.1 |
288 | 2024-02-20 13:35:01 | harpist | 3 | 134027 | 276 | 7.923 | 16916.2 |
287 | 2024-02-20 13:34:59 | harpist | 2 | 107671 | 18 | 4.766 | 22591.5 |
286 | 2024-02-20 07:33:18 | harpist | 1 | 69583 | 2 | 2.643 | 26327.3 |
285 | 2024-01-20 20:06:57 | harpist | 1 | 69583 | 2 | 1.063 | 65459.1 |
284 | 2024-01-08 22:03:08 | harpist | 1 | 69583 | 2 | 1.360 | 51164.0 |
283 | 2024-01-08 21:13:51 | harpist | 1 | 69583 | 2 | 1.076 | 64668.2 |
282 | 2023-11-19 12:01:24 | harpist | 1 | 69583 | 2 | 1.280 | 54361.7 |
281 | 2023-11-11 06:44:02 | harpist | 1 | 69583 | 2 | 1.080 | 64428.7 |
280 | 2023-11-11 04:46:13 | harpist | 1 | 69583 | 2 | 1.216 | 57222.9 |
279 | 2023-11-03 14:37:27 | harpist | 1 | 69583 | 2 | 1.063 | 65459.1 |
278 | 2023-10-29 14:07:43 | harpist | 1 | 69583 | 2 | 1.080 | 64428.7 |
277 | 2023-10-25 09:27:56 | harpist | 1 | 69583 | 2 | 1.203 | 57841.2 |
276 | 2023-10-24 17:53:57 | harpist | 1 | 69583 | 2 | 1.233 | 56433.9 |
275 | 2023-10-08 08:59:13 | harpist | 1 | 69583 | 2 | 2.500 | 27833.2 |
274 | 2023-09-29 00:28:34 | harpist | 1 | 69583 | 2 | 1.173 | 59320.5 |
273 | 2023-09-21 21:56:41 | harpist | 1 | 69583 | 2 | 1.093 | 63662.4 |
272 | 2023-08-25 10:19:59 | harpist | 1 | 69583 | 2 | 1.096 | 63488.1 |
271 | 2023-07-09 14:59:47 | harpist | 1 | 69583 | 2 | 1.063 | 65459.1 |
270 | 2023-05-29 06:40:38 | harpist | 1 | 69583 | 2 | 1.046 | 66522.9 |
269 | 2023-03-25 21:13:50 | harpist | 1 | 69583 | 2 | 1.076 | 64668.2 |
268 | 2023-03-19 00:33:59 | harpist | 1 | 69583 | 2 | 1.170 | 59472.6 |
267 | 2023-01-09 12:44:10 | harpist | 1 | 69583 | 2 | 1.076 | 64668.2 |
266 | 2022-11-27 15:17:45 | harpist | 1 | 69583 | 2 | 1.080 | 64428.7 |
265 | 2022-10-11 07:52:48 | harpist | 1 | 69583 | 2 | 1.106 | 62914.1 |
264 | 2022-07-28 03:35:56 | harpist | 1 | 69583 | 2 | 1.203 | 57841.2 |
263 | 2022-05-31 23:54:55 | harpist | 1 | 69583 | 2 | 1.076 | 64668.2 |
262 | 2022-05-29 19:09:11 | harpist | 1 | 69583 | 2 | 1.220 | 57035.2 |
261 | 2022-03-23 06:31:41 | harpist | 1 | 69583 | 2 | 1.220 | 57035.2 |
260 | 2021-12-05 23:45:46 | harpist | 1 | 69583 | 2 | 1.110 | 62687.4 |
259 | 2021-08-26 07:30:59 | harpist | 1 | 69583 | 2 | 1.106 | 62914.1 |
258 | 2021-08-06 11:40:01 | harpist | 1 | 69583 | 2 | 1.190 | 58473.1 |
257 | 2021-07-28 12:20:31 | harpist | 2 | 107671 | 18 | 3.250 | 33129.5 |
256 | 2021-06-07 13:56:39 | harpist | 1 | 69583 | 2 | 1.110 | 62687.4 |
255 | 2021-05-25 13:38:38 | harpist | 1 | 69583 | 2 | 1.280 | 54361.7 |
254 | 2021-05-19 10:57:56 | harpist | 2 | 107671 | 18 | 2.923 | 36835.8 |
253 | 2021-05-13 13:36:07 | harpist | 1 | 69583 | 2 | 1.216 | 57222.9 |
252 | 2021-04-19 09:11:13 | harpist | 2 | 107671 | 18 | 3.266 | 32967.2 |
251 | 2021-04-12 11:42:44 | harpist | 1 | 69583 | 2 | 1.313 | 52995.4 |
250 | 2021-02-24 18:37:36 | harpist | 2 | 107671 | 18 | 3.280 | 32826.5 |
249 | 2021-02-21 03:18:52 | harpist | 1 | 69583 | 2 | 1.076 | 64668.2 |
248 | 2021-02-20 02:00:42 | harpist | 1 | 69583 | 2 | 1.093 | 63662.4 |
247 | 2021-02-06 01:28:29 | harpist | 1 | 69583 | 2 | 1.206 | 57697.3 |
246 | 2021-01-26 11:02:53 | harpist | 1 | 69583 | 2 | 1.266 | 54962.9 |
245 | 2020-11-21 03:34:51 | harpist | 1 | 69583 | 2 | 1.063 | 65459.1 |
244 | 2020-11-10 03:39:31 | harpist | 1 | 69583 | 2 | 1.203 | 57841.2 |
243 | 2020-11-08 14:41:24 | harpist | 1 | 69583 | 2 | 1.156 | 60192.9 |
242 | 2020-10-28 02:00:37 | harpist | 3 | 134027 | 276 | 6.420 | 20876.5 |
241 | 2020-10-14 15:34:44 | harpist | 1 | 69583 | 2 | 1.110 | 62687.4 |
240 | 2020-09-26 07:33:33 | harpist | 1 | 69583 | 2 | 1.080 | 64428.7 |
239 | 2020-08-31 22:00:17 | harpist | 1 | 69583 | 2 | 1.126 | 61796.6 |
238 | 2020-08-29 20:39:47 | harpist | 1 | 69583 | 2 | 1.093 | 63662.4 |
237 | 2020-08-20 11:09:46 | harpist | 1 | 69583 | 2 | 1.296 | 53690.6 |
236 | 2020-08-17 03:33:45 | harpist | 1 | 69583 | 2 | 1.220 | 57035.2 |
235 | 2020-07-27 18:18:23 | harpist | 1 | 69583 | 2 | 1.343 | 51811.6 |
234 | 2020-07-20 16:14:22 | harpist | 1 | 69583 | 2 | 1.203 | 57841.2 |
233 | 2020-05-09 23:45:38 | harpist | 1 | 69583 | 2 | 1.093 | 63662.4 |
232 | 2020-04-17 01:16:33 | harpist | 1 | 69583 | 2 | 1.110 | 62687.4 |
231 | 2020-03-28 15:16:01 | harpist | 1 | 69583 | 2 | 1.810 | 38443.6 |
230 | 2020-03-24 22:37:41 | harpist | 1 | 69583 | 2 | 1.220 | 57035.2 |
229 | 2020-03-24 18:29:48 | harpist | 1 | 69583 | 2 | 1.156 | 60192.9 |
228 | 2020-03-20 04:04:48 | harpist | 1 | 69583 | 2 | 1.360 | 51164.0 |
227 | 2020-02-27 13:14:51 | harpist | 3 | 134027 | 276 | 23.643 | 5668.8 |
226 | 2020-02-18 14:22:45 | harpist | 1 | 69583 | 2 | 2.623 | 26528.0 |
225 | 2020-02-17 03:55:16 | harpist | 3 | 134027 | 276 | 7.563 | 17721.4 |
224 | 2020-02-17 03:11:14 | harpist | 3 | 134027 | 276 | 16.690 | 8030.4 |
223 | 2020-02-15 08:26:00 | harpist | 3 | 134027 | 276 | 7.766 | 17258.2 |
222 | 2020-02-15 01:58:41 | harpist | 1 | 69583 | 2 | 1.406 | 49490.0 |
221 | 2020-02-12 11:09:41 | harpist | 1 | 69583 | 2 | 1.486 | 46825.7 |
220 | 2020-02-11 02:35:03 | harpist | 1 | 69583 | 2 | 2.580 | 26970.2 |
219 | 2020-02-10 22:33:53 | harpist | 1 | 69583 | 2 | 1.343 | 51811.6 |
218 | 2020-02-07 10:24:39 | harpist | 1 | 69583 | 2 | 1.326 | 52475.9 |
217 | 2020-02-06 02:06:05 | harpist | 1 | 69583 | 2 | 1.296 | 53690.6 |
216 | 2020-02-05 13:09:37 | harpist | 1 | 69583 | 2 | 1.436 | 48456.1 |
215 | 2020-01-23 22:46:26 | harpist | 1 | 69583 | 2 | 1.360 | 51164.0 |
214 | 2020-01-20 12:48:59 | harpist | 1 | 69583 | 2 | 1.390 | 50059.7 |
213 | 2020-01-20 01:07:31 | harpist | 1 | 69583 | 2 | 2.576 | 27012.0 |
212 | 2020-01-18 11:42:18 | harpist | 3 | 134027 | 276 | 14.076 | 9521.7 |
211 | 2020-01-18 06:29:33 | harpist | 3 | 134027 | 276 | 9.000 | 14891.9 |
210 | 2020-01-18 00:54:53 | harpist | 3 | 134027 | 276 | 7.203 | 18607.1 |
209 | 2020-01-17 18:22:30 | harpist | 1 | 69583 | 2 | 1.453 | 47889.2 |
208 | 2020-01-13 19:48:08 | harpist | 1 | 69583 | 2 | 1.436 | 48456.1 |
207 | 2020-01-08 00:11:28 | harpist | 1 | 69583 | 2 | 3.986 | 17456.8 |
206 | 2019-12-28 05:40:00 | harpist | 1 | 69583 | 2 | 1.296 | 53690.6 |
205 | 2019-12-27 16:28:14 | harpist | 1 | 69583 | 2 | 2.186 | 31831.2 |
204 | 2019-12-27 16:18:52 | harpist | 1 | 69583 | 2 | 1.216 | 57222.9 |