History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"dollars"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
335 | 2024-04-25 05:00:31 | dollars | 1 | 69583 | 3 | 3.860 | 18026.7 |
334 | 2024-04-19 12:23:36 | dollars | 1 | 69583 | 3 | 1.606 | 43326.9 |
333 | 2024-03-28 23:47:11 | dollars | 1 | 69583 | 3 | 4.060 | 17138.7 |
332 | 2024-03-20 19:29:29 | dollars | 2 | 107671 | 37 | 3.610 | 29825.8 |
331 | 2024-03-20 19:29:17 | dollars | 3 | 134027 | 369 | 9.250 | 14489.4 |
330 | 2024-03-20 19:28:51 | dollars | 1 | 69583 | 3 | 1.936 | 35941.6 |
329 | 2024-03-10 13:02:18 | dollars | 3 | 134027 | 369 | 20.203 | 6634.0 |
328 | 2024-03-08 23:55:53 | dollars | 3 | 134027 | 369 | 23.033 | 5818.9 |
327 | 2024-03-07 20:17:16 | dollars | 2 | 107671 | 37 | 4.970 | 21664.2 |
326 | 2024-03-07 20:16:35 | dollars | 3 | 134027 | 369 | 7.003 | 19138.5 |
325 | 2024-03-07 14:31:08 | dollars | 3 | 134027 | 369 | 10.110 | 13256.9 |
324 | 2024-03-07 14:31:09 | dollars | 2 | 107671 | 37 | 3.623 | 29718.7 |
323 | 2024-03-07 12:54:22 | dollars | 1 | 69583 | 3 | 1.170 | 59472.6 |
322 | 2024-02-23 22:46:41 | dollars | 1 | 69583 | 3 | 1.360 | 51164.0 |
321 | 2024-02-22 09:58:47 | dollars | 2 | 107671 | 37 | 3.280 | 32826.5 |
320 | 2024-02-22 09:58:25 | dollars | 3 | 134027 | 369 | 7.236 | 18522.2 |
319 | 2024-02-19 18:04:03 | dollars | 3 | 134027 | 369 | 11.046 | 12133.5 |
318 | 2024-02-19 18:04:04 | dollars | 2 | 107671 | 37 | 3.906 | 27565.5 |
317 | 2024-02-19 17:44:40 | dollars | 1 | 69583 | 3 | 1.156 | 60192.9 |
316 | 2024-01-20 14:41:08 | dollars | 1 | 69583 | 3 | 1.076 | 64668.2 |
315 | 2023-12-10 00:03:40 | dollars | 3 | 134027 | 369 | 6.750 | 19855.9 |
314 | 2023-12-07 15:20:22 | dollars | 1 | 69583 | 3 | 1.126 | 61796.6 |
313 | 2023-12-07 15:20:20 | dollars | 1 | 69583 | 3 | 1.266 | 54962.9 |
312 | 2023-12-05 22:50:38 | dollars | 1 | 69583 | 3 | 1.216 | 57222.9 |
311 | 2023-12-05 20:52:10 | dollars | 2 | 107671 | 37 | 3.470 | 31029.1 |
310 | 2023-12-02 18:49:26 | dollars | 3 | 134027 | 369 | 7.110 | 18850.5 |
309 | 2023-11-27 19:45:49 | dollars | 1 | 69583 | 3 | 1.266 | 54962.9 |
308 | 2023-11-21 00:11:37 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
307 | 2023-11-02 23:20:29 | dollars | 1 | 69583 | 3 | 1.076 | 64668.2 |
306 | 2023-10-27 11:08:10 | dollars | 3 | 134027 | 369 | 6.343 | 21129.9 |
305 | 2023-10-27 11:07:59 | dollars | 2 | 107671 | 37 | 3.250 | 33129.5 |
304 | 2023-10-25 12:46:47 | dollars | 1 | 69583 | 3 | 1.296 | 53690.6 |
303 | 2023-10-21 00:27:25 | dollars | 1 | 69583 | 3 | 1.126 | 61796.6 |
302 | 2023-10-13 10:27:59 | dollars | 1 | 69583 | 3 | 2.203 | 31585.6 |
301 | 2023-09-24 23:08:11 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
300 | 2023-09-20 04:51:56 | dollars | 1 | 69583 | 3 | 1.186 | 58670.3 |
299 | 2023-09-17 03:10:12 | dollars | 1 | 69583 | 3 | 1.483 | 46920.4 |
298 | 2023-07-22 10:13:43 | dollars | 1 | 69583 | 3 | 1.060 | 65644.3 |
297 | 2023-07-12 19:19:30 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
296 | 2023-04-20 08:47:40 | dollars | 1 | 69583 | 3 | 1.250 | 55666.4 |
295 | 2023-04-10 18:33:22 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
294 | 2023-02-08 04:52:40 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
293 | 2023-01-27 23:18:57 | dollars | 1 | 69583 | 3 | 1.046 | 66522.9 |
292 | 2023-01-01 20:18:53 | dollars | 1 | 69583 | 3 | 1.173 | 59320.5 |
291 | 2022-12-13 05:30:47 | dollars | 1 | 69583 | 3 | 1.203 | 57841.2 |
290 | 2022-12-06 03:50:27 | dollars | 1 | 69583 | 3 | 1.033 | 67360.1 |
289 | 2022-11-07 17:14:59 | dollars | 1 | 69583 | 3 | 1.186 | 58670.3 |
288 | 2022-09-21 22:06:00 | dollars | 1 | 69583 | 3 | 1.050 | 66269.5 |
287 | 2022-09-12 05:03:33 | dollars | 1 | 69583 | 3 | 1.423 | 48898.8 |
286 | 2022-08-06 21:51:20 | dollars | 1 | 69583 | 3 | 1.310 | 53116.8 |
285 | 2022-08-02 17:05:57 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
284 | 2022-07-31 10:00:26 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
283 | 2022-07-05 23:51:38 | dollars | 1 | 69583 | 3 | 1.313 | 52995.4 |
282 | 2022-07-03 08:35:45 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
281 | 2022-06-16 08:34:24 | dollars | 1 | 69583 | 3 | 1.110 | 62687.4 |
280 | 2022-06-15 16:40:57 | dollars | 1 | 69583 | 3 | 1.203 | 57841.2 |
279 | 2022-06-08 12:28:36 | dollars | 1 | 69583 | 3 | 1.173 | 59320.5 |
278 | 2022-06-04 21:13:28 | dollars | 1 | 69583 | 3 | 1.060 | 65644.3 |
277 | 2022-03-04 07:40:53 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
276 | 2022-02-25 01:40:42 | dollars | 1 | 69583 | 3 | 1.046 | 66522.9 |
275 | 2021-12-21 02:53:46 | dollars | 1 | 69583 | 3 | 1.250 | 55666.4 |
274 | 2021-12-09 00:01:49 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
273 | 2021-11-20 05:27:44 | dollars | 1 | 69583 | 3 | 1.110 | 62687.4 |
272 | 2021-10-28 03:10:01 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
271 | 2021-09-24 03:56:39 | dollars | 1 | 69583 | 3 | 1.203 | 57841.2 |
270 | 2021-09-12 01:42:02 | dollars | 1 | 69583 | 3 | 1.393 | 49951.9 |
269 | 2021-08-23 07:21:11 | dollars | 1 | 69583 | 3 | 1.076 | 64668.2 |
268 | 2021-08-21 02:03:55 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
267 | 2021-08-20 15:36:40 | dollars | 1 | 69583 | 3 | 1.093 | 63662.4 |
266 | 2021-05-30 04:46:20 | dollars | 3 | 134027 | 369 | 6.703 | 19995.1 |
265 | 2021-05-23 05:26:39 | dollars | 1 | 69583 | 3 | 1.093 | 63662.4 |
264 | 2021-05-20 00:50:14 | dollars | 1 | 69583 | 3 | 1.110 | 62687.4 |
263 | 2021-04-24 09:40:03 | dollars | 1 | 69583 | 3 | 1.236 | 56296.9 |
262 | 2021-03-28 19:24:16 | dollars | 2 | 107671 | 37 | 2.940 | 36622.8 |
261 | 2021-03-26 08:37:51 | dollars | 1 | 69583 | 3 | 1.063 | 65459.1 |
260 | 2021-02-17 06:06:26 | dollars | 1 | 69583 | 3 | 1.140 | 61037.7 |
259 | 2021-02-04 12:49:41 | dollars | 1 | 69583 | 3 | 1.233 | 56433.9 |
258 | 2021-01-12 13:42:25 | dollars | 2 | 107671 | 37 | 3.093 | 34811.2 |
257 | 2020-12-13 22:55:17 | dollars | 3 | 134027 | 369 | 6.343 | 21129.9 |
256 | 2020-11-12 23:49:04 | dollars | 1 | 69583 | 3 | 1.060 | 65644.3 |
255 | 2020-10-24 20:18:38 | dollars | 2 | 107671 | 37 | 2.826 | 38100.1 |
254 | 2020-10-09 22:46:45 | dollars | 1 | 69583 | 3 | 1.046 | 66522.9 |
253 | 2020-09-06 21:16:30 | dollars | 1 | 69583 | 3 | 1.233 | 56433.9 |
252 | 2020-08-31 17:47:48 | dollars | 1 | 69583 | 3 | 1.143 | 60877.5 |
251 | 2020-08-26 15:33:10 | dollars | 1 | 69583 | 3 | 1.093 | 63662.4 |
250 | 2020-08-09 05:45:40 | dollars | 1 | 69583 | 3 | 1.110 | 62687.4 |
249 | 2020-08-08 22:50:35 | dollars | 1 | 69583 | 3 | 1.123 | 61961.7 |
248 | 2020-08-05 15:28:54 | dollars | 1 | 69583 | 3 | 1.110 | 62687.4 |
247 | 2020-08-02 09:54:21 | dollars | 1 | 69583 | 3 | 1.140 | 61037.7 |
246 | 2020-08-01 20:52:14 | dollars | 1 | 69583 | 3 | 1.093 | 63662.4 |
245 | 2020-08-01 17:11:17 | dollars | 1 | 69583 | 3 | 1.093 | 63662.4 |
244 | 2020-08-01 01:26:23 | dollars | 1 | 69583 | 3 | 1.126 | 61796.6 |
243 | 2020-05-08 00:28:23 | dollars | 1 | 69583 | 3 | 1.076 | 64668.2 |
242 | 2020-04-21 21:05:30 | dollars | 1 | 69583 | 3 | 1.123 | 61961.7 |
241 | 2020-04-19 04:58:36 | dollars | 3 | 134027 | 369 | 6.000 | 22337.8 |
240 | 2020-04-18 06:22:15 | dollars | 1 | 69583 | 3 | 1.096 | 63488.1 |
239 | 2020-04-17 06:27:59 | dollars | 1 | 69583 | 3 | 1.076 | 64668.2 |
238 | 2020-04-16 07:04:53 | dollars | 1 | 69583 | 3 | 1.080 | 64428.7 |
237 | 2020-03-28 04:04:02 | dollars | 1 | 69583 | 3 | 1.220 | 57035.2 |
236 | 2020-03-26 19:36:37 | dollars | 1 | 69583 | 3 | 1.250 | 55666.4 |