History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"potato"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
341 | 2024-04-27 12:04:52 | potato | 1 | 48755 | 2 | 2.030 | 24017.2 |
340 | 2024-04-25 21:24:27 | potato | 1 | 48755 | 2 | 1.030 | 47335.0 |
339 | 2024-04-07 11:02:12 | potato | 3 | 112716 | 315 | 13.843 | 8142.5 |
338 | 2024-04-06 15:07:11 | potato | 3 | 112716 | 315 | 6.140 | 18357.7 |
337 | 2024-04-06 15:07:14 | potato | 2 | 82551 | 18 | 2.660 | 31034.2 |
336 | 2024-04-06 15:07:06 | potato | 1 | 48755 | 2 | 0.830 | 58741.0 |
335 | 2024-04-02 20:08:31 | potato | 1 | 48755 | 2 | 0.763 | 63899.1 |
334 | 2024-03-31 06:27:09 | potato | 1 | 48755 | 2 | 2.920 | 16696.9 |
333 | 2024-03-28 18:15:46 | potato | 1 | 48755 | 2 | 2.420 | 20146.7 |
332 | 2024-02-28 19:55:15 | potato | 1 | 48755 | 2 | 0.860 | 56691.9 |
331 | 2024-02-06 15:50:38 | potato | 2 | 82551 | 18 | 2.593 | 31836.1 |
330 | 2024-02-06 15:50:22 | potato | 3 | 112716 | 315 | 6.466 | 17432.1 |
329 | 2024-02-04 13:33:38 | potato | 1 | 48755 | 2 | 6.670 | 7309.6 |
328 | 2024-01-31 14:01:15 | potato | 2 | 82551 | 18 | 2.453 | 33653.1 |
327 | 2024-01-31 13:55:11 | potato | 3 | 112716 | 315 | 5.873 | 19192.2 |
326 | 2024-01-30 17:24:54 | potato | 2 | 82551 | 18 | 2.546 | 32423.8 |
325 | 2024-01-30 17:23:19 | potato | 3 | 112716 | 315 | 5.846 | 19280.9 |
324 | 2024-01-30 12:17:11 | potato | 2 | 82551 | 18 | 2.250 | 36689.3 |
323 | 2024-01-30 12:16:55 | potato | 3 | 112716 | 315 | 5.813 | 19390.3 |
322 | 2024-01-18 23:53:07 | potato | 3 | 112716 | 315 | 7.236 | 15577.1 |
321 | 2024-01-15 08:40:45 | potato | 2 | 82551 | 18 | 2.280 | 36206.6 |
320 | 2023-12-26 11:44:31 | potato | 3 | 112716 | 315 | 6.033 | 18683.2 |
319 | 2023-12-24 11:48:04 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
318 | 2023-12-04 13:18:59 | potato | 1 | 48755 | 2 | 0.813 | 59969.2 |
317 | 2023-11-19 21:32:46 | potato | 1 | 48755 | 2 | 0.796 | 61250.0 |
316 | 2023-11-11 12:10:16 | potato | 1 | 48755 | 2 | 1.720 | 28345.9 |
315 | 2023-11-08 01:17:34 | potato | 1 | 48755 | 2 | 0.843 | 57835.1 |
314 | 2023-10-29 21:57:01 | potato | 3 | 112716 | 315 | 5.016 | 22471.3 |
313 | 2023-10-21 12:45:40 | potato | 2 | 82551 | 18 | 2.500 | 33020.4 |
312 | 2023-10-20 06:46:28 | potato | 1 | 48755 | 2 | 2.750 | 17729.1 |
311 | 2023-10-19 22:31:05 | potato | 1 | 48755 | 2 | 0.796 | 61250.0 |
310 | 2023-10-12 04:58:18 | potato | 1 | 48755 | 2 | 0.733 | 66514.3 |
309 | 2023-10-11 14:03:39 | potato | 1 | 48755 | 2 | 0.843 | 57835.1 |
308 | 2023-10-07 11:21:27 | potato | 1 | 48755 | 2 | 0.860 | 56691.9 |
307 | 2023-09-27 15:03:13 | potato | 1 | 48755 | 2 | 0.923 | 52822.3 |
306 | 2023-09-14 19:42:21 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
305 | 2023-08-07 16:46:45 | potato | 1 | 48755 | 2 | 0.763 | 63899.1 |
304 | 2023-08-06 23:38:58 | potato | 3 | 112716 | 315 | 5.813 | 19390.3 |
303 | 2023-08-01 16:27:38 | potato | 2 | 82551 | 18 | 2.453 | 33653.1 |
302 | 2023-07-09 04:55:29 | potato | 1 | 48755 | 2 | 1.656 | 29441.4 |
301 | 2023-05-07 00:05:32 | potato | 1 | 48755 | 2 | 0.906 | 53813.5 |
300 | 2023-04-20 04:13:53 | potato | 3 | 112716 | 315 | 5.656 | 19928.6 |
299 | 2023-04-11 01:30:32 | potato | 2 | 82551 | 18 | 2.110 | 39123.7 |
298 | 2023-03-12 01:51:00 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
297 | 2023-02-28 11:48:39 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
296 | 2023-01-20 17:13:18 | potato | 3 | 112716 | 315 | 4.673 | 24120.7 |
295 | 2023-01-17 21:32:45 | potato | 2 | 82551 | 18 | 2.140 | 38575.2 |
294 | 2022-12-26 06:29:13 | potato | 1 | 48755 | 2 | 0.716 | 68093.6 |
293 | 2022-12-11 21:50:58 | potato | 3 | 112716 | 315 | 5.173 | 21789.3 |
292 | 2022-11-09 16:08:10 | potato | 1 | 48755 | 2 | 0.796 | 61250.0 |
291 | 2022-11-06 06:33:58 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
290 | 2022-10-31 14:16:35 | potato | 3 | 112716 | 315 | 4.860 | 23192.6 |
289 | 2022-10-29 06:52:21 | potato | 2 | 82551 | 18 | 2.110 | 39123.7 |
288 | 2022-09-14 02:07:18 | potato | 1 | 48755 | 2 | 0.843 | 57835.1 |
287 | 2022-07-19 07:15:03 | potato | 1 | 48755 | 2 | 0.783 | 62266.9 |
286 | 2022-07-16 23:10:25 | potato | 1 | 48755 | 2 | 0.763 | 63899.1 |
285 | 2022-06-29 06:16:29 | potato | 1 | 48755 | 2 | 0.733 | 66514.3 |
284 | 2022-05-23 11:27:41 | potato | 2 | 82551 | 18 | 2.376 | 34743.7 |
283 | 2022-05-16 11:54:29 | potato | 3 | 112716 | 315 | 6.893 | 16352.2 |
282 | 2022-03-18 21:41:07 | potato | 1 | 48755 | 2 | 0.830 | 58741.0 |
281 | 2022-03-16 18:15:25 | potato | 1 | 48755 | 2 | 1.093 | 44606.6 |
280 | 2022-02-23 13:49:29 | potato | 1 | 48755 | 2 | 0.813 | 59969.2 |
279 | 2022-01-10 21:50:40 | potato | 1 | 48755 | 2 | 0.906 | 53813.5 |
278 | 2021-11-23 04:39:08 | potato | 1 | 48755 | 2 | 0.810 | 60191.4 |
277 | 2021-11-02 00:55:42 | potato | 1 | 48755 | 2 | 0.893 | 54596.9 |
276 | 2021-07-19 09:58:43 | potato | 1 | 48755 | 2 | 0.736 | 66243.2 |
275 | 2021-07-15 19:24:03 | potato | 1 | 48755 | 2 | 0.860 | 56691.9 |
274 | 2021-06-05 17:01:04 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
273 | 2021-05-11 16:51:07 | potato | 1 | 48755 | 2 | 1.096 | 44484.5 |
272 | 2021-04-12 22:15:16 | potato | 1 | 48755 | 2 | 0.843 | 57835.1 |
271 | 2021-04-10 10:39:10 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
270 | 2021-01-24 21:04:55 | potato | 1 | 48755 | 2 | 0.843 | 57835.1 |
269 | 2021-01-03 04:56:20 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
268 | 2020-11-06 09:25:48 | potato | 1 | 48755 | 2 | 0.766 | 63648.8 |
267 | 2020-11-04 12:30:59 | potato | 1 | 48755 | 2 | 0.763 | 63899.1 |
266 | 2020-10-30 23:18:52 | potato | 1 | 48755 | 2 | 0.780 | 62506.4 |
265 | 2020-10-13 01:02:23 | potato | 1 | 48755 | 2 | 0.763 | 63899.1 |
264 | 2020-10-12 04:54:04 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
263 | 2020-10-01 07:48:52 | potato | 1 | 48755 | 2 | 0.733 | 66514.3 |
262 | 2020-09-19 04:30:50 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
261 | 2020-06-21 08:18:58 | potato | 1 | 48755 | 2 | 0.826 | 59025.4 |
260 | 2020-06-18 03:39:27 | potato | 1 | 48755 | 2 | 0.783 | 62266.9 |
259 | 2020-06-11 12:56:15 | potato | 1 | 48755 | 2 | 0.810 | 60191.4 |
258 | 2020-03-25 20:07:13 | potato | 1 | 48755 | 2 | 0.783 | 62266.9 |
257 | 2020-03-24 20:30:25 | potato | 1 | 48755 | 2 | 0.923 | 52822.3 |
256 | 2020-03-23 20:04:38 | potato | 1 | 48755 | 2 | 1.843 | 26454.2 |
255 | 2020-03-22 20:36:38 | potato | 1 | 48755 | 2 | 0.983 | 49598.2 |
254 | 2020-03-21 13:48:13 | potato | 1 | 48755 | 2 | 0.873 | 55847.7 |
253 | 2020-03-18 09:01:58 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
252 | 2020-03-15 19:47:34 | potato | 1 | 48755 | 2 | 0.750 | 65006.7 |
251 | 2020-03-04 15:31:33 | potato | 1 | 48755 | 2 | 0.890 | 54780.9 |
250 | 2020-02-24 22:35:40 | potato | 3 | 112716 | 315 | 10.610 | 10623.6 |
249 | 2020-02-24 19:49:30 | potato | 1 | 48755 | 2 | 0.860 | 56691.9 |
248 | 2020-02-17 18:44:32 | potato | 1 | 48755 | 2 | 0.906 | 53813.5 |
247 | 2020-02-16 19:46:09 | potato | 3 | 112716 | 315 | 12.966 | 8693.2 |
246 | 2020-02-15 07:10:29 | potato | 3 | 112716 | 315 | 7.533 | 14963.0 |
245 | 2020-02-15 04:50:03 | potato | 3 | 112716 | 315 | 5.670 | 19879.4 |
244 | 2020-02-15 01:39:56 | potato | 3 | 112716 | 315 | 5.593 | 20153.0 |
243 | 2020-02-14 21:58:37 | potato | 3 | 112716 | 315 | 8.706 | 12946.9 |
242 | 2020-02-12 21:13:09 | potato | 1 | 48755 | 2 | 1.016 | 47987.2 |