History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"expenses"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
284 | 2024-04-30 03:32:55 | expenses | 3 | 146162 | 117 | 24.753 | 5904.8 |
283 | 2024-04-30 03:32:53 | expenses | 2 | 121059 | 15 | 13.923 | 8694.9 |
282 | 2024-04-30 00:26:09 | expenses | 1 | 82945 | 4 | 1.266 | 65517.4 |
281 | 2024-04-26 19:41:26 | expenses | 1 | 82945 | 4 | 2.530 | 32784.6 |
280 | 2024-04-12 23:01:47 | expenses | 1 | 82945 | 4 | 2.936 | 28251.0 |
279 | 2024-04-08 14:41:00 | expenses | 3 | 146162 | 117 | 8.046 | 18165.8 |
278 | 2024-04-06 10:35:38 | expenses | 3 | 146162 | 117 | 27.250 | 5363.7 |
277 | 2024-04-06 10:33:16 | expenses | 1 | 82945 | 4 | 5.170 | 16043.5 |
276 | 2024-04-05 19:31:47 | expenses | 3 | 146162 | 117 | 14.096 | 10369.0 |
275 | 2024-04-05 19:01:08 | expenses | 1 | 82945 | 4 | 5.326 | 15573.6 |
274 | 2024-04-04 11:22:32 | expenses | 1 | 82945 | 4 | 1.266 | 65517.4 |
273 | 2024-04-04 01:47:06 | expenses | 2 | 121059 | 15 | 4.156 | 29128.7 |
272 | 2024-04-04 01:41:03 | expenses | 3 | 146162 | 117 | 16.376 | 8925.4 |
271 | 2024-04-03 21:39:48 | expenses | 1 | 82945 | 4 | 5.733 | 14468.0 |
270 | 2024-04-03 21:39:22 | expenses | 3 | 146162 | 117 | 10.796 | 13538.5 |
269 | 2024-04-03 21:39:24 | expenses | 2 | 121059 | 15 | 8.686 | 13937.3 |
268 | 2024-04-01 02:44:07 | expenses | 1 | 82945 | 4 | 1.470 | 56425.2 |
267 | 2024-03-31 00:16:05 | expenses | 2 | 121059 | 15 | 4.953 | 24441.6 |
266 | 2024-03-31 00:15:42 | expenses | 3 | 146162 | 117 | 20.580 | 7102.1 |
265 | 2024-03-31 00:01:12 | expenses | 1 | 82945 | 4 | 1.483 | 55930.5 |
264 | 2024-03-30 05:34:23 | expenses | 2 | 121059 | 15 | 3.516 | 34430.9 |
263 | 2024-03-07 06:17:56 | expenses | 2 | 121059 | 15 | 4.500 | 26902.0 |
262 | 2024-03-07 03:06:38 | expenses | 3 | 146162 | 117 | 9.483 | 15413.1 |
261 | 2024-03-06 15:44:08 | expenses | 2 | 121059 | 15 | 7.470 | 16206.0 |
260 | 2024-03-06 15:04:02 | expenses | 3 | 146162 | 117 | 8.126 | 17987.0 |
259 | 2024-03-06 08:41:15 | expenses | 1 | 82945 | 4 | 5.080 | 16327.8 |
258 | 2024-03-04 14:17:28 | expenses | 3 | 146162 | 117 | 12.656 | 11548.8 |
257 | 2024-03-04 14:17:27 | expenses | 2 | 121059 | 15 | 4.203 | 28803.0 |
256 | 2024-03-04 12:13:08 | expenses | 3 | 146162 | 117 | 18.203 | 8029.6 |
255 | 2024-03-04 12:13:18 | expenses | 1 | 82945 | 4 | 2.953 | 28088.4 |
254 | 2024-03-04 12:13:07 | expenses | 2 | 121059 | 15 | 7.813 | 15494.6 |
253 | 2024-02-29 17:57:36 | expenses | 1 | 82945 | 4 | 1.436 | 57761.1 |
252 | 2024-02-28 16:48:37 | expenses | 1 | 82945 | 4 | 1.436 | 57761.1 |
251 | 2024-02-25 19:43:35 | expenses | 3 | 146162 | 117 | 14.483 | 10092.0 |
250 | 2024-02-03 01:24:02 | expenses | 2 | 121059 | 15 | 5.343 | 22657.5 |
249 | 2024-02-03 01:23:50 | expenses | 3 | 146162 | 117 | 6.483 | 22545.4 |
248 | 2024-02-02 21:48:13 | expenses | 2 | 121059 | 15 | 3.813 | 31749.0 |
247 | 2024-02-02 21:46:57 | expenses | 3 | 146162 | 117 | 7.986 | 18302.3 |
246 | 2024-02-02 05:09:40 | expenses | 2 | 121059 | 15 | 3.390 | 35710.6 |
245 | 2024-02-02 05:09:36 | expenses | 3 | 146162 | 117 | 6.450 | 22660.8 |
244 | 2024-01-30 06:55:18 | expenses | 1 | 82945 | 4 | 1.390 | 59672.7 |
243 | 2024-01-07 05:02:07 | expenses | 1 | 82945 | 4 | 1.423 | 58288.8 |
242 | 2023-12-26 05:31:47 | expenses | 1 | 82945 | 4 | 1.280 | 64800.8 |
241 | 2023-12-24 04:50:34 | expenses | 1 | 82945 | 4 | 1.453 | 57085.3 |
240 | 2023-12-06 10:34:21 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
239 | 2023-11-21 04:47:49 | expenses | 3 | 146162 | 117 | 6.030 | 24239.1 |
238 | 2023-11-11 16:56:24 | expenses | 1 | 82945 | 4 | 1.453 | 57085.3 |
237 | 2023-11-03 10:55:23 | expenses | 1 | 82945 | 4 | 1.296 | 64000.8 |
236 | 2023-10-17 02:01:57 | expenses | 1 | 82945 | 4 | 2.966 | 27965.3 |
235 | 2023-10-12 06:51:14 | expenses | 1 | 82945 | 4 | 1.326 | 62552.8 |
234 | 2023-09-28 23:19:22 | expenses | 1 | 82945 | 4 | 1.283 | 64649.3 |
233 | 2023-09-25 15:46:53 | expenses | 1 | 82945 | 4 | 1.346 | 61623.3 |
232 | 2023-09-11 10:44:39 | expenses | 1 | 82945 | 4 | 2.203 | 37650.9 |
231 | 2023-08-22 00:03:58 | expenses | 3 | 146162 | 117 | 6.453 | 22650.2 |
230 | 2023-08-08 11:17:56 | expenses | 1 | 82945 | 4 | 1.220 | 67987.7 |
229 | 2023-05-31 23:58:40 | expenses | 1 | 82945 | 4 | 1.360 | 60989.0 |
228 | 2023-05-28 10:54:37 | expenses | 1 | 82945 | 4 | 1.203 | 68948.5 |
227 | 2023-05-08 13:46:36 | expenses | 1 | 82945 | 4 | 1.216 | 68211.3 |
226 | 2023-05-07 17:08:48 | expenses | 3 | 146162 | 117 | 6.110 | 23921.8 |
225 | 2023-03-01 17:52:35 | expenses | 1 | 82945 | 4 | 1.203 | 68948.5 |
224 | 2023-02-19 11:08:34 | expenses | 1 | 82945 | 4 | 1.280 | 64800.8 |
223 | 2023-02-14 00:48:03 | expenses | 3 | 146162 | 117 | 6.390 | 22873.6 |
222 | 2022-12-26 01:59:54 | expenses | 1 | 82945 | 4 | 1.233 | 67270.9 |
221 | 2022-11-25 02:29:31 | expenses | 3 | 146162 | 117 | 5.983 | 24429.6 |
220 | 2022-11-02 09:18:03 | expenses | 1 | 82945 | 4 | 1.360 | 60989.0 |
219 | 2022-09-10 10:39:35 | expenses | 1 | 82945 | 4 | 1.233 | 67270.9 |
218 | 2022-09-08 09:05:06 | expenses | 1 | 82945 | 4 | 1.360 | 60989.0 |
217 | 2022-07-19 23:54:21 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
216 | 2022-05-02 10:08:26 | expenses | 3 | 146162 | 117 | 6.033 | 24227.1 |
215 | 2022-04-19 13:09:14 | expenses | 1 | 82945 | 4 | 1.736 | 47779.4 |
214 | 2022-04-17 08:56:26 | expenses | 1 | 82945 | 4 | 1.406 | 58993.6 |
213 | 2022-03-25 20:58:25 | expenses | 1 | 82945 | 4 | 1.376 | 60279.8 |
212 | 2022-01-28 05:37:05 | expenses | 1 | 82945 | 4 | 1.266 | 65517.4 |
211 | 2021-12-14 23:39:35 | expenses | 1 | 82945 | 4 | 1.330 | 62364.7 |
210 | 2021-11-15 20:18:27 | expenses | 1 | 82945 | 4 | 1.483 | 55930.5 |
209 | 2021-11-15 15:57:00 | expenses | 1 | 82945 | 4 | 1.470 | 56425.2 |
208 | 2021-10-06 05:19:33 | expenses | 1 | 82945 | 4 | 1.906 | 43517.8 |
207 | 2021-09-10 23:32:39 | expenses | 1 | 82945 | 4 | 1.453 | 57085.3 |
206 | 2021-09-07 17:19:40 | expenses | 1 | 82945 | 4 | 1.376 | 60279.8 |
205 | 2021-06-06 20:14:01 | expenses | 1 | 82945 | 4 | 1.376 | 60279.8 |
204 | 2021-06-03 15:55:02 | expenses | 1 | 82945 | 4 | 1.440 | 57600.7 |
203 | 2021-05-20 05:32:59 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
202 | 2021-03-01 05:25:39 | expenses | 1 | 82945 | 4 | 1.233 | 67270.9 |
201 | 2021-02-06 03:24:24 | expenses | 1 | 82945 | 4 | 1.283 | 64649.3 |
200 | 2021-02-02 04:01:25 | expenses | 3 | 146162 | 117 | 6.063 | 24107.2 |
199 | 2021-02-01 12:40:30 | expenses | 1 | 82945 | 4 | 1.280 | 64800.8 |
198 | 2021-01-30 22:59:56 | expenses | 1 | 82945 | 4 | 1.313 | 63172.1 |
197 | 2021-01-05 01:17:42 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
196 | 2020-11-29 12:54:11 | expenses | 1 | 82945 | 4 | 1.233 | 67270.9 |
195 | 2020-11-19 23:28:12 | expenses | 1 | 82945 | 4 | 1.263 | 65673.0 |
194 | 2020-10-28 03:26:56 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
193 | 2020-10-20 21:39:00 | expenses | 1 | 82945 | 4 | 2.250 | 36864.4 |
192 | 2020-10-18 05:16:40 | expenses | 1 | 82945 | 4 | 1.296 | 64000.8 |
191 | 2020-10-08 03:42:25 | expenses | 1 | 82945 | 4 | 1.326 | 62552.8 |
190 | 2020-08-22 22:18:37 | expenses | 1 | 82945 | 4 | 1.250 | 66356.0 |
189 | 2020-08-19 17:43:38 | expenses | 1 | 82945 | 4 | 1.296 | 64000.8 |
188 | 2020-08-17 07:55:52 | expenses | 1 | 82945 | 4 | 1.420 | 58412.0 |
187 | 2020-08-14 09:01:56 | expenses | 1 | 82945 | 4 | 1.393 | 59544.1 |
186 | 2020-07-31 01:29:32 | expenses | 1 | 82945 | 4 | 1.360 | 60989.0 |
185 | 2020-06-18 22:59:38 | expenses | 1 | 82945 | 4 | 1.283 | 64649.3 |