History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"upstates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
279 | 2024-04-27 17:50:59 | upstates | 3 | 146162 | 177 | 12.940 | 11295.4 |
278 | 2024-04-27 16:40:59 | upstates | 3 | 146162 | 177 | 9.733 | 15017.2 |
277 | 2024-04-09 20:34:27 | upstates | 2 | 121059 | 32 | 3.626 | 33386.4 |
276 | 2024-04-09 20:34:02 | upstates | 1 | 82945 | 7 | 1.390 | 59672.7 |
275 | 2024-04-04 23:57:46 | upstates | 2 | 121059 | 32 | 9.766 | 12396.0 |
274 | 2024-04-04 23:57:46 | upstates | 1 | 82945 | 7 | 3.250 | 25521.5 |
273 | 2024-04-03 09:39:43 | upstates | 3 | 146162 | 177 | 18.063 | 8091.8 |
272 | 2024-04-01 20:25:32 | upstates | 3 | 146162 | 177 | 17.160 | 8517.6 |
271 | 2024-04-01 07:13:46 | upstates | 3 | 146162 | 177 | 13.110 | 11148.9 |
270 | 2024-03-30 08:40:53 | upstates | 2 | 121059 | 32 | 11.936 | 10142.3 |
269 | 2024-03-30 08:09:35 | upstates | 1 | 82945 | 7 | 1.483 | 55930.5 |
268 | 2024-03-29 20:55:51 | upstates | 2 | 121059 | 32 | 6.843 | 17690.9 |
267 | 2024-03-28 20:59:45 | upstates | 3 | 146162 | 177 | 18.516 | 7893.8 |
266 | 2024-03-28 13:34:01 | upstates | 1 | 82945 | 7 | 1.466 | 56579.1 |
265 | 2024-03-28 13:33:48 | upstates | 3 | 146162 | 177 | 7.360 | 19859.0 |
264 | 2024-03-28 13:33:49 | upstates | 2 | 121059 | 32 | 3.656 | 33112.4 |
263 | 2024-03-28 13:32:03 | upstates | 1 | 82945 | 7 | 1.486 | 55817.6 |
262 | 2024-03-07 10:53:05 | upstates | 1 | 82945 | 7 | 1.813 | 45750.1 |
261 | 2024-03-01 15:32:21 | upstates | 2 | 121059 | 32 | 8.280 | 14620.7 |
260 | 2024-03-01 15:32:17 | upstates | 1 | 82945 | 7 | 3.220 | 25759.3 |
259 | 2024-03-01 13:51:03 | upstates | 3 | 146162 | 177 | 14.970 | 9763.7 |
258 | 2024-02-29 03:33:00 | upstates | 1 | 82945 | 7 | 1.500 | 55296.7 |
257 | 2024-02-29 00:47:57 | upstates | 2 | 121059 | 32 | 3.673 | 32959.2 |
256 | 2024-02-29 00:47:45 | upstates | 3 | 146162 | 177 | 7.890 | 18525.0 |
255 | 2024-02-26 10:52:06 | upstates | 2 | 121059 | 32 | 7.203 | 16806.7 |
254 | 2024-02-26 10:51:48 | upstates | 3 | 146162 | 177 | 6.686 | 21860.9 |
253 | 2024-02-22 04:10:05 | upstates | 3 | 146162 | 177 | 17.143 | 8526.0 |
252 | 2024-02-22 04:10:01 | upstates | 2 | 121059 | 32 | 8.300 | 14585.4 |
251 | 2024-02-21 17:51:01 | upstates | 3 | 146162 | 177 | 24.566 | 5949.8 |
250 | 2024-02-21 17:51:00 | upstates | 2 | 121059 | 32 | 4.390 | 27576.1 |
249 | 2024-02-21 06:40:32 | upstates | 1 | 82945 | 7 | 2.453 | 33813.7 |
248 | 2024-02-03 20:32:22 | upstates | 1 | 82945 | 7 | 1.390 | 59672.7 |
247 | 2023-12-04 15:56:46 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |
246 | 2023-11-29 11:23:10 | upstates | 1 | 82945 | 7 | 1.250 | 66356.0 |
245 | 2023-11-26 19:14:23 | upstates | 1 | 82945 | 7 | 1.250 | 66356.0 |
244 | 2023-11-26 08:08:15 | upstates | 1 | 82945 | 7 | 1.423 | 58288.8 |
243 | 2023-11-06 12:05:32 | upstates | 1 | 82945 | 7 | 1.360 | 60989.0 |
242 | 2023-10-18 03:30:49 | upstates | 1 | 82945 | 7 | 1.266 | 65517.4 |
241 | 2023-10-17 22:16:17 | upstates | 1 | 82945 | 7 | 1.376 | 60279.8 |
240 | 2023-10-07 14:20:07 | upstates | 1 | 82945 | 7 | 1.236 | 67107.6 |
239 | 2023-09-28 13:47:03 | upstates | 1 | 82945 | 7 | 1.280 | 64800.8 |
238 | 2023-09-12 16:27:47 | upstates | 1 | 82945 | 7 | 1.593 | 52068.4 |
237 | 2023-07-16 06:06:47 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |
236 | 2023-06-26 21:06:44 | upstates | 1 | 82945 | 7 | 1.216 | 68211.3 |
235 | 2023-06-10 19:46:16 | upstates | 1 | 82945 | 7 | 1.233 | 67270.9 |
234 | 2023-04-08 03:47:11 | upstates | 1 | 82945 | 7 | 1.203 | 68948.5 |
233 | 2023-02-12 12:12:49 | upstates | 1 | 82945 | 7 | 1.326 | 62552.8 |
232 | 2023-02-09 00:38:25 | upstates | 1 | 82945 | 7 | 1.326 | 62552.8 |
231 | 2023-01-31 03:44:07 | upstates | 1 | 82945 | 7 | 1.280 | 64800.8 |
230 | 2022-11-28 20:20:38 | upstates | 1 | 82945 | 7 | 1.266 | 65517.4 |
229 | 2022-11-15 13:52:04 | upstates | 1 | 82945 | 7 | 1.530 | 54212.4 |
228 | 2022-10-07 20:40:15 | upstates | 1 | 82945 | 7 | 1.233 | 67270.9 |
227 | 2022-07-23 18:43:20 | upstates | 1 | 82945 | 7 | 1.236 | 67107.6 |
226 | 2022-05-30 22:50:00 | upstates | 1 | 82945 | 7 | 1.266 | 65517.4 |
225 | 2022-03-18 18:20:49 | upstates | 1 | 82945 | 7 | 1.296 | 64000.8 |
224 | 2022-03-16 14:42:49 | upstates | 1 | 82945 | 7 | 1.500 | 55296.7 |
223 | 2022-01-26 08:46:36 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |
222 | 2021-12-28 23:21:35 | upstates | 1 | 82945 | 7 | 1.420 | 58412.0 |
221 | 2021-12-22 08:59:58 | upstates | 1 | 82945 | 7 | 1.266 | 65517.4 |
220 | 2021-12-18 16:56:45 | upstates | 1 | 82945 | 7 | 1.360 | 60989.0 |
219 | 2021-11-19 05:06:55 | upstates | 1 | 82945 | 7 | 1.263 | 65673.0 |
218 | 2021-10-03 09:54:43 | upstates | 1 | 82945 | 7 | 1.406 | 58993.6 |
217 | 2021-06-30 18:59:55 | upstates | 1 | 82945 | 7 | 1.360 | 60989.0 |
216 | 2021-05-11 05:54:57 | upstates | 1 | 82945 | 7 | 1.466 | 56579.1 |
215 | 2021-04-09 23:29:02 | upstates | 1 | 82945 | 7 | 1.390 | 59672.7 |
214 | 2021-04-01 08:14:33 | upstates | 1 | 82945 | 7 | 1.406 | 58993.6 |
213 | 2021-03-30 17:02:24 | upstates | 1 | 82945 | 7 | 1.533 | 54106.3 |
212 | 2021-03-20 15:36:23 | upstates | 2 | 121059 | 32 | 3.546 | 34139.6 |
211 | 2021-02-23 07:52:35 | upstates | 2 | 121059 | 32 | 3.266 | 37066.4 |
210 | 2021-01-24 12:04:55 | upstates | 1 | 82945 | 7 | 1.436 | 57761.1 |
209 | 2020-12-15 05:27:15 | upstates | 1 | 82945 | 7 | 1.250 | 66356.0 |
208 | 2020-12-11 15:56:16 | upstates | 1 | 82945 | 7 | 1.436 | 57761.1 |
207 | 2020-10-27 21:48:47 | upstates | 1 | 82945 | 7 | 1.393 | 59544.1 |
206 | 2020-10-27 01:40:48 | upstates | 1 | 82945 | 7 | 1.343 | 61761.0 |
205 | 2020-10-22 04:41:49 | upstates | 1 | 82945 | 7 | 1.923 | 43133.1 |
204 | 2020-10-13 10:30:42 | upstates | 1 | 82945 | 7 | 1.263 | 65673.0 |
203 | 2020-10-06 21:17:08 | upstates | 1 | 82945 | 7 | 1.280 | 64800.8 |
202 | 2020-08-29 05:58:45 | upstates | 1 | 82945 | 7 | 1.233 | 67270.9 |
201 | 2020-08-26 01:41:46 | upstates | 1 | 82945 | 7 | 1.233 | 67270.9 |
200 | 2020-07-19 07:08:45 | upstates | 1 | 82945 | 7 | 1.423 | 58288.8 |
199 | 2020-05-15 06:50:47 | upstates | 1 | 82945 | 7 | 1.440 | 57600.7 |
198 | 2020-04-20 08:35:37 | upstates | 1 | 82945 | 7 | 1.390 | 59672.7 |
197 | 2020-04-08 20:09:03 | upstates | 3 | 146162 | 177 | 7.046 | 20744.0 |
196 | 2020-04-08 20:08:57 | upstates | 2 | 121059 | 32 | 3.580 | 33815.4 |
195 | 2020-04-08 18:05:38 | upstates | 1 | 82945 | 7 | 1.266 | 65517.4 |
194 | 2020-03-28 16:52:48 | upstates | 1 | 82945 | 7 | 1.516 | 54713.1 |
193 | 2020-03-21 01:26:10 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |
192 | 2020-03-02 22:07:10 | upstates | 1 | 82945 | 7 | 1.860 | 44594.1 |
191 | 2020-02-26 19:52:31 | upstates | 1 | 82945 | 7 | 1.593 | 52068.4 |
190 | 2020-02-26 17:29:57 | upstates | 1 | 82945 | 7 | 1.546 | 53651.4 |
189 | 2020-02-25 22:46:10 | upstates | 1 | 82945 | 7 | 1.530 | 54212.4 |
188 | 2020-02-18 00:40:36 | upstates | 1 | 82945 | 7 | 1.626 | 51011.7 |
187 | 2020-02-17 23:22:06 | upstates | 1 | 82945 | 7 | 1.563 | 53067.8 |
186 | 2020-02-09 17:24:45 | upstates | 1 | 82945 | 7 | 2.750 | 30161.8 |
185 | 2020-02-06 19:41:32 | upstates | 1 | 82945 | 7 | 3.280 | 25288.1 |
184 | 2020-02-05 21:39:08 | upstates | 1 | 82945 | 7 | 1.593 | 52068.4 |
183 | 2020-01-31 07:52:30 | upstates | 1 | 82945 | 7 | 1.576 | 52630.1 |
182 | 2020-01-29 23:25:47 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |
181 | 2020-01-29 17:58:08 | upstates | 1 | 82945 | 7 | 2.750 | 30161.8 |
180 | 2020-01-20 05:55:21 | upstates | 1 | 82945 | 7 | 1.453 | 57085.3 |