History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prorates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
362 | 2024-03-15 17:05:46 | prorates | 1 | 82945 | 8 | 5.000 | 16589.0 |
361 | 2024-03-14 17:46:41 | prorates | 1 | 82945 | 8 | 3.440 | 24111.9 |
360 | 2024-02-29 14:37:49 | prorates | 1 | 82945 | 8 | 1.356 | 61168.9 |
359 | 2024-02-29 02:11:56 | prorates | 2 | 121059 | 42 | 3.876 | 31233.0 |
358 | 2024-02-29 01:53:31 | prorates | 1 | 82945 | 8 | 1.533 | 54106.3 |
357 | 2024-02-28 18:37:50 | prorates | 2 | 121059 | 42 | 4.906 | 24675.7 |
356 | 2024-02-28 18:37:42 | prorates | 3 | 146162 | 346 | 6.750 | 21653.6 |
355 | 2024-02-28 17:35:12 | prorates | 1 | 82945 | 8 | 1.483 | 55930.5 |
354 | 2024-01-30 05:41:56 | prorates | 1 | 82945 | 8 | 2.313 | 35860.4 |
353 | 2023-12-31 11:12:48 | prorates | 1 | 82945 | 8 | 1.343 | 61761.0 |
352 | 2023-12-30 18:02:31 | prorates | 1 | 82945 | 8 | 1.483 | 55930.5 |
351 | 2023-12-28 06:01:49 | prorates | 1 | 82945 | 8 | 1.420 | 58412.0 |
350 | 2023-12-23 13:47:29 | prorates | 2 | 121059 | 42 | 3.343 | 36212.7 |
349 | 2023-11-30 13:00:10 | prorates | 1 | 82945 | 8 | 1.356 | 61168.9 |
348 | 2023-11-27 05:31:33 | prorates | 1 | 82945 | 8 | 1.420 | 58412.0 |
347 | 2023-11-25 22:15:14 | prorates | 1 | 82945 | 8 | 1.516 | 54713.1 |
346 | 2023-11-22 15:32:25 | prorates | 3 | 146162 | 346 | 6.593 | 22169.3 |
345 | 2023-11-22 14:32:16 | prorates | 2 | 121059 | 42 | 3.516 | 34430.9 |
344 | 2023-11-15 19:47:39 | prorates | 1 | 82945 | 8 | 1.436 | 57761.1 |
343 | 2023-11-13 04:26:37 | prorates | 1 | 82945 | 8 | 1.266 | 65517.4 |
342 | 2023-10-24 23:03:31 | prorates | 1 | 82945 | 8 | 1.390 | 59672.7 |
341 | 2023-10-22 11:00:23 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |
340 | 2023-10-20 16:32:03 | prorates | 1 | 82945 | 8 | 1.313 | 63172.1 |
339 | 2023-10-09 21:37:22 | prorates | 1 | 82945 | 8 | 1.280 | 64800.8 |
338 | 2023-09-30 02:43:30 | prorates | 1 | 82945 | 8 | 1.420 | 58412.0 |
337 | 2023-09-24 06:08:24 | prorates | 2 | 121059 | 42 | 3.903 | 31016.9 |
336 | 2023-08-17 10:31:27 | prorates | 1 | 82945 | 8 | 1.483 | 55930.5 |
335 | 2023-08-04 00:52:09 | prorates | 1 | 82945 | 8 | 1.483 | 55930.5 |
334 | 2023-07-06 08:03:21 | prorates | 2 | 121059 | 42 | 3.656 | 33112.4 |
333 | 2023-05-18 13:14:44 | prorates | 1 | 82945 | 8 | 1.266 | 65517.4 |
332 | 2023-04-26 13:51:46 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
331 | 2023-03-29 00:54:53 | prorates | 2 | 121059 | 42 | 3.126 | 38726.5 |
330 | 2023-03-12 17:44:20 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |
329 | 2023-01-17 22:33:36 | prorates | 1 | 82945 | 8 | 1.326 | 62552.8 |
328 | 2023-01-01 04:53:43 | prorates | 1 | 82945 | 8 | 1.280 | 64800.8 |
327 | 2022-12-29 03:18:51 | prorates | 1 | 82945 | 8 | 1.250 | 66356.0 |
326 | 2022-12-26 12:48:32 | prorates | 2 | 121059 | 42 | 3.143 | 38517.0 |
325 | 2022-11-26 13:21:07 | prorates | 1 | 82945 | 8 | 1.406 | 58993.6 |
324 | 2022-10-03 20:34:48 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |
323 | 2022-09-30 05:41:56 | prorates | 1 | 82945 | 8 | 1.296 | 64000.8 |
322 | 2022-09-20 22:05:25 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |
321 | 2022-08-28 19:26:26 | prorates | 2 | 121059 | 42 | 3.186 | 37997.2 |
320 | 2022-06-13 06:35:01 | prorates | 1 | 82945 | 8 | 1.313 | 63172.1 |
319 | 2022-04-29 00:47:06 | prorates | 1 | 82945 | 8 | 1.643 | 50483.9 |
318 | 2022-03-21 12:40:16 | prorates | 2 | 121059 | 42 | 3.656 | 33112.4 |
317 | 2022-02-26 02:41:46 | prorates | 1 | 82945 | 8 | 1.313 | 63172.1 |
316 | 2022-02-22 16:41:38 | prorates | 1 | 82945 | 8 | 1.733 | 47862.1 |
315 | 2022-01-22 08:02:17 | prorates | 1 | 82945 | 8 | 1.453 | 57085.3 |
314 | 2022-01-20 05:24:28 | prorates | 1 | 82945 | 8 | 1.470 | 56425.2 |
313 | 2022-01-18 01:32:30 | prorates | 1 | 82945 | 8 | 1.530 | 54212.4 |
312 | 2021-11-17 21:52:23 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
311 | 2021-11-13 18:57:46 | prorates | 1 | 82945 | 8 | 1.580 | 52496.8 |
310 | 2021-10-03 13:41:20 | prorates | 1 | 82945 | 8 | 1.280 | 64800.8 |
309 | 2021-09-14 09:42:43 | prorates | 1 | 82945 | 8 | 1.453 | 57085.3 |
308 | 2021-08-18 09:01:30 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |
307 | 2021-08-15 01:42:06 | prorates | 1 | 82945 | 8 | 1.280 | 64800.8 |
306 | 2021-07-25 13:51:38 | prorates | 1 | 82945 | 8 | 1.296 | 64000.8 |
305 | 2021-05-26 10:22:49 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
304 | 2021-05-15 22:24:23 | prorates | 1 | 82945 | 8 | 1.360 | 60989.0 |
303 | 2021-05-14 09:58:58 | prorates | 1 | 82945 | 8 | 1.406 | 58993.6 |
302 | 2021-04-15 11:52:28 | prorates | 1 | 82945 | 8 | 1.453 | 57085.3 |
301 | 2021-02-21 12:45:00 | prorates | 1 | 82945 | 8 | 2.593 | 31988.0 |
300 | 2021-02-11 05:14:46 | prorates | 1 | 82945 | 8 | 1.280 | 64800.8 |
299 | 2021-02-06 09:31:10 | prorates | 1 | 82945 | 8 | 1.420 | 58412.0 |
298 | 2021-02-06 09:03:36 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
297 | 2021-02-06 08:38:16 | prorates | 1 | 82945 | 8 | 1.486 | 55817.6 |
296 | 2021-02-06 08:15:07 | prorates | 1 | 82945 | 8 | 1.296 | 64000.8 |
295 | 2020-11-04 08:22:52 | prorates | 1 | 82945 | 8 | 1.330 | 62364.7 |
294 | 2020-10-31 09:54:33 | prorates | 1 | 82945 | 8 | 1.843 | 45005.4 |
293 | 2020-10-20 09:48:45 | prorates | 1 | 82945 | 8 | 1.330 | 62364.7 |
292 | 2020-10-12 23:05:10 | prorates | 1 | 82945 | 8 | 1.420 | 58412.0 |
291 | 2020-08-29 16:23:23 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
290 | 2020-08-28 21:37:00 | prorates | 1 | 82945 | 8 | 1.360 | 60989.0 |
289 | 2020-08-26 17:08:06 | prorates | 1 | 82945 | 8 | 1.483 | 55930.5 |
288 | 2020-08-23 23:10:27 | prorates | 1 | 82945 | 8 | 1.360 | 60989.0 |
287 | 2020-07-31 19:32:30 | prorates | 1 | 82945 | 8 | 1.373 | 60411.5 |
286 | 2020-05-31 10:22:11 | prorates | 1 | 82945 | 8 | 1.516 | 54713.1 |
285 | 2020-04-29 08:23:28 | prorates | 1 | 82945 | 8 | 1.310 | 63316.8 |
284 | 2020-03-28 02:53:15 | prorates | 1 | 82945 | 8 | 1.486 | 55817.6 |
283 | 2020-03-27 22:18:39 | prorates | 1 | 82945 | 8 | 1.436 | 57761.1 |
282 | 2020-03-24 11:02:47 | prorates | 1 | 82945 | 8 | 1.843 | 45005.4 |
281 | 2020-03-23 00:39:50 | prorates | 1 | 82945 | 8 | 2.953 | 28088.4 |
280 | 2020-03-20 02:13:33 | prorates | 1 | 82945 | 8 | 1.576 | 52630.1 |
279 | 2020-03-09 13:18:53 | prorates | 1 | 82945 | 8 | 1.263 | 65673.0 |
278 | 2020-02-22 14:50:57 | prorates | 1 | 82945 | 8 | 3.110 | 26670.4 |
277 | 2020-02-20 10:55:44 | prorates | 1 | 82945 | 8 | 1.686 | 49196.3 |
276 | 2020-02-17 00:49:41 | prorates | 1 | 82945 | 8 | 3.516 | 23590.7 |
275 | 2020-02-05 22:40:55 | prorates | 1 | 82945 | 8 | 3.016 | 27501.7 |
274 | 2020-02-05 02:53:34 | prorates | 1 | 82945 | 8 | 3.936 | 21073.4 |
273 | 2020-01-31 07:01:21 | prorates | 1 | 82945 | 8 | 3.296 | 25165.4 |
272 | 2020-01-30 16:38:21 | prorates | 1 | 82945 | 8 | 1.500 | 55296.7 |
271 | 2020-01-28 19:19:12 | prorates | 1 | 82945 | 8 | 1.860 | 44594.1 |
270 | 2020-01-28 11:24:05 | prorates | 1 | 82945 | 8 | 1.330 | 62364.7 |
269 | 2020-01-25 12:39:30 | prorates | 1 | 82945 | 8 | 1.750 | 47397.1 |
268 | 2020-01-25 12:05:56 | prorates | 1 | 82945 | 8 | 1.703 | 48705.2 |
267 | 2020-01-16 16:34:29 | prorates | 1 | 82945 | 8 | 1.466 | 56579.1 |
266 | 2020-01-16 05:43:52 | prorates | 1 | 82945 | 8 | 1.533 | 54106.3 |
265 | 2020-01-12 13:04:00 | prorates | 2 | 121059 | 42 | 12.080 | 10021.4 |
264 | 2020-01-12 08:00:51 | prorates | 1 | 82945 | 8 | 1.593 | 52068.4 |
263 | 2020-01-04 08:25:09 | prorates | 1 | 82945 | 8 | 1.283 | 64649.3 |