History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trotting"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
281 | 2024-04-27 14:49:47 | trotting | 1 | 82945 | 4 | 5.830 | 14227.3 |
280 | 2024-04-25 10:45:56 | trotting | 3 | 146162 | 463 | 9.670 | 15115.0 |
279 | 2024-04-25 10:45:59 | trotting | 2 | 121059 | 59 | 6.643 | 18223.5 |
278 | 2024-04-23 11:17:17 | trotting | 2 | 121059 | 59 | 6.596 | 18353.4 |
277 | 2024-04-23 11:17:12 | trotting | 3 | 146162 | 463 | 9.423 | 15511.2 |
276 | 2024-04-23 02:49:51 | trotting | 1 | 82945 | 4 | 2.716 | 30539.4 |
275 | 2024-04-23 02:49:38 | trotting | 3 | 146162 | 463 | 12.203 | 11977.5 |
274 | 2024-04-23 02:49:40 | trotting | 2 | 121059 | 59 | 5.873 | 20612.8 |
273 | 2024-04-22 12:09:29 | trotting | 1 | 82945 | 4 | 2.030 | 40859.6 |
272 | 2024-04-13 07:07:35 | trotting | 1 | 82945 | 4 | 1.360 | 60989.0 |
271 | 2024-03-29 23:42:19 | trotting | 1 | 82945 | 4 | 4.266 | 19443.3 |
270 | 2024-03-04 16:41:25 | trotting | 1 | 82945 | 4 | 2.716 | 30539.4 |
269 | 2024-02-13 16:51:53 | trotting | 3 | 146162 | 463 | 16.860 | 8669.2 |
268 | 2024-02-12 13:25:26 | trotting | 2 | 121059 | 59 | 4.296 | 28179.5 |
267 | 2024-02-12 11:39:54 | trotting | 3 | 146162 | 463 | 12.766 | 11449.3 |
266 | 2024-02-11 18:15:45 | trotting | 2 | 121059 | 59 | 12.076 | 10024.8 |
265 | 2024-02-09 20:40:09 | trotting | 3 | 146162 | 463 | 14.830 | 9855.8 |
264 | 2024-02-09 19:08:28 | trotting | 2 | 121059 | 59 | 3.703 | 32692.1 |
263 | 2024-02-09 19:07:37 | trotting | 3 | 146162 | 463 | 8.033 | 18195.2 |
262 | 2024-02-08 03:46:16 | trotting | 3 | 146162 | 463 | 13.860 | 10545.6 |
261 | 2024-02-08 00:57:06 | trotting | 3 | 146162 | 463 | 14.266 | 10245.5 |
260 | 2024-02-08 00:57:05 | trotting | 2 | 121059 | 59 | 11.003 | 11002.4 |
259 | 2024-01-31 22:05:32 | trotting | 1 | 82945 | 4 | 1.483 | 55930.5 |
258 | 2024-01-04 16:48:59 | trotting | 3 | 146162 | 463 | 6.593 | 22169.3 |
257 | 2023-12-30 01:17:30 | trotting | 1 | 82945 | 4 | 1.326 | 62552.8 |
256 | 2023-12-25 09:17:49 | trotting | 1 | 82945 | 4 | 1.343 | 61761.0 |
255 | 2023-12-10 23:52:14 | trotting | 1 | 82945 | 4 | 1.410 | 58826.2 |
254 | 2023-12-06 03:19:20 | trotting | 1 | 82945 | 4 | 1.470 | 56425.2 |
253 | 2023-11-05 04:23:51 | trotting | 1 | 82945 | 4 | 1.360 | 60989.0 |
252 | 2023-11-03 06:41:35 | trotting | 1 | 82945 | 4 | 1.263 | 65673.0 |
251 | 2023-10-27 16:16:20 | trotting | 1 | 82945 | 4 | 1.420 | 58412.0 |
250 | 2023-10-18 11:45:01 | trotting | 1 | 82945 | 4 | 1.486 | 55817.6 |
249 | 2023-10-11 07:41:35 | trotting | 3 | 146162 | 463 | 8.190 | 17846.4 |
248 | 2023-10-06 20:52:58 | trotting | 1 | 82945 | 4 | 1.406 | 58993.6 |
247 | 2023-09-23 12:13:28 | trotting | 1 | 82945 | 4 | 1.453 | 57085.3 |
246 | 2023-08-15 03:59:26 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
245 | 2023-07-23 00:21:51 | trotting | 3 | 146162 | 463 | 7.300 | 20022.2 |
244 | 2023-06-26 05:09:57 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
243 | 2023-05-13 05:33:35 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
242 | 2023-04-04 04:55:01 | trotting | 3 | 146162 | 463 | 6.126 | 23859.3 |
241 | 2023-03-07 23:51:53 | trotting | 1 | 82945 | 4 | 1.233 | 67270.9 |
240 | 2023-02-21 15:14:58 | trotting | 1 | 82945 | 4 | 1.390 | 59672.7 |
239 | 2023-01-01 01:38:26 | trotting | 3 | 146162 | 463 | 7.173 | 20376.7 |
238 | 2022-12-28 22:32:29 | trotting | 1 | 82945 | 4 | 1.360 | 60989.0 |
237 | 2022-10-13 22:56:11 | trotting | 1 | 82945 | 4 | 1.330 | 62364.7 |
236 | 2022-09-16 23:42:44 | trotting | 1 | 82945 | 4 | 1.263 | 65673.0 |
235 | 2022-09-01 20:52:35 | trotting | 3 | 146162 | 463 | 6.783 | 21548.3 |
234 | 2022-09-01 08:13:31 | trotting | 1 | 82945 | 4 | 1.330 | 62364.7 |
233 | 2022-06-29 21:58:07 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
232 | 2022-06-12 10:52:37 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
231 | 2022-06-07 09:51:40 | trotting | 3 | 146162 | 463 | 7.343 | 19904.9 |
230 | 2022-05-05 06:53:51 | trotting | 3 | 146162 | 463 | 6.406 | 22816.4 |
229 | 2022-03-27 09:00:54 | trotting | 3 | 146162 | 463 | 6.626 | 22058.9 |
228 | 2022-03-04 18:54:36 | trotting | 1 | 82945 | 4 | 1.453 | 57085.3 |
227 | 2022-02-04 12:18:30 | trotting | 1 | 82945 | 4 | 1.453 | 57085.3 |
226 | 2022-01-21 23:24:25 | trotting | 1 | 82945 | 4 | 1.343 | 61761.0 |
225 | 2021-12-21 14:58:35 | trotting | 1 | 82945 | 4 | 1.483 | 55930.5 |
224 | 2021-12-19 12:48:44 | trotting | 1 | 82945 | 4 | 1.500 | 55296.7 |
223 | 2021-11-10 02:45:41 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
222 | 2021-10-22 12:49:15 | trotting | 1 | 82945 | 4 | 2.420 | 34274.8 |
221 | 2021-10-15 02:42:09 | trotting | 1 | 82945 | 4 | 1.390 | 59672.7 |
220 | 2021-09-23 06:35:58 | trotting | 1 | 82945 | 4 | 1.486 | 55817.6 |
219 | 2021-07-14 04:31:56 | trotting | 1 | 82945 | 4 | 1.470 | 56425.2 |
218 | 2021-04-10 22:40:02 | trotting | 1 | 82945 | 4 | 1.360 | 60989.0 |
217 | 2021-04-07 19:43:36 | trotting | 1 | 82945 | 4 | 1.313 | 63172.1 |
216 | 2021-02-15 14:13:10 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
215 | 2020-12-28 16:53:43 | trotting | 1 | 82945 | 4 | 1.296 | 64000.8 |
214 | 2020-12-24 03:04:57 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
213 | 2020-11-01 02:13:43 | trotting | 1 | 82945 | 4 | 1.313 | 63172.1 |
212 | 2020-10-28 02:00:25 | trotting | 1 | 82945 | 4 | 1.280 | 64800.8 |
211 | 2020-10-26 07:58:43 | trotting | 1 | 82945 | 4 | 1.373 | 60411.5 |
210 | 2020-10-05 17:35:22 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
209 | 2020-09-25 05:30:08 | trotting | 1 | 82945 | 4 | 1.313 | 63172.1 |
208 | 2020-08-30 01:45:27 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
207 | 2020-08-27 03:28:38 | trotting | 1 | 82945 | 4 | 1.406 | 58993.6 |
206 | 2020-06-10 15:24:25 | trotting | 1 | 82945 | 4 | 1.283 | 64649.3 |
205 | 2020-06-07 18:38:22 | trotting | 1 | 82945 | 4 | 1.266 | 65517.4 |
204 | 2020-03-21 04:39:59 | trotting | 1 | 82945 | 4 | 1.423 | 58288.8 |
203 | 2020-03-19 20:33:39 | trotting | 1 | 82945 | 4 | 1.546 | 53651.4 |
202 | 2020-03-09 01:51:26 | trotting | 1 | 82945 | 4 | 1.420 | 58412.0 |
201 | 2020-03-02 01:27:27 | trotting | 1 | 82945 | 4 | 1.313 | 63172.1 |
200 | 2020-02-24 12:17:54 | trotting | 1 | 82945 | 4 | 1.406 | 58993.6 |
199 | 2020-02-22 13:24:53 | trotting | 3 | 146162 | 463 | 15.500 | 9429.8 |
198 | 2020-02-22 09:35:54 | trotting | 3 | 146162 | 463 | 8.456 | 17285.0 |
197 | 2020-02-21 05:37:33 | trotting | 1 | 82945 | 4 | 1.483 | 55930.5 |
196 | 2020-02-11 23:52:59 | trotting | 1 | 82945 | 4 | 2.813 | 29486.3 |
195 | 2020-02-11 17:47:32 | trotting | 1 | 82945 | 4 | 1.656 | 50087.6 |
194 | 2020-02-11 11:47:59 | trotting | 3 | 146162 | 463 | 18.033 | 8105.3 |
193 | 2020-02-11 02:11:33 | trotting | 3 | 146162 | 463 | 14.233 | 10269.2 |
192 | 2020-02-10 18:36:11 | trotting | 3 | 146162 | 463 | 13.233 | 11045.3 |
191 | 2020-02-10 15:38:29 | trotting | 3 | 146162 | 463 | 18.906 | 7731.0 |
190 | 2020-02-05 01:16:42 | trotting | 1 | 82945 | 4 | 4.640 | 17876.1 |
189 | 2020-01-31 00:05:16 | trotting | 1 | 82945 | 4 | 2.970 | 27927.6 |
188 | 2020-01-27 14:04:51 | trotting | 1 | 82945 | 4 | 4.796 | 17294.6 |
187 | 2020-01-27 12:13:26 | trotting | 1 | 82945 | 4 | 1.326 | 62552.8 |
186 | 2020-01-26 12:51:27 | trotting | 1 | 82945 | 4 | 1.440 | 57600.7 |
185 | 2020-01-22 00:55:33 | trotting | 1 | 82945 | 4 | 2.360 | 35146.2 |
184 | 2020-01-19 03:57:04 | trotting | 1 | 82945 | 4 | 2.330 | 35598.7 |
183 | 2020-01-14 15:54:38 | trotting | 2 | 121059 | 59 | 9.890 | 12240.5 |
182 | 2020-01-14 14:07:38 | trotting | 2 | 121059 | 59 | 11.736 | 10315.2 |