History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"honoree"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
357 | 2024-03-31 08:44:58 | honoree | 1 | 69583 | 4 | 1.843 | 37755.3 |
356 | 2024-03-31 05:56:51 | honoree | 1 | 69583 | 4 | 2.843 | 24475.2 |
355 | 2024-01-27 05:08:55 | honoree | 3 | 134027 | 124 | 6.970 | 19229.1 |
354 | 2024-01-26 08:38:48 | honoree | 3 | 134027 | 124 | 8.783 | 15259.8 |
353 | 2024-01-21 05:38:13 | honoree | 2 | 107671 | 9 | 3.593 | 29966.9 |
352 | 2024-01-16 10:26:09 | honoree | 1 | 69583 | 4 | 1.220 | 57035.2 |
351 | 2024-01-13 09:55:55 | honoree | 1 | 69583 | 4 | 1.186 | 58670.3 |
350 | 2023-12-16 02:11:27 | honoree | 1 | 69583 | 4 | 1.186 | 58670.3 |
349 | 2023-12-04 15:33:06 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
348 | 2023-11-12 00:32:32 | honoree | 1 | 69583 | 4 | 1.106 | 62914.1 |
347 | 2023-11-05 13:44:04 | honoree | 3 | 134027 | 124 | 6.233 | 21502.8 |
346 | 2023-11-01 16:39:23 | honoree | 2 | 107671 | 9 | 3.140 | 34290.1 |
345 | 2023-10-20 06:18:43 | honoree | 1 | 69583 | 4 | 1.250 | 55666.4 |
344 | 2023-10-13 15:28:17 | honoree | 1 | 69583 | 4 | 1.186 | 58670.3 |
343 | 2023-09-10 08:05:20 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
342 | 2023-09-06 21:37:52 | honoree | 1 | 69583 | 4 | 2.156 | 32274.1 |
341 | 2023-09-01 08:55:32 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
340 | 2023-08-12 09:11:31 | honoree | 3 | 134027 | 124 | 5.750 | 23309.0 |
339 | 2023-08-08 14:47:37 | honoree | 2 | 107671 | 9 | 2.766 | 38926.6 |
338 | 2023-06-06 05:05:58 | honoree | 1 | 69583 | 4 | 1.173 | 59320.5 |
337 | 2023-05-14 05:17:31 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
336 | 2023-04-22 19:45:42 | honoree | 3 | 134027 | 124 | 5.640 | 23763.7 |
335 | 2023-04-16 11:23:45 | honoree | 2 | 107671 | 9 | 2.736 | 39353.4 |
334 | 2023-03-28 00:10:07 | honoree | 1 | 69583 | 4 | 1.156 | 60192.9 |
333 | 2023-01-26 11:19:32 | honoree | 3 | 134027 | 124 | 5.720 | 23431.3 |
332 | 2023-01-21 13:11:52 | honoree | 2 | 107671 | 9 | 2.936 | 36672.7 |
331 | 2023-01-17 05:32:49 | honoree | 1 | 69583 | 4 | 1.156 | 60192.9 |
330 | 2023-01-12 15:28:35 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
329 | 2022-11-07 14:11:21 | honoree | 3 | 134027 | 124 | 6.263 | 21399.8 |
328 | 2022-11-01 04:35:20 | honoree | 2 | 107671 | 9 | 3.093 | 34811.2 |
327 | 2022-10-29 08:18:57 | honoree | 1 | 69583 | 4 | 1.173 | 59320.5 |
326 | 2022-09-15 03:32:45 | honoree | 1 | 69583 | 4 | 1.110 | 62687.4 |
325 | 2022-09-12 06:59:36 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
324 | 2022-07-11 12:43:28 | honoree | 1 | 69583 | 4 | 1.200 | 57985.8 |
323 | 2022-07-10 00:45:03 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
322 | 2022-06-25 05:48:19 | honoree | 1 | 69583 | 4 | 1.063 | 65459.1 |
321 | 2022-06-17 14:22:33 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
320 | 2022-06-09 19:20:44 | honoree | 3 | 134027 | 124 | 5.843 | 22938.0 |
319 | 2022-05-22 16:23:03 | honoree | 2 | 107671 | 9 | 2.843 | 37872.3 |
318 | 2022-05-16 09:36:23 | honoree | 1 | 69583 | 4 | 1.373 | 50679.5 |
317 | 2022-02-25 02:33:09 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
316 | 2022-02-22 22:05:06 | honoree | 1 | 69583 | 4 | 1.140 | 61037.7 |
315 | 2022-01-25 06:16:30 | honoree | 1 | 69583 | 4 | 1.220 | 57035.2 |
314 | 2021-12-09 21:56:04 | honoree | 1 | 69583 | 4 | 1.060 | 65644.3 |
313 | 2021-10-19 06:18:30 | honoree | 1 | 69583 | 4 | 1.076 | 64668.2 |
312 | 2021-10-05 12:52:18 | honoree | 1 | 69583 | 4 | 1.063 | 65459.1 |
311 | 2021-09-04 18:08:31 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
310 | 2021-08-20 07:58:03 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
309 | 2021-07-06 15:01:05 | honoree | 1 | 69583 | 4 | 1.076 | 64668.2 |
308 | 2021-07-03 01:52:08 | honoree | 1 | 69583 | 4 | 1.360 | 51164.0 |
307 | 2021-06-16 17:49:43 | honoree | 1 | 69583 | 4 | 1.063 | 65459.1 |
306 | 2021-03-29 06:32:02 | honoree | 1 | 69583 | 4 | 1.280 | 54361.7 |
305 | 2021-03-27 08:59:45 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
304 | 2021-03-24 22:15:09 | honoree | 1 | 69583 | 4 | 1.313 | 52995.4 |
303 | 2021-02-10 10:02:23 | honoree | 1 | 69583 | 4 | 1.060 | 65644.3 |
302 | 2021-01-10 17:07:08 | honoree | 1 | 69583 | 4 | 1.080 | 64428.7 |
301 | 2020-12-14 03:19:44 | honoree | 1 | 69583 | 4 | 1.110 | 62687.4 |
300 | 2020-11-08 19:53:56 | honoree | 1 | 69583 | 4 | 1.750 | 39761.7 |
299 | 2020-10-23 23:20:46 | honoree | 1 | 69583 | 4 | 1.063 | 65459.1 |
298 | 2020-10-18 19:53:29 | honoree | 1 | 69583 | 4 | 1.250 | 55666.4 |
297 | 2020-09-11 19:32:50 | honoree | 1 | 69583 | 4 | 1.156 | 60192.9 |
296 | 2020-09-11 10:01:31 | honoree | 1 | 69583 | 4 | 1.093 | 63662.4 |
295 | 2020-09-03 19:01:56 | honoree | 1 | 69583 | 4 | 1.220 | 57035.2 |
294 | 2020-07-22 10:55:38 | honoree | 1 | 69583 | 4 | 1.143 | 60877.5 |
293 | 2020-05-23 15:15:54 | honoree | 1 | 69583 | 4 | 1.063 | 65459.1 |
292 | 2020-03-29 03:15:34 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
291 | 2020-03-28 20:46:50 | honoree | 1 | 69583 | 4 | 2.453 | 28366.5 |
290 | 2020-03-26 03:33:50 | honoree | 1 | 69583 | 4 | 1.233 | 56433.9 |
289 | 2020-03-24 14:24:40 | honoree | 1 | 69583 | 4 | 2.046 | 34009.3 |
288 | 2020-03-20 16:53:44 | honoree | 1 | 69583 | 4 | 1.046 | 66522.9 |
287 | 2020-02-23 23:35:16 | honoree | 1 | 69583 | 4 | 2.440 | 28517.6 |
286 | 2020-02-23 14:51:34 | honoree | 1 | 69583 | 4 | 1.250 | 55666.4 |
285 | 2020-02-23 11:32:45 | honoree | 1 | 69583 | 4 | 2.483 | 28023.8 |
284 | 2020-02-22 12:27:28 | honoree | 1 | 69583 | 4 | 1.373 | 50679.5 |
283 | 2020-02-21 03:27:47 | honoree | 1 | 69583 | 4 | 1.610 | 43219.3 |
282 | 2020-02-17 13:46:07 | honoree | 1 | 69583 | 4 | 1.170 | 59472.6 |
281 | 2020-02-08 21:39:30 | honoree | 1 | 69583 | 4 | 1.343 | 51811.6 |
280 | 2020-02-01 12:59:44 | honoree | 1 | 69583 | 4 | 2.186 | 31831.2 |
279 | 2020-01-26 18:53:08 | honoree | 1 | 69583 | 4 | 1.170 | 59472.6 |
278 | 2020-01-26 13:08:01 | honoree | 1 | 69583 | 4 | 1.330 | 52318.0 |
277 | 2020-01-21 19:46:26 | honoree | 1 | 69583 | 4 | 4.046 | 17198.0 |
276 | 2020-01-18 11:31:01 | honoree | 1 | 69583 | 4 | 1.313 | 52995.4 |
275 | 2020-01-14 16:50:31 | honoree | 1 | 69583 | 4 | 1.313 | 52995.4 |
274 | 2020-01-06 19:31:00 | honoree | 1 | 69583 | 4 | 1.250 | 55666.4 |
273 | 2020-01-01 07:28:57 | honoree | 1 | 69583 | 4 | 1.296 | 53690.6 |
272 | 2019-12-29 00:30:41 | honoree | 1 | 69583 | 4 | 1.360 | 51164.0 |
271 | 2019-12-28 05:00:00 | honoree | 1 | 69583 | 4 | 1.233 | 56433.9 |
270 | 2019-11-18 01:15:03 | honoree | 1 | 69583 | 4 | 1.203 | 57841.2 |
269 | 2019-08-16 11:22:43 | honoree | 1 | 69583 | 4 | 1.013 | 68690.0 |
268 | 2019-05-16 17:22:45 | honoree | 1 | 69583 | 4 | 1.066 | 65274.9 |
267 | 2019-03-13 09:07:07 | honoree | 1 | 69583 | 4 | 1.043 | 66714.3 |
266 | 2019-02-13 15:49:02 | honoree | 1 | 69583 | 4 | 1.023 | 68018.6 |
265 | 2019-02-10 04:22:23 | honoree | 1 | 69583 | 4 | 1.006 | 69168.0 |
264 | 2019-02-07 08:46:11 | honoree | 1 | 69583 | 4 | 1.016 | 68487.2 |
263 | 2019-01-13 09:21:08 | honoree | 1 | 69583 | 4 | 1.056 | 65893.0 |
262 | 2019-01-07 21:41:54 | honoree | 1 | 69583 | 4 | 1.073 | 64849.0 |
261 | 2018-12-25 09:09:46 | honoree | 1 | 69583 | 4 | 1.066 | 65274.9 |
260 | 2018-12-02 15:41:25 | honoree | 1 | 69583 | 4 | 1.010 | 68894.1 |
259 | 2018-11-30 16:24:28 | honoree | 1 | 69583 | 4 | 1.020 | 68218.6 |
258 | 2018-11-19 10:31:58 | honoree | 1 | 69583 | 4 | 1.223 | 56895.3 |