History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"yearend"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
275 | 2025-08-17 08:14:15 | yearend | 1 | 69583 | 3 | 2.670 | 26061.0 |
274 | 2025-08-05 15:42:14 | yearend | 2 | 107671 | 18 | 8.300 | 12972.4 |
273 | 2025-08-02 14:38:59 | yearend | 2 | 107671 | 18 | 8.813 | 12217.3 |
272 | 2025-08-02 03:52:20 | yearend | 1 | 69583 | 3 | 5.893 | 11807.7 |
271 | 2025-08-01 03:08:26 | yearend | 1 | 69583 | 3 | 8.483 | 8202.6 |
270 | 2025-08-01 02:14:06 | yearend | 1 | 69583 | 3 | 3.360 | 20709.2 |
269 | 2025-07-31 07:13:32 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
268 | 2025-07-31 02:22:39 | yearend | 2 | 107671 | 18 | 3.376 | 31893.1 |
267 | 2025-07-30 22:58:45 | yearend | 1 | 69583 | 3 | 4.720 | 14742.2 |
266 | 2025-07-30 22:19:32 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
265 | 2025-07-30 18:22:04 | yearend | 3 | 134027 | 260 | 17.000 | 7883.9 |
264 | 2025-07-30 15:22:40 | yearend | 3 | 134027 | 260 | 6.860 | 19537.5 |
263 | 2025-07-29 09:54:23 | yearend | 3 | 134027 | 260 | 27.190 | 4929.3 |
262 | 2025-07-29 09:54:18 | yearend | 3 | 134027 | 260 | 25.123 | 5334.8 |
261 | 2025-07-25 11:05:51 | yearend | 3 | 134027 | 260 | 26.253 | 5105.2 |
260 | 2025-07-11 15:11:25 | yearend | 1 | 69583 | 3 | 8.440 | 8244.4 |
259 | 2025-07-04 19:33:50 | yearend | 2 | 107671 | 18 | 5.796 | 18576.8 |
258 | 2025-07-02 02:19:08 | yearend | 1 | 69583 | 3 | 3.563 | 19529.3 |
257 | 2025-06-30 07:22:20 | yearend | 1 | 69583 | 3 | 2.953 | 23563.5 |
256 | 2025-06-09 10:21:49 | yearend | 1 | 69583 | 3 | 1.216 | 57222.9 |
255 | 2025-06-06 14:14:16 | yearend | 2 | 107671 | 18 | 10.516 | 10238.8 |
254 | 2025-06-03 11:08:55 | yearend | 1 | 69583 | 3 | 1.140 | 61037.7 |
253 | 2025-06-02 15:11:39 | yearend | 1 | 69583 | 3 | 6.033 | 11533.7 |
252 | 2025-05-31 23:19:05 | yearend | 2 | 107671 | 18 | 8.186 | 13153.1 |
251 | 2025-05-28 06:49:30 | yearend | 3 | 134027 | 260 | 6.936 | 19323.4 |
250 | 2025-05-23 08:00:22 | yearend | 1 | 69583 | 3 | 5.073 | 13716.3 |
249 | 2025-05-20 08:42:27 | yearend | 1 | 69583 | 3 | 4.063 | 17126.0 |
248 | 2025-05-20 01:58:48 | yearend | 1 | 69583 | 3 | 8.123 | 8566.2 |
247 | 2025-05-13 04:02:50 | yearend | 1 | 69583 | 3 | 4.780 | 14557.1 |
246 | 2025-05-08 14:57:19 | yearend | 2 | 107671 | 18 | 19.923 | 5404.4 |
245 | 2025-05-07 06:22:40 | yearend | 1 | 69583 | 3 | 1.186 | 58670.3 |
244 | 2025-05-03 08:00:42 | yearend | 3 | 134027 | 260 | 20.156 | 6649.5 |
243 | 2025-05-02 15:31:50 | yearend | 3 | 134027 | 260 | 38.796 | 3454.7 |
242 | 2025-05-02 02:46:44 | yearend | 3 | 134027 | 260 | 37.250 | 3598.0 |
241 | 2025-05-02 01:33:49 | yearend | 1 | 69583 | 3 | 5.890 | 11813.8 |
240 | 2025-05-01 05:16:17 | yearend | 3 | 134027 | 260 | 24.530 | 5463.8 |
239 | 2025-04-23 09:21:21 | yearend | 3 | 134027 | 260 | 37.330 | 3590.3 |
238 | 2025-04-22 13:44:07 | yearend | 2 | 107671 | 18 | 3.703 | 29076.7 |
237 | 2025-04-22 04:58:12 | yearend | 3 | 134027 | 260 | 11.766 | 11391.0 |
236 | 2025-04-20 07:45:38 | yearend | 1 | 69583 | 3 | 3.190 | 21812.9 |
235 | 2025-04-20 07:45:21 | yearend | 1 | 69583 | 3 | 5.890 | 11813.8 |
234 | 2025-04-20 01:22:25 | yearend | 1 | 69583 | 3 | 7.280 | 9558.1 |
233 | 2025-03-27 08:31:07 | yearend | 1 | 69583 | 3 | 5.390 | 12909.6 |
232 | 2025-03-20 10:08:48 | yearend | 1 | 69583 | 3 | 7.440 | 9352.6 |
231 | 2025-03-20 08:55:38 | yearend | 1 | 69583 | 3 | 4.313 | 16133.3 |
230 | 2025-03-18 22:55:13 | yearend | 1 | 69583 | 3 | 1.266 | 54962.9 |
229 | 2025-03-13 07:21:07 | yearend | 1 | 69583 | 3 | 5.046 | 13789.7 |
228 | 2025-02-27 18:00:01 | yearend | 1 | 69583 | 3 | 2.733 | 25460.3 |
227 | 2024-12-29 09:26:03 | yearend | 1 | 69583 | 3 | 2.986 | 23303.1 |
226 | 2024-12-22 02:38:43 | yearend | 1 | 69583 | 3 | 5.750 | 12101.4 |
225 | 2024-12-09 14:10:44 | yearend | 1 | 69583 | 3 | 8.233 | 8451.7 |
224 | 2024-12-05 09:08:59 | yearend | 3 | 134027 | 260 | 27.110 | 4943.8 |
223 | 2024-12-04 20:55:04 | yearend | 3 | 134027 | 260 | 36.176 | 3704.9 |
222 | 2024-12-04 20:55:01 | yearend | 2 | 107671 | 18 | 14.266 | 7547.4 |
221 | 2024-12-01 20:04:52 | yearend | 1 | 69583 | 3 | 3.016 | 23071.3 |
220 | 2024-11-25 15:38:50 | yearend | 1 | 69583 | 3 | 5.936 | 11722.2 |
219 | 2024-10-26 09:13:56 | yearend | 1 | 69583 | 3 | 5.470 | 12720.8 |
218 | 2024-10-21 02:22:05 | yearend | 1 | 69583 | 3 | 4.826 | 14418.4 |
217 | 2024-10-08 17:32:46 | yearend | 1 | 69583 | 3 | 5.873 | 11847.9 |
216 | 2024-09-19 00:41:12 | yearend | 1 | 69583 | 3 | 7.890 | 8819.1 |
215 | 2024-09-10 17:58:02 | yearend | 1 | 69583 | 3 | 10.250 | 6788.6 |
214 | 2024-09-02 00:23:00 | yearend | 1 | 69583 | 3 | 4.593 | 15149.8 |
213 | 2024-08-17 00:11:24 | yearend | 1 | 69583 | 3 | 4.843 | 14367.7 |
212 | 2024-08-13 15:16:06 | yearend | 1 | 69583 | 3 | 10.406 | 6686.8 |
211 | 2024-08-03 22:45:29 | yearend | 1 | 69583 | 3 | 3.356 | 20733.9 |
210 | 2024-08-02 11:46:06 | yearend | 1 | 69583 | 3 | 4.143 | 16795.3 |
209 | 2024-08-02 11:43:42 | yearend | 1 | 69583 | 3 | 4.080 | 17054.7 |
208 | 2024-07-30 15:07:44 | yearend | 1 | 69583 | 3 | 2.343 | 29698.3 |
207 | 2024-07-23 14:34:35 | yearend | 1 | 69583 | 3 | 7.720 | 9013.3 |
206 | 2024-07-18 15:27:00 | yearend | 1 | 69583 | 3 | 4.093 | 17000.5 |
205 | 2024-07-15 06:11:37 | yearend | 1 | 69583 | 3 | 2.563 | 27149.0 |
204 | 2024-06-17 05:53:50 | yearend | 1 | 69583 | 3 | 4.140 | 16807.5 |
203 | 2024-06-17 00:27:43 | yearend | 1 | 69583 | 3 | 6.296 | 11051.9 |
202 | 2024-06-16 02:34:04 | yearend | 1 | 69583 | 3 | 4.156 | 16742.8 |
201 | 2024-06-14 17:02:29 | yearend | 1 | 69583 | 3 | 3.890 | 17887.7 |
200 | 2024-06-06 16:20:05 | yearend | 1 | 69583 | 3 | 2.500 | 27833.2 |
199 | 2024-04-30 10:43:20 | yearend | 1 | 69583 | 3 | 1.266 | 54962.9 |
198 | 2024-04-28 09:52:43 | yearend | 1 | 69583 | 3 | 2.673 | 26031.8 |
197 | 2024-03-09 03:29:52 | yearend | 1 | 69583 | 3 | 1.093 | 63662.4 |
196 | 2024-03-06 06:22:25 | yearend | 1 | 69583 | 3 | 3.406 | 20429.5 |
195 | 2024-02-28 05:19:27 | yearend | 1 | 69583 | 3 | 2.250 | 30925.8 |
194 | 2023-12-30 04:09:35 | yearend | 3 | 134027 | 260 | 6.686 | 20045.9 |
193 | 2023-12-19 12:47:46 | yearend | 1 | 69583 | 3 | 1.046 | 66522.9 |
192 | 2023-12-15 03:06:48 | yearend | 1 | 69583 | 3 | 1.046 | 66522.9 |
191 | 2023-12-09 12:14:40 | yearend | 1 | 69583 | 3 | 1.216 | 57222.9 |
190 | 2023-12-03 12:05:58 | yearend | 1 | 69583 | 3 | 1.033 | 67360.1 |
189 | 2023-11-03 10:59:11 | yearend | 1 | 69583 | 3 | 1.080 | 64428.7 |
188 | 2023-10-30 10:41:45 | yearend | 3 | 134027 | 260 | 7.550 | 17751.9 |
187 | 2023-10-20 03:17:22 | yearend | 3 | 134027 | 260 | 6.780 | 19768.0 |
186 | 2023-10-17 02:18:00 | yearend | 1 | 69583 | 3 | 1.156 | 60192.9 |
185 | 2023-10-16 01:23:48 | yearend | 3 | 134027 | 260 | 7.233 | 18529.9 |
184 | 2023-10-08 22:29:02 | yearend | 3 | 134027 | 260 | 15.203 | 8815.8 |
183 | 2023-10-08 22:29:03 | yearend | 2 | 107671 | 18 | 3.546 | 30364.1 |
182 | 2023-10-03 15:08:03 | yearend | 1 | 69583 | 3 | 1.170 | 59472.6 |
181 | 2023-10-02 08:04:16 | yearend | 1 | 69583 | 3 | 1.033 | 67360.1 |
180 | 2023-09-22 07:00:40 | yearend | 1 | 69583 | 3 | 1.266 | 54962.9 |
179 | 2023-07-30 15:36:53 | yearend | 1 | 69583 | 3 | 1.143 | 60877.5 |
178 | 2023-07-23 21:51:21 | yearend | 1 | 69583 | 3 | 1.203 | 57841.2 |
177 | 2023-04-29 17:40:14 | yearend | 1 | 69583 | 3 | 1.030 | 67556.3 |
176 | 2023-04-08 13:37:55 | yearend | 1 | 69583 | 3 | 1.170 | 59472.6 |