History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"joyride"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
256 | 2024-04-27 10:28:34 | joyride | 1 | 69583 | 4 | 1.376 | 50569.0 |
255 | 2024-04-21 13:00:40 | joyride | 3 | 134027 | 75 | 19.800 | 6769.0 |
254 | 2024-04-21 13:00:33 | joyride | 2 | 107671 | 8 | 5.826 | 18481.1 |
253 | 2024-04-16 10:04:58 | joyride | 4 | 151207 | 1237 | 12.893 | 11727.8 |
252 | 2024-04-16 08:19:07 | joyride | 4 | 151207 | 1237 | 20.423 | 7403.8 |
251 | 2024-04-16 08:19:05 | joyride | 3 | 134027 | 75 | 14.983 | 8945.3 |
250 | 2024-04-16 08:19:03 | joyride | 2 | 107671 | 8 | 3.720 | 28943.8 |
249 | 2024-04-16 08:19:03 | joyride | 1 | 69583 | 4 | 2.640 | 26357.2 |
248 | 2024-04-03 07:35:32 | joyride | 1 | 69583 | 4 | 4.093 | 17000.5 |
247 | 2024-04-03 07:35:03 | joyride | 4 | 151207 | 1237 | 31.253 | 4838.2 |
246 | 2024-04-02 03:41:44 | joyride | 4 | 151207 | 1237 | 13.940 | 10847.0 |
245 | 2024-04-01 16:54:32 | joyride | 4 | 151207 | 1237 | 33.173 | 4558.1 |
244 | 2024-04-01 16:26:36 | joyride | 4 | 151207 | 1237 | 27.253 | 5548.3 |
243 | 2024-04-01 16:26:59 | joyride | 1 | 69583 | 4 | 2.716 | 25619.7 |
242 | 2024-04-01 16:26:33 | joyride | 3 | 134027 | 75 | 14.610 | 9173.6 |
241 | 2024-04-01 16:26:36 | joyride | 2 | 107671 | 8 | 6.860 | 15695.5 |
240 | 2024-03-29 07:18:09 | joyride | 1 | 69583 | 4 | 2.750 | 25302.9 |
239 | 2024-03-27 11:18:41 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
238 | 2024-03-05 00:59:28 | joyride | 2 | 107671 | 8 | 11.156 | 9651.4 |
237 | 2024-03-02 12:51:57 | joyride | 2 | 107671 | 8 | 3.483 | 30913.3 |
236 | 2024-03-01 09:40:41 | joyride | 4 | 151207 | 1237 | 20.843 | 7254.6 |
235 | 2024-03-01 09:28:54 | joyride | 3 | 134027 | 75 | 16.346 | 8199.4 |
234 | 2024-02-29 21:12:11 | joyride | 4 | 151207 | 1237 | 10.390 | 14553.1 |
233 | 2024-02-29 20:10:40 | joyride | 4 | 151207 | 1237 | 25.423 | 5947.6 |
232 | 2024-02-29 20:10:44 | joyride | 3 | 134027 | 75 | 7.296 | 18369.9 |
231 | 2024-02-29 20:10:32 | joyride | 2 | 107671 | 8 | 6.440 | 16719.1 |
230 | 2024-02-28 03:37:14 | joyride | 1 | 69583 | 4 | 2.576 | 27012.0 |
229 | 2024-02-21 08:36:02 | joyride | 1 | 69583 | 4 | 1.843 | 37755.3 |
228 | 2024-02-16 16:24:09 | joyride | 1 | 69583 | 4 | 4.436 | 15686.0 |
227 | 2024-02-14 22:54:12 | joyride | 1 | 69583 | 4 | 9.233 | 7536.3 |
226 | 2024-02-12 18:12:50 | joyride | 2 | 107671 | 8 | 2.733 | 39396.6 |
225 | 2024-01-22 14:22:47 | joyride | 1 | 69583 | 4 | 1.030 | 67556.3 |
224 | 2024-01-08 06:11:03 | joyride | 1 | 69583 | 4 | 1.013 | 68690.0 |
223 | 2024-01-07 17:01:52 | joyride | 1 | 69583 | 4 | 1.156 | 60192.9 |
222 | 2023-11-18 02:53:04 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
221 | 2023-11-13 22:53:00 | joyride | 2 | 107671 | 8 | 2.983 | 36094.9 |
220 | 2023-11-10 21:55:39 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
219 | 2023-11-02 00:00:06 | joyride | 1 | 69583 | 4 | 1.173 | 59320.5 |
218 | 2023-10-05 00:37:28 | joyride | 1 | 69583 | 4 | 1.063 | 65459.1 |
217 | 2023-09-01 16:10:09 | joyride | 1 | 69583 | 4 | 1.030 | 67556.3 |
216 | 2023-08-26 00:48:42 | joyride | 1 | 69583 | 4 | 1.190 | 58473.1 |
215 | 2023-08-16 07:44:03 | joyride | 2 | 107671 | 8 | 2.860 | 37647.2 |
214 | 2023-05-28 09:13:21 | joyride | 1 | 69583 | 4 | 2.013 | 34566.8 |
213 | 2023-05-03 09:42:12 | joyride | 2 | 107671 | 8 | 3.126 | 34443.7 |
212 | 2023-04-23 21:29:28 | joyride | 1 | 69583 | 4 | 1.110 | 62687.4 |
211 | 2023-03-24 19:31:50 | joyride | 1 | 69583 | 4 | 1.030 | 67556.3 |
210 | 2023-02-11 21:10:00 | joyride | 2 | 107671 | 8 | 2.720 | 39584.9 |
209 | 2023-01-08 17:14:56 | joyride | 1 | 69583 | 4 | 1.110 | 62687.4 |
208 | 2022-12-23 21:09:12 | joyride | 1 | 69583 | 4 | 1.013 | 68690.0 |
207 | 2022-11-23 20:03:17 | joyride | 2 | 107671 | 8 | 2.686 | 40086.0 |
206 | 2022-10-08 02:30:56 | joyride | 1 | 69583 | 4 | 1.063 | 65459.1 |
205 | 2022-08-03 15:47:15 | joyride | 1 | 69583 | 4 | 1.046 | 66522.9 |
204 | 2022-07-13 08:29:31 | joyride | 3 | 134027 | 75 | 5.436 | 24655.4 |
203 | 2022-05-27 01:59:25 | joyride | 1 | 69583 | 4 | 1.063 | 65459.1 |
202 | 2022-05-20 00:19:12 | joyride | 1 | 69583 | 4 | 1.186 | 58670.3 |
201 | 2022-04-24 19:15:29 | joyride | 2 | 107671 | 8 | 2.780 | 38730.6 |
200 | 2022-03-12 14:35:40 | joyride | 1 | 69583 | 4 | 1.076 | 64668.2 |
199 | 2022-02-10 11:47:10 | joyride | 1 | 69583 | 4 | 1.173 | 59320.5 |
198 | 2022-02-08 08:54:54 | joyride | 1 | 69583 | 4 | 1.016 | 68487.2 |
197 | 2021-12-16 18:22:42 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
196 | 2021-12-14 17:19:05 | joyride | 1 | 69583 | 4 | 1.063 | 65459.1 |
195 | 2021-11-05 12:17:33 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
194 | 2021-07-15 21:19:57 | joyride | 1 | 69583 | 4 | 1.046 | 66522.9 |
193 | 2021-05-08 18:17:24 | joyride | 1 | 69583 | 4 | 1.126 | 61796.6 |
192 | 2021-04-13 00:06:04 | joyride | 1 | 69583 | 4 | 1.326 | 52475.9 |
191 | 2021-04-07 05:32:55 | joyride | 1 | 69583 | 4 | 1.076 | 64668.2 |
190 | 2021-03-11 11:23:19 | joyride | 1 | 69583 | 4 | 1.030 | 67556.3 |
189 | 2021-01-22 08:49:34 | joyride | 1 | 69583 | 4 | 1.093 | 63662.4 |
188 | 2020-12-30 10:14:22 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
187 | 2020-12-23 11:47:13 | joyride | 1 | 69583 | 4 | 1.046 | 66522.9 |
186 | 2020-09-27 02:26:31 | joyride | 1 | 69583 | 4 | 1.033 | 67360.1 |
185 | 2020-09-21 04:55:31 | joyride | 1 | 69583 | 4 | 1.170 | 59472.6 |
184 | 2020-05-31 04:57:18 | joyride | 1 | 69583 | 4 | 1.046 | 66522.9 |
183 | 2020-05-28 01:45:39 | joyride | 1 | 69583 | 4 | 1.033 | 67360.1 |
182 | 2020-04-22 13:44:31 | joyride | 1 | 69583 | 4 | 1.156 | 60192.9 |
181 | 2020-03-21 16:10:20 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
180 | 2020-02-29 14:26:38 | joyride | 1 | 69583 | 4 | 1.500 | 46388.7 |
179 | 2020-02-26 02:05:27 | joyride | 1 | 69583 | 4 | 1.233 | 56433.9 |
178 | 2020-02-23 16:49:55 | joyride | 1 | 69583 | 4 | 1.170 | 59472.6 |
177 | 2020-02-23 14:50:31 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
176 | 2020-02-19 03:43:52 | joyride | 1 | 69583 | 4 | 1.220 | 57035.2 |
175 | 2020-02-19 00:58:10 | joyride | 1 | 69583 | 4 | 1.330 | 52318.0 |
174 | 2020-02-10 00:55:07 | joyride | 1 | 69583 | 4 | 3.966 | 17544.9 |
173 | 2020-02-07 04:26:14 | joyride | 1 | 69583 | 4 | 1.236 | 56296.9 |
172 | 2020-01-27 04:50:54 | joyride | 1 | 69583 | 4 | 1.720 | 40455.2 |
171 | 2020-01-24 11:52:54 | joyride | 1 | 69583 | 4 | 1.313 | 52995.4 |
170 | 2020-01-23 08:42:30 | joyride | 1 | 69583 | 4 | 1.406 | 49490.0 |
169 | 2020-01-20 15:36:20 | joyride | 1 | 69583 | 4 | 2.546 | 27330.3 |
168 | 2020-01-19 04:44:26 | joyride | 3 | 134027 | 75 | 9.046 | 14816.2 |
167 | 2020-01-18 08:07:55 | joyride | 3 | 134027 | 75 | 7.736 | 17325.1 |
166 | 2020-01-18 08:07:31 | joyride | 2 | 107671 | 8 | 3.453 | 31181.9 |
165 | 2020-01-18 02:03:02 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
164 | 2020-01-12 11:56:21 | joyride | 1 | 69583 | 4 | 1.203 | 57841.2 |
163 | 2019-12-31 02:39:43 | joyride | 1 | 69583 | 4 | 1.220 | 57035.2 |
162 | 2019-12-30 22:12:06 | joyride | 1 | 69583 | 4 | 1.233 | 56433.9 |
161 | 2019-11-06 15:24:50 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
160 | 2019-08-08 13:03:29 | joyride | 1 | 69583 | 4 | 1.063 | 65459.1 |
159 | 2019-07-23 01:58:25 | joyride | 1 | 69583 | 4 | 1.013 | 68690.0 |
158 | 2019-04-26 00:44:45 | joyride | 1 | 69583 | 4 | 1.140 | 61037.7 |
157 | 2019-03-25 00:55:54 | joyride | 1 | 69583 | 4 | 1.020 | 68218.6 |