History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"newsie"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
306 | 2024-04-27 09:36:20 | newsie | 1 | 48755 | 5 | 1.046 | 46610.9 |
305 | 2024-04-06 02:23:45 | newsie | 1 | 48755 | 5 | 1.436 | 33951.9 |
304 | 2024-04-01 23:57:39 | newsie | 1 | 48755 | 5 | 0.876 | 55656.4 |
303 | 2024-03-28 19:36:32 | newsie | 1 | 48755 | 5 | 2.890 | 16870.2 |
302 | 2024-03-06 23:58:47 | newsie | 1 | 48755 | 5 | 2.156 | 22613.6 |
301 | 2024-03-06 10:02:22 | newsie | 1 | 48755 | 5 | 0.936 | 52088.7 |
300 | 2024-02-28 04:55:31 | newsie | 1 | 48755 | 5 | 1.936 | 25183.4 |
299 | 2024-01-31 16:24:00 | newsie | 2 | 82551 | 17 | 2.580 | 31996.5 |
298 | 2024-01-31 16:23:28 | newsie | 3 | 112716 | 269 | 5.596 | 20142.2 |
297 | 2024-01-31 00:16:23 | newsie | 2 | 82551 | 17 | 4.563 | 18091.4 |
296 | 2024-01-31 00:15:43 | newsie | 3 | 112716 | 269 | 5.250 | 21469.7 |
295 | 2024-01-30 04:31:12 | newsie | 3 | 112716 | 269 | 9.673 | 11652.6 |
294 | 2024-01-30 04:30:40 | newsie | 2 | 82551 | 17 | 2.516 | 32810.4 |
293 | 2024-01-30 04:30:23 | newsie | 3 | 112716 | 269 | 5.376 | 20966.5 |
292 | 2024-01-17 23:34:07 | newsie | 3 | 112716 | 269 | 11.126 | 10130.9 |
291 | 2023-12-30 21:24:43 | newsie | 1 | 48755 | 5 | 0.813 | 59969.2 |
290 | 2023-12-09 02:46:48 | newsie | 1 | 48755 | 5 | 0.826 | 59025.4 |
289 | 2023-12-03 23:24:42 | newsie | 3 | 112716 | 269 | 9.203 | 12247.7 |
288 | 2023-12-02 22:57:19 | newsie | 2 | 82551 | 17 | 2.250 | 36689.3 |
287 | 2023-11-18 08:28:51 | newsie | 1 | 48755 | 5 | 0.843 | 57835.1 |
286 | 2023-11-13 22:54:31 | newsie | 1 | 48755 | 5 | 0.733 | 66514.3 |
285 | 2023-11-10 12:44:46 | newsie | 3 | 112716 | 269 | 11.330 | 9948.5 |
284 | 2023-11-10 12:35:02 | newsie | 1 | 48755 | 5 | 0.750 | 65006.7 |
283 | 2023-11-02 09:58:53 | newsie | 3 | 112716 | 269 | 6.390 | 17639.4 |
282 | 2023-10-25 10:38:56 | newsie | 1 | 48755 | 5 | 0.873 | 55847.7 |
281 | 2023-10-20 01:35:05 | newsie | 1 | 48755 | 5 | 0.796 | 61250.0 |
280 | 2023-10-17 10:11:26 | newsie | 3 | 112716 | 269 | 7.110 | 15853.2 |
279 | 2023-10-16 02:56:26 | newsie | 2 | 82551 | 17 | 2.266 | 36430.3 |
278 | 2023-10-10 23:38:15 | newsie | 1 | 48755 | 5 | 0.826 | 59025.4 |
277 | 2023-09-29 06:41:01 | newsie | 1 | 48755 | 5 | 0.716 | 68093.6 |
276 | 2023-09-22 00:45:20 | newsie | 1 | 48755 | 5 | 0.716 | 68093.6 |
275 | 2023-09-14 19:57:06 | newsie | 1 | 48755 | 5 | 0.793 | 61481.7 |
274 | 2023-08-21 20:05:31 | newsie | 1 | 48755 | 5 | 0.720 | 67715.3 |
273 | 2023-07-14 11:27:38 | newsie | 1 | 48755 | 5 | 0.846 | 57630.0 |
272 | 2023-04-30 14:37:06 | newsie | 1 | 48755 | 5 | 0.736 | 66243.2 |
271 | 2023-04-17 06:16:24 | newsie | 1 | 48755 | 5 | 0.860 | 56691.9 |
270 | 2023-03-28 14:50:21 | newsie | 1 | 48755 | 5 | 0.736 | 66243.2 |
269 | 2023-03-04 13:15:35 | newsie | 1 | 48755 | 5 | 0.716 | 68093.6 |
268 | 2023-02-09 01:36:59 | newsie | 1 | 48755 | 5 | 0.766 | 63648.8 |
267 | 2023-01-10 20:26:48 | newsie | 1 | 48755 | 5 | 0.720 | 67715.3 |
266 | 2022-12-07 02:12:05 | newsie | 1 | 48755 | 5 | 0.813 | 59969.2 |
265 | 2022-09-12 14:36:16 | newsie | 1 | 48755 | 5 | 0.716 | 68093.6 |
264 | 2022-09-10 20:50:40 | newsie | 1 | 48755 | 5 | 0.813 | 59969.2 |
263 | 2022-09-03 21:39:20 | newsie | 1 | 48755 | 5 | 0.796 | 61250.0 |
262 | 2022-08-31 23:06:15 | newsie | 1 | 48755 | 5 | 0.813 | 59969.2 |
261 | 2022-08-07 16:17:44 | newsie | 1 | 48755 | 5 | 0.733 | 66514.3 |
260 | 2022-08-05 15:54:25 | newsie | 1 | 48755 | 5 | 0.733 | 66514.3 |
259 | 2022-08-03 07:55:18 | newsie | 1 | 48755 | 5 | 0.750 | 65006.7 |
258 | 2022-05-17 10:39:07 | newsie | 1 | 48755 | 5 | 1.046 | 46610.9 |
257 | 2022-05-16 07:53:43 | newsie | 1 | 48755 | 5 | 0.750 | 65006.7 |
256 | 2022-05-13 21:28:59 | newsie | 1 | 48755 | 5 | 1.656 | 29441.4 |
255 | 2022-03-26 08:51:26 | newsie | 1 | 48755 | 5 | 0.750 | 65006.7 |
254 | 2022-01-25 21:42:53 | newsie | 1 | 48755 | 5 | 0.843 | 57835.1 |
253 | 2022-01-22 15:56:18 | newsie | 1 | 48755 | 5 | 0.906 | 53813.5 |
252 | 2022-01-05 14:13:13 | newsie | 1 | 48755 | 5 | 0.796 | 61250.0 |
251 | 2021-12-13 03:56:52 | newsie | 1 | 48755 | 5 | 0.733 | 66514.3 |
250 | 2021-11-07 21:59:39 | newsie | 1 | 48755 | 5 | 0.890 | 54780.9 |
249 | 2021-10-14 07:59:05 | newsie | 1 | 48755 | 5 | 0.826 | 59025.4 |
248 | 2021-10-09 16:17:16 | newsie | 1 | 48755 | 5 | 0.843 | 57835.1 |
247 | 2021-07-07 17:27:18 | newsie | 1 | 48755 | 5 | 0.906 | 53813.5 |
246 | 2021-04-07 22:11:52 | newsie | 1 | 48755 | 5 | 0.860 | 56691.9 |
245 | 2021-04-03 18:27:29 | newsie | 1 | 48755 | 5 | 1.610 | 30282.6 |
244 | 2021-02-18 14:08:15 | newsie | 1 | 48755 | 5 | 0.796 | 61250.0 |
243 | 2020-12-29 18:17:54 | newsie | 1 | 48755 | 5 | 0.780 | 62506.4 |
242 | 2020-11-03 12:18:19 | newsie | 1 | 48755 | 5 | 0.846 | 57630.0 |
241 | 2020-10-26 02:07:51 | newsie | 1 | 48755 | 5 | 0.830 | 58741.0 |
240 | 2020-09-26 11:00:40 | newsie | 1 | 48755 | 5 | 0.733 | 66514.3 |
239 | 2020-06-17 15:46:12 | newsie | 1 | 48755 | 5 | 0.750 | 65006.7 |
238 | 2020-03-28 18:03:30 | newsie | 1 | 48755 | 5 | 1.720 | 28345.9 |
237 | 2020-03-24 10:50:35 | newsie | 1 | 48755 | 5 | 0.876 | 55656.4 |
236 | 2020-03-24 01:32:08 | newsie | 1 | 48755 | 5 | 0.890 | 54780.9 |
235 | 2020-03-20 01:01:54 | newsie | 1 | 48755 | 5 | 0.796 | 61250.0 |
234 | 2020-03-09 23:46:21 | newsie | 1 | 48755 | 5 | 0.736 | 66243.2 |
233 | 2020-02-24 01:43:46 | newsie | 1 | 48755 | 5 | 1.893 | 25755.4 |
232 | 2020-02-17 23:12:28 | newsie | 1 | 48755 | 5 | 2.576 | 18926.6 |
231 | 2020-02-14 12:29:51 | newsie | 1 | 48755 | 5 | 1.906 | 25579.7 |
230 | 2020-02-12 20:30:23 | newsie | 1 | 48755 | 5 | 1.313 | 37132.5 |
229 | 2020-02-09 19:51:58 | newsie | 3 | 112716 | 269 | 6.000 | 18786.0 |
228 | 2020-02-08 22:54:36 | newsie | 1 | 48755 | 5 | 1.906 | 25579.7 |
227 | 2020-02-06 09:34:21 | newsie | 3 | 112716 | 269 | 11.313 | 9963.4 |
226 | 2020-02-05 11:39:37 | newsie | 3 | 112716 | 269 | 6.423 | 17548.8 |
225 | 2020-02-05 06:50:48 | newsie | 3 | 112716 | 269 | 17.470 | 6452.0 |
224 | 2020-02-04 14:26:46 | newsie | 3 | 112716 | 269 | 7.283 | 15476.6 |
223 | 2020-01-29 18:43:39 | newsie | 1 | 48755 | 5 | 1.763 | 27654.6 |
222 | 2020-01-29 07:13:33 | newsie | 3 | 112716 | 269 | 18.110 | 6224.0 |
221 | 2020-01-29 04:05:19 | newsie | 3 | 112716 | 269 | 6.860 | 16430.9 |
220 | 2020-01-27 12:51:48 | newsie | 1 | 48755 | 5 | 1.033 | 47197.5 |
219 | 2020-01-21 19:50:11 | newsie | 1 | 48755 | 5 | 2.780 | 17537.8 |
218 | 2020-01-21 19:08:06 | newsie | 1 | 48755 | 5 | 1.080 | 45143.5 |
217 | 2020-01-21 16:35:35 | newsie | 1 | 48755 | 5 | 1.766 | 27607.6 |
216 | 2020-01-19 06:12:33 | newsie | 1 | 48755 | 5 | 1.703 | 28628.9 |
215 | 2020-01-14 12:07:21 | newsie | 1 | 48755 | 5 | 0.920 | 52994.6 |
214 | 2020-01-14 09:54:47 | newsie | 1 | 48755 | 5 | 0.860 | 56691.9 |
213 | 2020-01-08 18:18:25 | newsie | 3 | 112716 | 269 | 6.030 | 18692.5 |
212 | 2020-01-08 08:21:34 | newsie | 3 | 112716 | 269 | 10.110 | 11149.0 |
211 | 2019-12-29 01:13:13 | newsie | 3 | 112716 | 269 | 6.906 | 16321.5 |
210 | 2019-12-28 23:17:06 | newsie | 1 | 48755 | 5 | 0.860 | 56691.9 |
209 | 2019-12-28 21:58:38 | newsie | 1 | 48755 | 5 | 1.750 | 27860.0 |
208 | 2019-12-28 19:23:59 | newsie | 1 | 48755 | 5 | 0.860 | 56691.9 |
207 | 2019-12-28 00:03:47 | newsie | 1 | 48755 | 5 | 1.766 | 27607.6 |