History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"longbows"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
342 | 2024-05-16 05:30:15 | longbows | 4 | 161609 | 430 | 34.976 | 4620.6 |
341 | 2024-05-13 20:32:18 | longbows | 4 | 161609 | 430 | 16.110 | 10031.6 |
340 | 2024-05-11 13:02:33 | longbows | 1 | 82945 | 2 | 2.890 | 28700.7 |
339 | 2024-05-08 20:51:54 | longbows | 2 | 121059 | 6 | 3.860 | 31362.4 |
338 | 2024-05-08 20:51:29 | longbows | 3 | 146162 | 54 | 7.813 | 18707.5 |
337 | 2024-05-06 04:09:24 | longbows | 4 | 161609 | 430 | 15.750 | 10260.9 |
336 | 2024-05-06 01:28:22 | longbows | 2 | 121059 | 6 | 5.140 | 23552.3 |
335 | 2024-05-06 01:26:38 | longbows | 3 | 146162 | 54 | 14.580 | 10024.8 |
334 | 2024-05-04 17:54:12 | longbows | 3 | 146162 | 54 | 13.140 | 11123.4 |
333 | 2024-05-04 17:54:19 | longbows | 1 | 82945 | 2 | 2.953 | 28088.4 |
332 | 2024-05-04 17:54:08 | longbows | 2 | 121059 | 6 | 4.576 | 26455.2 |
331 | 2024-05-04 17:52:04 | longbows | 3 | 146162 | 54 | 7.923 | 18447.8 |
330 | 2024-05-04 17:52:07 | longbows | 2 | 121059 | 6 | 3.810 | 31774.0 |
329 | 2024-05-04 06:30:47 | longbows | 4 | 161609 | 430 | 14.423 | 11205.0 |
328 | 2024-05-04 05:01:25 | longbows | 4 | 161609 | 430 | 15.003 | 10771.8 |
327 | 2024-05-04 03:44:44 | longbows | 4 | 161609 | 430 | 13.203 | 12240.3 |
326 | 2024-05-04 03:44:39 | longbows | 1 | 82945 | 2 | 1.500 | 55296.7 |
325 | 2024-04-20 06:47:18 | longbows | 2 | 121059 | 6 | 4.046 | 29920.7 |
324 | 2024-04-20 06:46:57 | longbows | 3 | 146162 | 54 | 8.816 | 16579.2 |
323 | 2024-04-19 13:55:25 | longbows | 3 | 146162 | 54 | 16.110 | 9072.7 |
322 | 2024-04-19 13:55:21 | longbows | 2 | 121059 | 6 | 11.846 | 10219.4 |
321 | 2024-04-19 13:55:15 | longbows | 1 | 82945 | 2 | 1.610 | 51518.6 |
320 | 2024-04-12 16:13:50 | longbows | 4 | 161609 | 430 | 32.503 | 4972.1 |
319 | 2024-04-11 03:21:33 | longbows | 4 | 161609 | 430 | 14.093 | 11467.3 |
318 | 2024-04-05 16:22:30 | longbows | 3 | 146162 | 54 | 17.923 | 8155.0 |
317 | 2024-04-04 12:22:05 | longbows | 3 | 146162 | 54 | 17.003 | 8596.2 |
316 | 2024-04-04 12:21:59 | longbows | 1 | 82945 | 2 | 3.623 | 22894.0 |
315 | 2024-04-04 12:21:48 | longbows | 3 | 146162 | 54 | 8.046 | 18165.8 |
314 | 2024-04-04 12:21:50 | longbows | 2 | 121059 | 6 | 3.903 | 31016.9 |
313 | 2024-04-03 21:47:16 | longbows | 1 | 82945 | 2 | 3.720 | 22297.0 |
312 | 2024-04-03 15:44:01 | longbows | 1 | 82945 | 2 | 2.970 | 27927.6 |
311 | 2024-03-31 20:57:45 | longbows | 4 | 161609 | 430 | 35.296 | 4578.7 |
310 | 2024-03-31 13:23:25 | longbows | 4 | 161609 | 430 | 15.143 | 10672.2 |
309 | 2024-03-29 09:00:21 | longbows | 4 | 161609 | 430 | 29.393 | 5498.2 |
308 | 2024-03-29 08:57:44 | longbows | 4 | 161609 | 430 | 21.093 | 7661.7 |
307 | 2024-03-29 08:57:43 | longbows | 2 | 121059 | 6 | 7.796 | 15528.3 |
306 | 2024-03-29 08:57:41 | longbows | 1 | 82945 | 2 | 3.156 | 26281.7 |
305 | 2024-03-14 13:57:01 | longbows | 1 | 82945 | 2 | 1.420 | 58412.0 |
304 | 2024-03-07 20:56:53 | longbows | 2 | 121059 | 6 | 3.903 | 31016.9 |
303 | 2024-03-07 20:56:49 | longbows | 3 | 146162 | 54 | 7.500 | 19488.3 |
302 | 2024-03-07 11:40:49 | longbows | 1 | 82945 | 2 | 3.313 | 25036.2 |
301 | 2024-03-06 23:37:13 | longbows | 4 | 161609 | 430 | 49.610 | 3257.6 |
300 | 2024-03-06 12:34:08 | longbows | 4 | 161609 | 430 | 21.360 | 7566.0 |
299 | 2024-03-06 12:34:08 | longbows | 2 | 121059 | 6 | 7.503 | 16134.7 |
298 | 2024-03-06 12:34:08 | longbows | 1 | 82945 | 2 | 2.343 | 35401.2 |
297 | 2024-03-06 12:11:41 | longbows | 3 | 146162 | 54 | 8.970 | 16294.5 |
296 | 2024-03-05 16:17:28 | longbows | 2 | 121059 | 6 | 4.720 | 25648.1 |
295 | 2024-03-05 11:02:40 | longbows | 3 | 146162 | 54 | 7.440 | 19645.4 |
294 | 2024-03-04 23:22:36 | longbows | 1 | 82945 | 2 | 1.593 | 52068.4 |
293 | 2024-03-04 23:22:21 | longbows | 3 | 146162 | 54 | 7.640 | 19131.2 |
292 | 2024-03-04 22:17:15 | longbows | 3 | 146162 | 54 | 22.923 | 6376.2 |
291 | 2024-03-04 22:17:12 | longbows | 2 | 121059 | 6 | 8.783 | 13783.3 |
290 | 2024-03-02 21:12:04 | longbows | 3 | 146162 | 54 | 16.300 | 8967.0 |
289 | 2024-03-02 21:12:07 | longbows | 2 | 121059 | 6 | 8.763 | 13814.8 |
288 | 2024-03-02 21:12:03 | longbows | 1 | 82945 | 2 | 3.206 | 25871.8 |
287 | 2024-02-28 05:09:32 | longbows | 4 | 161609 | 430 | 37.533 | 4305.8 |
286 | 2024-02-28 04:20:10 | longbows | 4 | 161609 | 430 | 34.096 | 4739.8 |
285 | 2024-02-28 04:20:05 | longbows | 2 | 121059 | 6 | 5.013 | 24149.0 |
284 | 2024-02-28 04:19:57 | longbows | 1 | 82945 | 2 | 2.673 | 31030.7 |
283 | 2024-02-16 05:11:17 | longbows | 1 | 82945 | 2 | 1.406 | 58993.6 |
282 | 2024-02-04 00:42:31 | longbows | 4 | 161609 | 430 | 12.783 | 12642.5 |
281 | 2024-01-31 09:48:00 | longbows | 1 | 82945 | 2 | 1.360 | 60989.0 |
280 | 2024-01-31 06:41:35 | longbows | 3 | 146162 | 54 | 11.250 | 12992.2 |
279 | 2024-01-30 10:10:03 | longbows | 3 | 146162 | 54 | 7.830 | 18666.9 |
278 | 2024-01-30 08:37:05 | longbows | 2 | 121059 | 6 | 3.563 | 33976.7 |
277 | 2024-01-30 08:37:01 | longbows | 3 | 146162 | 54 | 7.233 | 20207.7 |
276 | 2024-01-30 08:36:57 | longbows | 1 | 82945 | 2 | 1.420 | 58412.0 |
275 | 2024-01-25 18:09:12 | longbows | 4 | 161609 | 430 | 25.016 | 6460.2 |
274 | 2024-01-23 17:30:56 | longbows | 4 | 161609 | 430 | 15.393 | 10498.9 |
273 | 2024-01-22 11:47:43 | longbows | 4 | 161609 | 430 | 37.253 | 4338.1 |
272 | 2024-01-22 11:47:50 | longbows | 2 | 121059 | 6 | 8.516 | 14215.5 |
271 | 2024-01-15 16:46:54 | longbows | 4 | 161609 | 430 | 21.673 | 7456.7 |
270 | 2024-01-15 07:40:31 | longbows | 2 | 121059 | 6 | 3.530 | 34294.3 |
269 | 2023-12-17 10:10:10 | longbows | 1 | 82945 | 2 | 1.516 | 54713.1 |
268 | 2023-12-01 13:04:42 | longbows | 1 | 82945 | 2 | 1.250 | 66356.0 |
267 | 2023-11-25 22:15:47 | longbows | 1 | 82945 | 2 | 1.390 | 59672.7 |
266 | 2023-11-12 12:37:16 | longbows | 4 | 161609 | 430 | 16.830 | 9602.4 |
265 | 2023-11-09 17:42:42 | longbows | 4 | 161609 | 430 | 12.813 | 12612.9 |
264 | 2023-11-07 06:44:37 | longbows | 4 | 161609 | 430 | 30.316 | 5330.8 |
263 | 2023-11-07 06:44:15 | longbows | 4 | 161609 | 430 | 14.970 | 10795.5 |
262 | 2023-11-06 17:15:30 | longbows | 1 | 82945 | 2 | 1.423 | 58288.8 |
261 | 2023-11-06 01:49:59 | longbows | 1 | 82945 | 2 | 1.250 | 66356.0 |
260 | 2023-11-04 21:07:06 | longbows | 4 | 161609 | 430 | 12.516 | 12912.2 |
259 | 2023-11-02 22:42:59 | longbows | 4 | 161609 | 430 | 16.423 | 9840.4 |
258 | 2023-10-28 06:56:40 | longbows | 2 | 121059 | 6 | 4.186 | 28920.0 |
257 | 2023-10-23 20:27:32 | longbows | 4 | 161609 | 430 | 22.830 | 7078.8 |
256 | 2023-10-14 14:57:43 | longbows | 1 | 82945 | 2 | 1.360 | 60989.0 |
255 | 2023-09-29 12:42:01 | longbows | 1 | 82945 | 2 | 1.343 | 61761.0 |
254 | 2023-09-17 11:00:25 | longbows | 1 | 82945 | 2 | 1.233 | 67270.9 |
253 | 2023-09-16 09:35:42 | longbows | 1 | 82945 | 2 | 1.250 | 66356.0 |
252 | 2023-08-05 02:01:46 | longbows | 2 | 121059 | 6 | 4.550 | 26606.4 |
251 | 2023-08-02 08:13:16 | longbows | 4 | 161609 | 430 | 10.530 | 15347.5 |
250 | 2023-07-03 23:19:22 | longbows | 1 | 82945 | 2 | 1.216 | 68211.3 |
249 | 2023-04-21 04:32:56 | longbows | 1 | 82945 | 2 | 1.453 | 57085.3 |
248 | 2023-04-16 19:43:46 | longbows | 2 | 121059 | 6 | 3.093 | 39139.7 |
247 | 2023-04-11 19:26:12 | longbows | 4 | 161609 | 430 | 12.003 | 13464.1 |
246 | 2023-04-10 22:53:41 | longbows | 1 | 82945 | 2 | 1.266 | 65517.4 |
245 | 2023-03-27 15:49:41 | longbows | 4 | 161609 | 430 | 12.206 | 13240.1 |
244 | 2023-03-25 08:49:24 | longbows | 4 | 161609 | 430 | 10.906 | 14818.4 |
243 | 2023-03-08 21:15:31 | longbows | 2 | 121059 | 6 | 3.123 | 38763.7 |