History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preferrer"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-05-12 05:50:19 | preferrer | 1 | 81242 | 4 | 3.250 | 24997.5 |
275 | 2024-05-04 01:19:57 | preferrer | 4 | 165329 | 420 | 28.160 | 5871.1 |
274 | 2024-05-03 11:04:46 | preferrer | 4 | 165329 | 420 | 38.503 | 4293.9 |
273 | 2024-05-03 08:45:40 | preferrer | 4 | 165329 | 420 | 15.986 | 10342.1 |
272 | 2024-05-03 08:45:43 | preferrer | 3 | 148641 | 50 | 8.643 | 17197.8 |
271 | 2024-05-03 08:45:47 | preferrer | 2 | 121436 | 9 | 4.343 | 27961.3 |
270 | 2024-05-03 04:23:28 | preferrer | 1 | 81242 | 4 | 4.170 | 19482.5 |
269 | 2024-04-28 22:13:31 | preferrer | 1 | 81242 | 4 | 1.470 | 55266.7 |
268 | 2024-04-28 21:30:57 | preferrer | 1 | 81242 | 4 | 3.046 | 26671.7 |
267 | 2024-04-08 17:06:59 | preferrer | 1 | 81242 | 4 | 5.826 | 13944.7 |
266 | 2024-03-29 20:48:07 | preferrer | 1 | 81242 | 4 | 1.436 | 56575.2 |
265 | 2024-03-06 03:56:04 | preferrer | 1 | 81242 | 4 | 4.610 | 17623.0 |
264 | 2024-03-05 13:24:56 | preferrer | 1 | 81242 | 4 | 1.406 | 57782.4 |
263 | 2024-02-28 12:30:06 | preferrer | 1 | 81242 | 4 | 1.343 | 60492.9 |
262 | 2024-02-27 05:13:29 | preferrer | 1 | 81242 | 4 | 1.436 | 56575.2 |
261 | 2024-01-31 11:33:07 | preferrer | 1 | 81242 | 4 | 1.330 | 61084.2 |
260 | 2024-01-29 07:46:42 | preferrer | 1 | 81242 | 4 | 1.296 | 62686.7 |
259 | 2023-12-26 11:08:31 | preferrer | 1 | 81242 | 4 | 1.406 | 57782.4 |
258 | 2023-12-25 13:53:04 | preferrer | 1 | 81242 | 4 | 1.250 | 64993.6 |
257 | 2023-12-21 13:37:39 | preferrer | 3 | 148641 | 50 | 6.953 | 21378.0 |
256 | 2023-12-21 13:37:31 | preferrer | 4 | 165329 | 420 | 11.720 | 14106.6 |
255 | 2023-12-21 13:37:24 | preferrer | 2 | 121436 | 9 | 3.436 | 35342.3 |
254 | 2023-11-26 18:27:51 | preferrer | 1 | 81242 | 4 | 1.263 | 64324.6 |
253 | 2023-11-12 13:20:07 | preferrer | 1 | 81242 | 4 | 1.330 | 61084.2 |
252 | 2023-10-31 00:36:58 | preferrer | 1 | 81242 | 4 | 1.483 | 54782.2 |
251 | 2023-09-12 13:24:39 | preferrer | 1 | 81242 | 4 | 1.563 | 51978.2 |
250 | 2023-06-21 07:00:11 | preferrer | 1 | 81242 | 4 | 1.376 | 59042.2 |
249 | 2023-04-02 05:11:30 | preferrer | 1 | 81242 | 4 | 1.360 | 59736.8 |
248 | 2023-01-14 20:15:33 | preferrer | 1 | 81242 | 4 | 1.343 | 60492.9 |
247 | 2022-11-03 00:10:21 | preferrer | 1 | 81242 | 4 | 1.233 | 65889.7 |
246 | 2022-06-22 07:11:54 | preferrer | 1 | 81242 | 4 | 1.263 | 64324.6 |
245 | 2022-02-27 12:01:18 | preferrer | 1 | 81242 | 4 | 1.420 | 57212.7 |
244 | 2021-12-14 08:35:18 | preferrer | 1 | 81242 | 4 | 1.750 | 46424.0 |
243 | 2021-10-19 11:58:07 | preferrer | 1 | 81242 | 4 | 1.266 | 64172.2 |
242 | 2021-09-20 04:30:12 | preferrer | 1 | 81242 | 4 | 1.546 | 52549.8 |
241 | 2021-06-19 19:12:54 | preferrer | 3 | 148641 | 50 | 6.983 | 21286.1 |
240 | 2021-05-23 07:56:48 | preferrer | 3 | 148641 | 50 | 7.283 | 20409.3 |
239 | 2021-05-22 21:42:44 | preferrer | 3 | 148641 | 50 | 7.466 | 19909.1 |
238 | 2021-05-22 10:27:44 | preferrer | 3 | 148641 | 50 | 7.343 | 20242.5 |
237 | 2021-05-21 18:55:06 | preferrer | 3 | 148641 | 50 | 6.173 | 24079.2 |
236 | 2021-05-18 20:11:25 | preferrer | 3 | 148641 | 50 | 6.813 | 21817.3 |
235 | 2021-05-17 14:17:57 | preferrer | 3 | 148641 | 50 | 6.140 | 24208.6 |
234 | 2021-05-17 12:25:34 | preferrer | 3 | 148641 | 50 | 7.000 | 21234.4 |
233 | 2021-05-16 18:04:40 | preferrer | 3 | 148641 | 50 | 6.140 | 24208.6 |
232 | 2021-05-14 05:09:15 | preferrer | 3 | 148641 | 50 | 8.456 | 17578.2 |
231 | 2021-05-13 17:17:57 | preferrer | 3 | 148641 | 50 | 7.876 | 18872.7 |
230 | 2021-05-12 19:21:54 | preferrer | 3 | 148641 | 50 | 7.390 | 20113.8 |
229 | 2021-05-11 02:26:34 | preferrer | 3 | 148641 | 50 | 6.940 | 21418.0 |
228 | 2021-05-10 05:11:29 | preferrer | 3 | 148641 | 50 | 8.000 | 18580.1 |
227 | 2021-05-09 08:31:19 | preferrer | 3 | 148641 | 50 | 6.703 | 22175.3 |
226 | 2021-05-08 17:44:53 | preferrer | 3 | 148641 | 50 | 7.093 | 20956.0 |
225 | 2021-05-05 15:03:13 | preferrer | 3 | 148641 | 50 | 7.826 | 18993.2 |
224 | 2021-05-05 12:24:05 | preferrer | 3 | 148641 | 50 | 6.936 | 21430.4 |
223 | 2021-05-04 22:32:45 | preferrer | 3 | 148641 | 50 | 7.940 | 18720.5 |
222 | 2021-05-04 08:20:36 | preferrer | 3 | 148641 | 50 | 7.860 | 18911.1 |
221 | 2021-05-03 21:03:21 | preferrer | 3 | 148641 | 50 | 6.673 | 22275.0 |
220 | 2021-05-03 07:37:10 | preferrer | 3 | 148641 | 50 | 7.546 | 19698.0 |
219 | 2021-05-02 23:06:33 | preferrer | 1 | 81242 | 4 | 1.283 | 63321.9 |
218 | 2021-05-02 09:51:29 | preferrer | 3 | 148641 | 50 | 7.266 | 20457.1 |
217 | 2021-05-01 18:57:23 | preferrer | 3 | 148641 | 50 | 7.763 | 19147.4 |
216 | 2021-05-01 05:01:44 | preferrer | 3 | 148641 | 50 | 7.783 | 19098.2 |
215 | 2021-04-30 12:49:56 | preferrer | 3 | 148641 | 50 | 7.173 | 20722.3 |
214 | 2021-04-29 11:11:05 | preferrer | 3 | 148641 | 50 | 7.533 | 19732.0 |
213 | 2021-04-28 13:50:10 | preferrer | 3 | 148641 | 50 | 7.456 | 19935.8 |
212 | 2021-04-28 05:10:27 | preferrer | 3 | 148641 | 50 | 7.670 | 19379.5 |
211 | 2021-04-27 18:59:23 | preferrer | 3 | 148641 | 50 | 7.970 | 18650.1 |
210 | 2021-04-26 10:12:01 | preferrer | 3 | 148641 | 50 | 6.783 | 21913.8 |
209 | 2021-04-16 06:16:11 | preferrer | 3 | 148641 | 50 | 6.466 | 22988.1 |
208 | 2021-04-15 13:20:44 | preferrer | 3 | 148641 | 50 | 6.470 | 22973.9 |
207 | 2021-04-11 15:15:26 | preferrer | 3 | 148641 | 50 | 6.440 | 23080.9 |
206 | 2021-04-10 17:12:06 | preferrer | 3 | 148641 | 50 | 7.110 | 20905.9 |
205 | 2021-04-07 05:30:42 | preferrer | 3 | 148641 | 50 | 7.236 | 20541.9 |
204 | 2021-04-06 15:03:46 | preferrer | 3 | 148641 | 50 | 7.080 | 20994.5 |
203 | 2021-04-05 15:39:16 | preferrer | 3 | 148641 | 50 | 6.986 | 21277.0 |
202 | 2021-04-01 05:12:41 | preferrer | 1 | 81242 | 4 | 1.326 | 61268.5 |
201 | 2021-03-31 12:15:59 | preferrer | 3 | 148641 | 50 | 6.893 | 21564.1 |
200 | 2021-03-30 11:46:02 | preferrer | 3 | 148641 | 50 | 6.856 | 21680.4 |
199 | 2021-03-29 20:47:47 | preferrer | 3 | 148641 | 50 | 6.796 | 21871.8 |
198 | 2021-03-19 08:17:41 | preferrer | 3 | 148641 | 50 | 9.280 | 16017.3 |
197 | 2021-03-18 06:58:20 | preferrer | 3 | 148641 | 50 | 7.890 | 18839.2 |
196 | 2021-03-17 20:45:00 | preferrer | 3 | 148641 | 50 | 6.530 | 22762.8 |
195 | 2021-03-17 09:30:58 | preferrer | 3 | 148641 | 50 | 10.923 | 13608.1 |
194 | 2021-03-16 14:13:28 | preferrer | 3 | 148641 | 50 | 8.156 | 18224.7 |
193 | 2021-03-15 19:41:08 | preferrer | 3 | 148641 | 50 | 8.110 | 18328.1 |
192 | 2021-01-16 04:48:24 | preferrer | 1 | 81242 | 4 | 1.266 | 64172.2 |
191 | 2020-10-27 20:27:08 | preferrer | 1 | 81242 | 4 | 1.266 | 64172.2 |
190 | 2020-10-17 14:00:52 | preferrer | 1 | 81242 | 4 | 1.326 | 61268.5 |
189 | 2020-06-02 11:18:33 | preferrer | 3 | 148641 | 50 | 6.656 | 22331.9 |
188 | 2020-06-01 11:46:20 | preferrer | 3 | 148641 | 50 | 6.673 | 22275.0 |
187 | 2020-05-29 16:42:04 | preferrer | 3 | 148641 | 50 | 6.266 | 23721.8 |
186 | 2020-05-28 16:58:15 | preferrer | 3 | 148641 | 50 | 6.390 | 23261.5 |
185 | 2020-05-27 16:16:51 | preferrer | 3 | 148641 | 50 | 6.140 | 24208.6 |
184 | 2020-05-24 08:49:14 | preferrer | 3 | 148641 | 50 | 6.343 | 23433.9 |
183 | 2020-05-23 09:25:33 | preferrer | 3 | 148641 | 50 | 6.390 | 23261.5 |
182 | 2020-05-18 17:15:38 | preferrer | 3 | 148641 | 50 | 6.296 | 23608.8 |
181 | 2020-05-17 16:27:29 | preferrer | 3 | 148641 | 50 | 6.453 | 23034.4 |
180 | 2020-05-15 05:43:58 | preferrer | 3 | 148641 | 50 | 6.250 | 23782.6 |
179 | 2020-04-28 05:50:23 | preferrer | 3 | 148641 | 50 | 6.356 | 23385.9 |
178 | 2020-04-27 06:08:54 | preferrer | 3 | 148641 | 50 | 7.110 | 20905.9 |
177 | 2020-04-26 06:25:09 | preferrer | 3 | 148641 | 50 | 7.393 | 20105.6 |