History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"coalpit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
248 | 2024-04-27 16:53:42 | coalpit | 1 | 69583 | 2 | 1.500 | 46388.7 |
247 | 2024-04-27 11:46:14 | coalpit | 3 | 134027 | 111 | 26.373 | 5082.0 |
246 | 2024-04-25 21:01:04 | coalpit | 2 | 107671 | 7 | 6.186 | 17405.6 |
245 | 2024-04-25 21:00:24 | coalpit | 3 | 134027 | 111 | 9.016 | 14865.5 |
244 | 2024-04-24 19:22:24 | coalpit | 3 | 134027 | 111 | 20.736 | 6463.5 |
243 | 2024-04-24 10:48:58 | coalpit | 3 | 134027 | 111 | 13.393 | 10007.2 |
242 | 2024-04-23 07:24:36 | coalpit | 3 | 134027 | 111 | 14.046 | 9542.0 |
241 | 2024-04-07 00:53:00 | coalpit | 1 | 69583 | 2 | 2.186 | 31831.2 |
240 | 2024-03-31 00:48:55 | coalpit | 1 | 69583 | 2 | 1.406 | 49490.0 |
239 | 2024-02-01 10:17:05 | coalpit | 1 | 69583 | 2 | 1.186 | 58670.3 |
238 | 2024-01-18 09:10:09 | coalpit | 2 | 107671 | 7 | 3.280 | 32826.5 |
237 | 2023-12-19 10:00:18 | coalpit | 3 | 134027 | 111 | 6.156 | 21771.8 |
236 | 2023-11-27 03:24:47 | coalpit | 1 | 69583 | 2 | 1.170 | 59472.6 |
235 | 2023-11-25 04:08:00 | coalpit | 1 | 69583 | 2 | 1.080 | 64428.7 |
234 | 2023-11-04 12:36:13 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
233 | 2023-10-29 19:05:00 | coalpit | 2 | 107671 | 7 | 2.906 | 37051.3 |
232 | 2023-10-25 17:19:11 | coalpit | 1 | 69583 | 2 | 1.106 | 62914.1 |
231 | 2023-10-14 23:19:17 | coalpit | 1 | 69583 | 2 | 1.106 | 62914.1 |
230 | 2023-09-25 05:15:47 | coalpit | 3 | 134027 | 111 | 8.766 | 15289.4 |
229 | 2023-09-23 01:08:19 | coalpit | 1 | 69583 | 2 | 1.263 | 55093.4 |
228 | 2023-09-18 03:57:37 | coalpit | 3 | 134027 | 111 | 5.983 | 22401.3 |
227 | 2023-09-15 14:15:54 | coalpit | 1 | 69583 | 2 | 1.216 | 57222.9 |
226 | 2023-08-10 12:23:45 | coalpit | 1 | 69583 | 2 | 1.173 | 59320.5 |
225 | 2023-08-07 13:48:17 | coalpit | 2 | 107671 | 7 | 2.923 | 36835.8 |
224 | 2023-07-05 05:46:14 | coalpit | 1 | 69583 | 2 | 1.170 | 59472.6 |
223 | 2023-06-13 10:59:55 | coalpit | 3 | 134027 | 111 | 12.093 | 11083.0 |
222 | 2023-05-10 23:11:13 | coalpit | 1 | 69583 | 2 | 1.266 | 54962.9 |
221 | 2023-04-16 21:15:53 | coalpit | 2 | 107671 | 7 | 2.860 | 37647.2 |
220 | 2023-03-21 18:00:13 | coalpit | 1 | 69583 | 2 | 1.076 | 64668.2 |
219 | 2023-03-13 23:00:42 | coalpit | 3 | 134027 | 111 | 6.763 | 19817.7 |
218 | 2023-02-27 18:20:12 | coalpit | 1 | 69583 | 2 | 1.190 | 58473.1 |
217 | 2023-01-23 11:21:47 | coalpit | 2 | 107671 | 7 | 2.856 | 37699.9 |
216 | 2022-12-24 05:44:56 | coalpit | 1 | 69583 | 2 | 1.063 | 65459.1 |
215 | 2022-12-17 22:30:26 | coalpit | 3 | 134027 | 111 | 6.610 | 20276.4 |
214 | 2022-11-30 08:38:34 | coalpit | 1 | 69583 | 2 | 1.076 | 64668.2 |
213 | 2022-11-27 01:46:44 | coalpit | 1 | 69583 | 2 | 1.063 | 65459.1 |
212 | 2022-11-03 23:45:38 | coalpit | 2 | 107671 | 7 | 2.906 | 37051.3 |
211 | 2022-09-13 12:28:46 | coalpit | 3 | 134027 | 111 | 5.983 | 22401.3 |
210 | 2022-08-09 09:24:53 | coalpit | 3 | 134027 | 111 | 5.876 | 22809.2 |
209 | 2022-08-07 01:54:41 | coalpit | 3 | 134027 | 111 | 5.910 | 22678.0 |
208 | 2022-07-30 23:16:20 | coalpit | 1 | 69583 | 2 | 1.096 | 63488.1 |
207 | 2022-06-05 21:35:50 | coalpit | 2 | 107671 | 7 | 3.263 | 32997.5 |
206 | 2022-05-11 10:21:47 | coalpit | 1 | 69583 | 2 | 1.123 | 61961.7 |
205 | 2022-04-05 10:10:32 | coalpit | 1 | 69583 | 2 | 1.266 | 54962.9 |
204 | 2022-04-01 23:03:15 | coalpit | 1 | 69583 | 2 | 1.076 | 64668.2 |
203 | 2022-03-08 06:44:41 | coalpit | 3 | 134027 | 111 | 6.970 | 19229.1 |
202 | 2022-01-28 05:38:08 | coalpit | 1 | 69583 | 2 | 1.216 | 57222.9 |
201 | 2022-01-26 01:40:17 | coalpit | 1 | 69583 | 2 | 1.216 | 57222.9 |
200 | 2021-12-21 13:38:48 | coalpit | 1 | 69583 | 2 | 1.140 | 61037.7 |
199 | 2021-12-08 02:29:29 | coalpit | 1 | 69583 | 2 | 1.200 | 57985.8 |
198 | 2021-10-29 09:23:27 | coalpit | 1 | 69583 | 2 | 1.283 | 54234.6 |
197 | 2021-09-17 13:57:25 | coalpit | 1 | 69583 | 2 | 1.110 | 62687.4 |
196 | 2021-08-12 12:21:26 | coalpit | 1 | 69583 | 2 | 1.110 | 62687.4 |
195 | 2021-07-12 07:14:37 | coalpit | 1 | 69583 | 2 | 1.093 | 63662.4 |
194 | 2021-06-14 04:42:58 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
193 | 2021-04-30 09:32:11 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
192 | 2021-03-11 08:55:45 | coalpit | 1 | 69583 | 2 | 1.093 | 63662.4 |
191 | 2021-02-28 14:54:59 | coalpit | 1 | 69583 | 2 | 1.110 | 62687.4 |
190 | 2021-02-07 14:35:36 | coalpit | 1 | 69583 | 2 | 1.200 | 57985.8 |
189 | 2021-02-01 21:45:51 | coalpit | 1 | 69583 | 2 | 1.140 | 61037.7 |
188 | 2021-01-13 11:06:23 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
187 | 2021-01-05 12:31:53 | coalpit | 1 | 69583 | 2 | 1.156 | 60192.9 |
186 | 2020-12-08 07:29:21 | coalpit | 1 | 69583 | 2 | 1.140 | 61037.7 |
185 | 2020-12-08 04:06:34 | coalpit | 1 | 69583 | 2 | 1.186 | 58670.3 |
184 | 2020-11-12 16:28:15 | coalpit | 1 | 69583 | 2 | 1.203 | 57841.2 |
183 | 2020-10-29 23:46:44 | coalpit | 1 | 69583 | 2 | 1.233 | 56433.9 |
182 | 2020-09-05 03:57:15 | coalpit | 1 | 69583 | 2 | 1.096 | 63488.1 |
181 | 2020-07-21 20:22:49 | coalpit | 1 | 69583 | 2 | 1.266 | 54962.9 |
180 | 2020-07-18 11:29:58 | coalpit | 1 | 69583 | 2 | 1.236 | 56296.9 |
179 | 2020-06-18 01:04:58 | coalpit | 1 | 69583 | 2 | 1.203 | 57841.2 |
178 | 2020-05-30 23:00:54 | coalpit | 1 | 69583 | 2 | 1.110 | 62687.4 |
177 | 2020-05-27 20:10:17 | coalpit | 1 | 69583 | 2 | 1.093 | 63662.4 |
176 | 2020-03-25 05:46:58 | coalpit | 1 | 69583 | 2 | 1.123 | 61961.7 |
175 | 2020-03-24 21:28:33 | coalpit | 1 | 69583 | 2 | 2.750 | 25302.9 |
174 | 2020-03-21 20:04:48 | coalpit | 1 | 69583 | 2 | 1.126 | 61796.6 |
173 | 2020-03-15 23:32:34 | coalpit | 1 | 69583 | 2 | 1.216 | 57222.9 |
172 | 2020-02-24 20:42:52 | coalpit | 1 | 69583 | 2 | 1.220 | 57035.2 |
171 | 2020-02-22 19:00:55 | coalpit | 1 | 69583 | 2 | 2.610 | 26660.2 |
170 | 2020-02-21 15:51:21 | coalpit | 1 | 69583 | 2 | 2.593 | 26834.9 |
169 | 2020-02-18 16:18:11 | coalpit | 1 | 69583 | 2 | 1.313 | 52995.4 |
168 | 2020-02-15 13:10:44 | coalpit | 1 | 69583 | 2 | 2.830 | 24587.6 |
167 | 2020-02-15 06:31:22 | coalpit | 1 | 69583 | 2 | 4.186 | 16622.8 |
166 | 2020-02-07 08:40:48 | coalpit | 1 | 69583 | 2 | 2.360 | 29484.3 |
165 | 2020-01-31 07:32:10 | coalpit | 1 | 69583 | 2 | 1.406 | 49490.0 |
164 | 2020-01-25 19:00:30 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
163 | 2020-01-22 18:05:41 | coalpit | 1 | 69583 | 2 | 1.516 | 45899.1 |
162 | 2020-01-21 11:47:24 | coalpit | 1 | 69583 | 2 | 2.750 | 25302.9 |
161 | 2020-01-20 08:08:55 | coalpit | 1 | 69583 | 2 | 2.546 | 27330.3 |
160 | 2020-01-20 06:16:23 | coalpit | 1 | 69583 | 2 | 1.343 | 51811.6 |
159 | 2020-01-16 04:20:01 | coalpit | 1 | 69583 | 2 | 2.266 | 30707.4 |
158 | 2020-01-08 15:00:06 | coalpit | 1 | 69583 | 2 | 1.640 | 42428.7 |
157 | 2019-12-29 03:57:40 | coalpit | 1 | 69583 | 2 | 1.296 | 53690.6 |
156 | 2019-12-28 09:27:27 | coalpit | 1 | 69583 | 2 | 1.376 | 50569.0 |
155 | 2019-12-28 05:11:17 | coalpit | 1 | 69583 | 2 | 1.156 | 60192.9 |
154 | 2019-12-05 23:21:52 | coalpit | 1 | 69583 | 2 | 1.346 | 51696.1 |
153 | 2019-11-19 08:08:43 | coalpit | 1 | 69583 | 2 | 1.076 | 64668.2 |
152 | 2019-10-22 18:23:33 | coalpit | 1 | 69583 | 2 | 1.250 | 55666.4 |
151 | 2019-09-24 20:14:23 | coalpit | 1 | 69583 | 2 | 1.033 | 67360.1 |
150 | 2019-09-15 06:41:31 | coalpit | 1 | 69583 | 2 | 1.166 | 59676.7 |
149 | 2019-09-07 16:02:10 | coalpit | 1 | 69583 | 2 | 1.083 | 64250.2 |