History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preppier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
239 | 2024-04-27 23:13:36 | preppier | 1 | 82945 | 4 | 1.733 | 47862.1 |
238 | 2024-04-26 01:34:54 | preppier | 1 | 82945 | 4 | 1.736 | 47779.4 |
237 | 2024-04-13 01:39:52 | preppier | 1 | 82945 | 4 | 1.560 | 53169.9 |
236 | 2024-04-07 02:35:03 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
235 | 2024-04-06 15:14:16 | preppier | 2 | 121059 | 20 | 3.826 | 31641.1 |
234 | 2024-04-06 15:14:07 | preppier | 1 | 82945 | 4 | 1.530 | 54212.4 |
233 | 2024-04-04 01:55:48 | preppier | 3 | 146162 | 223 | 21.593 | 6769.0 |
232 | 2024-04-02 22:41:21 | preppier | 3 | 146162 | 223 | 10.560 | 13841.1 |
231 | 2024-04-01 20:19:39 | preppier | 3 | 146162 | 223 | 19.483 | 7502.0 |
230 | 2024-03-29 22:43:23 | preppier | 2 | 121059 | 20 | 13.013 | 9302.9 |
229 | 2024-03-29 03:41:27 | preppier | 3 | 146162 | 223 | 16.550 | 8831.5 |
228 | 2024-03-29 03:38:59 | preppier | 3 | 146162 | 223 | 12.203 | 11977.5 |
227 | 2024-03-29 03:38:53 | preppier | 1 | 82945 | 4 | 5.093 | 16286.1 |
226 | 2024-03-29 03:38:46 | preppier | 2 | 121059 | 20 | 11.486 | 10539.7 |
225 | 2024-03-29 03:38:00 | preppier | 2 | 121059 | 20 | 13.436 | 9010.0 |
224 | 2024-03-28 12:01:28 | preppier | 1 | 82945 | 4 | 1.563 | 53067.8 |
223 | 2024-03-28 00:36:24 | preppier | 2 | 121059 | 20 | 3.983 | 30393.9 |
222 | 2024-03-05 00:44:59 | preppier | 1 | 82945 | 4 | 4.750 | 17462.1 |
221 | 2024-03-03 08:40:38 | preppier | 2 | 121059 | 20 | 4.123 | 29361.9 |
220 | 2024-03-01 07:36:00 | preppier | 2 | 121059 | 20 | 4.033 | 30017.1 |
219 | 2024-03-01 07:35:49 | preppier | 3 | 146162 | 223 | 8.076 | 18098.3 |
218 | 2024-02-28 01:52:43 | preppier | 2 | 121059 | 20 | 7.860 | 15401.9 |
217 | 2024-02-27 22:06:45 | preppier | 3 | 146162 | 223 | 12.516 | 11678.0 |
216 | 2024-02-27 18:49:35 | preppier | 3 | 146162 | 223 | 9.030 | 16186.3 |
215 | 2024-02-27 18:49:34 | preppier | 2 | 121059 | 20 | 8.860 | 13663.5 |
214 | 2024-02-27 18:49:26 | preppier | 1 | 82945 | 4 | 3.296 | 25165.4 |
213 | 2023-12-27 08:13:06 | preppier | 1 | 82945 | 4 | 1.406 | 58993.6 |
212 | 2023-12-22 17:10:33 | preppier | 3 | 146162 | 223 | 6.813 | 21453.4 |
211 | 2023-12-21 21:20:23 | preppier | 2 | 121059 | 20 | 3.500 | 34588.3 |
210 | 2023-12-15 01:28:15 | preppier | 1 | 82945 | 4 | 1.373 | 60411.5 |
209 | 2023-12-10 00:08:21 | preppier | 1 | 82945 | 4 | 1.750 | 47397.1 |
208 | 2023-12-04 01:46:24 | preppier | 2 | 121059 | 20 | 3.623 | 33414.0 |
207 | 2023-11-20 22:22:38 | preppier | 1 | 82945 | 4 | 1.436 | 57761.1 |
206 | 2023-11-12 08:04:22 | preppier | 1 | 82945 | 4 | 1.390 | 59672.7 |
205 | 2023-11-03 22:56:49 | preppier | 1 | 82945 | 4 | 1.310 | 63316.8 |
204 | 2023-10-18 08:59:21 | preppier | 1 | 82945 | 4 | 1.406 | 58993.6 |
203 | 2023-10-14 20:35:26 | preppier | 1 | 82945 | 4 | 1.826 | 45424.4 |
202 | 2023-10-06 22:00:50 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
201 | 2023-09-29 18:07:36 | preppier | 1 | 82945 | 4 | 1.326 | 62552.8 |
200 | 2023-09-01 17:58:28 | preppier | 2 | 121059 | 20 | 3.923 | 30858.8 |
199 | 2023-08-10 23:13:52 | preppier | 1 | 82945 | 4 | 1.500 | 55296.7 |
198 | 2023-08-06 21:01:35 | preppier | 1 | 82945 | 4 | 1.516 | 54713.1 |
197 | 2023-05-21 12:44:03 | preppier | 2 | 121059 | 20 | 3.640 | 33258.0 |
196 | 2023-05-09 16:51:03 | preppier | 1 | 82945 | 4 | 1.250 | 66356.0 |
195 | 2023-04-25 03:10:58 | preppier | 1 | 82945 | 4 | 1.483 | 55930.5 |
194 | 2023-04-10 23:14:03 | preppier | 1 | 82945 | 4 | 1.266 | 65517.4 |
193 | 2023-03-27 14:51:44 | preppier | 1 | 82945 | 4 | 1.376 | 60279.8 |
192 | 2023-03-02 07:05:10 | preppier | 1 | 82945 | 4 | 1.280 | 64800.8 |
191 | 2023-03-02 00:55:29 | preppier | 2 | 121059 | 20 | 3.186 | 37997.2 |
190 | 2022-12-26 11:46:30 | preppier | 1 | 82945 | 4 | 1.453 | 57085.3 |
189 | 2022-12-15 05:24:13 | preppier | 1 | 82945 | 4 | 1.280 | 64800.8 |
188 | 2022-12-10 18:29:23 | preppier | 2 | 121059 | 20 | 3.546 | 34139.6 |
187 | 2022-09-12 15:03:50 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
186 | 2022-08-21 02:37:16 | preppier | 1 | 82945 | 4 | 1.436 | 57761.1 |
185 | 2022-08-08 13:51:15 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
184 | 2022-07-28 09:02:19 | preppier | 2 | 121059 | 20 | 3.640 | 33258.0 |
183 | 2022-07-19 02:08:57 | preppier | 1 | 82945 | 4 | 1.343 | 61761.0 |
182 | 2022-07-18 13:31:18 | preppier | 1 | 82945 | 4 | 1.326 | 62552.8 |
181 | 2022-07-16 06:31:56 | preppier | 1 | 82945 | 4 | 1.283 | 64649.3 |
180 | 2022-04-07 08:44:37 | preppier | 1 | 82945 | 4 | 2.156 | 38471.7 |
179 | 2022-03-25 04:38:28 | preppier | 2 | 121059 | 20 | 3.843 | 31501.2 |
178 | 2022-03-13 22:12:47 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
177 | 2022-03-11 17:57:54 | preppier | 1 | 82945 | 4 | 1.373 | 60411.5 |
176 | 2021-12-24 04:28:37 | preppier | 1 | 82945 | 4 | 1.450 | 57203.4 |
175 | 2021-12-16 22:51:31 | preppier | 1 | 82945 | 4 | 1.390 | 59672.7 |
174 | 2021-10-29 01:39:25 | preppier | 1 | 82945 | 4 | 1.453 | 57085.3 |
173 | 2021-10-26 23:58:17 | preppier | 1 | 82945 | 4 | 1.423 | 58288.8 |
172 | 2021-08-27 14:12:55 | preppier | 1 | 82945 | 4 | 1.373 | 60411.5 |
171 | 2021-07-15 00:01:13 | preppier | 1 | 82945 | 4 | 1.453 | 57085.3 |
170 | 2021-06-19 01:24:58 | preppier | 1 | 82945 | 4 | 1.440 | 57600.7 |
169 | 2021-05-16 22:21:40 | preppier | 1 | 82945 | 4 | 1.546 | 53651.4 |
168 | 2021-02-09 22:28:32 | preppier | 1 | 82945 | 4 | 1.450 | 57203.4 |
167 | 2021-01-17 08:30:49 | preppier | 1 | 82945 | 4 | 1.296 | 64000.8 |
166 | 2020-11-22 21:09:00 | preppier | 1 | 82945 | 4 | 1.436 | 57761.1 |
165 | 2020-11-08 06:58:39 | preppier | 1 | 82945 | 4 | 1.296 | 64000.8 |
164 | 2020-10-02 17:41:26 | preppier | 1 | 82945 | 4 | 1.343 | 61761.0 |
163 | 2020-08-08 11:00:03 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
162 | 2020-07-31 00:04:43 | preppier | 1 | 82945 | 4 | 1.436 | 57761.1 |
161 | 2020-07-24 23:29:16 | preppier | 1 | 82945 | 4 | 1.656 | 50087.6 |
160 | 2020-04-22 07:43:30 | preppier | 1 | 82945 | 4 | 1.576 | 52630.1 |
159 | 2020-03-24 04:55:35 | preppier | 1 | 82945 | 4 | 1.513 | 54821.5 |
158 | 2020-02-18 13:22:03 | preppier | 1 | 82945 | 4 | 3.296 | 25165.4 |
157 | 2020-02-17 01:51:16 | preppier | 1 | 82945 | 4 | 3.266 | 25396.5 |
156 | 2020-02-15 07:32:41 | preppier | 1 | 82945 | 4 | 2.266 | 36604.1 |
155 | 2020-02-07 12:56:24 | preppier | 1 | 82945 | 4 | 1.500 | 55296.7 |
154 | 2020-02-04 11:30:47 | preppier | 1 | 82945 | 4 | 1.580 | 52496.8 |
153 | 2020-02-03 17:19:54 | preppier | 1 | 82945 | 4 | 6.373 | 13015.1 |
152 | 2020-01-24 01:58:26 | preppier | 1 | 82945 | 4 | 4.390 | 18894.1 |
151 | 2020-01-21 20:01:58 | preppier | 1 | 82945 | 4 | 1.703 | 48705.2 |
150 | 2020-01-20 12:13:09 | preppier | 1 | 82945 | 4 | 1.530 | 54212.4 |
149 | 2020-01-17 06:59:43 | preppier | 1 | 82945 | 4 | 1.343 | 61761.0 |
148 | 2020-01-11 19:05:47 | preppier | 1 | 82945 | 4 | 1.626 | 51011.7 |
147 | 2020-01-06 20:50:30 | preppier | 1 | 82945 | 4 | 1.563 | 53067.8 |
146 | 2019-12-31 14:39:43 | preppier | 1 | 82945 | 4 | 1.563 | 53067.8 |
145 | 2019-12-28 21:32:15 | preppier | 1 | 82945 | 4 | 1.326 | 62552.8 |
144 | 2019-10-23 04:37:27 | preppier | 1 | 82945 | 4 | 1.313 | 63172.1 |
143 | 2019-07-19 00:37:43 | preppier | 1 | 82945 | 4 | 1.263 | 65673.0 |
142 | 2019-04-14 18:12:43 | preppier | 1 | 82945 | 4 | 1.280 | 64800.8 |
141 | 2019-03-18 00:28:27 | preppier | 1 | 82945 | 4 | 1.430 | 58003.5 |
140 | 2019-03-11 03:16:53 | preppier | 1 | 82945 | 4 | 1.250 | 66356.0 |