History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"tattered"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
294 | 2024-04-17 02:02:43 | tattered | 1 | 82945 | 8 | 1.470 | 56425.2 |
293 | 2024-04-13 17:32:20 | tattered | 3 | 146162 | 340 | 15.013 | 9735.7 |
292 | 2024-04-11 03:56:51 | tattered | 2 | 121059 | 71 | 4.033 | 30017.1 |
291 | 2024-04-10 20:19:11 | tattered | 3 | 146162 | 340 | 16.033 | 9116.3 |
290 | 2024-04-09 17:43:17 | tattered | 3 | 146162 | 340 | 24.676 | 5923.2 |
289 | 2024-04-08 23:25:14 | tattered | 3 | 146162 | 340 | 15.533 | 9409.8 |
288 | 2024-04-08 23:25:24 | tattered | 1 | 82945 | 8 | 3.360 | 24686.0 |
287 | 2024-04-08 23:25:11 | tattered | 2 | 121059 | 71 | 8.250 | 14673.8 |
286 | 2024-04-08 18:33:49 | tattered | 3 | 146162 | 340 | 24.953 | 5857.5 |
285 | 2024-04-08 18:33:49 | tattered | 2 | 121059 | 71 | 16.110 | 7514.5 |
284 | 2024-04-08 18:31:40 | tattered | 1 | 82945 | 8 | 2.360 | 35146.2 |
283 | 2024-04-06 08:28:37 | tattered | 1 | 82945 | 8 | 9.766 | 8493.2 |
282 | 2024-03-15 15:07:11 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
281 | 2024-03-05 23:13:01 | tattered | 1 | 82945 | 8 | 1.923 | 43133.1 |
280 | 2024-03-04 20:41:22 | tattered | 1 | 82945 | 8 | 3.233 | 25655.7 |
279 | 2024-03-01 14:25:27 | tattered | 1 | 82945 | 8 | 1.796 | 46183.2 |
278 | 2024-03-01 14:24:57 | tattered | 3 | 146162 | 340 | 11.720 | 12471.2 |
277 | 2024-02-29 01:40:45 | tattered | 2 | 121059 | 71 | 3.283 | 36874.5 |
276 | 2024-02-29 01:28:00 | tattered | 3 | 146162 | 340 | 9.703 | 15063.6 |
275 | 2024-02-28 10:12:10 | tattered | 2 | 121059 | 71 | 13.156 | 9201.8 |
274 | 2024-02-27 21:28:52 | tattered | 3 | 146162 | 340 | 8.503 | 17189.5 |
273 | 2024-02-27 05:55:04 | tattered | 3 | 146162 | 340 | 7.580 | 19282.6 |
272 | 2024-02-27 05:54:33 | tattered | 2 | 121059 | 71 | 4.016 | 30144.2 |
271 | 2024-02-25 15:11:01 | tattered | 2 | 121059 | 71 | 3.546 | 34139.6 |
270 | 2024-01-25 17:16:43 | tattered | 3 | 146162 | 340 | 7.313 | 19986.6 |
269 | 2024-01-16 06:30:31 | tattered | 3 | 146162 | 340 | 13.923 | 10497.9 |
268 | 2023-12-28 04:36:02 | tattered | 1 | 82945 | 8 | 1.360 | 60989.0 |
267 | 2023-12-14 17:43:20 | tattered | 1 | 82945 | 8 | 1.313 | 63172.1 |
266 | 2023-12-05 08:59:45 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
265 | 2023-11-17 14:24:05 | tattered | 3 | 146162 | 340 | 7.190 | 20328.5 |
264 | 2023-11-17 14:23:59 | tattered | 2 | 121059 | 71 | 3.580 | 33815.4 |
263 | 2023-11-17 13:49:16 | tattered | 2 | 121059 | 71 | 3.376 | 35858.7 |
262 | 2023-11-08 10:21:56 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
261 | 2023-10-29 21:55:33 | tattered | 1 | 82945 | 8 | 1.436 | 57761.1 |
260 | 2023-10-18 04:57:13 | tattered | 1 | 82945 | 8 | 1.486 | 55817.6 |
259 | 2023-10-13 04:36:09 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
258 | 2023-10-08 17:33:08 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
257 | 2023-09-30 10:19:00 | tattered | 1 | 82945 | 8 | 1.266 | 65517.4 |
256 | 2023-08-18 17:14:13 | tattered | 2 | 121059 | 71 | 3.203 | 37795.5 |
255 | 2023-07-27 23:27:01 | tattered | 1 | 82945 | 8 | 1.326 | 62552.8 |
254 | 2023-06-12 22:35:24 | tattered | 1 | 82945 | 8 | 1.390 | 59672.7 |
253 | 2023-05-05 20:47:41 | tattered | 1 | 82945 | 8 | 1.360 | 60989.0 |
252 | 2023-05-05 05:36:26 | tattered | 2 | 121059 | 71 | 3.203 | 37795.5 |
251 | 2023-04-21 07:41:13 | tattered | 1 | 82945 | 8 | 1.250 | 66356.0 |
250 | 2023-03-22 15:11:15 | tattered | 1 | 82945 | 8 | 1.360 | 60989.0 |
249 | 2023-02-14 18:19:36 | tattered | 1 | 82945 | 8 | 1.436 | 57761.1 |
248 | 2023-02-11 19:10:55 | tattered | 2 | 121059 | 71 | 3.123 | 38763.7 |
247 | 2023-02-07 17:53:28 | tattered | 1 | 82945 | 8 | 1.423 | 58288.8 |
246 | 2022-12-11 06:22:41 | tattered | 1 | 82945 | 8 | 1.373 | 60411.5 |
245 | 2022-11-24 01:55:57 | tattered | 2 | 121059 | 71 | 3.500 | 34588.3 |
244 | 2022-10-06 15:32:01 | tattered | 1 | 82945 | 8 | 2.533 | 32745.8 |
243 | 2022-10-03 01:21:54 | tattered | 1 | 82945 | 8 | 1.263 | 65673.0 |
242 | 2022-08-15 00:15:33 | tattered | 1 | 82945 | 8 | 1.263 | 65673.0 |
241 | 2022-07-18 23:37:22 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
240 | 2022-06-01 23:11:37 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
239 | 2022-05-29 18:45:25 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
238 | 2022-04-27 14:52:19 | tattered | 2 | 121059 | 71 | 3.876 | 31233.0 |
237 | 2022-04-23 03:15:55 | tattered | 2 | 121059 | 71 | 4.173 | 29010.1 |
236 | 2022-04-06 01:41:32 | tattered | 1 | 82945 | 8 | 1.813 | 45750.1 |
235 | 2022-01-28 13:49:19 | tattered | 1 | 82945 | 8 | 1.263 | 65673.0 |
234 | 2022-01-05 11:59:10 | tattered | 1 | 82945 | 8 | 1.640 | 50576.2 |
233 | 2021-12-24 06:10:20 | tattered | 2 | 121059 | 71 | 3.220 | 37596.0 |
232 | 2021-11-09 22:28:44 | tattered | 1 | 82945 | 8 | 1.500 | 55296.7 |
231 | 2021-11-07 20:39:54 | tattered | 1 | 82945 | 8 | 1.390 | 59672.7 |
230 | 2021-10-08 16:03:46 | tattered | 1 | 82945 | 8 | 1.420 | 58412.0 |
229 | 2021-10-06 13:31:07 | tattered | 2 | 121059 | 71 | 3.703 | 32692.1 |
228 | 2021-09-23 06:42:28 | tattered | 1 | 82945 | 8 | 1.453 | 57085.3 |
227 | 2021-09-01 11:32:52 | tattered | 1 | 82945 | 8 | 1.313 | 63172.1 |
226 | 2021-07-25 02:33:05 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
225 | 2021-07-11 22:03:36 | tattered | 1 | 82945 | 8 | 1.436 | 57761.1 |
224 | 2021-07-10 10:01:28 | tattered | 1 | 82945 | 8 | 1.266 | 65517.4 |
223 | 2021-05-15 07:45:10 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
222 | 2021-04-06 14:52:27 | tattered | 1 | 82945 | 8 | 1.406 | 58993.6 |
221 | 2021-04-02 11:00:39 | tattered | 1 | 82945 | 8 | 2.610 | 31779.7 |
220 | 2021-03-18 02:54:56 | tattered | 1 | 82945 | 8 | 1.466 | 56579.1 |
219 | 2020-12-30 06:21:19 | tattered | 1 | 82945 | 8 | 1.483 | 55930.5 |
218 | 2020-12-25 03:49:54 | tattered | 1 | 82945 | 8 | 1.313 | 63172.1 |
217 | 2020-12-02 13:31:17 | tattered | 1 | 82945 | 8 | 1.296 | 64000.8 |
216 | 2020-11-11 17:31:55 | tattered | 1 | 82945 | 8 | 1.530 | 54212.4 |
215 | 2020-10-28 22:34:30 | tattered | 2 | 121059 | 71 | 3.733 | 32429.4 |
214 | 2020-10-23 14:42:53 | tattered | 1 | 82945 | 8 | 1.283 | 64649.3 |
213 | 2020-09-25 05:29:50 | tattered | 1 | 82945 | 8 | 1.280 | 64800.8 |
212 | 2020-09-04 11:46:00 | tattered | 1 | 82945 | 8 | 1.326 | 62552.8 |
211 | 2020-08-29 03:18:54 | tattered | 1 | 82945 | 8 | 1.610 | 51518.6 |
210 | 2020-08-24 00:52:55 | tattered | 1 | 82945 | 8 | 1.500 | 55296.7 |
209 | 2020-08-02 07:31:54 | tattered | 1 | 82945 | 8 | 1.423 | 58288.8 |
208 | 2020-07-24 07:10:48 | tattered | 1 | 82945 | 8 | 1.343 | 61761.0 |
207 | 2020-06-21 04:39:04 | tattered | 1 | 82945 | 8 | 1.903 | 43586.4 |
206 | 2020-06-13 15:04:37 | tattered | 1 | 82945 | 8 | 1.330 | 62364.7 |
205 | 2020-03-29 06:24:27 | tattered | 1 | 82945 | 8 | 1.826 | 45424.4 |
204 | 2020-03-22 02:08:22 | tattered | 1 | 82945 | 8 | 1.516 | 54713.1 |
203 | 2020-03-19 23:22:51 | tattered | 1 | 82945 | 8 | 1.406 | 58993.6 |
202 | 2020-03-09 01:51:13 | tattered | 1 | 82945 | 8 | 1.423 | 58288.8 |
201 | 2020-02-28 13:21:33 | tattered | 3 | 146162 | 340 | 26.360 | 5544.8 |
200 | 2020-02-28 12:45:58 | tattered | 3 | 146162 | 340 | 18.376 | 7954.0 |
199 | 2020-02-27 16:27:07 | tattered | 3 | 146162 | 340 | 12.623 | 11579.0 |
198 | 2020-02-27 12:37:31 | tattered | 3 | 146162 | 340 | 7.296 | 20033.2 |
197 | 2020-02-26 21:29:01 | tattered | 1 | 82945 | 8 | 1.546 | 53651.4 |
196 | 2020-02-24 09:16:01 | tattered | 1 | 82945 | 8 | 1.593 | 52068.4 |
195 | 2020-02-19 19:52:33 | tattered | 3 | 146162 | 340 | 9.060 | 16132.7 |