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 |
| 1209 | 2025-11-24 16:11:27 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1208 | 2025-11-24 02:47:22 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1207 | 2025-11-21 15:27:04 | pier | 2 | 29872 | 380 | 0.873 | 34217.6 |
| 1206 | 2025-11-20 23:08:41 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1205 | 2025-11-19 21:18:42 | pier | 1 | 13983 | 17 | 0.846 | 16528.4 |
| 1204 | 2025-11-19 11:56:04 | pier | 1 | 13983 | 17 | 0.656 | 21315.5 |
| 1203 | 2025-11-19 06:03:45 | pier | 1 | 13983 | 17 | 0.530 | 26383.0 |
| 1202 | 2025-11-18 11:01:56 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1201 | 2025-11-18 06:30:34 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1200 | 2025-11-17 06:58:07 | pier | 2 | 29872 | 380 | 0.906 | 32971.3 |
| 1199 | 2025-11-16 23:01:16 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1198 | 2025-11-16 14:15:31 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1197 | 2025-11-14 13:19:48 | pier | 2 | 29872 | 380 | 0.920 | 32469.6 |
| 1196 | 2025-11-14 09:27:52 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1195 | 2025-11-13 16:31:08 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1194 | 2025-11-13 04:44:20 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1193 | 2025-11-12 14:15:47 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1192 | 2025-11-11 21:09:39 | pier | 1 | 13983 | 17 | 0.296 | 47239.9 |
| 1191 | 2025-11-10 20:22:15 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1190 | 2025-11-10 02:42:08 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1189 | 2025-11-05 12:56:23 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1188 | 2025-10-31 01:05:09 | pier | 2 | 29872 | 380 | 0.890 | 33564.0 |
| 1187 | 2025-10-30 09:32:32 | pier | 2 | 29872 | 380 | 0.893 | 33451.3 |
| 1186 | 2025-10-29 13:06:14 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1185 | 2025-10-25 15:49:32 | pier | 1 | 13983 | 17 | 0.253 | 55268.8 |
| 1184 | 2025-10-19 06:58:57 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1183 | 2025-10-19 00:27:46 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1182 | 2025-10-18 12:31:53 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1181 | 2025-10-17 00:07:49 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1180 | 2025-10-15 18:14:30 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1179 | 2025-10-15 10:13:47 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1178 | 2025-10-12 15:32:12 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1177 | 2025-10-11 22:02:34 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1176 | 2025-10-08 23:29:54 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1175 | 2025-09-29 14:51:17 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1174 | 2025-09-28 13:47:27 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1173 | 2025-09-25 09:49:13 | pier | 1 | 13983 | 17 | 0.796 | 17566.6 |
| 1172 | 2025-09-25 09:49:02 | pier | 1 | 13983 | 17 | 0.690 | 20265.2 |
| 1171 | 2025-09-25 09:48:36 | pier | 1 | 13983 | 17 | 1.406 | 9945.2 |
| 1170 | 2025-09-25 09:48:14 | pier | 1 | 13983 | 17 | 2.046 | 6834.3 |
| 1169 | 2025-09-24 15:44:23 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1168 | 2025-09-21 20:48:31 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1167 | 2025-09-18 00:12:22 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1166 | 2025-09-16 12:31:35 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1165 | 2025-09-14 00:15:45 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
| 1164 | 2025-09-13 20:43:08 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1163 | 2025-09-13 19:53:16 | pier | 1 | 13983 | 17 | 0.516 | 27098.8 |
| 1162 | 2025-09-11 17:38:16 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1161 | 2025-09-11 17:38:06 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1160 | 2025-09-11 15:32:34 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
| 1159 | 2025-09-10 22:33:47 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1158 | 2025-09-03 07:05:46 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1157 | 2025-08-28 19:41:18 | pier | 2 | 29872 | 380 | 0.953 | 31345.2 |
| 1156 | 2025-08-28 14:41:35 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1155 | 2025-08-16 12:12:18 | pier | 1 | 13983 | 17 | 0.216 | 64736.1 |
| 1154 | 2025-08-11 14:57:53 | pier | 2 | 29872 | 380 | 1.563 | 19112.0 |
| 1153 | 2025-08-09 20:09:14 | pier | 1 | 13983 | 17 | 2.030 | 6888.2 |
| 1152 | 2025-08-07 03:55:42 | pier | 1 | 13983 | 17 | 0.280 | 49939.3 |
| 1151 | 2025-08-05 23:18:05 | pier | 1 | 13983 | 17 | 1.216 | 11499.2 |
| 1150 | 2025-08-04 16:21:27 | pier | 1 | 13983 | 17 | 0.783 | 17858.2 |
| 1149 | 2025-08-03 06:21:29 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1148 | 2025-07-31 00:00:01 | pier | 1 | 13983 | 17 | 1.420 | 9847.2 |
| 1147 | 2025-07-30 09:44:36 | pier | 1 | 13983 | 17 | 0.500 | 27966.0 |
| 1146 | 2025-07-27 15:17:32 | pier | 1 | 13983 | 17 | 0.580 | 24108.6 |
| 1145 | 2025-07-26 19:49:05 | pier | 2 | 29872 | 380 | 2.890 | 10336.3 |
| 1144 | 2025-07-24 10:09:33 | pier | 2 | 29872 | 380 | 4.343 | 6878.2 |
| 1143 | 2025-07-23 04:57:31 | pier | 2 | 29872 | 380 | 3.966 | 7532.0 |
| 1142 | 2025-07-22 23:18:50 | pier | 1 | 13983 | 17 | 0.686 | 20383.4 |
| 1141 | 2025-07-20 19:25:37 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1140 | 2025-07-15 21:13:44 | pier | 1 | 13983 | 17 | 0.250 | 55932.0 |
| 1139 | 2025-07-15 13:45:03 | pier | 1 | 13983 | 17 | 0.970 | 14415.5 |
| 1138 | 2025-07-13 09:26:26 | pier | 1 | 13983 | 17 | 0.266 | 52567.7 |
| 1137 | 2025-07-12 00:40:23 | pier | 1 | 13983 | 17 | 0.263 | 53167.3 |
| 1136 | 2025-07-11 01:03:45 | pier | 2 | 29872 | 380 | 6.423 | 4650.8 |
| 1135 | 2025-07-09 18:30:18 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1134 | 2025-07-09 06:35:21 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1133 | 2025-07-08 04:33:27 | pier | 1 | 13983 | 17 | 0.983 | 14224.8 |
| 1132 | 2025-07-08 01:53:42 | pier | 1 | 13983 | 17 | 0.690 | 20265.2 |
| 1131 | 2025-07-03 08:52:08 | pier | 2 | 29872 | 380 | 0.783 | 38150.7 |
| 1130 | 2025-07-02 18:35:15 | pier | 1 | 13983 | 17 | 0.580 | 24108.6 |
| 1129 | 2025-07-02 15:55:22 | pier | 1 | 13983 | 17 | 1.826 | 7657.7 |
| 1128 | 2025-07-01 16:22:05 | pier | 2 | 29872 | 380 | 0.970 | 30795.9 |
| 1127 | 2025-07-01 04:20:29 | pier | 1 | 13983 | 17 | 0.220 | 63559.1 |
| 1126 | 2025-06-30 14:16:44 | pier | 1 | 13983 | 17 | 1.173 | 11920.7 |
| 1125 | 2025-06-29 12:59:01 | pier | 2 | 29872 | 380 | 2.046 | 14600.2 |
| 1124 | 2025-06-28 23:15:05 | pier | 1 | 13983 | 17 | 0.233 | 60012.9 |
| 1123 | 2025-06-28 22:59:31 | pier | 1 | 13983 | 17 | 1.530 | 9139.2 |
| 1122 | 2025-06-19 14:31:33 | pier | 2 | 29872 | 380 | 0.766 | 38997.4 |
| 1121 | 2025-06-17 19:14:36 | pier | 1 | 13983 | 17 | 2.126 | 6577.1 |
| 1120 | 2025-06-15 18:50:37 | pier | 2 | 29872 | 380 | 3.140 | 9513.4 |
| 1119 | 2025-06-15 12:46:54 | pier | 1 | 13983 | 17 | 0.236 | 59250.0 |
| 1118 | 2025-06-12 05:41:30 | pier | 1 | 13983 | 17 | 0.670 | 20870.1 |
| 1117 | 2025-06-11 01:02:28 | pier | 1 | 13983 | 17 | 1.156 | 12096.0 |
| 1116 | 2025-06-10 08:26:35 | pier | 2 | 29872 | 380 | 5.843 | 5112.4 |
| 1115 | 2025-06-04 14:26:39 | pier | 1 | 13983 | 17 | 0.970 | 14415.5 |
| 1114 | 2025-06-01 15:00:39 | pier | 2 | 29872 | 380 | 3.640 | 8206.6 |
| 1113 | 2025-06-01 14:57:41 | pier | 1 | 13983 | 17 | 1.326 | 10545.2 |
| 1112 | 2025-06-01 07:29:52 | pier | 2 | 29872 | 380 | 4.470 | 6682.8 |
| 1111 | 2025-05-31 20:19:55 | pier | 1 | 13983 | 17 | 1.626 | 8599.6 |
| 1110 | 2025-05-31 06:41:16 | pier | 1 | 13983 | 17 | 1.610 | 8685.1 |