History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"excreta"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-05-03 18:05:33 | excreta | 1 | 69583 | 3 | 1.330 | 52318.0 |
275 | 2024-04-15 22:26:41 | excreta | 2 | 107671 | 7 | 2.826 | 38100.1 |
274 | 2024-04-02 18:49:02 | excreta | 4 | 151207 | 623 | 34.346 | 4402.5 |
273 | 2024-04-01 09:40:44 | excreta | 4 | 151207 | 623 | 20.890 | 7238.2 |
272 | 2024-03-30 05:52:28 | excreta | 2 | 107671 | 7 | 7.830 | 13751.1 |
271 | 2024-03-29 23:25:23 | excreta | 3 | 134027 | 58 | 21.390 | 6265.9 |
270 | 2024-03-29 12:39:41 | excreta | 4 | 151207 | 623 | 36.563 | 4135.5 |
269 | 2024-03-29 12:39:40 | excreta | 2 | 107671 | 7 | 7.783 | 13834.1 |
268 | 2024-03-29 12:39:39 | excreta | 3 | 134027 | 58 | 8.000 | 16753.4 |
267 | 2024-03-29 12:13:39 | excreta | 1 | 69583 | 3 | 3.843 | 18106.4 |
266 | 2024-03-01 20:00:10 | excreta | 1 | 69583 | 3 | 1.690 | 41173.4 |
265 | 2024-02-20 17:08:53 | excreta | 1 | 69583 | 3 | 1.970 | 35321.3 |
264 | 2024-01-19 16:04:41 | excreta | 1 | 69583 | 3 | 1.250 | 55666.4 |
263 | 2024-01-15 22:50:03 | excreta | 1 | 69583 | 3 | 1.266 | 54962.9 |
262 | 2024-01-08 16:29:47 | excreta | 4 | 151207 | 623 | 9.640 | 15685.4 |
261 | 2023-12-27 02:03:37 | excreta | 1 | 69583 | 3 | 1.190 | 58473.1 |
260 | 2023-12-15 03:00:56 | excreta | 2 | 107671 | 7 | 3.016 | 35699.9 |
259 | 2023-11-30 10:54:38 | excreta | 1 | 69583 | 3 | 1.233 | 56433.9 |
258 | 2023-11-12 10:53:44 | excreta | 1 | 69583 | 3 | 2.406 | 28920.6 |
257 | 2023-11-05 01:53:48 | excreta | 1 | 69583 | 3 | 1.030 | 67556.3 |
256 | 2023-11-03 18:02:07 | excreta | 1 | 69583 | 3 | 1.140 | 61037.7 |
255 | 2023-10-31 12:01:53 | excreta | 1 | 69583 | 3 | 1.156 | 60192.9 |
254 | 2023-10-22 03:08:59 | excreta | 4 | 151207 | 623 | 13.550 | 11159.2 |
253 | 2023-10-18 18:39:55 | excreta | 4 | 151207 | 623 | 12.936 | 11688.9 |
252 | 2023-10-15 15:27:06 | excreta | 4 | 151207 | 623 | 11.330 | 13345.7 |
251 | 2023-09-15 17:13:55 | excreta | 2 | 107671 | 7 | 2.750 | 39153.1 |
250 | 2023-09-01 14:57:25 | excreta | 1 | 69583 | 3 | 1.143 | 60877.5 |
249 | 2023-07-25 19:07:55 | excreta | 4 | 151207 | 623 | 11.423 | 13237.1 |
248 | 2023-06-26 19:00:33 | excreta | 1 | 69583 | 3 | 2.093 | 33245.6 |
247 | 2023-06-19 18:22:38 | excreta | 2 | 107671 | 7 | 2.843 | 37872.3 |
246 | 2023-06-06 02:56:17 | excreta | 1 | 69583 | 3 | 1.033 | 67360.1 |
245 | 2023-04-03 20:33:38 | excreta | 4 | 151207 | 623 | 9.376 | 16127.0 |
244 | 2023-03-27 17:26:24 | excreta | 1 | 69583 | 3 | 1.096 | 63488.1 |
243 | 2023-03-17 20:05:27 | excreta | 2 | 107671 | 7 | 2.673 | 40281.0 |
242 | 2023-02-28 23:16:45 | excreta | 1 | 69583 | 3 | 1.156 | 60192.9 |
241 | 2023-01-10 22:27:50 | excreta | 1 | 69583 | 3 | 1.140 | 61037.7 |
240 | 2023-01-01 00:34:35 | excreta | 4 | 151207 | 623 | 9.643 | 15680.5 |
239 | 2022-12-20 08:49:26 | excreta | 2 | 107671 | 7 | 6.110 | 17622.1 |
238 | 2022-11-01 15:04:54 | excreta | 1 | 69583 | 3 | 1.046 | 66522.9 |
237 | 2022-10-14 17:34:26 | excreta | 1 | 69583 | 3 | 1.030 | 67556.3 |
236 | 2022-09-05 08:06:18 | excreta | 4 | 151207 | 623 | 9.516 | 15889.8 |
235 | 2022-08-23 01:00:14 | excreta | 3 | 134027 | 58 | 5.563 | 24092.6 |
234 | 2022-08-18 18:32:11 | excreta | 2 | 107671 | 7 | 2.766 | 38926.6 |
233 | 2022-06-27 23:52:33 | excreta | 1 | 69583 | 3 | 1.046 | 66522.9 |
232 | 2022-06-04 00:04:38 | excreta | 1 | 69583 | 3 | 1.076 | 64668.2 |
231 | 2022-06-01 17:49:20 | excreta | 1 | 69583 | 3 | 1.096 | 63488.1 |
230 | 2022-02-15 16:32:39 | excreta | 1 | 69583 | 3 | 1.033 | 67360.1 |
229 | 2022-02-11 16:33:05 | excreta | 1 | 69583 | 3 | 1.030 | 67556.3 |
228 | 2021-12-03 07:39:51 | excreta | 1 | 69583 | 3 | 1.160 | 59985.3 |
227 | 2021-10-25 06:55:08 | excreta | 1 | 69583 | 3 | 1.110 | 62687.4 |
226 | 2021-10-12 18:45:09 | excreta | 1 | 69583 | 3 | 1.250 | 55666.4 |
225 | 2021-10-10 15:55:40 | excreta | 1 | 69583 | 3 | 1.266 | 54962.9 |
224 | 2021-07-11 03:23:01 | excreta | 1 | 69583 | 3 | 1.190 | 58473.1 |
223 | 2021-04-07 05:23:47 | excreta | 1 | 69583 | 3 | 1.170 | 59472.6 |
222 | 2021-04-03 01:33:59 | excreta | 1 | 69583 | 3 | 1.063 | 65459.1 |
221 | 2021-04-02 07:31:42 | excreta | 1 | 69583 | 3 | 1.106 | 62914.1 |
220 | 2021-02-10 21:19:34 | excreta | 1 | 69583 | 3 | 1.153 | 60349.5 |
219 | 2021-01-17 08:23:00 | excreta | 1 | 69583 | 3 | 1.076 | 64668.2 |
218 | 2020-12-22 01:20:51 | excreta | 1 | 69583 | 3 | 1.156 | 60192.9 |
217 | 2020-11-01 20:31:34 | excreta | 1 | 69583 | 3 | 1.483 | 46920.4 |
216 | 2020-10-28 01:45:37 | excreta | 1 | 69583 | 3 | 1.233 | 56433.9 |
215 | 2020-10-27 02:27:20 | excreta | 1 | 69583 | 3 | 1.233 | 56433.9 |
214 | 2020-10-18 20:41:56 | excreta | 1 | 69583 | 3 | 1.046 | 66522.9 |
213 | 2020-10-03 05:33:59 | excreta | 1 | 69583 | 3 | 1.046 | 66522.9 |
212 | 2020-09-21 20:45:34 | excreta | 1 | 69583 | 3 | 1.186 | 58670.3 |
211 | 2020-08-27 20:40:56 | excreta | 1 | 69583 | 3 | 1.110 | 62687.4 |
210 | 2020-05-30 02:31:59 | excreta | 1 | 69583 | 3 | 1.063 | 65459.1 |
209 | 2020-03-30 07:47:58 | excreta | 1 | 69583 | 3 | 1.296 | 53690.6 |
208 | 2020-03-29 15:25:50 | excreta | 1 | 69583 | 3 | 1.156 | 60192.9 |
207 | 2020-03-28 15:50:01 | excreta | 1 | 69583 | 3 | 1.190 | 58473.1 |
206 | 2020-03-28 07:36:04 | excreta | 1 | 69583 | 3 | 1.266 | 54962.9 |
205 | 2020-03-27 19:11:12 | excreta | 1 | 69583 | 3 | 1.236 | 56296.9 |
204 | 2020-03-21 20:35:28 | excreta | 1 | 69583 | 3 | 1.126 | 61796.6 |
203 | 2020-02-26 17:24:13 | excreta | 1 | 69583 | 3 | 1.330 | 52318.0 |
202 | 2020-02-24 08:10:03 | excreta | 1 | 69583 | 3 | 1.266 | 54962.9 |
201 | 2020-02-20 19:52:52 | excreta | 1 | 69583 | 3 | 1.190 | 58473.1 |
200 | 2020-02-19 19:49:33 | excreta | 1 | 69583 | 3 | 1.220 | 57035.2 |
199 | 2020-02-05 13:37:08 | excreta | 1 | 69583 | 3 | 1.360 | 51164.0 |
198 | 2020-01-31 01:23:56 | excreta | 1 | 69583 | 3 | 2.813 | 24736.2 |
197 | 2020-01-27 13:59:46 | excreta | 1 | 69583 | 3 | 1.470 | 47335.4 |
196 | 2020-01-25 08:27:57 | excreta | 1 | 69583 | 3 | 3.406 | 20429.5 |
195 | 2020-01-24 10:31:53 | excreta | 1 | 69583 | 3 | 1.203 | 57841.2 |
194 | 2020-01-18 07:01:13 | excreta | 1 | 69583 | 3 | 1.220 | 57035.2 |
193 | 2020-01-18 02:36:57 | excreta | 1 | 69583 | 3 | 1.216 | 57222.9 |
192 | 2020-01-17 23:42:38 | excreta | 1 | 69583 | 3 | 1.313 | 52995.4 |
191 | 2020-01-10 23:44:00 | excreta | 1 | 69583 | 3 | 1.076 | 64668.2 |
190 | 2020-01-03 05:19:57 | excreta | 1 | 69583 | 3 | 1.483 | 46920.4 |
189 | 2020-01-01 14:13:44 | excreta | 1 | 69583 | 3 | 3.153 | 22068.8 |
188 | 2019-12-30 23:25:04 | excreta | 1 | 69583 | 3 | 1.250 | 55666.4 |
187 | 2019-11-21 21:12:12 | excreta | 1 | 69583 | 3 | 1.266 | 54962.9 |
186 | 2019-11-21 08:13:05 | excreta | 1 | 69583 | 3 | 1.186 | 58670.3 |
185 | 2019-08-19 23:27:41 | excreta | 1 | 69583 | 3 | 1.023 | 68018.6 |
184 | 2019-05-10 18:31:05 | excreta | 1 | 69583 | 3 | 1.226 | 56756.1 |
183 | 2019-01-19 15:30:48 | excreta | 1 | 69583 | 3 | 1.146 | 60718.2 |
182 | 2018-12-03 11:41:36 | excreta | 1 | 69583 | 3 | 1.133 | 61414.8 |
181 | 2018-09-23 02:36:43 | excreta | 1 | 69583 | 3 | 1.186 | 58670.3 |
180 | 2018-09-12 21:28:12 | excreta | 1 | 69583 | 3 | 1.026 | 67819.7 |
179 | 2018-09-07 23:11:39 | excreta | 1 | 69583 | 3 | 1.176 | 59169.2 |
178 | 2018-08-30 04:44:37 | excreta | 1 | 69583 | 3 | 1.033 | 67360.1 |
177 | 2018-08-19 14:28:07 | excreta | 1 | 69583 | 3 | 1.033 | 67360.1 |