History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"whacko"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
437 | 2024-04-06 13:07:30 | whacko | 1 | 48755 | 7 | 0.906 | 53813.5 |
436 | 2024-04-04 23:39:34 | whacko | 2 | 82551 | 26 | 2.513 | 32849.6 |
435 | 2024-04-04 23:39:33 | whacko | 1 | 48755 | 7 | 0.873 | 55847.7 |
434 | 2024-04-04 23:39:21 | whacko | 3 | 112716 | 221 | 7.003 | 16095.4 |
433 | 2024-04-04 11:13:03 | whacko | 3 | 112716 | 221 | 4.423 | 25484.1 |
432 | 2024-03-31 16:38:45 | whacko | 1 | 48755 | 7 | 1.843 | 26454.2 |
431 | 2024-03-30 04:15:38 | whacko | 1 | 48755 | 7 | 2.500 | 19502.0 |
430 | 2024-03-28 02:50:53 | whacko | 1 | 48755 | 7 | 0.876 | 55656.4 |
429 | 2024-03-02 15:39:00 | whacko | 1 | 48755 | 7 | 1.843 | 26454.2 |
428 | 2024-02-29 08:27:38 | whacko | 3 | 112716 | 221 | 10.393 | 10845.4 |
427 | 2024-02-29 03:10:17 | whacko | 2 | 82551 | 26 | 5.156 | 16010.7 |
426 | 2024-02-29 03:10:04 | whacko | 3 | 112716 | 221 | 5.656 | 19928.6 |
425 | 2024-02-28 22:30:03 | whacko | 3 | 112716 | 221 | 4.890 | 23050.3 |
424 | 2024-02-27 22:07:44 | whacko | 2 | 82551 | 26 | 5.500 | 15009.3 |
423 | 2024-02-19 22:00:54 | whacko | 1 | 48755 | 7 | 0.906 | 53813.5 |
422 | 2024-02-04 08:41:01 | whacko | 1 | 48755 | 7 | 1.780 | 27390.4 |
421 | 2024-01-17 02:59:46 | whacko | 2 | 82551 | 26 | 4.813 | 17151.7 |
420 | 2024-01-07 05:20:46 | whacko | 1 | 48755 | 7 | 0.700 | 69650.0 |
419 | 2023-12-08 04:03:04 | whacko | 3 | 112716 | 221 | 5.110 | 22057.9 |
418 | 2023-12-06 11:53:11 | whacko | 1 | 48755 | 7 | 0.846 | 57630.0 |
417 | 2023-11-29 16:16:30 | whacko | 3 | 112716 | 221 | 4.753 | 23714.7 |
416 | 2023-11-20 10:55:07 | whacko | 2 | 82551 | 26 | 2.063 | 40015.0 |
415 | 2023-11-17 11:07:01 | whacko | 1 | 48755 | 7 | 1.483 | 32875.9 |
414 | 2023-11-10 02:42:06 | whacko | 3 | 112716 | 221 | 5.156 | 21861.1 |
413 | 2023-11-10 02:42:07 | whacko | 2 | 82551 | 26 | 2.436 | 33887.9 |
412 | 2023-11-07 08:49:39 | whacko | 1 | 48755 | 7 | 0.716 | 68093.6 |
411 | 2023-11-03 13:24:15 | whacko | 1 | 48755 | 7 | 0.830 | 58741.0 |
410 | 2023-11-01 04:37:55 | whacko | 1 | 48755 | 7 | 0.700 | 69650.0 |
409 | 2023-10-11 15:15:15 | whacko | 1 | 48755 | 7 | 0.733 | 66514.3 |
408 | 2023-10-06 17:51:03 | whacko | 1 | 48755 | 7 | 0.703 | 69352.8 |
407 | 2023-09-26 14:17:26 | whacko | 1 | 48755 | 7 | 0.893 | 54596.9 |
406 | 2023-09-15 07:19:53 | whacko | 3 | 112716 | 221 | 5.876 | 19182.4 |
405 | 2023-09-14 09:12:23 | whacko | 1 | 48755 | 7 | 0.736 | 66243.2 |
404 | 2023-09-11 14:09:17 | whacko | 1 | 48755 | 7 | 0.846 | 57630.0 |
403 | 2023-09-05 08:39:41 | whacko | 3 | 112716 | 221 | 4.376 | 25757.8 |
402 | 2023-08-23 05:49:14 | whacko | 3 | 112716 | 221 | 5.283 | 21335.6 |
401 | 2023-08-21 06:30:23 | whacko | 2 | 82551 | 26 | 2.063 | 40015.0 |
400 | 2023-06-14 08:05:52 | whacko | 3 | 112716 | 221 | 5.110 | 22057.9 |
399 | 2023-05-22 13:29:21 | whacko | 3 | 112716 | 221 | 4.406 | 25582.4 |
398 | 2023-05-04 22:47:13 | whacko | 2 | 82551 | 26 | 1.983 | 41629.3 |
397 | 2023-04-19 20:05:34 | whacko | 1 | 48755 | 7 | 0.733 | 66514.3 |
396 | 2023-03-02 13:36:38 | whacko | 3 | 112716 | 221 | 4.360 | 25852.3 |
395 | 2023-02-09 11:12:10 | whacko | 2 | 82551 | 26 | 2.033 | 40605.5 |
394 | 2022-12-11 14:58:20 | whacko | 3 | 112716 | 221 | 4.360 | 25852.3 |
393 | 2022-12-10 15:07:15 | whacko | 3 | 112716 | 221 | 4.516 | 24959.3 |
392 | 2022-12-06 22:17:05 | whacko | 1 | 48755 | 7 | 0.733 | 66514.3 |
391 | 2022-11-22 06:20:18 | whacko | 2 | 82551 | 26 | 2.296 | 35954.3 |
390 | 2022-11-14 14:53:06 | whacko | 3 | 112716 | 221 | 4.750 | 23729.7 |
389 | 2022-11-02 22:45:32 | whacko | 3 | 112716 | 221 | 5.000 | 22543.2 |
388 | 2022-10-01 14:56:40 | whacko | 3 | 112716 | 221 | 4.610 | 24450.3 |
387 | 2022-09-09 01:47:19 | whacko | 3 | 112716 | 221 | 4.923 | 22895.8 |
386 | 2022-09-01 18:02:46 | whacko | 1 | 48755 | 7 | 0.783 | 62266.9 |
385 | 2022-08-04 17:40:22 | whacko | 1 | 48755 | 7 | 0.733 | 66514.3 |
384 | 2022-06-29 01:17:34 | whacko | 3 | 112716 | 221 | 4.516 | 24959.3 |
383 | 2022-06-28 23:08:19 | whacko | 1 | 48755 | 7 | 0.720 | 67715.3 |
382 | 2022-06-26 19:00:01 | whacko | 3 | 112716 | 221 | 4.406 | 25582.4 |
381 | 2022-06-10 06:22:05 | whacko | 3 | 112716 | 221 | 4.470 | 25216.1 |
380 | 2022-06-02 07:20:10 | whacko | 3 | 112716 | 221 | 4.390 | 25675.6 |
379 | 2022-04-25 20:50:08 | whacko | 2 | 82551 | 26 | 2.673 | 30883.3 |
378 | 2022-03-25 13:19:29 | whacko | 1 | 48755 | 7 | 1.046 | 46610.9 |
377 | 2022-03-23 09:07:40 | whacko | 1 | 48755 | 7 | 1.000 | 48755.0 |
376 | 2022-03-11 20:44:41 | whacko | 2 | 82551 | 26 | 2.173 | 37989.4 |
375 | 2022-03-11 08:31:40 | whacko | 2 | 82551 | 26 | 2.500 | 33020.4 |
374 | 2022-03-10 19:36:47 | whacko | 2 | 82551 | 26 | 2.470 | 33421.5 |
373 | 2022-03-10 12:36:38 | whacko | 2 | 82551 | 26 | 2.063 | 40015.0 |
372 | 2022-03-09 13:34:12 | whacko | 2 | 82551 | 26 | 2.296 | 35954.3 |
371 | 2022-03-08 20:07:51 | whacko | 2 | 82551 | 26 | 2.796 | 29524.7 |
370 | 2022-03-08 06:22:13 | whacko | 2 | 82551 | 26 | 2.123 | 38884.1 |
369 | 2022-03-07 14:54:15 | whacko | 2 | 82551 | 26 | 2.906 | 28407.1 |
368 | 2022-03-07 04:26:55 | whacko | 2 | 82551 | 26 | 2.093 | 39441.5 |
367 | 2022-03-06 09:23:49 | whacko | 2 | 82551 | 26 | 2.686 | 30733.8 |
366 | 2022-03-05 16:51:52 | whacko | 2 | 82551 | 26 | 2.280 | 36206.6 |
365 | 2022-03-04 23:53:14 | whacko | 2 | 82551 | 26 | 2.376 | 34743.7 |
364 | 2022-03-04 08:23:57 | whacko | 2 | 82551 | 26 | 2.873 | 28733.4 |
363 | 2022-03-03 16:30:34 | whacko | 2 | 82551 | 26 | 2.640 | 31269.3 |
362 | 2022-03-03 01:41:08 | whacko | 2 | 82551 | 26 | 2.266 | 36430.3 |
361 | 2022-03-02 14:25:14 | whacko | 2 | 82551 | 26 | 2.483 | 33246.5 |
360 | 2022-03-01 20:10:38 | whacko | 2 | 82551 | 26 | 2.313 | 35690.0 |
359 | 2022-03-01 16:10:00 | whacko | 2 | 82551 | 26 | 2.453 | 33653.1 |
358 | 2022-02-28 14:12:09 | whacko | 2 | 82551 | 26 | 2.643 | 31233.8 |
357 | 2022-02-27 20:42:01 | whacko | 2 | 82551 | 26 | 2.550 | 32372.9 |
356 | 2022-02-27 09:24:34 | whacko | 2 | 82551 | 26 | 2.780 | 29694.6 |
355 | 2022-02-26 15:54:33 | whacko | 2 | 82551 | 26 | 2.123 | 38884.1 |
354 | 2022-02-26 02:05:45 | whacko | 2 | 82551 | 26 | 2.500 | 33020.4 |
353 | 2022-02-25 13:34:59 | whacko | 2 | 82551 | 26 | 4.906 | 16826.5 |
352 | 2022-02-25 04:45:02 | whacko | 2 | 82551 | 26 | 2.466 | 33475.7 |
351 | 2022-02-24 11:07:34 | whacko | 2 | 82551 | 26 | 2.830 | 29170.0 |
350 | 2022-02-23 20:00:51 | whacko | 2 | 82551 | 26 | 2.546 | 32423.8 |
349 | 2022-02-23 00:48:17 | whacko | 2 | 82551 | 26 | 2.140 | 38575.2 |
348 | 2022-02-22 05:33:10 | whacko | 2 | 82551 | 26 | 2.080 | 39688.0 |
347 | 2022-02-21 09:15:36 | whacko | 2 | 82551 | 26 | 2.453 | 33653.1 |
346 | 2022-02-20 20:41:21 | whacko | 2 | 82551 | 26 | 2.470 | 33421.5 |
345 | 2022-02-20 09:34:40 | whacko | 2 | 82551 | 26 | 2.373 | 34787.6 |
344 | 2022-02-19 19:10:55 | whacko | 2 | 82551 | 26 | 4.063 | 20317.7 |
343 | 2022-02-19 06:34:20 | whacko | 2 | 82551 | 26 | 2.186 | 37763.5 |
342 | 2022-02-18 20:22:19 | whacko | 2 | 82551 | 26 | 2.563 | 32208.7 |
341 | 2022-02-18 10:47:57 | whacko | 2 | 82551 | 26 | 2.063 | 40015.0 |
340 | 2022-02-17 18:41:01 | whacko | 2 | 82551 | 26 | 2.656 | 31080.9 |
339 | 2022-02-17 00:51:38 | whacko | 2 | 82551 | 26 | 2.080 | 39688.0 |
338 | 2022-02-16 08:52:29 | whacko | 2 | 82551 | 26 | 2.296 | 35954.3 |