History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"spottier"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-30 19:24:25 | spottier | 1 | 82945 | 5 | 3.296 | 25165.4 |
280 | 2024-04-29 23:46:20 | spottier | 1 | 82945 | 5 | 1.436 | 57761.1 |
279 | 2024-04-11 03:15:56 | spottier | 3 | 146162 | 289 | 11.420 | 12798.8 |
278 | 2024-03-31 18:44:15 | spottier | 2 | 121059 | 41 | 9.876 | 12257.9 |
277 | 2024-03-31 18:43:41 | spottier | 1 | 82945 | 5 | 3.420 | 24252.9 |
276 | 2024-03-31 18:35:31 | spottier | 3 | 146162 | 289 | 21.373 | 6838.6 |
275 | 2024-03-31 05:24:17 | spottier | 2 | 121059 | 41 | 8.373 | 14458.3 |
274 | 2024-03-31 03:43:30 | spottier | 2 | 121059 | 41 | 3.936 | 30756.9 |
273 | 2024-03-31 03:43:15 | spottier | 3 | 146162 | 289 | 7.750 | 18859.6 |
272 | 2024-03-31 03:36:43 | spottier | 1 | 82945 | 5 | 3.343 | 24811.5 |
271 | 2024-03-30 04:23:30 | spottier | 3 | 146162 | 289 | 9.080 | 16097.1 |
270 | 2024-03-30 03:19:14 | spottier | 3 | 146162 | 289 | 19.173 | 7623.3 |
269 | 2024-03-30 03:19:18 | spottier | 1 | 82945 | 5 | 3.280 | 25288.1 |
268 | 2024-03-30 03:18:14 | spottier | 2 | 121059 | 41 | 6.063 | 19966.8 |
267 | 2024-03-17 13:56:55 | spottier | 1 | 82945 | 5 | 1.593 | 52068.4 |
266 | 2024-03-07 00:17:28 | spottier | 1 | 82945 | 5 | 2.296 | 36125.9 |
265 | 2024-02-29 19:11:57 | spottier | 1 | 82945 | 5 | 1.453 | 57085.3 |
264 | 2024-02-28 10:10:36 | spottier | 3 | 146162 | 289 | 21.626 | 6758.6 |
263 | 2024-02-27 22:18:42 | spottier | 3 | 146162 | 289 | 17.300 | 8448.7 |
262 | 2024-02-27 22:18:19 | spottier | 2 | 121059 | 41 | 4.140 | 29241.3 |
261 | 2024-02-27 10:47:33 | spottier | 3 | 146162 | 289 | 6.953 | 21021.4 |
260 | 2024-02-27 10:47:33 | spottier | 2 | 121059 | 41 | 3.596 | 33664.9 |
259 | 2024-02-27 10:47:28 | spottier | 1 | 82945 | 5 | 1.453 | 57085.3 |
258 | 2024-01-26 01:24:57 | spottier | 2 | 121059 | 41 | 3.593 | 33693.0 |
257 | 2023-12-17 16:47:31 | spottier | 1 | 82945 | 5 | 1.280 | 64800.8 |
256 | 2023-12-09 15:53:18 | spottier | 1 | 82945 | 5 | 1.373 | 60411.5 |
255 | 2023-11-28 06:26:21 | spottier | 1 | 82945 | 5 | 1.623 | 51106.0 |
254 | 2023-11-24 07:34:29 | spottier | 1 | 82945 | 5 | 1.296 | 64000.8 |
253 | 2023-11-19 11:47:16 | spottier | 2 | 121059 | 41 | 4.076 | 29700.4 |
252 | 2023-11-11 10:58:48 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
251 | 2023-11-06 07:42:47 | spottier | 1 | 82945 | 5 | 1.360 | 60989.0 |
250 | 2023-11-05 12:43:28 | spottier | 2 | 121059 | 41 | 3.110 | 38925.7 |
249 | 2023-10-07 01:27:20 | spottier | 1 | 82945 | 5 | 1.406 | 58993.6 |
248 | 2023-10-04 18:09:05 | spottier | 1 | 82945 | 5 | 1.436 | 57761.1 |
247 | 2023-08-10 20:59:23 | spottier | 2 | 121059 | 41 | 6.893 | 17562.6 |
246 | 2023-07-31 16:26:20 | spottier | 1 | 82945 | 5 | 1.296 | 64000.8 |
245 | 2023-07-22 07:23:49 | spottier | 1 | 82945 | 5 | 1.376 | 60279.8 |
244 | 2023-04-29 21:03:39 | spottier | 1 | 82945 | 5 | 1.283 | 64649.3 |
243 | 2023-04-24 21:43:03 | spottier | 2 | 121059 | 41 | 3.250 | 37248.9 |
242 | 2023-03-20 01:11:57 | spottier | 1 | 82945 | 5 | 1.360 | 60989.0 |
241 | 2023-03-16 18:04:40 | spottier | 1 | 82945 | 5 | 1.406 | 58993.6 |
240 | 2023-02-18 22:05:49 | spottier | 1 | 82945 | 5 | 1.266 | 65517.4 |
239 | 2023-01-26 00:13:49 | spottier | 2 | 121059 | 41 | 3.126 | 38726.5 |
238 | 2022-12-15 21:40:59 | spottier | 1 | 82945 | 5 | 1.266 | 65517.4 |
237 | 2022-11-07 16:24:44 | spottier | 1 | 82945 | 5 | 1.283 | 64649.3 |
236 | 2022-11-06 03:30:21 | spottier | 2 | 121059 | 41 | 3.110 | 38925.7 |
235 | 2022-08-26 01:16:54 | spottier | 1 | 82945 | 5 | 1.296 | 64000.8 |
234 | 2022-08-23 17:07:48 | spottier | 1 | 82945 | 5 | 1.263 | 65673.0 |
233 | 2022-07-19 13:39:05 | spottier | 1 | 82945 | 5 | 1.266 | 65517.4 |
232 | 2022-07-18 18:43:29 | spottier | 1 | 82945 | 5 | 1.326 | 62552.8 |
231 | 2022-07-15 10:14:24 | spottier | 3 | 146162 | 289 | 6.390 | 22873.6 |
230 | 2022-07-04 16:30:31 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
229 | 2022-05-10 10:33:08 | spottier | 2 | 121059 | 41 | 3.920 | 30882.4 |
228 | 2022-04-07 08:19:00 | spottier | 1 | 82945 | 5 | 3.063 | 27079.7 |
227 | 2022-02-24 23:07:34 | spottier | 1 | 82945 | 5 | 1.296 | 64000.8 |
226 | 2022-01-11 04:32:21 | spottier | 1 | 82945 | 5 | 1.376 | 60279.8 |
225 | 2021-11-11 04:53:29 | spottier | 1 | 82945 | 5 | 1.326 | 62552.8 |
224 | 2021-11-09 05:16:13 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
223 | 2021-10-24 11:11:18 | spottier | 1 | 82945 | 5 | 1.376 | 60279.8 |
222 | 2021-09-24 14:50:30 | spottier | 1 | 82945 | 5 | 1.296 | 64000.8 |
221 | 2021-09-07 09:12:00 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
220 | 2021-07-09 22:41:56 | spottier | 1 | 82945 | 5 | 1.330 | 62364.7 |
219 | 2021-07-03 17:09:34 | spottier | 1 | 82945 | 5 | 1.483 | 55930.5 |
218 | 2021-04-17 05:36:38 | spottier | 1 | 82945 | 5 | 1.346 | 61623.3 |
217 | 2021-04-06 02:13:04 | spottier | 1 | 82945 | 5 | 1.283 | 64649.3 |
216 | 2021-04-01 22:20:26 | spottier | 1 | 82945 | 5 | 1.436 | 57761.1 |
215 | 2021-03-20 03:25:01 | spottier | 1 | 82945 | 5 | 1.500 | 55296.7 |
214 | 2021-01-29 18:38:41 | spottier | 1 | 82945 | 5 | 1.453 | 57085.3 |
213 | 2021-01-01 10:39:32 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
212 | 2020-12-17 06:42:29 | spottier | 1 | 82945 | 5 | 1.360 | 60989.0 |
211 | 2020-11-11 12:17:23 | spottier | 1 | 82945 | 5 | 1.373 | 60411.5 |
210 | 2020-11-11 06:48:55 | spottier | 1 | 82945 | 5 | 1.376 | 60279.8 |
209 | 2020-10-17 09:23:28 | spottier | 1 | 82945 | 5 | 1.423 | 58288.8 |
208 | 2020-09-13 08:47:42 | spottier | 1 | 82945 | 5 | 1.470 | 56425.2 |
207 | 2020-08-26 06:19:49 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
206 | 2020-08-23 04:23:11 | spottier | 1 | 82945 | 5 | 1.313 | 63172.1 |
205 | 2020-05-23 04:08:12 | spottier | 1 | 82945 | 5 | 1.406 | 58993.6 |
204 | 2020-05-15 21:49:08 | spottier | 1 | 82945 | 5 | 1.280 | 64800.8 |
203 | 2020-03-28 00:49:25 | spottier | 1 | 82945 | 5 | 1.593 | 52068.4 |
202 | 2020-03-21 10:08:38 | spottier | 1 | 82945 | 5 | 1.486 | 55817.6 |
201 | 2020-02-22 18:11:40 | spottier | 1 | 82945 | 5 | 1.546 | 53651.4 |
200 | 2020-02-22 17:21:08 | spottier | 1 | 82945 | 5 | 1.576 | 52630.1 |
199 | 2020-02-22 11:12:11 | spottier | 1 | 82945 | 5 | 1.830 | 45325.1 |
198 | 2020-02-13 12:04:13 | spottier | 1 | 82945 | 5 | 1.483 | 55930.5 |
197 | 2020-02-13 06:51:12 | spottier | 1 | 82945 | 5 | 4.296 | 19307.5 |
196 | 2020-02-11 06:23:12 | spottier | 1 | 82945 | 5 | 1.453 | 57085.3 |
195 | 2020-02-04 07:03:12 | spottier | 1 | 82945 | 5 | 1.686 | 49196.3 |
194 | 2020-02-03 18:35:40 | spottier | 1 | 82945 | 5 | 1.596 | 51970.6 |
193 | 2020-02-03 14:04:08 | spottier | 1 | 82945 | 5 | 4.813 | 17233.5 |
192 | 2020-01-22 06:47:39 | spottier | 1 | 82945 | 5 | 1.470 | 56425.2 |
191 | 2020-01-21 18:24:32 | spottier | 1 | 82945 | 5 | 2.530 | 32784.6 |
190 | 2020-01-16 16:08:34 | spottier | 1 | 82945 | 5 | 1.703 | 48705.2 |
189 | 2020-01-16 15:17:18 | spottier | 1 | 82945 | 5 | 1.546 | 53651.4 |
188 | 2020-01-10 17:46:27 | spottier | 1 | 82945 | 5 | 1.420 | 58412.0 |
187 | 2020-01-02 20:08:31 | spottier | 1 | 82945 | 5 | 1.563 | 53067.8 |
186 | 2019-12-30 22:12:57 | spottier | 1 | 82945 | 5 | 1.623 | 51106.0 |
185 | 2019-12-30 18:54:43 | spottier | 1 | 82945 | 5 | 3.060 | 27106.2 |
184 | 2019-11-11 01:17:37 | spottier | 1 | 82945 | 5 | 1.406 | 58993.6 |
183 | 2019-09-10 20:03:24 | spottier | 1 | 82945 | 5 | 1.610 | 51518.6 |
182 | 2019-08-09 18:15:49 | spottier | 1 | 82945 | 5 | 1.250 | 66356.0 |