History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agreements"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
366 | 2024-04-08 18:39:41 | agreements | 4 | 161450 | 199 | 49.110 | 3287.5 |
365 | 2024-04-06 11:32:47 | agreements | 2 | 108824 | 2 | 9.656 | 11270.1 |
364 | 2024-04-06 11:32:08 | agreements | 1 | 67641 | 2 | 2.830 | 23901.4 |
363 | 2024-04-02 05:27:56 | agreements | 1 | 67641 | 2 | 3.783 | 17880.3 |
362 | 2024-04-02 03:56:50 | agreements | 1 | 67641 | 2 | 1.263 | 53555.8 |
361 | 2024-04-01 14:38:55 | agreements | 4 | 161450 | 199 | 39.940 | 4042.3 |
360 | 2024-04-01 12:22:11 | agreements | 3 | 140603 | 21 | 26.906 | 5225.7 |
359 | 2024-04-01 12:22:11 | agreements | 2 | 108824 | 2 | 12.860 | 8462.2 |
358 | 2024-04-01 12:15:18 | agreements | 1 | 67641 | 2 | 1.123 | 60232.4 |
357 | 2024-03-31 06:46:50 | agreements | 4 | 161450 | 199 | 36.486 | 4425.0 |
356 | 2024-03-28 12:22:20 | agreements | 2 | 108824 | 2 | 2.876 | 37838.7 |
355 | 2024-03-27 05:45:57 | agreements | 1 | 67641 | 2 | 2.126 | 31816.1 |
354 | 2024-03-24 13:07:58 | agreements | 4 | 161450 | 199 | 25.423 | 6350.5 |
353 | 2024-03-23 03:13:40 | agreements | 4 | 161450 | 199 | 28.156 | 5734.1 |
352 | 2024-03-23 03:13:41 | agreements | 3 | 140603 | 21 | 23.936 | 5874.1 |
351 | 2024-03-23 03:13:49 | agreements | 2 | 108824 | 2 | 7.280 | 14948.4 |
350 | 2024-03-23 03:02:11 | agreements | 1 | 67641 | 2 | 1.060 | 63812.3 |
349 | 2024-03-02 08:15:32 | agreements | 4 | 161450 | 199 | 23.610 | 6838.2 |
348 | 2024-03-02 08:15:37 | agreements | 3 | 140603 | 21 | 7.656 | 18365.1 |
347 | 2024-03-02 08:15:35 | agreements | 2 | 108824 | 2 | 3.563 | 30542.8 |
346 | 2024-03-02 08:14:39 | agreements | 1 | 67641 | 2 | 1.250 | 54112.8 |
345 | 2024-02-19 18:01:01 | agreements | 3 | 140603 | 21 | 11.203 | 12550.5 |
344 | 2024-02-17 05:02:30 | agreements | 2 | 108824 | 2 | 10.250 | 10617.0 |
343 | 2024-02-17 02:02:13 | agreements | 3 | 140603 | 21 | 14.390 | 9770.9 |
342 | 2024-02-16 23:51:30 | agreements | 1 | 67641 | 2 | 1.360 | 49736.0 |
341 | 2024-02-16 10:24:48 | agreements | 1 | 67641 | 2 | 2.610 | 25916.1 |
340 | 2024-02-15 17:29:10 | agreements | 4 | 161450 | 199 | 39.940 | 4042.3 |
339 | 2024-02-15 16:46:01 | agreements | 1 | 67641 | 2 | 1.530 | 44209.8 |
338 | 2024-02-14 02:05:16 | agreements | 4 | 161450 | 199 | 28.050 | 5755.8 |
337 | 2024-02-12 14:41:04 | agreements | 4 | 161450 | 199 | 19.186 | 8415.0 |
336 | 2024-02-12 14:41:05 | agreements | 3 | 140603 | 21 | 10.953 | 12836.9 |
335 | 2024-02-11 19:42:23 | agreements | 4 | 161450 | 199 | 47.720 | 3383.3 |
334 | 2024-02-11 19:42:32 | agreements | 2 | 108824 | 2 | 9.343 | 11647.7 |
333 | 2024-02-11 19:42:19 | agreements | 3 | 140603 | 21 | 12.140 | 11581.8 |
332 | 2024-02-11 14:50:23 | agreements | 1 | 67641 | 2 | 1.093 | 61885.6 |
331 | 2024-02-03 20:18:21 | agreements | 1 | 67641 | 2 | 1.173 | 57665.0 |
330 | 2024-01-30 20:04:40 | agreements | 1 | 67641 | 2 | 1.156 | 58513.0 |
329 | 2024-01-27 05:31:39 | agreements | 1 | 67641 | 2 | 1.013 | 66773.0 |
328 | 2023-12-21 21:33:04 | agreements | 3 | 140603 | 21 | 6.593 | 21326.1 |
327 | 2023-12-08 16:11:16 | agreements | 1 | 67641 | 2 | 1.076 | 62863.4 |
326 | 2023-12-04 03:00:31 | agreements | 1 | 67641 | 2 | 0.966 | 70021.7 |
325 | 2023-11-29 18:18:42 | agreements | 2 | 108824 | 2 | 2.686 | 40515.3 |
324 | 2023-11-26 04:42:52 | agreements | 1 | 67641 | 2 | 1.220 | 55443.4 |
323 | 2023-11-20 18:01:34 | agreements | 1 | 67641 | 2 | 1.173 | 57665.0 |
322 | 2023-11-08 05:02:44 | agreements | 1 | 67641 | 2 | 1.110 | 60937.8 |
321 | 2023-09-22 17:02:15 | agreements | 3 | 140603 | 21 | 5.906 | 23806.8 |
320 | 2023-09-11 02:52:26 | agreements | 1 | 67641 | 2 | 0.983 | 68810.8 |
319 | 2023-08-28 16:43:14 | agreements | 2 | 108824 | 2 | 2.580 | 42179.8 |
318 | 2023-07-13 04:43:18 | agreements | 1 | 67641 | 2 | 1.140 | 59334.2 |
317 | 2023-06-27 15:50:55 | agreements | 3 | 140603 | 21 | 5.310 | 26478.9 |
316 | 2023-06-19 15:02:32 | agreements | 1 | 67641 | 2 | 0.966 | 70021.7 |
315 | 2023-05-14 05:03:28 | agreements | 2 | 108824 | 2 | 2.610 | 41695.0 |
314 | 2023-04-03 12:54:34 | agreements | 1 | 67641 | 2 | 1.093 | 61885.6 |
313 | 2023-03-25 11:18:33 | agreements | 1 | 67641 | 2 | 0.966 | 70021.7 |
312 | 2023-03-21 07:06:04 | agreements | 3 | 140603 | 21 | 5.326 | 26399.4 |
311 | 2023-02-18 04:14:03 | agreements | 2 | 108824 | 2 | 2.563 | 42459.6 |
310 | 2023-01-17 14:42:46 | agreements | 1 | 67641 | 2 | 1.063 | 63632.2 |
309 | 2022-12-21 18:53:43 | agreements | 3 | 140603 | 21 | 5.826 | 24133.7 |
308 | 2022-11-30 17:11:47 | agreements | 1 | 67641 | 2 | 0.966 | 70021.7 |
307 | 2022-11-29 17:12:04 | agreements | 2 | 108824 | 2 | 2.546 | 42743.1 |
306 | 2022-11-27 10:24:32 | agreements | 1 | 67641 | 2 | 1.000 | 67641.0 |
305 | 2022-11-13 10:21:38 | agreements | 1 | 67641 | 2 | 0.986 | 68601.4 |
304 | 2022-08-16 14:35:28 | agreements | 3 | 140603 | 21 | 5.483 | 25643.4 |
303 | 2022-07-27 22:48:58 | agreements | 1 | 67641 | 2 | 1.106 | 61158.2 |
302 | 2022-07-05 04:29:46 | agreements | 1 | 67641 | 2 | 1.126 | 60071.9 |
301 | 2022-04-21 12:22:30 | agreements | 2 | 108824 | 2 | 2.720 | 40008.8 |
300 | 2022-03-26 09:46:31 | agreements | 1 | 67641 | 2 | 1.030 | 65670.9 |
299 | 2022-03-03 12:40:00 | agreements | 1 | 67641 | 2 | 1.423 | 47534.1 |
298 | 2022-01-02 01:47:43 | agreements | 1 | 67641 | 2 | 1.110 | 60937.8 |
297 | 2021-12-09 01:35:23 | agreements | 1 | 67641 | 2 | 1.156 | 58513.0 |
296 | 2021-11-02 21:25:40 | agreements | 2 | 108824 | 2 | 2.640 | 41221.2 |
295 | 2021-10-03 07:55:00 | agreements | 3 | 140603 | 21 | 5.576 | 25215.7 |
294 | 2021-09-26 18:55:26 | agreements | 2 | 108824 | 2 | 2.596 | 41919.9 |
293 | 2021-09-22 07:32:42 | agreements | 1 | 67641 | 2 | 1.093 | 61885.6 |
292 | 2021-09-22 04:45:10 | agreements | 3 | 140603 | 21 | 6.780 | 20737.9 |
291 | 2021-09-22 02:18:21 | agreements | 2 | 108824 | 2 | 3.076 | 35378.4 |
290 | 2021-09-14 18:45:24 | agreements | 1 | 67641 | 2 | 1.000 | 67641.0 |
289 | 2021-09-12 10:04:51 | agreements | 4 | 161450 | 199 | 10.050 | 16064.7 |
288 | 2021-08-29 09:42:23 | agreements | 1 | 67641 | 2 | 1.000 | 67641.0 |
287 | 2021-06-30 00:16:29 | agreements | 4 | 161450 | 199 | 11.140 | 14492.8 |
286 | 2021-05-28 16:58:30 | agreements | 1 | 67641 | 2 | 1.000 | 67641.0 |
285 | 2021-05-20 21:17:40 | agreements | 1 | 67641 | 2 | 1.186 | 57032.9 |
284 | 2021-05-13 02:25:38 | agreements | 4 | 161450 | 199 | 9.516 | 16966.2 |
283 | 2021-05-09 15:06:05 | agreements | 4 | 161450 | 199 | 10.750 | 15018.6 |
282 | 2021-05-06 01:55:20 | agreements | 4 | 161450 | 199 | 10.893 | 14821.4 |
281 | 2021-04-11 14:15:35 | agreements | 4 | 161450 | 199 | 11.406 | 14154.8 |
280 | 2021-02-25 17:12:41 | agreements | 1 | 67641 | 2 | 1.016 | 66575.8 |
279 | 2021-02-18 14:32:18 | agreements | 4 | 161450 | 199 | 10.830 | 14907.7 |
278 | 2021-01-24 13:48:07 | agreements | 4 | 161450 | 199 | 10.093 | 15996.2 |
277 | 2020-11-25 17:49:37 | agreements | 1 | 67641 | 2 | 1.016 | 66575.8 |
276 | 2020-11-13 17:42:22 | agreements | 1 | 67641 | 2 | 1.110 | 60937.8 |
275 | 2020-10-23 01:02:28 | agreements | 4 | 161450 | 199 | 10.330 | 15629.2 |
274 | 2020-08-26 14:17:09 | agreements | 1 | 67641 | 2 | 1.000 | 67641.0 |
273 | 2020-08-23 10:34:55 | agreements | 1 | 67641 | 2 | 1.013 | 66773.0 |
272 | 2020-05-09 19:52:58 | agreements | 1 | 67641 | 2 | 1.016 | 66575.8 |
271 | 2020-03-28 05:37:38 | agreements | 4 | 161450 | 199 | 13.000 | 12419.2 |
270 | 2020-03-23 08:38:19 | agreements | 4 | 161450 | 199 | 13.593 | 11877.4 |
269 | 2020-03-22 05:43:17 | agreements | 4 | 161450 | 199 | 10.390 | 15539.0 |
268 | 2020-03-21 19:02:56 | agreements | 1 | 67641 | 2 | 1.110 | 60937.8 |
267 | 2020-03-06 00:22:44 | agreements | 2 | 108824 | 2 | 2.796 | 38921.3 |