History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"canonry"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
273 | 2024-04-27 11:42:13 | canonry | 1 | 69583 | 2 | 2.876 | 24194.4 |
272 | 2024-03-30 20:58:49 | canonry | 1 | 69583 | 2 | 1.436 | 48456.1 |
271 | 2024-02-29 02:16:17 | canonry | 2 | 107671 | 13 | 3.376 | 31893.1 |
270 | 2024-02-29 02:16:01 | canonry | 3 | 134027 | 140 | 7.890 | 16986.9 |
269 | 2024-02-28 15:35:36 | canonry | 3 | 134027 | 140 | 12.796 | 10474.1 |
268 | 2024-02-25 14:58:55 | canonry | 3 | 134027 | 140 | 5.966 | 22465.1 |
267 | 2024-02-17 23:16:59 | canonry | 2 | 107671 | 13 | 5.236 | 20563.6 |
266 | 2024-01-21 05:48:46 | canonry | 1 | 69583 | 2 | 1.406 | 49490.0 |
265 | 2024-01-19 15:02:01 | canonry | 3 | 134027 | 140 | 6.923 | 19359.7 |
264 | 2024-01-14 03:56:00 | canonry | 2 | 107671 | 13 | 3.280 | 32826.5 |
263 | 2024-01-13 03:16:08 | canonry | 3 | 134027 | 140 | 6.813 | 19672.2 |
262 | 2024-01-12 20:30:01 | canonry | 3 | 134027 | 140 | 6.656 | 20136.3 |
261 | 2024-01-12 20:30:02 | canonry | 2 | 107671 | 13 | 3.500 | 30763.1 |
260 | 2024-01-06 07:09:15 | canonry | 2 | 107671 | 13 | 3.436 | 31336.1 |
259 | 2023-12-26 00:09:41 | canonry | 1 | 69583 | 2 | 1.156 | 60192.9 |
258 | 2023-11-27 03:43:19 | canonry | 1 | 69583 | 2 | 1.203 | 57841.2 |
257 | 2023-11-17 07:31:45 | canonry | 3 | 134027 | 140 | 6.910 | 19396.1 |
256 | 2023-11-16 21:16:32 | canonry | 1 | 69583 | 2 | 2.186 | 31831.2 |
255 | 2023-11-14 06:56:42 | canonry | 2 | 107671 | 13 | 2.876 | 37437.8 |
254 | 2023-11-05 20:05:08 | canonry | 1 | 69583 | 2 | 1.253 | 55533.1 |
253 | 2023-11-01 11:41:14 | canonry | 1 | 69583 | 2 | 1.280 | 54361.7 |
252 | 2023-10-17 01:52:37 | canonry | 1 | 69583 | 2 | 2.890 | 24077.2 |
251 | 2023-09-24 12:11:12 | canonry | 1 | 69583 | 2 | 1.533 | 45390.1 |
250 | 2023-09-17 04:25:49 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
249 | 2023-09-05 05:42:57 | canonry | 1 | 69583 | 2 | 1.283 | 54234.6 |
248 | 2023-08-18 18:36:34 | canonry | 3 | 134027 | 140 | 5.906 | 22693.4 |
247 | 2023-08-16 03:15:35 | canonry | 2 | 107671 | 13 | 2.940 | 36622.8 |
246 | 2023-08-12 05:06:07 | canonry | 1 | 69583 | 2 | 1.173 | 59320.5 |
245 | 2023-06-26 09:43:01 | canonry | 1 | 69583 | 2 | 1.076 | 64668.2 |
244 | 2023-05-04 01:39:25 | canonry | 3 | 134027 | 140 | 7.236 | 18522.2 |
243 | 2023-05-01 00:08:37 | canonry | 1 | 69583 | 2 | 1.170 | 59472.6 |
242 | 2023-04-28 17:06:29 | canonry | 2 | 107671 | 13 | 3.310 | 32529.0 |
241 | 2023-03-24 22:56:52 | canonry | 1 | 69583 | 2 | 1.096 | 63488.1 |
240 | 2023-03-24 10:46:14 | canonry | 1 | 69583 | 2 | 1.186 | 58670.3 |
239 | 2023-03-04 01:55:51 | canonry | 1 | 69583 | 2 | 1.106 | 62914.1 |
238 | 2023-02-08 18:01:56 | canonry | 3 | 134027 | 140 | 5.936 | 22578.7 |
237 | 2023-02-02 23:25:08 | canonry | 2 | 107671 | 13 | 2.860 | 37647.2 |
236 | 2023-01-10 05:49:35 | canonry | 1 | 69583 | 2 | 1.076 | 64668.2 |
235 | 2022-11-20 08:54:55 | canonry | 3 | 134027 | 140 | 7.283 | 18402.7 |
234 | 2022-11-14 21:01:07 | canonry | 2 | 107671 | 13 | 3.390 | 31761.4 |
233 | 2022-11-11 17:07:00 | canonry | 1 | 69583 | 2 | 1.220 | 57035.2 |
232 | 2022-10-12 10:41:44 | canonry | 1 | 69583 | 2 | 1.250 | 55666.4 |
231 | 2022-09-01 19:13:40 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
230 | 2022-07-22 13:28:04 | canonry | 1 | 69583 | 2 | 1.076 | 64668.2 |
229 | 2022-06-23 04:54:32 | canonry | 3 | 134027 | 140 | 6.780 | 19768.0 |
228 | 2022-06-17 01:18:16 | canonry | 2 | 107671 | 13 | 3.140 | 34290.1 |
227 | 2022-06-01 03:48:29 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
226 | 2022-05-29 22:10:39 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
225 | 2022-03-31 17:40:13 | canonry | 1 | 69583 | 2 | 1.236 | 56296.9 |
224 | 2022-02-24 02:31:51 | canonry | 1 | 69583 | 2 | 1.810 | 38443.6 |
223 | 2021-09-03 10:55:00 | canonry | 1 | 69583 | 2 | 1.096 | 63488.1 |
222 | 2021-07-05 00:36:28 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
221 | 2021-06-03 01:17:36 | canonry | 1 | 69583 | 2 | 1.266 | 54962.9 |
220 | 2021-06-02 13:56:55 | canonry | 1 | 69583 | 2 | 1.233 | 56433.9 |
219 | 2021-05-08 19:52:20 | canonry | 1 | 69583 | 2 | 1.580 | 44039.9 |
218 | 2021-04-29 05:49:12 | canonry | 3 | 134027 | 140 | 6.780 | 19768.0 |
217 | 2021-02-27 22:28:02 | canonry | 1 | 69583 | 2 | 1.266 | 54962.9 |
216 | 2021-02-15 03:25:32 | canonry | 1 | 69583 | 2 | 1.123 | 61961.7 |
215 | 2021-01-12 15:43:03 | canonry | 3 | 134027 | 140 | 7.656 | 17506.1 |
214 | 2020-11-18 15:11:47 | canonry | 1 | 69583 | 2 | 2.203 | 31585.6 |
213 | 2020-11-18 05:43:36 | canonry | 3 | 134027 | 140 | 6.076 | 22058.4 |
212 | 2020-10-28 07:14:11 | canonry | 3 | 134027 | 140 | 19.830 | 6758.8 |
211 | 2020-10-25 18:50:28 | canonry | 1 | 69583 | 2 | 1.220 | 57035.2 |
210 | 2020-10-21 19:44:23 | canonry | 1 | 69583 | 2 | 1.170 | 59472.6 |
209 | 2020-10-07 16:04:50 | canonry | 1 | 69583 | 2 | 1.313 | 52995.4 |
208 | 2020-09-02 17:28:39 | canonry | 1 | 69583 | 2 | 1.156 | 60192.9 |
207 | 2020-08-29 01:04:24 | canonry | 1 | 69583 | 2 | 1.236 | 56296.9 |
206 | 2020-08-12 17:37:41 | canonry | 1 | 69583 | 2 | 1.330 | 52318.0 |
205 | 2020-08-12 13:34:41 | canonry | 1 | 69583 | 2 | 1.266 | 54962.9 |
204 | 2020-08-09 14:09:52 | canonry | 1 | 69583 | 2 | 1.360 | 51164.0 |
203 | 2020-07-24 14:01:30 | canonry | 1 | 69583 | 2 | 1.203 | 57841.2 |
202 | 2020-05-18 11:26:35 | canonry | 1 | 69583 | 2 | 1.216 | 57222.9 |
201 | 2020-05-11 11:11:32 | canonry | 1 | 69583 | 2 | 1.110 | 62687.4 |
200 | 2020-03-29 13:23:54 | canonry | 1 | 69583 | 2 | 1.313 | 52995.4 |
199 | 2020-03-29 06:54:33 | canonry | 1 | 69583 | 2 | 1.170 | 59472.6 |
198 | 2020-03-25 17:50:02 | canonry | 1 | 69583 | 2 | 1.263 | 55093.4 |
197 | 2020-03-24 22:09:54 | canonry | 1 | 69583 | 2 | 1.233 | 56433.9 |
196 | 2020-03-21 03:35:59 | canonry | 1 | 69583 | 2 | 1.220 | 57035.2 |
195 | 2020-03-05 07:37:56 | canonry | 1 | 69583 | 2 | 1.326 | 52475.9 |
194 | 2020-03-05 05:43:09 | canonry | 1 | 69583 | 2 | 1.126 | 61796.6 |
193 | 2020-02-23 12:02:23 | canonry | 1 | 69583 | 2 | 1.280 | 54361.7 |
192 | 2020-02-22 18:58:11 | canonry | 1 | 69583 | 2 | 1.953 | 35628.8 |
191 | 2020-02-14 05:06:50 | canonry | 3 | 134027 | 140 | 23.813 | 5628.3 |
190 | 2020-02-13 20:47:07 | canonry | 2 | 107671 | 13 | 3.673 | 29314.2 |
189 | 2020-02-13 09:19:13 | canonry | 3 | 134027 | 140 | 15.610 | 8586.0 |
188 | 2020-02-13 05:17:56 | canonry | 3 | 134027 | 140 | 10.126 | 13235.9 |
187 | 2020-02-12 22:42:48 | canonry | 1 | 69583 | 2 | 1.326 | 52475.9 |
186 | 2020-02-12 20:45:53 | canonry | 1 | 69583 | 2 | 1.940 | 35867.5 |
185 | 2020-02-08 20:17:25 | canonry | 1 | 69583 | 2 | 1.280 | 54361.7 |
184 | 2020-02-07 00:03:20 | canonry | 1 | 69583 | 2 | 2.313 | 30083.4 |
183 | 2020-02-04 23:11:23 | canonry | 1 | 69583 | 2 | 1.390 | 50059.7 |
182 | 2020-01-30 19:04:47 | canonry | 1 | 69583 | 2 | 1.296 | 53690.6 |
181 | 2020-01-26 22:09:43 | canonry | 1 | 69583 | 2 | 1.250 | 55666.4 |
180 | 2020-01-25 17:33:06 | canonry | 1 | 69583 | 2 | 3.656 | 19032.5 |
179 | 2020-01-22 12:42:20 | canonry | 3 | 134027 | 140 | 8.766 | 15289.4 |
178 | 2020-01-21 17:11:07 | canonry | 1 | 69583 | 2 | 1.686 | 41271.1 |
177 | 2020-01-21 00:25:22 | canonry | 1 | 69583 | 2 | 2.686 | 25905.8 |
176 | 2020-01-15 17:28:08 | canonry | 3 | 134027 | 140 | 7.156 | 18729.3 |
175 | 2020-01-15 17:27:33 | canonry | 2 | 107671 | 13 | 5.830 | 18468.4 |
174 | 2020-01-15 12:35:19 | canonry | 1 | 69583 | 2 | 1.513 | 45990.1 |