History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"barnier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
463 | 2024-05-02 23:00:36 | barnier | 3 | 134027 | 799 | 8.986 | 14915.1 |
462 | 2024-05-02 20:51:57 | barnier | 1 | 69583 | 4 | 1.330 | 52318.0 |
461 | 2024-04-23 14:16:32 | barnier | 1 | 69583 | 4 | 4.923 | 14134.3 |
460 | 2024-04-20 22:08:00 | barnier | 3 | 134027 | 799 | 18.423 | 7275.0 |
459 | 2024-04-20 15:22:42 | barnier | 3 | 134027 | 799 | 8.530 | 15712.4 |
458 | 2024-04-17 13:43:43 | barnier | 2 | 107671 | 92 | 8.313 | 12952.1 |
457 | 2024-04-17 13:35:28 | barnier | 3 | 134027 | 799 | 7.953 | 16852.4 |
456 | 2024-04-15 19:40:31 | barnier | 3 | 134027 | 799 | 24.503 | 5469.8 |
455 | 2024-04-14 12:45:13 | barnier | 3 | 134027 | 799 | 18.626 | 7195.7 |
454 | 2024-04-13 01:13:45 | barnier | 2 | 107671 | 92 | 3.780 | 28484.4 |
453 | 2024-04-13 01:13:33 | barnier | 3 | 134027 | 799 | 7.733 | 17331.8 |
452 | 2024-04-13 01:11:21 | barnier | 1 | 69583 | 4 | 2.626 | 26497.7 |
451 | 2024-04-13 01:11:04 | barnier | 2 | 107671 | 92 | 3.716 | 28975.0 |
450 | 2024-04-12 23:00:45 | barnier | 2 | 107671 | 92 | 4.906 | 21946.8 |
449 | 2024-03-30 02:03:44 | barnier | 1 | 69583 | 4 | 1.970 | 35321.3 |
448 | 2024-03-15 20:28:16 | barnier | 2 | 107671 | 92 | 3.560 | 30244.7 |
447 | 2024-03-15 20:21:45 | barnier | 3 | 134027 | 799 | 7.283 | 18402.7 |
446 | 2024-03-14 15:39:54 | barnier | 3 | 134027 | 799 | 14.016 | 9562.4 |
445 | 2024-03-13 03:29:35 | barnier | 2 | 107671 | 92 | 4.173 | 25801.8 |
444 | 2024-03-13 03:28:53 | barnier | 3 | 134027 | 799 | 8.516 | 15738.3 |
443 | 2024-03-12 19:30:36 | barnier | 3 | 134027 | 799 | 9.733 | 13770.4 |
442 | 2024-03-12 06:53:43 | barnier | 3 | 134027 | 799 | 11.656 | 11498.5 |
441 | 2024-03-12 06:53:44 | barnier | 2 | 107671 | 92 | 3.563 | 30219.2 |
440 | 2024-03-12 06:53:33 | barnier | 3 | 134027 | 799 | 8.280 | 16186.8 |
439 | 2024-03-12 06:53:35 | barnier | 1 | 69583 | 4 | 2.450 | 28401.2 |
438 | 2024-03-12 06:53:21 | barnier | 2 | 107671 | 92 | 6.830 | 15764.4 |
437 | 2024-03-09 18:47:26 | barnier | 2 | 107671 | 92 | 10.673 | 10088.2 |
436 | 2024-02-23 11:06:30 | barnier | 1 | 69583 | 4 | 1.126 | 61796.6 |
435 | 2024-02-21 06:06:11 | barnier | 1 | 69583 | 4 | 4.046 | 17198.0 |
434 | 2024-02-10 05:46:24 | barnier | 2 | 107671 | 92 | 4.140 | 26007.5 |
433 | 2024-01-30 14:25:43 | barnier | 2 | 107671 | 92 | 3.423 | 31455.2 |
432 | 2024-01-21 11:03:19 | barnier | 1 | 69583 | 4 | 1.093 | 63662.4 |
431 | 2024-01-18 21:38:56 | barnier | 3 | 134027 | 799 | 7.310 | 18334.7 |
430 | 2024-01-09 13:32:59 | barnier | 3 | 134027 | 799 | 6.283 | 21331.7 |
429 | 2024-01-09 13:33:02 | barnier | 2 | 107671 | 92 | 3.390 | 31761.4 |
428 | 2023-12-12 21:38:10 | barnier | 2 | 107671 | 92 | 3.326 | 32372.5 |
427 | 2023-12-11 17:00:00 | barnier | 1 | 69583 | 4 | 1.186 | 58670.3 |
426 | 2023-12-05 18:39:11 | barnier | 1 | 69583 | 4 | 1.080 | 64428.7 |
425 | 2023-11-17 03:56:40 | barnier | 1 | 69583 | 4 | 1.233 | 56433.9 |
424 | 2023-11-15 11:16:07 | barnier | 1 | 69583 | 4 | 1.156 | 60192.9 |
423 | 2023-11-11 00:53:49 | barnier | 1 | 69583 | 4 | 1.076 | 64668.2 |
422 | 2023-10-27 16:15:21 | barnier | 3 | 134027 | 799 | 10.736 | 12483.9 |
421 | 2023-10-26 21:18:59 | barnier | 3 | 134027 | 799 | 14.783 | 9066.3 |
420 | 2023-10-25 16:07:17 | barnier | 3 | 134027 | 799 | 14.016 | 9562.4 |
419 | 2023-10-24 07:40:58 | barnier | 1 | 69583 | 4 | 1.283 | 54234.6 |
418 | 2023-10-22 23:15:54 | barnier | 2 | 107671 | 92 | 3.703 | 29076.7 |
417 | 2023-10-14 03:05:32 | barnier | 2 | 107671 | 92 | 2.906 | 37051.3 |
416 | 2023-10-12 02:36:06 | barnier | 3 | 134027 | 799 | 6.283 | 21331.7 |
415 | 2023-10-10 11:44:45 | barnier | 1 | 69583 | 4 | 1.266 | 54962.9 |
414 | 2023-10-08 09:24:02 | barnier | 1 | 69583 | 4 | 1.203 | 57841.2 |
413 | 2023-10-07 00:41:01 | barnier | 1 | 69583 | 4 | 1.126 | 61796.6 |
412 | 2023-10-03 18:26:25 | barnier | 1 | 69583 | 4 | 1.250 | 55666.4 |
411 | 2023-09-27 20:18:31 | barnier | 1 | 69583 | 4 | 1.326 | 52475.9 |
410 | 2023-09-19 18:51:26 | barnier | 1 | 69583 | 4 | 1.373 | 50679.5 |
409 | 2023-09-16 05:42:53 | barnier | 1 | 69583 | 4 | 1.313 | 52995.4 |
408 | 2023-09-12 23:34:58 | barnier | 2 | 107671 | 92 | 2.936 | 36672.7 |
407 | 2023-08-04 13:28:41 | barnier | 3 | 134027 | 799 | 5.940 | 22563.5 |
406 | 2023-07-23 14:08:13 | barnier | 3 | 134027 | 799 | 5.966 | 22465.1 |
405 | 2023-07-18 23:52:35 | barnier | 1 | 69583 | 4 | 1.233 | 56433.9 |
404 | 2023-07-08 23:43:34 | barnier | 1 | 69583 | 4 | 1.186 | 58670.3 |
403 | 2023-06-23 08:22:31 | barnier | 1 | 69583 | 4 | 1.250 | 55666.4 |
402 | 2023-06-09 09:41:44 | barnier | 2 | 107671 | 92 | 3.203 | 33615.7 |
401 | 2023-04-12 18:09:31 | barnier | 1 | 69583 | 4 | 1.110 | 62687.4 |
400 | 2023-04-11 19:43:15 | barnier | 3 | 134027 | 799 | 5.826 | 23005.0 |
399 | 2023-03-17 18:04:22 | barnier | 1 | 69583 | 4 | 1.080 | 64428.7 |
398 | 2023-03-14 16:11:48 | barnier | 2 | 107671 | 92 | 3.640 | 29579.9 |
397 | 2023-03-14 15:54:23 | barnier | 2 | 107671 | 92 | 3.670 | 29338.1 |
396 | 2023-02-04 07:22:47 | barnier | 3 | 134027 | 799 | 7.030 | 19065.0 |
395 | 2023-02-02 02:25:12 | barnier | 1 | 69583 | 4 | 1.170 | 59472.6 |
394 | 2023-01-14 20:26:29 | barnier | 3 | 134027 | 799 | 9.113 | 14707.2 |
393 | 2022-12-21 18:38:02 | barnier | 2 | 107671 | 92 | 3.000 | 35890.3 |
392 | 2022-12-19 05:32:50 | barnier | 3 | 134027 | 799 | 14.436 | 9284.2 |
391 | 2022-12-18 10:01:31 | barnier | 2 | 107671 | 92 | 2.846 | 37832.4 |
390 | 2022-12-09 12:08:31 | barnier | 1 | 69583 | 4 | 1.186 | 58670.3 |
389 | 2022-11-30 10:45:09 | barnier | 1 | 69583 | 4 | 1.063 | 65459.1 |
388 | 2022-11-23 01:14:36 | barnier | 3 | 134027 | 799 | 5.813 | 23056.4 |
387 | 2022-11-17 16:44:01 | barnier | 2 | 107671 | 92 | 3.453 | 31181.9 |
386 | 2022-11-12 07:10:13 | barnier | 3 | 134027 | 799 | 5.936 | 22578.7 |
385 | 2022-11-07 20:39:15 | barnier | 3 | 134027 | 799 | 5.876 | 22809.2 |
384 | 2022-11-06 06:10:23 | barnier | 3 | 134027 | 799 | 5.983 | 22401.3 |
383 | 2022-11-04 19:58:44 | barnier | 2 | 107671 | 92 | 3.373 | 31921.4 |
382 | 2022-11-01 22:55:01 | barnier | 3 | 134027 | 799 | 6.783 | 19759.3 |
381 | 2022-10-29 01:43:53 | barnier | 2 | 107671 | 92 | 2.826 | 38100.1 |
380 | 2022-10-28 22:42:04 | barnier | 2 | 107671 | 92 | 3.250 | 33129.5 |
379 | 2022-10-22 20:02:46 | barnier | 3 | 134027 | 799 | 5.826 | 23005.0 |
378 | 2022-10-14 22:04:22 | barnier | 3 | 134027 | 799 | 6.953 | 19276.1 |
377 | 2022-10-03 05:01:20 | barnier | 2 | 107671 | 92 | 2.860 | 37647.2 |
376 | 2022-09-27 20:42:19 | barnier | 3 | 134027 | 799 | 6.813 | 19672.2 |
375 | 2022-09-15 00:59:05 | barnier | 1 | 69583 | 4 | 1.110 | 62687.4 |
374 | 2022-08-29 13:46:40 | barnier | 1 | 69583 | 4 | 1.233 | 56433.9 |
373 | 2022-08-11 15:25:21 | barnier | 2 | 107671 | 92 | 3.076 | 35003.6 |
372 | 2022-07-26 17:57:46 | barnier | 1 | 69583 | 4 | 1.096 | 63488.1 |
371 | 2022-07-02 02:46:27 | barnier | 3 | 134027 | 799 | 5.873 | 22820.9 |
370 | 2022-05-16 20:49:49 | barnier | 3 | 134027 | 799 | 6.936 | 19323.4 |
369 | 2022-05-16 19:50:20 | barnier | 3 | 134027 | 799 | 7.486 | 17903.7 |
368 | 2022-05-13 10:24:30 | barnier | 1 | 69583 | 4 | 1.516 | 45899.1 |
367 | 2022-03-21 12:26:38 | barnier | 1 | 69583 | 4 | 1.530 | 45479.1 |
366 | 2022-02-08 18:24:11 | barnier | 1 | 69583 | 4 | 1.143 | 60877.5 |
365 | 2022-01-11 23:37:02 | barnier | 3 | 134027 | 799 | 6.780 | 19768.0 |
364 | 2022-01-04 23:59:30 | barnier | 1 | 69583 | 4 | 1.280 | 54361.7 |