History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lampoon"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
319 | 2024-04-27 08:50:26 | lampoon | 1 | 69583 | 3 | 1.423 | 48898.8 |
318 | 2024-01-20 01:01:15 | lampoon | 1 | 69583 | 3 | 2.516 | 27656.2 |
317 | 2024-01-05 07:01:24 | lampoon | 1 | 69583 | 3 | 1.076 | 64668.2 |
316 | 2023-12-15 23:12:03 | lampoon | 1 | 69583 | 3 | 1.173 | 59320.5 |
315 | 2023-12-08 07:06:00 | lampoon | 1 | 69583 | 3 | 1.280 | 54361.7 |
314 | 2023-12-08 07:05:58 | lampoon | 1 | 69583 | 3 | 1.200 | 57985.8 |
313 | 2023-12-02 19:13:11 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
312 | 2023-11-27 21:59:02 | lampoon | 1 | 69583 | 3 | 1.190 | 58473.1 |
311 | 2023-10-30 05:14:06 | lampoon | 1 | 69583 | 3 | 1.233 | 56433.9 |
310 | 2023-10-11 15:39:26 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
309 | 2023-09-29 21:27:47 | lampoon | 1 | 69583 | 3 | 1.203 | 57841.2 |
308 | 2023-09-17 19:28:20 | lampoon | 1 | 69583 | 3 | 1.076 | 64668.2 |
307 | 2023-09-16 08:25:22 | lampoon | 1 | 69583 | 3 | 2.750 | 25302.9 |
306 | 2023-09-12 23:21:03 | lampoon | 1 | 69583 | 3 | 1.580 | 44039.9 |
305 | 2023-08-23 18:38:28 | lampoon | 1 | 69583 | 3 | 1.220 | 57035.2 |
304 | 2023-05-27 05:50:07 | lampoon | 1 | 69583 | 3 | 1.216 | 57222.9 |
303 | 2023-05-16 22:37:24 | lampoon | 1 | 69583 | 3 | 1.060 | 65644.3 |
302 | 2023-03-21 23:00:02 | lampoon | 1 | 69583 | 3 | 1.080 | 64428.7 |
301 | 2023-01-16 10:40:52 | lampoon | 1 | 69583 | 3 | 1.063 | 65459.1 |
300 | 2023-01-08 09:00:47 | lampoon | 1 | 69583 | 3 | 1.046 | 66522.9 |
299 | 2022-10-13 17:53:44 | lampoon | 1 | 69583 | 3 | 1.203 | 57841.2 |
298 | 2022-09-14 09:40:21 | lampoon | 1 | 69583 | 3 | 1.143 | 60877.5 |
297 | 2022-05-30 15:05:34 | lampoon | 1 | 69583 | 3 | 1.063 | 65459.1 |
296 | 2022-05-15 15:31:45 | lampoon | 1 | 69583 | 3 | 1.080 | 64428.7 |
295 | 2022-02-11 19:00:36 | lampoon | 1 | 69583 | 3 | 2.296 | 30306.2 |
294 | 2022-01-27 22:26:02 | lampoon | 1 | 69583 | 3 | 1.126 | 61796.6 |
293 | 2021-12-01 07:35:51 | lampoon | 1 | 69583 | 3 | 1.093 | 63662.4 |
292 | 2021-10-25 03:01:49 | lampoon | 1 | 69583 | 3 | 1.203 | 57841.2 |
291 | 2021-10-11 06:11:05 | lampoon | 1 | 69583 | 3 | 1.080 | 64428.7 |
290 | 2021-10-05 04:01:53 | lampoon | 3 | 134027 | 113 | 6.690 | 20033.9 |
289 | 2021-10-02 00:21:03 | lampoon | 3 | 134027 | 113 | 5.843 | 22938.0 |
288 | 2021-08-06 20:21:30 | lampoon | 3 | 134027 | 113 | 5.720 | 23431.3 |
287 | 2021-07-09 16:54:32 | lampoon | 1 | 69583 | 3 | 1.330 | 52318.0 |
286 | 2021-06-25 01:19:49 | lampoon | 3 | 134027 | 113 | 7.093 | 18895.7 |
285 | 2021-05-23 09:38:45 | lampoon | 3 | 134027 | 113 | 6.406 | 20922.1 |
284 | 2021-04-07 00:45:08 | lampoon | 1 | 69583 | 3 | 1.093 | 63662.4 |
283 | 2021-04-05 20:23:06 | lampoon | 1 | 69583 | 3 | 1.250 | 55666.4 |
282 | 2021-04-01 16:09:56 | lampoon | 1 | 69583 | 3 | 1.296 | 53690.6 |
281 | 2021-01-22 04:56:07 | lampoon | 1 | 69583 | 3 | 1.203 | 57841.2 |
280 | 2021-01-17 17:52:03 | lampoon | 3 | 134027 | 113 | 5.766 | 23244.4 |
279 | 2021-01-17 10:38:09 | lampoon | 3 | 134027 | 113 | 6.923 | 19359.7 |
278 | 2020-12-24 10:18:17 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
277 | 2020-12-18 13:13:36 | lampoon | 3 | 134027 | 113 | 11.203 | 11963.5 |
276 | 2020-11-23 03:04:11 | lampoon | 3 | 134027 | 113 | 5.720 | 23431.3 |
275 | 2020-11-07 07:54:20 | lampoon | 2 | 107671 | 14 | 3.530 | 30501.7 |
274 | 2020-11-01 10:59:59 | lampoon | 3 | 134027 | 113 | 6.956 | 19267.8 |
273 | 2020-10-27 17:42:29 | lampoon | 3 | 134027 | 113 | 5.936 | 22578.7 |
272 | 2020-10-24 18:15:46 | lampoon | 1 | 69583 | 3 | 1.250 | 55666.4 |
271 | 2020-10-16 12:45:11 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
270 | 2020-10-07 10:37:14 | lampoon | 1 | 69583 | 3 | 1.233 | 56433.9 |
269 | 2020-09-29 01:02:33 | lampoon | 3 | 134027 | 113 | 5.750 | 23309.0 |
268 | 2020-09-24 12:21:00 | lampoon | 1 | 69583 | 3 | 1.140 | 61037.7 |
267 | 2020-09-23 09:11:31 | lampoon | 3 | 134027 | 113 | 6.640 | 20184.8 |
266 | 2020-08-25 12:00:40 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
265 | 2020-08-17 18:42:45 | lampoon | 3 | 134027 | 113 | 5.873 | 22820.9 |
264 | 2020-08-10 09:43:59 | lampoon | 1 | 69583 | 3 | 1.266 | 54962.9 |
263 | 2020-07-31 03:26:25 | lampoon | 3 | 134027 | 113 | 6.876 | 19492.0 |
262 | 2020-06-17 22:16:35 | lampoon | 3 | 134027 | 113 | 6.360 | 21073.4 |
261 | 2020-06-09 22:59:37 | lampoon | 1 | 69583 | 3 | 1.126 | 61796.6 |
260 | 2020-06-07 04:05:17 | lampoon | 1 | 69583 | 3 | 1.110 | 62687.4 |
259 | 2020-05-20 05:05:01 | lampoon | 3 | 134027 | 113 | 5.796 | 23124.1 |
258 | 2020-05-08 00:02:21 | lampoon | 3 | 134027 | 113 | 6.033 | 22215.6 |
257 | 2020-03-29 13:05:06 | lampoon | 1 | 69583 | 3 | 1.330 | 52318.0 |
256 | 2020-03-29 05:28:55 | lampoon | 1 | 69583 | 3 | 1.296 | 53690.6 |
255 | 2020-03-24 17:11:16 | lampoon | 1 | 69583 | 3 | 1.203 | 57841.2 |
254 | 2020-03-24 13:26:53 | lampoon | 1 | 69583 | 3 | 1.406 | 49490.0 |
253 | 2020-03-20 22:49:18 | lampoon | 1 | 69583 | 3 | 2.360 | 29484.3 |
252 | 2020-03-02 18:42:33 | lampoon | 1 | 69583 | 3 | 1.313 | 52995.4 |
251 | 2020-02-25 16:04:32 | lampoon | 1 | 69583 | 3 | 2.346 | 29660.3 |
250 | 2020-02-25 14:30:24 | lampoon | 1 | 69583 | 3 | 1.406 | 49490.0 |
249 | 2020-02-23 03:22:04 | lampoon | 1 | 69583 | 3 | 2.533 | 27470.6 |
248 | 2020-02-12 23:11:14 | lampoon | 3 | 134027 | 113 | 7.873 | 17023.6 |
247 | 2020-02-12 19:00:59 | lampoon | 3 | 134027 | 113 | 9.813 | 13658.1 |
246 | 2020-02-07 01:21:34 | lampoon | 1 | 69583 | 3 | 3.796 | 18330.6 |
245 | 2020-02-06 08:14:53 | lampoon | 3 | 134027 | 113 | 12.830 | 10446.4 |
244 | 2020-02-05 23:31:01 | lampoon | 3 | 134027 | 113 | 8.156 | 16432.9 |
243 | 2020-02-05 04:20:26 | lampoon | 3 | 134027 | 113 | 8.233 | 16279.2 |
242 | 2020-02-03 16:53:00 | lampoon | 1 | 69583 | 3 | 2.766 | 25156.5 |
241 | 2020-02-02 06:07:15 | lampoon | 1 | 69583 | 3 | 1.423 | 48898.8 |
240 | 2020-01-30 21:25:01 | lampoon | 3 | 134027 | 113 | 10.643 | 12593.0 |
239 | 2020-01-28 23:56:42 | lampoon | 1 | 69583 | 3 | 1.173 | 59320.5 |
238 | 2020-01-27 17:54:57 | lampoon | 1 | 69583 | 3 | 1.360 | 51164.0 |
237 | 2020-01-27 15:52:35 | lampoon | 1 | 69583 | 3 | 1.220 | 57035.2 |
236 | 2020-01-25 12:29:34 | lampoon | 3 | 134027 | 113 | 16.063 | 8343.8 |
235 | 2020-01-24 13:37:21 | lampoon | 1 | 69583 | 3 | 2.860 | 24329.7 |
234 | 2020-01-22 12:23:12 | lampoon | 3 | 134027 | 113 | 13.576 | 9872.3 |
233 | 2020-01-13 02:24:14 | lampoon | 3 | 134027 | 113 | 7.516 | 17832.2 |
232 | 2020-01-13 01:00:38 | lampoon | 3 | 134027 | 113 | 6.860 | 19537.5 |
231 | 2020-01-11 22:46:12 | lampoon | 1 | 69583 | 3 | 1.360 | 51164.0 |
230 | 2020-01-09 19:44:44 | lampoon | 3 | 134027 | 113 | 8.220 | 16305.0 |
229 | 2020-01-08 15:58:48 | lampoon | 1 | 69583 | 3 | 1.390 | 50059.7 |
228 | 2020-01-07 10:24:05 | lampoon | 1 | 69583 | 3 | 1.263 | 55093.4 |
227 | 2020-01-07 00:02:17 | lampoon | 1 | 69583 | 3 | 4.343 | 16021.9 |
226 | 2020-01-04 18:04:39 | lampoon | 3 | 134027 | 113 | 5.920 | 22639.7 |
225 | 2020-01-03 10:41:57 | lampoon | 3 | 134027 | 113 | 13.126 | 10210.8 |
224 | 2020-01-03 00:38:19 | lampoon | 3 | 134027 | 113 | 7.420 | 18062.9 |
223 | 2020-01-02 15:46:32 | lampoon | 3 | 134027 | 113 | 8.986 | 14915.1 |
222 | 2020-01-02 07:08:51 | lampoon | 3 | 134027 | 113 | 6.970 | 19229.1 |
221 | 2020-01-02 06:41:46 | lampoon | 3 | 134027 | 113 | 6.660 | 20124.2 |
220 | 2020-01-01 20:40:31 | lampoon | 3 | 134027 | 113 | 11.500 | 11654.5 |