History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"effort"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
312 | 2024-04-19 11:38:04 | effort | 1 | 48755 | 2 | 3.500 | 13930.0 |
311 | 2024-04-17 12:18:02 | effort | 2 | 82551 | 9 | 2.140 | 38575.2 |
310 | 2024-04-10 13:24:23 | effort | 1 | 48755 | 2 | 0.796 | 61250.0 |
309 | 2024-04-03 14:51:35 | effort | 2 | 82551 | 9 | 6.593 | 12521.0 |
308 | 2024-04-03 14:49:53 | effort | 3 | 112716 | 130 | 6.483 | 17386.4 |
307 | 2024-04-01 06:17:55 | effort | 3 | 112716 | 130 | 10.046 | 11220.0 |
306 | 2024-04-01 06:17:52 | effort | 2 | 82551 | 9 | 2.826 | 29211.3 |
305 | 2024-04-01 06:17:48 | effort | 1 | 48755 | 2 | 0.953 | 51159.5 |
304 | 2024-03-19 22:00:41 | effort | 3 | 112716 | 130 | 5.186 | 21734.7 |
303 | 2024-03-19 22:00:40 | effort | 2 | 82551 | 9 | 2.500 | 33020.4 |
302 | 2024-03-19 22:00:35 | effort | 2 | 82551 | 9 | 2.343 | 35233.0 |
301 | 2024-03-19 22:00:35 | effort | 1 | 48755 | 2 | 0.843 | 57835.1 |
300 | 2024-03-19 22:00:22 | effort | 3 | 112716 | 130 | 5.080 | 22188.2 |
299 | 2024-03-15 16:06:01 | effort | 1 | 48755 | 2 | 0.920 | 52994.6 |
298 | 2024-03-13 03:10:23 | effort | 3 | 112716 | 130 | 4.593 | 24540.8 |
297 | 2024-03-02 01:24:02 | effort | 2 | 82551 | 9 | 2.783 | 29662.6 |
296 | 2024-03-02 01:23:59 | effort | 1 | 48755 | 2 | 1.330 | 36657.9 |
295 | 2024-02-29 07:11:11 | effort | 3 | 112716 | 130 | 5.296 | 21283.2 |
294 | 2024-02-29 07:11:06 | effort | 2 | 82551 | 9 | 2.063 | 40015.0 |
293 | 2024-02-28 10:24:01 | effort | 1 | 48755 | 2 | 1.890 | 25796.3 |
292 | 2024-02-26 05:01:07 | effort | 1 | 48755 | 2 | 2.813 | 17332.0 |
291 | 2024-02-04 06:52:42 | effort | 3 | 112716 | 130 | 6.893 | 16352.2 |
290 | 2024-02-04 02:04:57 | effort | 2 | 82551 | 9 | 2.516 | 32810.4 |
289 | 2024-02-04 02:04:46 | effort | 3 | 112716 | 130 | 5.466 | 20621.3 |
288 | 2024-02-04 02:04:42 | effort | 2 | 82551 | 9 | 2.173 | 37989.4 |
287 | 2024-02-04 02:04:17 | effort | 3 | 112716 | 130 | 6.016 | 18736.0 |
286 | 2024-01-30 04:57:37 | effort | 3 | 112716 | 130 | 8.673 | 12996.2 |
285 | 2024-01-30 04:57:41 | effort | 2 | 82551 | 9 | 2.703 | 30540.5 |
284 | 2024-01-29 15:10:59 | effort | 1 | 48755 | 2 | 0.846 | 57630.0 |
283 | 2024-01-29 15:10:56 | effort | 2 | 82551 | 9 | 2.563 | 32208.7 |
282 | 2024-01-29 15:10:51 | effort | 3 | 112716 | 130 | 5.753 | 19592.6 |
281 | 2023-12-29 05:09:32 | effort | 1 | 48755 | 2 | 0.890 | 54780.9 |
280 | 2023-12-11 12:59:26 | effort | 2 | 82551 | 9 | 3.266 | 25275.9 |
279 | 2023-12-08 13:54:33 | effort | 1 | 48755 | 2 | 0.826 | 59025.4 |
278 | 2023-12-03 09:36:52 | effort | 1 | 48755 | 2 | 0.750 | 65006.7 |
277 | 2023-11-27 17:05:22 | effort | 3 | 112716 | 130 | 4.890 | 23050.3 |
276 | 2023-11-26 15:35:46 | effort | 3 | 112716 | 130 | 5.313 | 21215.1 |
275 | 2023-11-26 15:35:45 | effort | 2 | 82551 | 9 | 2.450 | 33694.3 |
274 | 2023-11-22 08:55:54 | effort | 1 | 48755 | 2 | 0.796 | 61250.0 |
273 | 2023-11-05 16:49:40 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
272 | 2023-10-27 11:20:25 | effort | 1 | 48755 | 2 | 0.813 | 59969.2 |
271 | 2023-10-24 14:23:22 | effort | 1 | 48755 | 2 | 0.813 | 59969.2 |
270 | 2023-10-17 09:44:58 | effort | 1 | 48755 | 2 | 0.750 | 65006.7 |
269 | 2023-10-11 12:52:07 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
268 | 2023-09-24 22:59:58 | effort | 1 | 48755 | 2 | 0.813 | 59969.2 |
267 | 2023-09-13 16:07:28 | effort | 1 | 48755 | 2 | 0.843 | 57835.1 |
266 | 2023-09-09 11:59:43 | effort | 2 | 82551 | 9 | 2.030 | 40665.5 |
265 | 2023-08-28 23:04:54 | effort | 3 | 112716 | 130 | 4.420 | 25501.4 |
264 | 2023-08-14 19:36:46 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
263 | 2023-08-09 03:32:20 | effort | 1 | 48755 | 2 | 0.800 | 60943.8 |
262 | 2023-05-29 22:19:01 | effort | 2 | 82551 | 9 | 2.033 | 40605.5 |
261 | 2023-05-16 18:06:22 | effort | 1 | 48755 | 2 | 0.826 | 59025.4 |
260 | 2023-05-14 10:57:26 | effort | 3 | 112716 | 130 | 4.500 | 25048.0 |
259 | 2023-05-12 17:47:41 | effort | 1 | 48755 | 2 | 0.720 | 67715.3 |
258 | 2023-04-20 11:55:15 | effort | 1 | 48755 | 2 | 0.843 | 57835.1 |
257 | 2023-04-04 01:25:15 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
256 | 2023-04-03 06:12:10 | effort | 1 | 48755 | 2 | 0.813 | 59969.2 |
255 | 2023-03-07 14:42:07 | effort | 2 | 82551 | 9 | 2.063 | 40015.0 |
254 | 2023-03-05 11:58:45 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
253 | 2023-02-20 16:33:48 | effort | 3 | 112716 | 130 | 4.546 | 24794.5 |
252 | 2022-12-31 14:42:30 | effort | 1 | 48755 | 2 | 0.826 | 59025.4 |
251 | 2022-12-28 12:43:46 | effort | 1 | 48755 | 2 | 0.813 | 59969.2 |
250 | 2022-12-12 12:44:42 | effort | 2 | 82551 | 9 | 2.280 | 36206.6 |
249 | 2022-12-02 19:48:02 | effort | 3 | 112716 | 130 | 4.420 | 25501.4 |
248 | 2022-09-16 13:08:53 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
247 | 2022-09-01 08:36:10 | effort | 1 | 48755 | 2 | 0.720 | 67715.3 |
246 | 2022-08-24 00:13:52 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
245 | 2022-07-16 08:22:22 | effort | 1 | 48755 | 2 | 0.750 | 65006.7 |
244 | 2022-07-14 06:26:12 | effort | 2 | 82551 | 9 | 2.076 | 39764.5 |
243 | 2022-07-13 20:21:54 | effort | 1 | 48755 | 2 | 0.750 | 65006.7 |
242 | 2022-04-12 22:49:02 | effort | 1 | 48755 | 2 | 0.766 | 63648.8 |
241 | 2022-04-11 07:27:45 | effort | 3 | 112716 | 130 | 4.560 | 24718.4 |
240 | 2022-03-09 15:33:21 | effort | 1 | 48755 | 2 | 0.846 | 57630.0 |
239 | 2022-02-16 11:00:47 | effort | 2 | 82551 | 9 | 2.156 | 38289.0 |
238 | 2022-02-14 06:41:03 | effort | 2 | 82551 | 9 | 2.486 | 33206.4 |
237 | 2021-12-25 07:31:03 | effort | 1 | 48755 | 2 | 0.766 | 63648.8 |
236 | 2021-12-22 02:44:14 | effort | 1 | 48755 | 2 | 0.796 | 61250.0 |
235 | 2021-12-20 01:43:00 | effort | 1 | 48755 | 2 | 0.763 | 63899.1 |
234 | 2021-11-14 22:27:54 | effort | 2 | 82551 | 9 | 2.140 | 38575.2 |
233 | 2021-11-12 21:14:20 | effort | 2 | 82551 | 9 | 2.640 | 31269.3 |
232 | 2021-10-23 01:11:30 | effort | 1 | 48755 | 2 | 0.780 | 62506.4 |
231 | 2021-09-30 13:33:55 | effort | 2 | 82551 | 9 | 2.373 | 34787.6 |
230 | 2021-09-08 19:04:16 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
229 | 2021-09-06 14:19:54 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
228 | 2021-09-05 04:46:08 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
227 | 2021-09-01 21:17:36 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
226 | 2021-08-22 04:13:55 | effort | 1 | 48755 | 2 | 0.826 | 59025.4 |
225 | 2021-06-01 04:26:01 | effort | 1 | 48755 | 2 | 1.780 | 27390.4 |
224 | 2021-05-21 20:50:29 | effort | 1 | 48755 | 2 | 0.923 | 52822.3 |
223 | 2021-04-22 12:29:03 | effort | 1 | 48755 | 2 | 0.876 | 55656.4 |
222 | 2021-03-01 23:56:56 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
221 | 2021-02-18 21:27:14 | effort | 1 | 48755 | 2 | 0.890 | 54780.9 |
220 | 2021-01-07 17:16:04 | effort | 1 | 48755 | 2 | 0.763 | 63899.1 |
219 | 2020-11-30 11:16:57 | effort | 1 | 48755 | 2 | 0.733 | 66514.3 |
218 | 2020-11-05 03:09:58 | effort | 1 | 48755 | 2 | 0.860 | 56691.9 |
217 | 2020-10-31 04:05:51 | effort | 1 | 48755 | 2 | 0.843 | 57835.1 |
216 | 2020-08-30 01:01:36 | effort | 1 | 48755 | 2 | 0.796 | 61250.0 |
215 | 2020-08-29 23:45:19 | effort | 1 | 48755 | 2 | 0.860 | 56691.9 |
214 | 2020-05-16 00:23:54 | effort | 1 | 48755 | 2 | 0.736 | 66243.2 |
213 | 2020-05-13 00:13:08 | effort | 1 | 48755 | 2 | 0.750 | 65006.7 |