History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"scantest"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
266 | 2024-05-01 20:29:23 | scantest | 2 | 121059 | 17 | 4.626 | 26169.3 |
265 | 2024-05-01 20:29:18 | scantest | 3 | 146162 | 208 | 8.703 | 16794.4 |
264 | 2024-05-01 20:29:14 | scantest | 1 | 82945 | 2 | 1.516 | 54713.1 |
263 | 2024-05-01 20:29:06 | scantest | 2 | 121059 | 17 | 4.346 | 27855.3 |
262 | 2024-04-29 21:45:32 | scantest | 2 | 121059 | 17 | 3.690 | 32807.3 |
261 | 2024-04-29 08:48:00 | scantest | 1 | 82945 | 2 | 7.360 | 11269.7 |
260 | 2024-04-08 09:25:35 | scantest | 1 | 82945 | 2 | 4.750 | 17462.1 |
259 | 2024-04-03 22:52:57 | scantest | 1 | 82945 | 2 | 1.483 | 55930.5 |
258 | 2024-03-28 08:55:47 | scantest | 1 | 82945 | 2 | 1.483 | 55930.5 |
257 | 2024-03-20 02:19:08 | scantest | 1 | 82945 | 2 | 1.500 | 55296.7 |
256 | 2024-03-07 22:11:03 | scantest | 2 | 121059 | 17 | 4.016 | 30144.2 |
255 | 2024-03-07 22:10:51 | scantest | 3 | 146162 | 208 | 8.940 | 16349.2 |
254 | 2024-03-07 18:56:09 | scantest | 2 | 121059 | 17 | 4.450 | 27204.3 |
253 | 2024-03-07 18:16:54 | scantest | 3 | 146162 | 208 | 9.016 | 16211.4 |
252 | 2024-03-06 22:59:56 | scantest | 3 | 146162 | 208 | 13.440 | 10875.1 |
251 | 2024-03-06 13:35:42 | scantest | 3 | 146162 | 208 | 18.983 | 7699.6 |
250 | 2024-03-05 22:26:31 | scantest | 3 | 146162 | 208 | 23.613 | 6189.9 |
249 | 2024-03-05 22:26:27 | scantest | 2 | 121059 | 17 | 13.780 | 8785.1 |
248 | 2024-03-05 22:25:54 | scantest | 1 | 82945 | 2 | 2.170 | 38223.5 |
247 | 2024-01-29 02:25:57 | scantest | 3 | 146162 | 208 | 7.593 | 19249.6 |
246 | 2024-01-28 09:31:11 | scantest | 2 | 121059 | 17 | 3.173 | 38152.9 |
245 | 2024-01-28 09:30:15 | scantest | 3 | 146162 | 208 | 6.936 | 21073.0 |
244 | 2024-01-21 08:40:27 | scantest | 1 | 82945 | 2 | 1.420 | 58412.0 |
243 | 2024-01-12 00:09:11 | scantest | 3 | 146162 | 208 | 7.093 | 20606.5 |
242 | 2023-12-28 09:55:49 | scantest | 3 | 146162 | 208 | 7.656 | 19091.2 |
241 | 2023-12-23 08:34:08 | scantest | 1 | 82945 | 2 | 1.313 | 63172.1 |
240 | 2023-12-23 05:12:53 | scantest | 2 | 121059 | 17 | 3.440 | 35191.6 |
239 | 2023-12-16 04:39:24 | scantest | 1 | 82945 | 2 | 1.420 | 58412.0 |
238 | 2023-12-06 10:05:35 | scantest | 3 | 146162 | 208 | 7.703 | 18974.7 |
237 | 2023-12-03 00:55:41 | scantest | 1 | 82945 | 2 | 1.423 | 58288.8 |
236 | 2023-11-25 20:36:48 | scantest | 1 | 82945 | 2 | 1.486 | 55817.6 |
235 | 2023-11-19 16:44:21 | scantest | 3 | 146162 | 208 | 7.296 | 20033.2 |
234 | 2023-11-14 23:49:18 | scantest | 3 | 146162 | 208 | 6.546 | 22328.4 |
233 | 2023-11-06 20:16:04 | scantest | 3 | 146162 | 208 | 7.326 | 19951.1 |
232 | 2023-11-01 21:17:56 | scantest | 1 | 82945 | 2 | 1.796 | 46183.2 |
231 | 2023-10-31 13:30:12 | scantest | 1 | 82945 | 2 | 1.280 | 64800.8 |
230 | 2023-10-21 11:51:10 | scantest | 3 | 146162 | 208 | 7.266 | 20115.9 |
229 | 2023-10-13 23:51:42 | scantest | 1 | 82945 | 2 | 1.280 | 64800.8 |
228 | 2023-10-10 11:30:46 | scantest | 1 | 82945 | 2 | 1.423 | 58288.8 |
227 | 2023-09-22 20:10:57 | scantest | 2 | 121059 | 17 | 3.673 | 32959.2 |
226 | 2023-09-17 01:51:09 | scantest | 1 | 82945 | 2 | 1.420 | 58412.0 |
225 | 2023-08-07 10:50:26 | scantest | 1 | 82945 | 2 | 1.330 | 62364.7 |
224 | 2023-08-06 02:24:25 | scantest | 1 | 82945 | 2 | 1.313 | 63172.1 |
223 | 2023-07-31 01:38:30 | scantest | 3 | 146162 | 208 | 6.546 | 22328.4 |
222 | 2023-06-25 08:14:10 | scantest | 2 | 121059 | 17 | 3.266 | 37066.4 |
221 | 2023-05-07 19:38:55 | scantest | 1 | 82945 | 2 | 1.390 | 59672.7 |
220 | 2023-04-18 08:01:04 | scantest | 1 | 82945 | 2 | 1.280 | 64800.8 |
219 | 2023-04-10 05:18:31 | scantest | 1 | 82945 | 2 | 1.296 | 64000.8 |
218 | 2023-04-08 11:23:08 | scantest | 3 | 146162 | 208 | 6.563 | 22270.6 |
217 | 2023-03-19 08:25:12 | scantest | 1 | 82945 | 2 | 1.300 | 63803.8 |
216 | 2023-03-18 20:31:58 | scantest | 2 | 121059 | 17 | 3.203 | 37795.5 |
215 | 2023-03-01 01:09:33 | scantest | 1 | 82945 | 2 | 1.373 | 60411.5 |
214 | 2023-01-14 11:42:19 | scantest | 3 | 146162 | 208 | 6.860 | 21306.4 |
213 | 2022-12-25 08:35:54 | scantest | 1 | 82945 | 2 | 1.263 | 65673.0 |
212 | 2022-12-22 13:40:16 | scantest | 2 | 121059 | 17 | 3.143 | 38517.0 |
211 | 2022-12-17 18:02:07 | scantest | 1 | 82945 | 2 | 1.390 | 59672.7 |
210 | 2022-11-30 19:50:29 | scantest | 2 | 121059 | 17 | 3.156 | 38358.4 |
209 | 2022-10-22 20:03:05 | scantest | 2 | 121059 | 17 | 3.190 | 37949.5 |
208 | 2022-10-20 09:39:24 | scantest | 3 | 146162 | 208 | 6.470 | 22590.7 |
207 | 2022-09-13 07:51:14 | scantest | 1 | 82945 | 2 | 1.296 | 64000.8 |
206 | 2022-08-18 07:16:51 | scantest | 2 | 121059 | 17 | 3.236 | 37410.1 |
205 | 2022-08-01 03:57:29 | scantest | 1 | 82945 | 2 | 1.296 | 64000.8 |
204 | 2022-07-28 17:14:22 | scantest | 1 | 82945 | 2 | 1.313 | 63172.1 |
203 | 2022-07-19 12:15:06 | scantest | 1 | 82945 | 2 | 1.280 | 64800.8 |
202 | 2022-07-13 23:44:01 | scantest | 1 | 82945 | 2 | 1.420 | 58412.0 |
201 | 2022-05-21 19:24:42 | scantest | 3 | 146162 | 208 | 6.563 | 22270.6 |
200 | 2022-04-10 19:27:10 | scantest | 1 | 82945 | 2 | 1.283 | 64649.3 |
199 | 2022-03-29 03:09:16 | scantest | 1 | 82945 | 2 | 1.343 | 61761.0 |
198 | 2022-03-26 23:01:31 | scantest | 1 | 82945 | 2 | 1.373 | 60411.5 |
197 | 2022-03-20 10:52:25 | scantest | 1 | 82945 | 2 | 1.343 | 61761.0 |
196 | 2022-03-17 00:22:30 | scantest | 1 | 82945 | 2 | 1.500 | 55296.7 |
195 | 2021-11-16 09:52:12 | scantest | 1 | 82945 | 2 | 1.296 | 64000.8 |
194 | 2021-08-27 01:32:05 | scantest | 1 | 82945 | 2 | 1.296 | 64000.8 |
193 | 2021-08-06 17:36:00 | scantest | 1 | 82945 | 2 | 1.313 | 63172.1 |
192 | 2021-04-21 10:29:50 | scantest | 1 | 82945 | 2 | 1.313 | 63172.1 |
191 | 2021-04-17 18:04:47 | scantest | 1 | 82945 | 2 | 1.516 | 54713.1 |
190 | 2021-03-26 10:54:45 | scantest | 1 | 82945 | 2 | 1.330 | 62364.7 |
189 | 2021-01-09 18:09:50 | scantest | 1 | 82945 | 2 | 1.440 | 57600.7 |
188 | 2021-01-04 06:15:52 | scantest | 1 | 82945 | 2 | 1.390 | 59672.7 |
187 | 2020-11-14 01:34:04 | scantest | 1 | 82945 | 2 | 1.483 | 55930.5 |
186 | 2020-10-25 20:07:14 | scantest | 1 | 82945 | 2 | 1.343 | 61761.0 |
185 | 2020-10-22 22:12:31 | scantest | 1 | 82945 | 2 | 1.283 | 64649.3 |
184 | 2020-10-02 16:07:32 | scantest | 1 | 82945 | 2 | 1.280 | 64800.8 |
183 | 2020-09-28 04:06:28 | scantest | 1 | 82945 | 2 | 1.483 | 55930.5 |
182 | 2020-08-14 06:47:18 | scantest | 1 | 82945 | 2 | 1.593 | 52068.4 |
181 | 2020-07-25 14:59:13 | scantest | 1 | 82945 | 2 | 1.373 | 60411.5 |
180 | 2020-07-23 11:02:00 | scantest | 1 | 82945 | 2 | 1.346 | 61623.3 |
179 | 2020-06-15 21:21:59 | scantest | 1 | 82945 | 2 | 1.576 | 52630.1 |
178 | 2020-03-27 18:08:26 | scantest | 1 | 82945 | 2 | 1.516 | 54713.1 |
177 | 2020-03-22 04:52:36 | scantest | 1 | 82945 | 2 | 2.000 | 41472.5 |
176 | 2020-03-11 06:28:29 | scantest | 1 | 82945 | 2 | 1.440 | 57600.7 |
175 | 2020-02-25 10:04:47 | scantest | 1 | 82945 | 2 | 1.550 | 53512.9 |
174 | 2020-02-25 06:03:08 | scantest | 1 | 82945 | 2 | 2.110 | 39310.4 |
173 | 2020-02-17 21:19:02 | scantest | 1 | 82945 | 2 | 1.623 | 51106.0 |
172 | 2020-02-14 22:32:05 | scantest | 1 | 82945 | 2 | 1.580 | 52496.8 |
171 | 2020-02-05 06:37:03 | scantest | 1 | 82945 | 2 | 1.563 | 53067.8 |
170 | 2020-02-05 02:43:30 | scantest | 1 | 82945 | 2 | 1.453 | 57085.3 |
169 | 2020-01-27 05:46:32 | scantest | 1 | 82945 | 2 | 2.186 | 37943.7 |
168 | 2020-01-23 04:53:19 | scantest | 1 | 82945 | 2 | 3.500 | 23698.6 |
167 | 2020-01-22 19:27:22 | scantest | 1 | 82945 | 2 | 3.296 | 25165.4 |