History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"confits"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
301 | 2024-04-01 15:05:56 | confits | 1 | 69583 | 3 | 1.626 | 42794.0 |
300 | 2024-03-29 23:34:02 | confits | 1 | 69583 | 3 | 3.450 | 20169.0 |
299 | 2024-03-06 01:20:23 | confits | 2 | 107671 | 32 | 7.940 | 13560.6 |
298 | 2024-03-05 15:58:00 | confits | 3 | 134027 | 370 | 13.156 | 10187.5 |
297 | 2024-03-05 01:14:56 | confits | 3 | 134027 | 370 | 12.860 | 10422.0 |
296 | 2024-03-04 04:09:22 | confits | 3 | 134027 | 370 | 19.643 | 6823.1 |
295 | 2024-03-04 04:09:23 | confits | 2 | 107671 | 32 | 11.453 | 9401.1 |
294 | 2024-03-04 03:55:07 | confits | 2 | 107671 | 32 | 3.406 | 31612.2 |
293 | 2024-03-03 14:20:23 | confits | 2 | 107671 | 32 | 3.326 | 32372.5 |
292 | 2024-03-03 14:14:50 | confits | 3 | 134027 | 370 | 7.453 | 17983.0 |
291 | 2024-03-03 04:25:23 | confits | 3 | 134027 | 370 | 5.953 | 22514.2 |
290 | 2024-01-11 16:06:21 | confits | 3 | 134027 | 370 | 6.360 | 21073.4 |
289 | 2024-01-11 16:06:19 | confits | 2 | 107671 | 32 | 2.983 | 36094.9 |
288 | 2023-12-30 21:19:58 | confits | 1 | 69583 | 3 | 3.343 | 20814.5 |
287 | 2023-12-22 03:33:09 | confits | 1 | 69583 | 3 | 1.123 | 61961.7 |
286 | 2023-12-12 01:36:14 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
285 | 2023-12-02 00:30:25 | confits | 1 | 69583 | 3 | 1.203 | 57841.2 |
284 | 2023-11-24 00:40:56 | confits | 3 | 134027 | 370 | 5.986 | 22390.1 |
283 | 2023-11-18 23:44:29 | confits | 1 | 69583 | 3 | 1.186 | 58670.3 |
282 | 2023-11-17 00:47:52 | confits | 1 | 69583 | 3 | 1.300 | 53525.4 |
281 | 2023-10-13 15:17:10 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
280 | 2023-10-10 04:15:50 | confits | 1 | 69583 | 3 | 1.173 | 59320.5 |
279 | 2023-09-29 01:22:14 | confits | 1 | 69583 | 3 | 2.436 | 28564.4 |
278 | 2023-08-25 00:47:23 | confits | 3 | 134027 | 370 | 6.046 | 22167.9 |
277 | 2023-08-06 07:59:35 | confits | 1 | 69583 | 3 | 1.076 | 64668.2 |
276 | 2023-08-05 22:34:27 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
275 | 2023-05-08 03:39:01 | confits | 3 | 134027 | 370 | 5.796 | 23124.1 |
274 | 2023-05-01 02:40:01 | confits | 1 | 69583 | 3 | 1.203 | 57841.2 |
273 | 2023-04-28 09:13:02 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
272 | 2023-04-24 17:04:18 | confits | 1 | 69583 | 3 | 1.233 | 56433.9 |
271 | 2023-02-22 02:19:03 | confits | 1 | 69583 | 3 | 1.076 | 64668.2 |
270 | 2023-02-15 19:41:00 | confits | 3 | 134027 | 370 | 7.000 | 19146.7 |
269 | 2023-01-12 08:40:11 | confits | 1 | 69583 | 3 | 1.076 | 64668.2 |
268 | 2022-12-21 05:20:40 | confits | 1 | 69583 | 3 | 2.076 | 33517.8 |
267 | 2022-11-28 00:28:26 | confits | 3 | 134027 | 370 | 11.656 | 11498.5 |
266 | 2022-09-28 10:10:28 | confits | 1 | 69583 | 3 | 1.080 | 64428.7 |
265 | 2022-09-01 23:51:01 | confits | 1 | 69583 | 3 | 1.313 | 52995.4 |
264 | 2022-07-04 19:22:48 | confits | 3 | 134027 | 370 | 5.873 | 22820.9 |
263 | 2022-06-28 06:30:14 | confits | 2 | 107671 | 32 | 2.843 | 37872.3 |
262 | 2022-06-11 10:25:38 | confits | 1 | 69583 | 3 | 1.093 | 63662.4 |
261 | 2022-04-17 07:24:02 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
260 | 2022-02-24 09:59:31 | confits | 1 | 69583 | 3 | 1.513 | 45990.1 |
259 | 2022-02-11 17:59:35 | confits | 3 | 134027 | 370 | 5.906 | 22693.4 |
258 | 2022-01-15 03:59:14 | confits | 1 | 69583 | 3 | 1.126 | 61796.6 |
257 | 2021-11-25 22:45:29 | confits | 1 | 69583 | 3 | 1.360 | 51164.0 |
256 | 2021-11-19 14:02:08 | confits | 1 | 69583 | 3 | 1.126 | 61796.6 |
255 | 2021-11-19 06:55:41 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
254 | 2021-11-14 13:23:18 | confits | 3 | 134027 | 370 | 6.953 | 19276.1 |
253 | 2021-10-23 14:20:45 | confits | 1 | 69583 | 3 | 1.220 | 57035.2 |
252 | 2021-08-16 17:52:45 | confits | 1 | 69583 | 3 | 1.093 | 63662.4 |
251 | 2021-08-07 16:05:15 | confits | 1 | 69583 | 3 | 1.076 | 64668.2 |
250 | 2021-07-23 21:26:40 | confits | 2 | 107671 | 32 | 2.860 | 37647.2 |
249 | 2021-05-16 00:33:47 | confits | 1 | 69583 | 3 | 1.173 | 59320.5 |
248 | 2021-05-13 22:52:18 | confits | 2 | 107671 | 32 | 3.373 | 31921.4 |
247 | 2021-05-12 16:28:31 | confits | 1 | 69583 | 3 | 1.266 | 54962.9 |
246 | 2021-05-05 09:20:19 | confits | 1 | 69583 | 3 | 1.343 | 51811.6 |
245 | 2021-05-02 18:02:04 | confits | 3 | 134027 | 370 | 6.953 | 19276.1 |
244 | 2021-04-12 21:35:51 | confits | 2 | 107671 | 32 | 2.953 | 36461.6 |
243 | 2021-04-03 12:03:09 | confits | 1 | 69583 | 3 | 1.216 | 57222.9 |
242 | 2021-03-16 17:16:58 | confits | 2 | 107671 | 32 | 3.500 | 30763.1 |
241 | 2021-02-20 04:54:59 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
240 | 2021-02-11 21:47:52 | confits | 1 | 69583 | 3 | 1.326 | 52475.9 |
239 | 2021-02-08 17:13:40 | confits | 1 | 69583 | 3 | 1.106 | 62914.1 |
238 | 2021-01-26 17:40:43 | confits | 2 | 107671 | 32 | 2.966 | 36301.8 |
237 | 2021-01-15 22:18:53 | confits | 3 | 134027 | 370 | 6.033 | 22215.6 |
236 | 2020-11-11 17:13:10 | confits | 1 | 69583 | 3 | 1.143 | 60877.5 |
235 | 2020-11-07 04:02:23 | confits | 2 | 107671 | 32 | 3.483 | 30913.3 |
234 | 2020-11-06 23:13:39 | confits | 1 | 69583 | 3 | 1.126 | 61796.6 |
233 | 2020-10-27 15:51:47 | confits | 3 | 134027 | 370 | 6.343 | 21129.9 |
232 | 2020-10-21 10:33:48 | confits | 1 | 69583 | 3 | 1.096 | 63488.1 |
231 | 2020-08-28 00:52:27 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
230 | 2020-08-22 21:17:22 | confits | 1 | 69583 | 3 | 1.126 | 61796.6 |
229 | 2020-08-20 00:54:06 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
228 | 2020-08-08 08:18:40 | confits | 1 | 69583 | 3 | 1.156 | 60192.9 |
227 | 2020-08-05 16:12:01 | confits | 1 | 69583 | 3 | 1.143 | 60877.5 |
226 | 2020-05-22 17:52:22 | confits | 1 | 69583 | 3 | 1.076 | 64668.2 |
225 | 2020-05-04 04:15:34 | confits | 1 | 69583 | 3 | 1.140 | 61037.7 |
224 | 2020-03-29 01:26:09 | confits | 1 | 69583 | 3 | 2.470 | 28171.3 |
223 | 2020-03-26 09:58:21 | confits | 1 | 69583 | 3 | 1.326 | 52475.9 |
222 | 2020-03-21 14:30:04 | confits | 1 | 69583 | 3 | 1.153 | 60349.5 |
221 | 2020-02-26 04:41:34 | confits | 1 | 69583 | 3 | 1.986 | 35036.8 |
220 | 2020-02-15 06:00:45 | confits | 1 | 69583 | 3 | 2.203 | 31585.6 |
219 | 2020-02-09 22:26:33 | confits | 1 | 69583 | 3 | 1.080 | 64428.7 |
218 | 2020-02-08 21:25:24 | confits | 1 | 69583 | 3 | 1.233 | 56433.9 |
217 | 2020-02-05 02:09:30 | confits | 1 | 69583 | 3 | 2.766 | 25156.5 |
216 | 2020-02-04 01:35:40 | confits | 1 | 69583 | 3 | 2.186 | 31831.2 |
215 | 2020-02-01 23:18:41 | confits | 1 | 69583 | 3 | 1.110 | 62687.4 |
214 | 2020-01-30 10:29:52 | confits | 1 | 69583 | 3 | 1.313 | 52995.4 |
213 | 2020-01-24 03:29:31 | confits | 1 | 69583 | 3 | 2.766 | 25156.5 |
212 | 2020-01-18 03:42:46 | confits | 1 | 69583 | 3 | 1.330 | 52318.0 |
211 | 2020-01-17 14:53:40 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
210 | 2020-01-14 01:37:47 | confits | 1 | 69583 | 3 | 2.500 | 27833.2 |
209 | 2020-01-08 06:01:16 | confits | 1 | 69583 | 3 | 1.343 | 51811.6 |
208 | 2019-12-31 23:10:32 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
207 | 2019-12-29 02:24:51 | confits | 1 | 69583 | 3 | 4.123 | 16876.8 |
206 | 2019-12-29 00:25:21 | confits | 1 | 69583 | 3 | 1.296 | 53690.6 |
205 | 2019-12-28 17:49:31 | confits | 1 | 69583 | 3 | 1.343 | 51811.6 |
204 | 2019-11-01 00:07:46 | confits | 1 | 69583 | 3 | 1.096 | 63488.1 |
203 | 2019-10-28 19:42:40 | confits | 1 | 69583 | 3 | 1.250 | 55666.4 |
202 | 2019-08-10 15:15:21 | confits | 1 | 69583 | 3 | 1.023 | 68018.6 |