History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1093 | 2025-04-18 19:53:36 | pier | 1 | 13983 | 17 | 1.936 | 7222.6 |
1092 | 2025-04-14 12:22:33 | pier | 1 | 13983 | 17 | 2.250 | 6214.7 |
1091 | 2025-04-11 01:35:29 | pier | 1 | 13983 | 17 | 1.046 | 13368.1 |
1090 | 2025-04-08 19:14:23 | pier | 2 | 29872 | 380 | 5.343 | 5590.9 |
1089 | 2025-04-08 09:10:58 | pier | 2 | 29872 | 380 | 4.046 | 7383.1 |
1088 | 2025-04-07 00:44:58 | pier | 1 | 13983 | 17 | 1.080 | 12947.2 |
1087 | 2025-04-06 21:14:59 | pier | 2 | 29872 | 380 | 4.360 | 6851.4 |
1086 | 2025-04-05 15:17:08 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1085 | 2025-03-31 17:47:08 | pier | 1 | 13983 | 17 | 0.423 | 33056.7 |
1084 | 2025-03-30 13:34:50 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1083 | 2025-03-27 22:45:49 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1082 | 2025-03-15 16:57:01 | pier | 2 | 29872 | 380 | 4.156 | 7187.7 |
1081 | 2025-03-15 16:25:27 | pier | 2 | 29872 | 380 | 0.906 | 32971.3 |
1080 | 2025-03-14 21:16:28 | pier | 1 | 13983 | 17 | 1.720 | 8129.7 |
1079 | 2025-03-12 08:41:46 | pier | 1 | 13983 | 17 | 2.530 | 5526.9 |
1078 | 2025-03-11 07:35:56 | pier | 1 | 13983 | 17 | 0.890 | 15711.2 |
1077 | 2025-03-10 09:11:38 | pier | 2 | 29872 | 380 | 1.860 | 16060.2 |
1076 | 2025-03-10 08:23:32 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1075 | 2025-03-07 03:06:24 | pier | 2 | 29872 | 380 | 2.436 | 12262.7 |
1074 | 2025-03-07 02:44:12 | pier | 1 | 13983 | 17 | 1.266 | 11045.0 |
1073 | 2025-02-26 01:02:32 | pier | 1 | 13983 | 17 | 1.030 | 13575.7 |
1072 | 2025-02-25 20:20:46 | pier | 2 | 29872 | 380 | 2.533 | 11793.1 |
1071 | 2025-02-25 09:01:31 | pier | 1 | 13983 | 17 | 1.796 | 7785.6 |
1070 | 2025-02-25 03:10:05 | pier | 2 | 29872 | 380 | 2.643 | 11302.3 |
1069 | 2025-02-25 01:43:47 | pier | 2 | 29872 | 380 | 2.423 | 12328.5 |
1068 | 2025-02-21 05:41:17 | pier | 1 | 13983 | 17 | 0.330 | 42372.7 |
1067 | 2025-02-18 01:44:30 | pier | 1 | 13983 | 17 | 0.580 | 24108.6 |
1066 | 2025-02-06 03:05:12 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
1065 | 2025-02-04 18:26:09 | pier | 1 | 13983 | 17 | 2.453 | 5700.4 |
1064 | 2025-01-26 20:56:14 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1063 | 2025-01-26 07:06:59 | pier | 2 | 29872 | 380 | 7.780 | 3839.6 |
1062 | 2025-01-26 00:34:05 | pier | 1 | 13983 | 17 | 0.203 | 68881.8 |
1061 | 2025-01-25 19:42:53 | pier | 2 | 29872 | 380 | 4.220 | 7078.7 |
1060 | 2025-01-25 17:16:10 | pier | 2 | 29872 | 380 | 2.236 | 13359.6 |
1059 | 2025-01-25 09:09:38 | pier | 1 | 13983 | 17 | 0.843 | 16587.2 |
1058 | 2025-01-06 16:08:28 | pier | 1 | 13983 | 17 | 1.250 | 11186.4 |
1057 | 2025-01-05 11:31:39 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1056 | 2024-12-27 15:03:13 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1055 | 2024-12-27 13:42:14 | pier | 1 | 13983 | 17 | 1.326 | 10545.2 |
1054 | 2024-12-26 23:01:57 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1053 | 2024-12-06 13:27:33 | pier | 2 | 29872 | 380 | 4.216 | 7085.4 |
1052 | 2024-12-06 10:45:33 | pier | 1 | 13983 | 17 | 1.110 | 12597.3 |
1051 | 2024-12-06 06:00:31 | pier | 2 | 29872 | 380 | 4.813 | 6206.5 |
1050 | 2024-12-04 17:47:24 | pier | 2 | 29872 | 380 | 1.846 | 16182.0 |
1049 | 2024-12-04 01:17:35 | pier | 2 | 29872 | 380 | 0.920 | 32469.6 |
1048 | 2024-11-27 08:40:17 | pier | 1 | 13983 | 17 | 1.076 | 12995.4 |
1047 | 2024-11-26 16:44:19 | pier | 1 | 13983 | 17 | 0.673 | 20777.1 |
1046 | 2024-11-26 13:51:48 | pier | 2 | 29872 | 380 | 3.970 | 7524.4 |
1045 | 2024-11-26 05:41:31 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
1044 | 2024-11-25 15:47:53 | pier | 2 | 29872 | 380 | 2.670 | 11188.0 |
1043 | 2024-11-12 11:00:10 | pier | 1 | 13983 | 17 | 0.406 | 34440.9 |
1042 | 2024-11-06 09:14:07 | pier | 2 | 29872 | 380 | 4.046 | 7383.1 |
1041 | 2024-11-06 07:57:00 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1040 | 2024-10-28 09:06:03 | pier | 2 | 29872 | 380 | 4.550 | 6565.3 |
1039 | 2024-10-28 08:50:59 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1038 | 2024-10-27 13:47:27 | pier | 2 | 29872 | 380 | 4.016 | 7438.2 |
1037 | 2024-10-27 13:24:42 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1036 | 2024-10-27 05:59:18 | pier | 1 | 13983 | 17 | 1.563 | 8946.3 |
1035 | 2024-10-22 05:28:59 | pier | 2 | 29872 | 380 | 4.503 | 6633.8 |
1034 | 2024-10-19 22:11:44 | pier | 1 | 13983 | 17 | 1.310 | 10674.0 |
1033 | 2024-10-07 09:14:58 | pier | 1 | 13983 | 17 | 1.233 | 11340.6 |
1032 | 2024-09-28 07:11:40 | pier | 2 | 29872 | 380 | 3.173 | 9414.4 |
1031 | 2024-09-28 05:04:08 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1030 | 2024-09-27 08:50:43 | pier | 2 | 29872 | 380 | 6.330 | 4719.1 |
1029 | 2024-09-27 08:33:39 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1028 | 2024-09-26 08:58:16 | pier | 1 | 13983 | 17 | 0.673 | 20777.1 |
1027 | 2024-09-08 18:28:47 | pier | 1 | 13983 | 17 | 1.953 | 7159.8 |
1026 | 2024-09-07 04:00:23 | pier | 1 | 13983 | 17 | 1.063 | 13154.3 |
1025 | 2024-08-30 04:59:45 | pier | 1 | 13983 | 17 | 2.106 | 6639.6 |
1024 | 2024-08-29 05:29:30 | pier | 2 | 29872 | 380 | 3.343 | 8935.7 |
1023 | 2024-08-29 03:58:57 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
1022 | 2024-08-28 12:40:51 | pier | 2 | 29872 | 380 | 9.640 | 3098.8 |
1021 | 2024-08-28 03:59:09 | pier | 2 | 29872 | 380 | 4.546 | 6571.1 |
1020 | 2024-08-28 03:31:28 | pier | 1 | 13983 | 17 | 1.753 | 7976.6 |
1019 | 2024-08-26 17:12:36 | pier | 1 | 13983 | 17 | 1.766 | 7917.9 |
1018 | 2024-08-21 11:50:14 | pier | 1 | 13983 | 17 | 1.830 | 7641.0 |
1017 | 2024-08-21 11:50:12 | pier | 1 | 13983 | 17 | 1.953 | 7159.8 |
1016 | 2024-08-07 21:18:36 | pier | 1 | 13983 | 17 | 0.733 | 19076.4 |
1015 | 2024-08-02 01:05:31 | pier | 1 | 13983 | 17 | 1.686 | 8293.6 |
1014 | 2024-08-01 02:15:59 | pier | 1 | 13983 | 17 | 0.733 | 19076.4 |
1013 | 2024-07-30 01:34:56 | pier | 1 | 13983 | 17 | 0.906 | 15433.8 |
1012 | 2024-07-29 23:50:16 | pier | 2 | 29872 | 380 | 3.080 | 9698.7 |
1011 | 2024-07-29 22:35:48 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
1010 | 2024-07-29 08:32:30 | pier | 2 | 29872 | 380 | 2.673 | 11175.5 |
1009 | 2024-07-29 08:07:49 | pier | 2 | 29872 | 380 | 4.653 | 6419.9 |
1008 | 2024-07-29 04:25:10 | pier | 2 | 29872 | 380 | 4.920 | 6071.5 |
1007 | 2024-07-29 03:23:43 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
1006 | 2024-07-25 07:32:43 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
1005 | 2024-07-16 22:22:55 | pier | 1 | 13983 | 17 | 1.533 | 9121.3 |
1004 | 2024-07-12 16:06:48 | pier | 1 | 13983 | 17 | 0.953 | 14672.6 |
1003 | 2024-07-07 00:20:18 | pier | 1 | 13983 | 17 | 1.236 | 11313.1 |
1002 | 2024-07-02 22:41:58 | pier | 1 | 13983 | 17 | 1.500 | 9322.0 |
1001 | 2024-06-30 23:17:04 | pier | 2 | 29872 | 380 | 2.953 | 10115.8 |
1000 | 2024-06-30 22:54:33 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
999 | 2024-06-29 21:22:13 | pier | 2 | 29872 | 380 | 1.703 | 17540.8 |
998 | 2024-06-29 20:43:29 | pier | 1 | 13983 | 17 | 0.546 | 25609.9 |
997 | 2024-06-28 19:30:50 | pier | 2 | 29872 | 380 | 3.563 | 8383.9 |
996 | 2024-06-28 16:45:01 | pier | 2 | 29872 | 380 | 0.876 | 34100.5 |
995 | 2024-06-28 15:09:54 | pier | 2 | 29872 | 380 | 1.236 | 24168.3 |
994 | 2024-06-28 15:01:11 | pier | 1 | 13983 | 17 | 0.313 | 44674.1 |