History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"rioja"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
337 | 2024-05-06 18:31:19 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
336 | 2024-05-02 17:43:07 | rioja | 2 | 53800 | 13 | 3.720 | 14462.4 |
335 | 2024-05-02 17:42:51 | rioja | 3 | 83667 | 451 | 4.360 | 19189.7 |
334 | 2024-05-02 00:43:52 | rioja | 2 | 53800 | 13 | 3.766 | 14285.7 |
333 | 2024-05-02 00:43:32 | rioja | 3 | 83667 | 451 | 9.360 | 8938.8 |
332 | 2024-05-02 00:08:18 | rioja | 2 | 53800 | 13 | 2.236 | 24060.8 |
331 | 2024-05-02 00:08:14 | rioja | 3 | 83667 | 451 | 5.533 | 15121.5 |
330 | 2024-05-02 00:08:10 | rioja | 1 | 28756 | 2 | 1.016 | 28303.1 |
329 | 2024-05-02 00:08:02 | rioja | 3 | 83667 | 451 | 6.890 | 12143.3 |
328 | 2024-05-02 00:08:06 | rioja | 2 | 53800 | 13 | 1.686 | 31909.8 |
327 | 2024-05-02 00:07:58 | rioja | 1 | 28756 | 2 | 0.563 | 51076.4 |
326 | 2024-04-30 04:53:29 | rioja | 1 | 28756 | 2 | 0.546 | 52666.7 |
325 | 2024-04-27 05:19:27 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
324 | 2024-04-25 20:24:59 | rioja | 1 | 28756 | 2 | 0.593 | 48492.4 |
323 | 2024-04-06 13:10:50 | rioja | 1 | 28756 | 2 | 1.750 | 16432.0 |
322 | 2024-03-31 18:13:14 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
321 | 2024-03-31 03:28:55 | rioja | 2 | 53800 | 13 | 4.453 | 12081.7 |
320 | 2024-03-31 03:28:30 | rioja | 3 | 83667 | 451 | 7.156 | 11691.9 |
319 | 2024-03-30 23:40:20 | rioja | 2 | 53800 | 13 | 1.826 | 29463.3 |
318 | 2024-03-30 23:40:19 | rioja | 1 | 28756 | 2 | 0.546 | 52666.7 |
317 | 2024-03-30 23:39:55 | rioja | 3 | 83667 | 451 | 7.376 | 11343.1 |
316 | 2024-03-29 23:41:56 | rioja | 3 | 83667 | 451 | 14.593 | 5733.4 |
315 | 2024-03-29 23:41:51 | rioja | 2 | 53800 | 13 | 7.423 | 7247.7 |
314 | 2024-03-28 20:52:31 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
313 | 2024-03-07 09:01:26 | rioja | 3 | 83667 | 451 | 10.563 | 7920.8 |
312 | 2024-03-07 09:01:27 | rioja | 2 | 53800 | 13 | 4.000 | 13450.0 |
311 | 2024-03-07 05:49:37 | rioja | 1 | 28756 | 2 | 0.483 | 59536.2 |
310 | 2024-03-01 13:09:18 | rioja | 1 | 28756 | 2 | 0.486 | 59168.7 |
309 | 2024-02-26 09:16:24 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
308 | 2024-02-09 13:28:39 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
307 | 2024-02-04 14:33:22 | rioja | 3 | 83667 | 451 | 4.690 | 17839.4 |
306 | 2024-02-04 03:30:43 | rioja | 2 | 53800 | 13 | 1.580 | 34050.6 |
305 | 2024-02-04 03:30:39 | rioja | 3 | 83667 | 451 | 3.826 | 21868.0 |
304 | 2024-02-04 03:30:31 | rioja | 1 | 28756 | 2 | 0.483 | 59536.2 |
303 | 2024-01-29 09:03:19 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
302 | 2024-01-26 16:45:25 | rioja | 1 | 28756 | 2 | 0.513 | 56054.6 |
301 | 2024-01-23 00:38:09 | rioja | 1 | 28756 | 2 | 0.486 | 59168.7 |
300 | 2024-01-19 10:33:03 | rioja | 2 | 53800 | 13 | 1.423 | 37807.4 |
299 | 2024-01-03 00:41:40 | rioja | 3 | 83667 | 451 | 3.703 | 22594.4 |
298 | 2023-12-28 14:37:05 | rioja | 3 | 83667 | 451 | 3.873 | 21602.6 |
297 | 2023-11-25 08:00:18 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
296 | 2023-11-18 19:36:20 | rioja | 1 | 28756 | 2 | 0.513 | 56054.6 |
295 | 2023-11-18 09:59:42 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
294 | 2023-11-14 06:01:06 | rioja | 3 | 83667 | 451 | 3.736 | 22394.8 |
293 | 2023-11-14 06:01:08 | rioja | 2 | 53800 | 13 | 1.673 | 32157.8 |
292 | 2023-10-26 19:37:30 | rioja | 1 | 28756 | 2 | 0.486 | 59168.7 |
291 | 2023-10-20 16:44:23 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
290 | 2023-10-11 16:08:32 | rioja | 1 | 28756 | 2 | 0.486 | 59168.7 |
289 | 2023-10-08 20:19:51 | rioja | 1 | 28756 | 2 | 0.436 | 65954.1 |
288 | 2023-09-26 14:11:51 | rioja | 1 | 28756 | 2 | 0.466 | 61708.2 |
287 | 2023-08-29 18:47:43 | rioja | 1 | 28756 | 2 | 0.453 | 63479.0 |
286 | 2023-04-09 15:41:22 | rioja | 1 | 28756 | 2 | 0.436 | 65954.1 |
285 | 2022-11-20 23:53:04 | rioja | 1 | 28756 | 2 | 0.483 | 59536.2 |
284 | 2022-09-19 20:47:37 | rioja | 1 | 28756 | 2 | 0.483 | 59536.2 |
283 | 2022-08-31 21:30:56 | rioja | 1 | 28756 | 2 | 0.436 | 65954.1 |
282 | 2022-08-14 19:28:43 | rioja | 1 | 28756 | 2 | 0.466 | 61708.2 |
281 | 2022-07-29 03:41:13 | rioja | 1 | 28756 | 2 | 0.546 | 52666.7 |
280 | 2022-06-22 03:15:20 | rioja | 1 | 28756 | 2 | 0.436 | 65954.1 |
279 | 2022-01-23 17:06:36 | rioja | 1 | 28756 | 2 | 0.453 | 63479.0 |
278 | 2021-09-11 18:53:31 | rioja | 1 | 28756 | 2 | 0.486 | 59168.7 |
277 | 2021-05-30 02:41:06 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
276 | 2021-05-28 23:51:08 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
275 | 2021-05-04 17:13:36 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
274 | 2021-01-29 19:39:36 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
273 | 2020-11-23 10:42:39 | rioja | 1 | 28756 | 2 | 0.440 | 65354.5 |
272 | 2020-11-17 04:56:10 | rioja | 1 | 28756 | 2 | 0.453 | 63479.0 |
271 | 2020-10-29 00:36:55 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
270 | 2020-10-22 00:06:39 | rioja | 1 | 28756 | 2 | 0.513 | 56054.6 |
269 | 2020-10-11 13:29:08 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
268 | 2020-06-16 02:05:55 | rioja | 1 | 28756 | 2 | 0.453 | 63479.0 |
267 | 2020-06-06 12:41:56 | rioja | 1 | 28756 | 2 | 0.466 | 61708.2 |
266 | 2020-03-26 00:20:25 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
265 | 2020-03-25 00:22:08 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
264 | 2020-03-23 01:08:32 | rioja | 1 | 28756 | 2 | 0.546 | 52666.7 |
263 | 2020-03-22 16:01:56 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
262 | 2020-03-21 13:07:53 | rioja | 1 | 28756 | 2 | 0.533 | 53951.2 |
261 | 2020-03-18 05:07:45 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
260 | 2020-03-13 13:11:08 | rioja | 1 | 28756 | 2 | 0.470 | 61183.0 |
259 | 2020-02-25 19:07:16 | rioja | 1 | 28756 | 2 | 0.533 | 53951.2 |
258 | 2020-02-17 17:03:24 | rioja | 1 | 28756 | 2 | 1.140 | 25224.6 |
257 | 2020-02-16 07:51:24 | rioja | 1 | 28756 | 2 | 0.453 | 63479.0 |
256 | 2020-02-06 17:52:49 | rioja | 1 | 28756 | 2 | 0.563 | 51076.4 |
255 | 2020-02-03 02:42:42 | rioja | 1 | 28756 | 2 | 1.123 | 25606.4 |
254 | 2020-02-01 08:45:20 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
253 | 2020-02-01 07:54:14 | rioja | 1 | 28756 | 2 | 0.513 | 56054.6 |
252 | 2020-01-27 19:51:52 | rioja | 1 | 28756 | 2 | 1.080 | 26625.9 |
251 | 2020-01-22 18:04:11 | rioja | 1 | 28756 | 2 | 0.546 | 52666.7 |
250 | 2020-01-14 09:14:16 | rioja | 1 | 28756 | 2 | 1.156 | 24875.4 |
249 | 2020-01-13 06:51:08 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
248 | 2020-01-11 05:36:32 | rioja | 1 | 28756 | 2 | 0.516 | 55728.7 |
247 | 2020-01-11 04:50:54 | rioja | 1 | 28756 | 2 | 0.483 | 59536.2 |
246 | 2020-01-04 01:09:21 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
245 | 2019-12-26 10:22:23 | rioja | 1 | 28756 | 2 | 0.903 | 31845.0 |
244 | 2019-12-25 13:46:50 | rioja | 1 | 28756 | 2 | 0.513 | 56054.6 |
243 | 2019-12-25 05:50:50 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
242 | 2019-12-24 07:18:09 | rioja | 1 | 28756 | 2 | 0.530 | 54256.6 |
241 | 2019-11-16 14:15:04 | rioja | 1 | 28756 | 2 | 0.500 | 57512.0 |
240 | 2019-08-15 03:05:41 | rioja | 1 | 28756 | 2 | 0.480 | 59908.3 |
239 | 2019-05-02 17:20:56 | rioja | 1 | 28756 | 2 | 0.460 | 62513.0 |
238 | 2019-02-26 09:46:55 | rioja | 1 | 28756 | 2 | 0.420 | 68466.7 |