History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"primary"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
261 | 2024-03-29 00:25:01 | primary | 1 | 69583 | 2 | 4.266 | 16311.1 |
260 | 2024-02-27 21:25:41 | primary | 1 | 69583 | 2 | 1.296 | 53690.6 |
259 | 2024-02-15 08:29:59 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
258 | 2024-01-01 02:38:31 | primary | 2 | 107671 | 22 | 2.813 | 38276.2 |
257 | 2023-12-19 00:17:06 | primary | 1 | 69583 | 2 | 1.110 | 62687.4 |
256 | 2023-12-10 16:18:48 | primary | 1 | 69583 | 2 | 1.060 | 65644.3 |
255 | 2023-12-02 15:14:17 | primary | 1 | 69583 | 2 | 1.063 | 65459.1 |
254 | 2023-11-20 00:10:18 | primary | 1 | 69583 | 2 | 1.110 | 62687.4 |
253 | 2023-11-06 11:33:33 | primary | 1 | 69583 | 2 | 1.060 | 65644.3 |
252 | 2023-11-02 04:36:19 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
251 | 2023-10-15 02:14:35 | primary | 1 | 69583 | 2 | 1.216 | 57222.9 |
250 | 2023-10-06 22:49:42 | primary | 2 | 107671 | 22 | 6.546 | 16448.4 |
249 | 2023-10-05 17:42:43 | primary | 1 | 69583 | 2 | 1.096 | 63488.1 |
248 | 2023-09-26 09:44:43 | primary | 1 | 69583 | 2 | 1.186 | 58670.3 |
247 | 2023-09-17 13:14:44 | primary | 1 | 69583 | 2 | 1.140 | 61037.7 |
246 | 2023-09-14 19:33:09 | primary | 1 | 69583 | 2 | 1.173 | 59320.5 |
245 | 2023-07-18 09:52:16 | primary | 2 | 107671 | 22 | 3.236 | 33272.9 |
244 | 2023-07-10 21:33:18 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
243 | 2023-06-20 04:55:33 | primary | 1 | 69583 | 2 | 1.110 | 62687.4 |
242 | 2023-05-01 17:29:27 | primary | 1 | 69583 | 2 | 1.063 | 65459.1 |
241 | 2023-04-22 20:22:02 | primary | 1 | 69583 | 2 | 1.063 | 65459.1 |
240 | 2023-04-15 20:16:40 | primary | 1 | 69583 | 2 | 1.043 | 66714.3 |
239 | 2023-04-01 16:33:32 | primary | 2 | 107671 | 22 | 2.923 | 36835.8 |
238 | 2023-03-19 20:05:31 | primary | 1 | 69583 | 2 | 1.060 | 65644.3 |
237 | 2023-02-07 22:34:26 | primary | 1 | 69583 | 2 | 1.046 | 66522.9 |
236 | 2022-12-28 18:42:11 | primary | 2 | 107671 | 22 | 3.360 | 32044.9 |
235 | 2022-12-07 04:29:11 | primary | 1 | 69583 | 2 | 1.046 | 66522.9 |
234 | 2022-09-10 19:11:04 | primary | 1 | 69583 | 2 | 1.220 | 57035.2 |
233 | 2022-08-29 04:49:23 | primary | 2 | 107671 | 22 | 3.313 | 32499.5 |
232 | 2022-08-26 08:21:14 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
231 | 2022-08-09 10:54:47 | primary | 1 | 69583 | 2 | 1.063 | 65459.1 |
230 | 2022-08-07 22:28:52 | primary | 1 | 69583 | 2 | 1.170 | 59472.6 |
229 | 2022-08-01 02:46:25 | primary | 1 | 69583 | 2 | 1.093 | 63662.4 |
228 | 2022-07-12 10:46:01 | primary | 3 | 134027 | 157 | 5.873 | 22820.9 |
227 | 2022-04-03 21:47:13 | primary | 1 | 69583 | 2 | 1.186 | 58670.3 |
226 | 2022-01-20 12:40:43 | primary | 1 | 69583 | 2 | 1.203 | 57841.2 |
225 | 2021-08-11 07:21:14 | primary | 1 | 69583 | 2 | 1.080 | 64428.7 |
224 | 2021-07-23 12:30:54 | primary | 2 | 107671 | 22 | 2.796 | 38508.9 |
223 | 2021-07-01 07:31:04 | primary | 3 | 134027 | 157 | 5.923 | 22628.2 |
222 | 2021-06-06 10:16:30 | primary | 1 | 69583 | 2 | 1.186 | 58670.3 |
221 | 2021-05-29 02:55:28 | primary | 3 | 134027 | 157 | 7.046 | 19021.7 |
220 | 2021-05-13 08:55:00 | primary | 2 | 107671 | 22 | 2.830 | 38046.3 |
219 | 2021-05-12 11:05:12 | primary | 1 | 69583 | 2 | 1.236 | 56296.9 |
218 | 2021-05-08 12:30:43 | primary | 3 | 134027 | 157 | 8.486 | 15793.9 |
217 | 2021-04-12 15:27:14 | primary | 3 | 134027 | 157 | 12.593 | 10643.0 |
216 | 2021-04-11 06:24:02 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
215 | 2021-02-19 11:35:05 | primary | 3 | 134027 | 157 | 6.656 | 20136.3 |
214 | 2021-01-25 08:53:14 | primary | 2 | 107671 | 22 | 2.830 | 38046.3 |
213 | 2020-12-27 18:38:14 | primary | 1 | 69583 | 2 | 1.093 | 63662.4 |
212 | 2020-11-05 15:33:32 | primary | 2 | 107671 | 22 | 2.936 | 36672.7 |
211 | 2020-11-02 04:08:43 | primary | 3 | 134027 | 157 | 12.330 | 10870.0 |
210 | 2020-10-26 10:39:04 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
209 | 2020-10-24 06:08:58 | primary | 1 | 69583 | 2 | 1.236 | 56296.9 |
208 | 2020-10-21 17:52:41 | primary | 1 | 69583 | 2 | 1.610 | 43219.3 |
207 | 2020-10-17 00:00:55 | primary | 1 | 69583 | 2 | 1.046 | 66522.9 |
206 | 2020-10-11 11:33:52 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
205 | 2020-03-29 21:39:23 | primary | 1 | 69583 | 2 | 1.296 | 53690.6 |
204 | 2020-03-24 11:41:49 | primary | 1 | 69583 | 2 | 1.330 | 52318.0 |
203 | 2020-03-23 19:00:18 | primary | 1 | 69583 | 2 | 1.203 | 57841.2 |
202 | 2020-03-21 01:36:37 | primary | 1 | 69583 | 2 | 1.170 | 59472.6 |
201 | 2020-03-13 07:25:22 | primary | 1 | 69583 | 2 | 1.093 | 63662.4 |
200 | 2020-03-01 01:48:31 | primary | 3 | 134027 | 157 | 8.233 | 16279.2 |
199 | 2020-02-29 07:12:01 | primary | 3 | 134027 | 157 | 9.750 | 13746.4 |
198 | 2020-02-29 06:22:39 | primary | 1 | 69583 | 2 | 1.953 | 35628.8 |
197 | 2020-02-29 04:06:06 | primary | 3 | 134027 | 157 | 7.643 | 17535.9 |
196 | 2020-02-28 23:47:59 | primary | 3 | 134027 | 157 | 13.783 | 9724.1 |
195 | 2020-02-28 19:28:18 | primary | 3 | 134027 | 157 | 7.686 | 17437.8 |
194 | 2020-02-28 17:18:15 | primary | 3 | 134027 | 157 | 11.050 | 12129.1 |
193 | 2020-02-21 13:32:41 | primary | 1 | 69583 | 2 | 1.360 | 51164.0 |
192 | 2020-02-11 09:27:34 | primary | 1 | 69583 | 2 | 2.766 | 25156.5 |
191 | 2020-02-10 02:08:48 | primary | 1 | 69583 | 2 | 1.330 | 52318.0 |
190 | 2020-02-05 19:40:18 | primary | 1 | 69583 | 2 | 2.763 | 25183.9 |
189 | 2020-02-03 22:43:58 | primary | 1 | 69583 | 2 | 2.800 | 24851.1 |
188 | 2020-02-02 20:54:46 | primary | 1 | 69583 | 2 | 1.470 | 47335.4 |
187 | 2020-01-25 00:10:22 | primary | 1 | 69583 | 2 | 1.420 | 49002.1 |
186 | 2020-01-17 19:49:36 | primary | 1 | 69583 | 2 | 1.390 | 50059.7 |
185 | 2020-01-17 00:22:37 | primary | 1 | 69583 | 2 | 1.076 | 64668.2 |
184 | 2020-01-13 21:17:04 | primary | 3 | 134027 | 157 | 7.843 | 17088.7 |
183 | 2020-01-13 21:10:42 | primary | 3 | 134027 | 157 | 14.953 | 8963.2 |
182 | 2020-01-13 14:56:23 | primary | 3 | 134027 | 157 | 16.593 | 8077.3 |
181 | 2020-01-13 14:56:15 | primary | 2 | 107671 | 22 | 7.796 | 13811.1 |
180 | 2020-01-13 13:33:02 | primary | 1 | 69583 | 2 | 2.796 | 24886.6 |
179 | 2020-01-04 00:53:19 | primary | 1 | 69583 | 2 | 1.110 | 62687.4 |
178 | 2020-01-01 19:41:46 | primary | 1 | 69583 | 2 | 1.893 | 36758.1 |
177 | 2019-12-27 05:01:58 | primary | 1 | 69583 | 2 | 1.406 | 49490.0 |
176 | 2019-12-27 04:15:17 | primary | 1 | 69583 | 2 | 1.296 | 53690.6 |
175 | 2019-12-26 22:16:31 | primary | 1 | 69583 | 2 | 1.326 | 52475.9 |
174 | 2019-12-10 09:47:59 | primary | 1 | 69583 | 2 | 1.186 | 58670.3 |
173 | 2019-09-11 15:49:05 | primary | 1 | 69583 | 2 | 1.180 | 58968.6 |
172 | 2019-08-17 00:43:23 | primary | 1 | 69583 | 2 | 1.166 | 59676.7 |
171 | 2019-08-03 00:10:01 | primary | 1 | 69583 | 2 | 1.036 | 67165.1 |
170 | 2019-06-11 23:29:57 | primary | 1 | 69583 | 2 | 1.216 | 57222.9 |
169 | 2019-05-25 14:04:09 | primary | 3 | 134027 | 157 | 6.053 | 22142.2 |
168 | 2019-03-13 02:26:11 | primary | 2 | 107671 | 22 | 3.140 | 34290.1 |
167 | 2019-03-02 17:03:07 | primary | 1 | 69583 | 2 | 1.040 | 66906.7 |
166 | 2019-03-01 12:11:10 | primary | 1 | 69583 | 2 | 1.043 | 66714.3 |
165 | 2019-02-14 05:06:17 | primary | 1 | 69583 | 2 | 1.046 | 66522.9 |
164 | 2019-02-07 05:57:40 | primary | 1 | 69583 | 2 | 1.226 | 56756.1 |
163 | 2019-01-31 05:46:42 | primary | 1 | 69583 | 2 | 1.160 | 59985.3 |
162 | 2019-01-26 06:23:17 | primary | 1 | 69583 | 2 | 1.290 | 53940.3 |