History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yakking"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
345 | 2024-04-30 13:51:13 | yakking | 1 | 69583 | 4 | 2.486 | 27989.9 |
344 | 2024-04-20 20:50:45 | yakking | 1 | 69583 | 4 | 1.673 | 41591.8 |
343 | 2024-04-16 18:21:41 | yakking | 1 | 69583 | 4 | 2.046 | 34009.3 |
342 | 2024-04-08 21:56:07 | yakking | 1 | 69583 | 4 | 2.093 | 33245.6 |
341 | 2024-03-20 19:15:53 | yakking | 3 | 134027 | 700 | 16.923 | 7919.8 |
340 | 2024-03-20 19:15:20 | yakking | 2 | 107671 | 64 | 3.440 | 31299.7 |
339 | 2024-03-20 13:15:05 | yakking | 2 | 107671 | 64 | 2.940 | 36622.8 |
338 | 2024-03-09 04:06:42 | yakking | 3 | 134027 | 700 | 6.846 | 19577.4 |
337 | 2024-03-09 04:06:42 | yakking | 1 | 69583 | 4 | 1.250 | 55666.4 |
336 | 2024-03-09 04:06:33 | yakking | 2 | 107671 | 64 | 3.453 | 31181.9 |
335 | 2024-03-09 03:54:00 | yakking | 1 | 69583 | 4 | 1.186 | 58670.3 |
334 | 2024-02-08 03:45:39 | yakking | 3 | 134027 | 700 | 7.186 | 18651.1 |
333 | 2024-02-08 03:45:38 | yakking | 2 | 107671 | 64 | 6.940 | 15514.6 |
332 | 2024-02-08 03:42:05 | yakking | 1 | 69583 | 4 | 1.250 | 55666.4 |
331 | 2024-01-08 22:03:41 | yakking | 1 | 69583 | 4 | 2.500 | 27833.2 |
330 | 2024-01-04 02:38:45 | yakking | 1 | 69583 | 4 | 1.063 | 65459.1 |
329 | 2023-11-30 18:34:26 | yakking | 1 | 69583 | 4 | 1.046 | 66522.9 |
328 | 2023-11-30 10:22:04 | yakking | 2 | 107671 | 64 | 2.750 | 39153.1 |
327 | 2023-11-06 23:02:01 | yakking | 1 | 69583 | 4 | 1.236 | 56296.9 |
326 | 2023-10-28 01:08:22 | yakking | 1 | 69583 | 4 | 1.173 | 59320.5 |
325 | 2023-10-01 23:48:05 | yakking | 1 | 69583 | 4 | 1.033 | 67360.1 |
324 | 2023-08-30 16:30:57 | yakking | 2 | 107671 | 64 | 2.860 | 37647.2 |
323 | 2023-08-22 08:03:22 | yakking | 1 | 69583 | 4 | 1.080 | 64428.7 |
322 | 2023-05-25 14:11:52 | yakking | 1 | 69583 | 4 | 1.050 | 66269.5 |
321 | 2023-05-16 11:07:04 | yakking | 2 | 107671 | 64 | 2.703 | 39833.9 |
320 | 2023-03-20 10:12:39 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
319 | 2023-02-22 08:14:29 | yakking | 2 | 107671 | 64 | 2.703 | 39833.9 |
318 | 2023-01-07 09:08:43 | yakking | 1 | 69583 | 4 | 1.030 | 67556.3 |
317 | 2022-12-02 15:45:07 | yakking | 2 | 107671 | 64 | 3.000 | 35890.3 |
316 | 2022-10-05 15:22:48 | yakking | 1 | 69583 | 4 | 1.046 | 66522.9 |
315 | 2022-06-28 20:28:03 | yakking | 3 | 134027 | 700 | 5.423 | 24714.5 |
314 | 2022-05-25 05:19:20 | yakking | 1 | 69583 | 4 | 1.033 | 67360.1 |
313 | 2022-04-19 18:34:27 | yakking | 2 | 107671 | 64 | 2.876 | 37437.8 |
312 | 2022-02-10 20:09:52 | yakking | 1 | 69583 | 4 | 1.423 | 48898.8 |
311 | 2022-02-08 16:41:01 | yakking | 1 | 69583 | 4 | 1.033 | 67360.1 |
310 | 2022-01-18 22:13:58 | yakking | 1 | 69583 | 4 | 1.140 | 61037.7 |
309 | 2022-01-12 09:08:04 | yakking | 2 | 107671 | 64 | 2.783 | 38688.8 |
308 | 2022-01-12 09:08:00 | yakking | 1 | 69583 | 4 | 1.046 | 66522.9 |
307 | 2021-12-09 18:30:00 | yakking | 1 | 69583 | 4 | 1.420 | 49002.1 |
306 | 2021-11-30 09:15:17 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
305 | 2021-11-28 07:11:28 | yakking | 1 | 69583 | 4 | 1.250 | 55666.4 |
304 | 2021-10-24 06:30:11 | yakking | 1 | 69583 | 4 | 1.170 | 59472.6 |
303 | 2021-05-30 01:34:56 | yakking | 1 | 69583 | 4 | 1.250 | 55666.4 |
302 | 2021-05-04 16:14:07 | yakking | 1 | 69583 | 4 | 1.173 | 59320.5 |
301 | 2021-01-17 18:32:10 | yakking | 1 | 69583 | 4 | 1.046 | 66522.9 |
300 | 2020-11-22 21:28:02 | yakking | 1 | 69583 | 4 | 1.030 | 67556.3 |
299 | 2020-11-05 18:26:39 | yakking | 1 | 69583 | 4 | 1.153 | 60349.5 |
298 | 2020-10-28 19:29:20 | yakking | 1 | 69583 | 4 | 2.390 | 29114.2 |
297 | 2020-10-28 14:49:16 | yakking | 1 | 69583 | 4 | 1.406 | 49490.0 |
296 | 2020-04-03 09:04:07 | yakking | 1 | 69583 | 4 | 1.076 | 64668.2 |
295 | 2020-03-27 06:51:29 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
294 | 2020-03-23 01:49:34 | yakking | 1 | 69583 | 4 | 1.220 | 57035.2 |
293 | 2020-03-14 11:15:00 | yakking | 1 | 69583 | 4 | 1.173 | 59320.5 |
292 | 2020-02-29 10:21:55 | yakking | 1 | 69583 | 4 | 1.250 | 55666.4 |
291 | 2020-02-24 23:38:30 | yakking | 1 | 69583 | 4 | 1.156 | 60192.9 |
290 | 2020-02-17 16:15:17 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
289 | 2020-02-15 13:43:20 | yakking | 1 | 69583 | 4 | 2.703 | 25742.9 |
288 | 2020-02-13 15:07:57 | yakking | 1 | 69583 | 4 | 1.233 | 56433.9 |
287 | 2020-02-04 15:49:59 | yakking | 1 | 69583 | 4 | 2.546 | 27330.3 |
286 | 2020-02-02 02:28:09 | yakking | 1 | 69583 | 4 | 2.013 | 34566.8 |
285 | 2020-01-23 00:42:26 | yakking | 1 | 69583 | 4 | 1.390 | 50059.7 |
284 | 2020-01-22 18:59:59 | yakking | 1 | 69583 | 4 | 3.250 | 21410.2 |
283 | 2020-01-22 01:42:18 | yakking | 1 | 69583 | 4 | 1.313 | 52995.4 |
282 | 2020-01-16 04:33:46 | yakking | 1 | 69583 | 4 | 1.343 | 51811.6 |
281 | 2020-01-13 10:27:06 | yakking | 1 | 69583 | 4 | 1.106 | 62914.1 |
280 | 2019-12-31 22:27:29 | yakking | 1 | 69583 | 4 | 1.826 | 38106.8 |
279 | 2019-12-29 21:26:28 | yakking | 1 | 69583 | 4 | 2.483 | 28023.8 |
278 | 2019-11-29 23:52:03 | yakking | 1 | 69583 | 4 | 1.030 | 67556.3 |
277 | 2019-08-28 11:00:36 | yakking | 1 | 69583 | 4 | 1.120 | 62127.7 |
276 | 2019-05-19 10:32:26 | yakking | 1 | 69583 | 4 | 1.173 | 59320.5 |
275 | 2019-02-27 02:58:56 | yakking | 1 | 69583 | 4 | 1.113 | 62518.4 |
274 | 2019-02-20 02:50:58 | yakking | 1 | 69583 | 4 | 1.043 | 66714.3 |
273 | 2019-02-09 21:46:27 | yakking | 1 | 69583 | 4 | 1.113 | 62518.4 |
272 | 2019-02-06 08:54:52 | yakking | 1 | 69583 | 4 | 1.010 | 68894.1 |
271 | 2019-01-22 00:33:27 | yakking | 1 | 69583 | 4 | 1.060 | 65644.3 |
270 | 2019-01-08 10:19:03 | yakking | 1 | 69583 | 4 | 1.006 | 69168.0 |
269 | 2019-01-06 10:15:32 | yakking | 1 | 69583 | 4 | 1.016 | 68487.2 |
268 | 2018-12-21 22:38:34 | yakking | 1 | 69583 | 4 | 1.393 | 49951.9 |
267 | 2018-11-19 22:49:15 | yakking | 1 | 69583 | 4 | 2.230 | 31203.1 |
266 | 2018-11-10 07:14:41 | yakking | 1 | 69583 | 4 | 0.993 | 70073.5 |
265 | 2018-11-08 07:19:50 | yakking | 1 | 69583 | 4 | 0.983 | 70786.4 |
264 | 2018-11-06 08:53:44 | yakking | 1 | 69583 | 4 | 1.053 | 66080.7 |
263 | 2018-11-06 08:51:04 | yakking | 1 | 69583 | 4 | 1.003 | 69374.9 |
262 | 2018-11-04 09:46:41 | yakking | 1 | 69583 | 4 | 0.990 | 70285.9 |
261 | 2018-11-04 09:44:05 | yakking | 1 | 69583 | 4 | 0.990 | 70285.9 |
260 | 2018-10-18 13:40:10 | yakking | 1 | 69583 | 4 | 0.983 | 70786.4 |
259 | 2018-10-16 21:55:28 | yakking | 1 | 69583 | 4 | 1.136 | 61252.6 |
258 | 2018-10-05 20:54:57 | yakking | 1 | 69583 | 4 | 1.050 | 66269.5 |
257 | 2018-10-04 00:31:00 | yakking | 1 | 69583 | 4 | 1.393 | 49951.9 |
256 | 2018-10-02 05:50:18 | yakking | 1 | 69583 | 4 | 1.053 | 66080.7 |
255 | 2018-09-26 20:22:11 | yakking | 1 | 69583 | 4 | 1.013 | 68690.0 |
254 | 2018-09-21 17:10:58 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
253 | 2018-09-19 09:41:19 | yakking | 1 | 69583 | 4 | 1.223 | 56895.3 |
252 | 2018-09-16 17:54:07 | yakking | 1 | 69583 | 4 | 1.090 | 63837.6 |
251 | 2018-09-14 18:21:59 | yakking | 1 | 69583 | 4 | 1.096 | 63488.1 |
250 | 2018-09-13 02:24:38 | yakking | 1 | 69583 | 4 | 1.063 | 65459.1 |
249 | 2018-09-09 17:51:31 | yakking | 1 | 69583 | 4 | 1.103 | 63085.2 |
248 | 2018-07-05 21:16:28 | yakking | 1 | 69583 | 4 | 1.203 | 57841.2 |
247 | 2018-06-30 05:51:36 | yakking | 1 | 69583 | 4 | 1.040 | 66906.7 |
246 | 2018-06-23 00:33:45 | yakking | 1 | 69583 | 4 | 1.196 | 58179.8 |