History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lampads"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
327 | 2024-03-30 16:30:12 | lampads | 1 | 69583 | 3 | 1.466 | 47464.5 |
326 | 2024-03-30 14:53:19 | lampads | 1 | 69583 | 3 | 2.750 | 25302.9 |
325 | 2024-03-25 19:35:34 | lampads | 1 | 69583 | 3 | 1.373 | 50679.5 |
324 | 2024-03-13 05:55:51 | lampads | 2 | 107671 | 17 | 3.016 | 35699.9 |
323 | 2023-12-17 13:01:06 | lampads | 1 | 69583 | 3 | 1.233 | 56433.9 |
322 | 2023-12-17 09:58:07 | lampads | 1 | 69583 | 3 | 1.310 | 53116.8 |
321 | 2023-12-08 11:16:31 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
320 | 2023-12-08 11:16:29 | lampads | 1 | 69583 | 3 | 1.203 | 57841.2 |
319 | 2023-12-07 08:20:36 | lampads | 1 | 69583 | 3 | 1.250 | 55666.4 |
318 | 2023-12-07 08:20:35 | lampads | 1 | 69583 | 3 | 1.186 | 58670.3 |
317 | 2023-11-28 08:04:26 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
316 | 2023-11-25 23:24:15 | lampads | 2 | 107671 | 17 | 2.860 | 37647.2 |
315 | 2023-11-16 07:49:16 | lampads | 1 | 69583 | 3 | 1.220 | 57035.2 |
314 | 2023-11-08 12:38:13 | lampads | 1 | 69583 | 3 | 1.080 | 64428.7 |
313 | 2023-11-01 23:41:06 | lampads | 1 | 69583 | 3 | 1.266 | 54962.9 |
312 | 2023-10-03 09:31:24 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
311 | 2023-09-28 23:46:59 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
310 | 2023-09-12 06:40:43 | lampads | 1 | 69583 | 3 | 1.343 | 51811.6 |
309 | 2023-08-25 08:09:17 | lampads | 2 | 107671 | 17 | 3.190 | 33752.7 |
308 | 2023-07-30 21:37:49 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
307 | 2023-07-13 14:18:27 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
306 | 2023-05-08 23:53:36 | lampads | 2 | 107671 | 17 | 2.846 | 37832.4 |
305 | 2023-04-26 10:32:15 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
304 | 2023-03-22 09:54:13 | lampads | 1 | 69583 | 3 | 1.300 | 53525.4 |
303 | 2023-02-16 07:14:34 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
302 | 2023-02-14 10:05:37 | lampads | 2 | 107671 | 17 | 2.810 | 38317.1 |
301 | 2022-12-12 14:47:11 | lampads | 1 | 69583 | 3 | 1.170 | 59472.6 |
300 | 2022-11-24 11:59:14 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
299 | 2022-11-24 08:39:19 | lampads | 2 | 107671 | 17 | 2.843 | 37872.3 |
298 | 2022-10-22 02:10:23 | lampads | 3 | 134027 | 242 | 6.800 | 19709.9 |
297 | 2022-09-26 21:36:53 | lampads | 3 | 134027 | 242 | 5.763 | 23256.5 |
296 | 2022-09-08 14:13:54 | lampads | 3 | 134027 | 242 | 7.000 | 19146.7 |
295 | 2022-09-04 18:44:20 | lampads | 3 | 134027 | 242 | 6.046 | 22167.9 |
294 | 2022-08-18 10:08:48 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
293 | 2022-08-18 09:39:33 | lampads | 1 | 69583 | 3 | 1.190 | 58473.1 |
292 | 2022-08-16 17:26:59 | lampads | 3 | 134027 | 242 | 5.830 | 22989.2 |
291 | 2022-08-12 09:13:46 | lampads | 3 | 134027 | 242 | 5.906 | 22693.4 |
290 | 2022-07-20 23:36:49 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
289 | 2022-07-17 06:15:34 | lampads | 1 | 69583 | 3 | 1.080 | 64428.7 |
288 | 2022-07-10 02:45:11 | lampads | 1 | 69583 | 3 | 1.110 | 62687.4 |
287 | 2022-07-01 12:00:47 | lampads | 3 | 134027 | 242 | 5.703 | 23501.1 |
286 | 2022-06-25 07:59:22 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
285 | 2022-06-17 09:13:31 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
284 | 2022-06-10 14:51:39 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
283 | 2022-06-04 09:23:18 | lampads | 1 | 69583 | 3 | 1.080 | 64428.7 |
282 | 2022-04-24 12:13:08 | lampads | 2 | 107671 | 17 | 2.796 | 38508.9 |
281 | 2022-04-10 12:45:06 | lampads | 1 | 69583 | 3 | 1.236 | 56296.9 |
280 | 2022-03-06 08:36:42 | lampads | 1 | 69583 | 3 | 1.296 | 53690.6 |
279 | 2022-01-25 18:18:13 | lampads | 1 | 69583 | 3 | 1.110 | 62687.4 |
278 | 2021-11-19 05:29:16 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
277 | 2021-11-15 21:47:52 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
276 | 2021-10-27 10:52:07 | lampads | 1 | 69583 | 3 | 1.266 | 54962.9 |
275 | 2021-10-02 16:25:27 | lampads | 1 | 69583 | 3 | 1.220 | 57035.2 |
274 | 2021-09-21 20:25:09 | lampads | 1 | 69583 | 3 | 1.186 | 58670.3 |
273 | 2021-09-21 03:14:39 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
272 | 2021-09-20 13:59:18 | lampads | 1 | 69583 | 3 | 1.046 | 66522.9 |
271 | 2021-09-14 09:15:42 | lampads | 1 | 69583 | 3 | 1.186 | 58670.3 |
270 | 2021-08-09 16:27:59 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
269 | 2021-04-24 17:16:01 | lampads | 1 | 69583 | 3 | 1.376 | 50569.0 |
268 | 2021-03-30 12:10:38 | lampads | 1 | 69583 | 3 | 1.080 | 64428.7 |
267 | 2021-01-14 01:38:46 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
266 | 2021-01-07 16:41:18 | lampads | 1 | 69583 | 3 | 1.156 | 60192.9 |
265 | 2020-11-19 00:53:33 | lampads | 1 | 69583 | 3 | 1.080 | 64428.7 |
264 | 2020-11-03 17:25:26 | lampads | 1 | 69583 | 3 | 1.140 | 61037.7 |
263 | 2020-11-01 07:06:25 | lampads | 1 | 69583 | 3 | 1.096 | 63488.1 |
262 | 2020-10-01 04:20:57 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
261 | 2020-09-27 15:44:34 | lampads | 1 | 69583 | 3 | 1.106 | 62914.1 |
260 | 2020-09-10 19:16:57 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
259 | 2020-09-10 02:51:19 | lampads | 1 | 69583 | 3 | 1.200 | 57985.8 |
258 | 2020-09-05 02:49:06 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
257 | 2020-08-09 07:26:18 | lampads | 1 | 69583 | 3 | 1.110 | 62687.4 |
256 | 2020-06-06 14:01:24 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
255 | 2020-04-19 23:11:20 | lampads | 1 | 69583 | 3 | 1.126 | 61796.6 |
254 | 2020-03-28 17:38:26 | lampads | 1 | 69583 | 3 | 1.393 | 49951.9 |
253 | 2020-03-24 16:19:08 | lampads | 1 | 69583 | 3 | 1.300 | 53525.4 |
252 | 2020-03-24 13:48:02 | lampads | 1 | 69583 | 3 | 2.610 | 26660.2 |
251 | 2020-03-19 22:54:13 | lampads | 1 | 69583 | 3 | 1.250 | 55666.4 |
250 | 2020-03-02 04:35:40 | lampads | 1 | 69583 | 3 | 1.076 | 64668.2 |
249 | 2020-02-28 09:25:35 | lampads | 1 | 69583 | 3 | 3.876 | 17952.3 |
248 | 2020-02-17 12:33:56 | lampads | 1 | 69583 | 3 | 1.313 | 52995.4 |
247 | 2020-02-11 10:36:54 | lampads | 1 | 69583 | 3 | 1.436 | 48456.1 |
246 | 2020-02-11 01:53:18 | lampads | 1 | 69583 | 3 | 2.876 | 24194.4 |
245 | 2020-02-10 20:19:35 | lampads | 1 | 69583 | 3 | 1.266 | 54962.9 |
244 | 2020-02-04 20:14:39 | lampads | 1 | 69583 | 3 | 2.486 | 27989.9 |
243 | 2020-02-03 06:40:06 | lampads | 1 | 69583 | 3 | 1.406 | 49490.0 |
242 | 2020-01-30 18:30:42 | lampads | 1 | 69583 | 3 | 1.203 | 57841.2 |
241 | 2020-01-22 19:49:20 | lampads | 1 | 69583 | 3 | 1.406 | 49490.0 |
240 | 2020-01-17 13:24:08 | lampads | 1 | 69583 | 3 | 4.140 | 16807.5 |
239 | 2020-01-17 12:40:19 | lampads | 1 | 69583 | 3 | 1.266 | 54962.9 |
238 | 2020-01-12 23:40:59 | lampads | 1 | 69583 | 3 | 1.343 | 51811.6 |
237 | 2020-01-03 15:31:48 | lampads | 1 | 69583 | 3 | 1.250 | 55666.4 |
236 | 2019-12-29 21:48:43 | lampads | 1 | 69583 | 3 | 1.173 | 59320.5 |
235 | 2019-12-28 07:10:43 | lampads | 1 | 69583 | 3 | 1.190 | 58473.1 |
234 | 2019-12-27 00:30:26 | lampads | 1 | 69583 | 3 | 1.220 | 57035.2 |
233 | 2019-12-26 13:36:47 | lampads | 1 | 69583 | 3 | 1.250 | 55666.4 |
232 | 2019-12-15 14:33:58 | lampads | 1 | 69583 | 3 | 1.063 | 65459.1 |
231 | 2019-11-29 04:53:18 | lampads | 1 | 69583 | 3 | 1.153 | 60349.5 |
230 | 2019-10-30 16:08:39 | lampads | 1 | 69583 | 3 | 1.093 | 63662.4 |
229 | 2019-08-27 14:55:28 | lampads | 1 | 69583 | 3 | 1.140 | 61037.7 |
228 | 2019-05-27 23:00:21 | lampads | 1 | 69583 | 3 | 1.270 | 54789.8 |