History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"alehouse"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
411 | 2024-03-27 07:20:46 | alehouse | 3 | 146162 | 66 | 8.326 | 17554.9 |
410 | 2024-03-27 07:20:41 | alehouse | 2 | 121059 | 8 | 3.953 | 30624.6 |
409 | 2024-03-26 16:57:20 | alehouse | 2 | 121059 | 8 | 3.923 | 30858.8 |
408 | 2024-03-26 16:54:56 | alehouse | 4 | 161609 | 472 | 14.936 | 10820.1 |
407 | 2024-03-26 16:54:52 | alehouse | 3 | 146162 | 66 | 8.753 | 16698.5 |
406 | 2024-03-26 07:25:49 | alehouse | 4 | 161609 | 472 | 12.483 | 12946.3 |
405 | 2024-03-26 07:17:33 | alehouse | 2 | 121059 | 8 | 8.376 | 14453.1 |
404 | 2024-03-26 07:16:57 | alehouse | 3 | 146162 | 66 | 7.873 | 18565.0 |
403 | 2024-03-25 22:50:13 | alehouse | 4 | 161609 | 472 | 34.080 | 4742.0 |
402 | 2024-03-25 17:41:25 | alehouse | 2 | 121059 | 8 | 4.686 | 25834.2 |
401 | 2024-03-25 17:40:53 | alehouse | 3 | 146162 | 66 | 8.546 | 17103.0 |
400 | 2024-03-25 17:39:01 | alehouse | 4 | 161609 | 472 | 12.483 | 12946.3 |
399 | 2024-03-25 14:21:10 | alehouse | 2 | 121059 | 8 | 3.440 | 35191.6 |
398 | 2024-03-25 14:08:13 | alehouse | 3 | 146162 | 66 | 7.360 | 19859.0 |
397 | 2024-03-25 01:41:21 | alehouse | 4 | 161609 | 472 | 12.706 | 12719.1 |
396 | 2024-03-24 16:42:11 | alehouse | 3 | 146162 | 66 | 7.576 | 19292.8 |
395 | 2024-03-24 16:42:03 | alehouse | 4 | 161609 | 472 | 12.360 | 13075.2 |
394 | 2024-03-24 16:42:05 | alehouse | 2 | 121059 | 8 | 3.830 | 31608.1 |
393 | 2024-03-24 16:42:01 | alehouse | 1 | 82945 | 2 | 1.423 | 58288.8 |
392 | 2024-03-02 05:58:04 | alehouse | 1 | 82945 | 2 | 3.610 | 22976.5 |
391 | 2024-02-29 07:32:28 | alehouse | 1 | 82945 | 2 | 1.516 | 54713.1 |
390 | 2024-02-29 07:26:14 | alehouse | 1 | 82945 | 2 | 1.563 | 53067.8 |
389 | 2024-02-07 01:55:28 | alehouse | 1 | 82945 | 2 | 3.156 | 26281.7 |
388 | 2024-02-04 14:47:23 | alehouse | 3 | 146162 | 66 | 7.673 | 19048.9 |
387 | 2024-02-03 04:06:34 | alehouse | 2 | 121059 | 8 | 12.593 | 9613.2 |
386 | 2024-02-01 09:51:56 | alehouse | 2 | 121059 | 8 | 4.563 | 26530.6 |
385 | 2024-02-01 09:51:28 | alehouse | 3 | 146162 | 66 | 6.326 | 23105.0 |
384 | 2024-01-31 23:40:32 | alehouse | 4 | 161609 | 472 | 17.423 | 9275.6 |
383 | 2024-01-31 22:05:28 | alehouse | 4 | 161609 | 472 | 20.843 | 7753.6 |
382 | 2024-01-31 22:05:24 | alehouse | 3 | 146162 | 66 | 8.283 | 17646.0 |
381 | 2024-01-31 22:05:15 | alehouse | 4 | 161609 | 472 | 13.643 | 11845.6 |
380 | 2024-01-31 22:05:27 | alehouse | 1 | 82945 | 2 | 1.560 | 53169.9 |
379 | 2024-01-31 22:05:04 | alehouse | 2 | 121059 | 8 | 3.516 | 34430.9 |
378 | 2024-01-31 22:04:52 | alehouse | 3 | 146162 | 66 | 10.593 | 13798.0 |
377 | 2024-01-31 22:04:47 | alehouse | 2 | 121059 | 8 | 3.670 | 32986.1 |
376 | 2024-01-13 15:08:42 | alehouse | 1 | 82945 | 2 | 1.296 | 64000.8 |
375 | 2024-01-07 19:13:25 | alehouse | 1 | 82945 | 2 | 1.420 | 58412.0 |
374 | 2023-12-26 03:56:13 | alehouse | 4 | 161609 | 472 | 13.343 | 12111.9 |
373 | 2023-12-26 03:56:11 | alehouse | 2 | 121059 | 8 | 3.876 | 31233.0 |
372 | 2023-12-26 03:56:07 | alehouse | 3 | 146162 | 66 | 7.343 | 19904.9 |
371 | 2023-12-24 04:31:06 | alehouse | 1 | 82945 | 2 | 1.513 | 54821.5 |
370 | 2023-12-18 14:05:24 | alehouse | 2 | 121059 | 8 | 3.783 | 32000.8 |
369 | 2023-12-03 18:26:26 | alehouse | 1 | 82945 | 2 | 1.513 | 54821.5 |
368 | 2023-12-02 08:02:38 | alehouse | 1 | 82945 | 2 | 1.483 | 55930.5 |
367 | 2023-11-12 13:21:20 | alehouse | 1 | 82945 | 2 | 1.500 | 55296.7 |
366 | 2023-11-08 19:07:08 | alehouse | 1 | 82945 | 2 | 1.266 | 65517.4 |
365 | 2023-10-14 23:45:00 | alehouse | 1 | 82945 | 2 | 1.296 | 64000.8 |
364 | 2023-09-17 23:21:34 | alehouse | 2 | 121059 | 8 | 3.453 | 35059.1 |
363 | 2023-08-29 19:23:43 | alehouse | 1 | 82945 | 2 | 1.436 | 57761.1 |
362 | 2023-07-31 00:36:26 | alehouse | 1 | 82945 | 2 | 1.250 | 66356.0 |
361 | 2023-06-17 21:23:26 | alehouse | 2 | 121059 | 8 | 3.360 | 36029.5 |
360 | 2023-06-01 23:40:46 | alehouse | 1 | 82945 | 2 | 1.280 | 64800.8 |
359 | 2023-04-11 15:43:10 | alehouse | 1 | 82945 | 2 | 1.236 | 67107.6 |
358 | 2023-03-25 12:42:44 | alehouse | 1 | 82945 | 2 | 1.393 | 59544.1 |
357 | 2023-03-15 21:21:53 | alehouse | 2 | 121059 | 8 | 3.123 | 38763.7 |
356 | 2023-01-09 21:34:09 | alehouse | 1 | 82945 | 2 | 1.250 | 66356.0 |
355 | 2022-12-26 08:24:29 | alehouse | 1 | 82945 | 2 | 1.486 | 55817.6 |
354 | 2022-12-22 16:06:17 | alehouse | 1 | 82945 | 2 | 1.343 | 61761.0 |
353 | 2022-12-19 00:10:58 | alehouse | 2 | 121059 | 8 | 3.106 | 38975.9 |
352 | 2022-10-10 22:04:15 | alehouse | 1 | 82945 | 2 | 1.486 | 55817.6 |
351 | 2022-08-26 04:16:37 | alehouse | 1 | 82945 | 2 | 1.403 | 59119.7 |
350 | 2022-08-11 03:24:55 | alehouse | 2 | 121059 | 8 | 3.563 | 33976.7 |
349 | 2022-06-10 07:54:19 | alehouse | 2 | 121059 | 8 | 3.530 | 34294.3 |
348 | 2022-05-31 01:29:50 | alehouse | 1 | 82945 | 2 | 1.466 | 56579.1 |
347 | 2022-05-10 18:03:00 | alehouse | 2 | 121059 | 8 | 4.096 | 29555.4 |
346 | 2022-04-15 00:22:10 | alehouse | 1 | 82945 | 2 | 1.420 | 58412.0 |
345 | 2022-03-16 08:08:09 | alehouse | 2 | 121059 | 8 | 3.186 | 37997.2 |
344 | 2022-02-12 06:06:05 | alehouse | 1 | 82945 | 2 | 1.296 | 64000.8 |
343 | 2022-02-10 02:18:40 | alehouse | 1 | 82945 | 2 | 1.563 | 53067.8 |
342 | 2021-12-23 23:26:27 | alehouse | 1 | 82945 | 2 | 1.453 | 57085.3 |
341 | 2021-12-16 01:17:12 | alehouse | 2 | 121059 | 8 | 3.173 | 38152.9 |
340 | 2021-11-29 16:57:30 | alehouse | 1 | 82945 | 2 | 1.470 | 56425.2 |
339 | 2021-10-29 14:56:38 | alehouse | 1 | 82945 | 2 | 1.296 | 64000.8 |
338 | 2021-09-10 08:07:36 | alehouse | 1 | 82945 | 2 | 1.266 | 65517.4 |
337 | 2021-08-07 23:09:10 | alehouse | 1 | 82945 | 2 | 1.486 | 55817.6 |
336 | 2021-06-30 15:59:38 | alehouse | 3 | 146162 | 66 | 8.173 | 17883.5 |
335 | 2021-06-09 11:00:57 | alehouse | 1 | 82945 | 2 | 1.266 | 65517.4 |
334 | 2021-04-28 08:58:39 | alehouse | 1 | 82945 | 2 | 1.546 | 53651.4 |
333 | 2021-03-28 05:01:55 | alehouse | 1 | 82945 | 2 | 1.313 | 63172.1 |
332 | 2021-03-18 01:08:15 | alehouse | 3 | 146162 | 66 | 6.326 | 23105.0 |
331 | 2021-03-10 11:09:15 | alehouse | 1 | 82945 | 2 | 1.330 | 62364.7 |
330 | 2021-02-21 11:41:46 | alehouse | 1 | 82945 | 2 | 1.356 | 61168.9 |
329 | 2021-01-19 22:38:05 | alehouse | 3 | 146162 | 66 | 6.703 | 21805.5 |
328 | 2020-12-07 03:04:54 | alehouse | 1 | 82945 | 2 | 1.296 | 64000.8 |
327 | 2020-10-31 23:12:25 | alehouse | 3 | 146162 | 66 | 11.280 | 12957.6 |
326 | 2020-10-31 09:27:58 | alehouse | 1 | 82945 | 2 | 1.283 | 64649.3 |
325 | 2020-10-31 04:06:45 | alehouse | 3 | 146162 | 66 | 6.623 | 22068.9 |
324 | 2020-10-25 08:19:44 | alehouse | 1 | 82945 | 2 | 1.330 | 62364.7 |
323 | 2020-10-20 17:02:57 | alehouse | 1 | 82945 | 2 | 1.436 | 57761.1 |
322 | 2020-10-15 07:04:21 | alehouse | 3 | 146162 | 66 | 6.560 | 22280.8 |
321 | 2020-10-13 22:38:36 | alehouse | 1 | 82945 | 2 | 1.436 | 57761.1 |
320 | 2020-10-08 07:14:11 | alehouse | 1 | 82945 | 2 | 1.250 | 66356.0 |
319 | 2020-09-22 00:08:30 | alehouse | 3 | 146162 | 66 | 6.936 | 21073.0 |
318 | 2020-09-04 06:30:25 | alehouse | 1 | 82945 | 2 | 1.423 | 58288.8 |
317 | 2020-08-31 20:19:50 | alehouse | 1 | 82945 | 2 | 1.470 | 56425.2 |
316 | 2020-06-05 16:23:52 | alehouse | 3 | 146162 | 66 | 6.576 | 22226.6 |
315 | 2020-06-02 17:32:53 | alehouse | 3 | 146162 | 66 | 6.610 | 22112.3 |
314 | 2020-05-30 03:09:21 | alehouse | 1 | 82945 | 2 | 1.263 | 65673.0 |
313 | 2020-05-24 11:38:15 | alehouse | 3 | 146162 | 66 | 6.656 | 21959.4 |
312 | 2020-05-23 12:21:02 | alehouse | 3 | 146162 | 66 | 6.406 | 22816.4 |