History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"payables"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
288 | 2024-04-11 03:28:25 | payables | 2 | 121059 | 13 | 3.763 | 32170.9 |
287 | 2024-04-11 03:28:10 | payables | 3 | 146162 | 123 | 8.000 | 18270.3 |
286 | 2024-04-10 10:09:19 | payables | 3 | 146162 | 123 | 12.096 | 12083.5 |
285 | 2024-04-10 08:01:03 | payables | 2 | 121059 | 13 | 8.843 | 13689.8 |
284 | 2024-04-09 11:14:24 | payables | 3 | 146162 | 123 | 24.736 | 5908.9 |
283 | 2024-04-09 11:14:22 | payables | 2 | 121059 | 13 | 10.783 | 11226.8 |
282 | 2024-04-09 10:35:20 | payables | 1 | 82945 | 3 | 1.356 | 61168.9 |
281 | 2024-03-31 18:52:53 | payables | 3 | 146162 | 123 | 8.906 | 16411.6 |
280 | 2024-03-30 03:31:50 | payables | 1 | 82945 | 3 | 4.876 | 17010.9 |
279 | 2024-03-29 03:10:41 | payables | 3 | 146162 | 123 | 12.203 | 11977.5 |
278 | 2024-03-28 21:26:27 | payables | 3 | 146162 | 123 | 8.216 | 17789.9 |
277 | 2024-03-28 21:26:28 | payables | 2 | 121059 | 13 | 5.686 | 21290.7 |
276 | 2024-03-28 21:26:17 | payables | 1 | 82945 | 3 | 2.533 | 32745.8 |
275 | 2024-03-11 03:49:58 | payables | 2 | 121059 | 13 | 8.016 | 15102.2 |
274 | 2024-03-11 03:42:06 | payables | 3 | 146162 | 123 | 7.906 | 18487.5 |
273 | 2024-03-07 23:38:25 | payables | 1 | 82945 | 3 | 1.860 | 44594.1 |
272 | 2024-03-05 20:09:09 | payables | 3 | 146162 | 123 | 17.376 | 8411.7 |
271 | 2024-03-05 20:09:07 | payables | 2 | 121059 | 13 | 7.080 | 17098.7 |
270 | 2024-03-05 19:54:04 | payables | 1 | 82945 | 3 | 1.360 | 60989.0 |
269 | 2024-02-22 05:36:56 | payables | 3 | 146162 | 123 | 6.846 | 21350.0 |
268 | 2024-02-22 05:36:59 | payables | 2 | 121059 | 13 | 3.780 | 32026.2 |
267 | 2024-02-09 17:57:49 | payables | 2 | 121059 | 13 | 3.686 | 32842.9 |
266 | 2024-02-09 17:57:37 | payables | 3 | 146162 | 123 | 6.516 | 22431.2 |
265 | 2024-02-09 07:03:33 | payables | 2 | 121059 | 13 | 4.236 | 28578.6 |
264 | 2024-02-09 07:03:13 | payables | 3 | 146162 | 123 | 8.326 | 17554.9 |
263 | 2024-02-08 19:51:04 | payables | 2 | 121059 | 13 | 11.906 | 10167.9 |
262 | 2024-02-08 19:51:05 | payables | 3 | 146162 | 123 | 8.750 | 16704.2 |
261 | 2024-02-01 10:21:52 | payables | 1 | 82945 | 3 | 1.533 | 54106.3 |
260 | 2024-01-30 05:30:06 | payables | 1 | 82945 | 3 | 1.500 | 55296.7 |
259 | 2024-01-19 06:59:33 | payables | 1 | 82945 | 3 | 1.483 | 55930.5 |
258 | 2024-01-04 13:50:07 | payables | 1 | 82945 | 3 | 3.033 | 27347.5 |
257 | 2024-01-01 20:41:50 | payables | 3 | 146162 | 123 | 7.750 | 18859.6 |
256 | 2023-12-11 10:26:56 | payables | 1 | 82945 | 3 | 1.390 | 59672.7 |
255 | 2023-11-25 01:36:43 | payables | 1 | 82945 | 3 | 1.293 | 64149.3 |
254 | 2023-11-05 20:26:54 | payables | 1 | 82945 | 3 | 1.500 | 55296.7 |
253 | 2023-11-05 09:19:53 | payables | 1 | 82945 | 3 | 1.263 | 65673.0 |
252 | 2023-10-23 18:25:55 | payables | 1 | 82945 | 3 | 1.500 | 55296.7 |
251 | 2023-10-05 17:34:50 | payables | 1 | 82945 | 3 | 1.453 | 57085.3 |
250 | 2023-10-05 09:08:02 | payables | 3 | 146162 | 123 | 6.313 | 23152.5 |
249 | 2023-09-09 22:29:41 | payables | 1 | 82945 | 3 | 1.423 | 58288.8 |
248 | 2023-09-02 04:37:15 | payables | 1 | 82945 | 3 | 1.330 | 62364.7 |
247 | 2023-07-17 15:35:39 | payables | 3 | 146162 | 123 | 6.313 | 23152.5 |
246 | 2023-06-25 10:00:18 | payables | 1 | 82945 | 3 | 1.390 | 59672.7 |
245 | 2023-05-05 14:20:58 | payables | 1 | 82945 | 3 | 1.436 | 57761.1 |
244 | 2023-03-31 10:51:07 | payables | 3 | 146162 | 123 | 6.970 | 20970.2 |
243 | 2023-01-12 02:26:55 | payables | 1 | 82945 | 3 | 1.440 | 57600.7 |
242 | 2022-12-28 14:43:05 | payables | 3 | 146162 | 123 | 6.093 | 23988.5 |
241 | 2022-12-09 04:55:56 | payables | 3 | 146162 | 123 | 6.250 | 23385.9 |
240 | 2022-11-25 11:39:52 | payables | 1 | 82945 | 3 | 1.280 | 64800.8 |
239 | 2022-10-31 14:07:16 | payables | 3 | 146162 | 123 | 6.500 | 22486.5 |
238 | 2022-09-10 04:43:49 | payables | 1 | 82945 | 3 | 1.296 | 64000.8 |
237 | 2022-08-27 14:01:46 | payables | 3 | 146162 | 123 | 7.720 | 18932.9 |
236 | 2022-05-13 15:04:39 | payables | 1 | 82945 | 3 | 1.453 | 57085.3 |
235 | 2022-05-11 11:27:58 | payables | 1 | 82945 | 3 | 1.733 | 47862.1 |
234 | 2022-04-27 05:39:12 | payables | 1 | 82945 | 3 | 1.280 | 64800.8 |
233 | 2022-03-20 10:01:34 | payables | 3 | 146162 | 123 | 6.140 | 23804.9 |
232 | 2022-02-14 14:10:33 | payables | 1 | 82945 | 3 | 1.373 | 60411.5 |
231 | 2021-12-31 21:19:33 | payables | 1 | 82945 | 3 | 1.360 | 60989.0 |
230 | 2021-09-11 22:44:03 | payables | 1 | 82945 | 3 | 1.470 | 56425.2 |
229 | 2021-06-11 13:56:54 | payables | 1 | 82945 | 3 | 1.436 | 57761.1 |
228 | 2021-05-21 11:45:41 | payables | 1 | 82945 | 3 | 1.500 | 55296.7 |
227 | 2021-04-22 00:10:34 | payables | 1 | 82945 | 3 | 1.470 | 56425.2 |
226 | 2021-03-08 13:32:01 | payables | 1 | 82945 | 3 | 1.686 | 49196.3 |
225 | 2021-02-21 08:16:15 | payables | 1 | 82945 | 3 | 1.283 | 64649.3 |
224 | 2021-02-02 18:47:25 | payables | 1 | 82945 | 3 | 1.373 | 60411.5 |
223 | 2021-01-07 01:24:16 | payables | 1 | 82945 | 3 | 1.280 | 64800.8 |
222 | 2020-12-05 02:08:40 | payables | 1 | 82945 | 3 | 1.640 | 50576.2 |
221 | 2020-10-29 22:53:24 | payables | 1 | 82945 | 3 | 1.296 | 64000.8 |
220 | 2020-10-29 15:51:24 | payables | 1 | 82945 | 3 | 1.546 | 53651.4 |
219 | 2020-10-22 06:37:57 | payables | 1 | 82945 | 3 | 1.673 | 49578.6 |
218 | 2020-10-21 04:43:37 | payables | 1 | 82945 | 3 | 1.580 | 52496.8 |
217 | 2020-09-24 22:16:40 | payables | 1 | 82945 | 3 | 1.390 | 59672.7 |
216 | 2020-09-02 10:05:55 | payables | 1 | 82945 | 3 | 1.483 | 55930.5 |
215 | 2020-08-22 21:32:48 | payables | 1 | 82945 | 3 | 1.516 | 54713.1 |
214 | 2020-05-22 12:33:38 | payables | 1 | 82945 | 3 | 1.420 | 58412.0 |
213 | 2020-05-19 10:14:35 | payables | 1 | 82945 | 3 | 1.280 | 64800.8 |
212 | 2020-03-30 00:54:03 | payables | 1 | 82945 | 3 | 2.830 | 29309.2 |
211 | 2020-03-28 13:14:09 | payables | 1 | 82945 | 3 | 1.750 | 47397.1 |
210 | 2020-03-26 08:56:09 | payables | 1 | 82945 | 3 | 1.343 | 61761.0 |
209 | 2020-03-21 04:06:38 | payables | 1 | 82945 | 3 | 1.563 | 53067.8 |
208 | 2020-02-23 02:04:03 | payables | 1 | 82945 | 3 | 2.190 | 37874.4 |
207 | 2020-02-23 01:40:57 | payables | 1 | 82945 | 3 | 2.016 | 41143.4 |
206 | 2020-02-12 10:00:03 | payables | 1 | 82945 | 3 | 3.313 | 25036.2 |
205 | 2020-02-11 14:24:40 | payables | 1 | 82945 | 3 | 3.470 | 23903.5 |
204 | 2020-02-07 15:33:17 | payables | 1 | 82945 | 3 | 1.500 | 55296.7 |
203 | 2020-02-03 13:52:46 | payables | 1 | 82945 | 3 | 3.360 | 24686.0 |
202 | 2020-01-30 02:17:59 | payables | 1 | 82945 | 3 | 1.533 | 54106.3 |
201 | 2020-01-25 16:01:05 | payables | 1 | 82945 | 3 | 2.190 | 37874.4 |
200 | 2020-01-22 16:00:54 | payables | 1 | 82945 | 3 | 3.156 | 26281.7 |
199 | 2020-01-21 03:44:07 | payables | 1 | 82945 | 3 | 2.063 | 40206.0 |
198 | 2020-01-15 17:58:01 | payables | 1 | 82945 | 3 | 1.670 | 49667.7 |
197 | 2020-01-10 17:46:09 | payables | 1 | 82945 | 3 | 1.530 | 54212.4 |
196 | 2020-01-03 01:49:05 | payables | 1 | 82945 | 3 | 1.546 | 53651.4 |
195 | 2019-12-31 17:54:26 | payables | 1 | 82945 | 3 | 1.440 | 57600.7 |
194 | 2019-12-29 22:54:53 | payables | 1 | 82945 | 3 | 1.436 | 57761.1 |
193 | 2019-11-07 03:18:15 | payables | 1 | 82945 | 3 | 1.406 | 58993.6 |
192 | 2019-08-05 22:33:25 | payables | 1 | 82945 | 3 | 1.230 | 67435.0 |
191 | 2019-04-29 16:58:33 | payables | 1 | 82945 | 3 | 1.360 | 60989.0 |
190 | 2019-02-28 23:49:36 | payables | 1 | 82945 | 3 | 1.390 | 59672.7 |
189 | 2019-02-25 13:53:04 | payables | 1 | 82945 | 3 | 1.270 | 65311.0 |