History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"jackass"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
293 | 2024-05-07 16:13:41 | jackass | 1 | 69583 | 2 | 3.280 | 21214.3 |
292 | 2024-05-07 04:29:52 | jackass | 1 | 69583 | 2 | 3.686 | 18877.6 |
291 | 2024-04-27 07:12:18 | jackass | 1 | 69583 | 2 | 1.983 | 35089.8 |
290 | 2024-04-15 11:27:50 | jackass | 1 | 69583 | 2 | 1.406 | 49490.0 |
289 | 2024-03-30 09:36:17 | jackass | 1 | 69583 | 2 | 1.796 | 38743.3 |
288 | 2024-03-24 16:57:52 | jackass | 1 | 69583 | 2 | 1.326 | 52475.9 |
287 | 2024-03-06 00:24:28 | jackass | 3 | 134027 | 130 | 6.876 | 19492.0 |
286 | 2024-03-05 17:36:28 | jackass | 3 | 134027 | 130 | 13.016 | 10297.1 |
285 | 2024-03-05 15:28:23 | jackass | 3 | 134027 | 130 | 6.110 | 21935.7 |
284 | 2024-03-02 04:57:45 | jackass | 3 | 134027 | 130 | 15.766 | 8501.0 |
283 | 2024-03-01 21:01:18 | jackass | 3 | 134027 | 130 | 12.876 | 10409.1 |
282 | 2024-03-01 21:00:00 | jackass | 1 | 69583 | 2 | 4.033 | 17253.4 |
281 | 2024-02-25 10:30:16 | jackass | 2 | 107671 | 10 | 7.513 | 14331.3 |
280 | 2024-02-18 15:52:43 | jackass | 2 | 107671 | 10 | 2.766 | 38926.6 |
279 | 2024-02-17 22:34:10 | jackass | 1 | 69583 | 2 | 3.983 | 17470.0 |
278 | 2024-01-14 17:01:39 | jackass | 2 | 107671 | 10 | 3.346 | 32179.0 |
277 | 2024-01-10 15:38:35 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
276 | 2023-12-28 09:12:15 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
275 | 2023-12-07 06:33:32 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
274 | 2023-12-04 04:29:37 | jackass | 1 | 69583 | 2 | 1.030 | 67556.3 |
273 | 2023-11-27 06:09:23 | jackass | 3 | 134027 | 130 | 14.296 | 9375.1 |
272 | 2023-11-25 19:38:32 | jackass | 1 | 69583 | 2 | 1.233 | 56433.9 |
271 | 2023-11-16 16:56:40 | jackass | 2 | 107671 | 10 | 2.750 | 39153.1 |
270 | 2023-10-16 19:21:07 | jackass | 1 | 69583 | 2 | 1.080 | 64428.7 |
269 | 2023-10-12 02:30:04 | jackass | 1 | 69583 | 2 | 1.050 | 66269.5 |
268 | 2023-09-20 01:36:08 | jackass | 1 | 69583 | 2 | 1.046 | 66522.9 |
267 | 2023-08-26 20:38:33 | jackass | 3 | 134027 | 130 | 5.593 | 23963.3 |
266 | 2023-08-18 01:01:46 | jackass | 2 | 107671 | 10 | 2.796 | 38508.9 |
265 | 2023-08-13 16:46:19 | jackass | 1 | 69583 | 2 | 1.203 | 57841.2 |
264 | 2023-07-25 18:03:17 | jackass | 1 | 69583 | 2 | 1.593 | 43680.5 |
263 | 2023-05-14 00:38:09 | jackass | 3 | 134027 | 130 | 5.453 | 24578.6 |
262 | 2023-05-12 13:30:30 | jackass | 1 | 69583 | 2 | 1.046 | 66522.9 |
261 | 2023-04-30 18:07:24 | jackass | 2 | 107671 | 10 | 2.873 | 37476.9 |
260 | 2023-04-06 14:38:53 | jackass | 1 | 69583 | 2 | 1.173 | 59320.5 |
259 | 2023-03-24 07:52:39 | jackass | 1 | 69583 | 2 | 1.216 | 57222.9 |
258 | 2023-03-23 07:35:03 | jackass | 1 | 69583 | 2 | 1.220 | 57035.2 |
257 | 2023-03-06 18:40:31 | jackass | 1 | 69583 | 2 | 1.033 | 67360.1 |
256 | 2023-02-20 15:02:24 | jackass | 3 | 134027 | 130 | 6.610 | 20276.4 |
255 | 2023-02-12 10:53:28 | jackass | 1 | 69583 | 2 | 1.170 | 59472.6 |
254 | 2023-02-08 02:38:31 | jackass | 2 | 107671 | 10 | 2.736 | 39353.4 |
253 | 2023-02-04 08:24:11 | jackass | 3 | 134027 | 130 | 5.686 | 23571.4 |
252 | 2022-12-28 23:18:01 | jackass | 1 | 69583 | 2 | 1.030 | 67556.3 |
251 | 2022-12-24 14:18:02 | jackass | 1 | 69583 | 2 | 1.046 | 66522.9 |
250 | 2022-12-19 06:09:22 | jackass | 3 | 134027 | 130 | 5.826 | 23005.0 |
249 | 2022-12-14 14:57:48 | jackass | 1 | 69583 | 2 | 1.140 | 61037.7 |
248 | 2022-12-11 11:04:12 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
247 | 2022-12-01 19:05:36 | jackass | 3 | 134027 | 130 | 5.530 | 24236.3 |
246 | 2022-11-19 20:40:10 | jackass | 2 | 107671 | 10 | 2.750 | 39153.1 |
245 | 2022-11-12 21:22:03 | jackass | 3 | 134027 | 130 | 6.390 | 20974.5 |
244 | 2022-11-11 09:06:37 | jackass | 1 | 69583 | 2 | 1.203 | 57841.2 |
243 | 2022-11-09 23:43:50 | jackass | 1 | 69583 | 2 | 1.033 | 67360.1 |
242 | 2022-09-15 07:18:44 | jackass | 1 | 69583 | 2 | 1.050 | 66269.5 |
241 | 2022-08-28 09:47:50 | jackass | 3 | 134027 | 130 | 5.500 | 24368.5 |
240 | 2022-08-07 11:45:31 | jackass | 1 | 69583 | 2 | 1.046 | 66522.9 |
239 | 2022-08-01 05:59:29 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
238 | 2022-07-28 18:44:40 | jackass | 1 | 69583 | 2 | 1.110 | 62687.4 |
237 | 2022-07-12 13:33:33 | jackass | 1 | 69583 | 2 | 1.076 | 64668.2 |
236 | 2022-07-07 22:00:08 | jackass | 3 | 134027 | 130 | 6.126 | 21878.4 |
235 | 2022-06-23 08:51:13 | jackass | 2 | 107671 | 10 | 2.766 | 38926.6 |
234 | 2022-06-18 09:13:51 | jackass | 3 | 134027 | 130 | 5.453 | 24578.6 |
233 | 2022-05-25 09:50:19 | jackass | 1 | 69583 | 2 | 1.203 | 57841.2 |
232 | 2022-05-15 00:12:41 | jackass | 3 | 134027 | 130 | 5.656 | 23696.4 |
231 | 2022-05-13 03:56:15 | jackass | 1 | 69583 | 2 | 1.673 | 41591.8 |
230 | 2022-05-06 22:11:00 | jackass | 3 | 134027 | 130 | 6.203 | 21606.8 |
229 | 2022-04-21 03:35:37 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
228 | 2022-04-10 19:39:20 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
227 | 2022-04-08 10:45:23 | jackass | 3 | 134027 | 130 | 7.436 | 18024.1 |
226 | 2022-04-03 06:43:40 | jackass | 1 | 69583 | 2 | 1.030 | 67556.3 |
225 | 2022-02-28 13:55:08 | jackass | 2 | 107671 | 10 | 3.800 | 28334.5 |
224 | 2022-01-16 19:29:00 | jackass | 1 | 69583 | 2 | 1.200 | 57985.8 |
223 | 2022-01-14 15:28:58 | jackass | 1 | 69583 | 2 | 1.093 | 63662.4 |
222 | 2021-12-13 02:56:38 | jackass | 1 | 69583 | 2 | 2.233 | 31161.2 |
221 | 2021-12-09 21:33:47 | jackass | 1 | 69583 | 2 | 1.250 | 55666.4 |
220 | 2021-11-06 10:42:27 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
219 | 2021-09-30 16:40:05 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
218 | 2021-09-28 04:08:58 | jackass | 1 | 69583 | 2 | 1.203 | 57841.2 |
217 | 2021-09-08 20:36:44 | jackass | 1 | 69583 | 2 | 1.093 | 63662.4 |
216 | 2021-08-30 06:08:33 | jackass | 1 | 69583 | 2 | 1.173 | 59320.5 |
215 | 2021-08-26 22:51:40 | jackass | 1 | 69583 | 2 | 1.153 | 60349.5 |
214 | 2021-08-22 20:31:49 | jackass | 1 | 69583 | 2 | 1.140 | 61037.7 |
213 | 2021-06-25 22:17:45 | jackass | 1 | 69583 | 2 | 1.250 | 55666.4 |
212 | 2021-05-22 23:04:23 | jackass | 1 | 69583 | 2 | 1.310 | 53116.8 |
211 | 2021-05-08 17:35:19 | jackass | 1 | 69583 | 2 | 1.186 | 58670.3 |
210 | 2021-04-24 02:56:19 | jackass | 1 | 69583 | 2 | 1.186 | 58670.3 |
209 | 2021-04-07 01:52:33 | jackass | 1 | 69583 | 2 | 1.140 | 61037.7 |
208 | 2021-02-20 20:25:54 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
207 | 2021-02-19 04:55:17 | jackass | 1 | 69583 | 2 | 1.063 | 65459.1 |
206 | 2021-01-22 05:36:08 | jackass | 1 | 69583 | 2 | 1.343 | 51811.6 |
205 | 2020-12-23 12:11:13 | jackass | 1 | 69583 | 2 | 2.156 | 32274.1 |
204 | 2020-11-17 10:13:27 | jackass | 1 | 69583 | 2 | 1.140 | 61037.7 |
203 | 2020-10-14 18:08:40 | jackass | 1 | 69583 | 2 | 1.173 | 59320.5 |
202 | 2020-08-11 19:08:25 | jackass | 1 | 69583 | 2 | 1.060 | 65644.3 |
201 | 2020-05-07 15:17:45 | jackass | 1 | 69583 | 2 | 1.156 | 60192.9 |
200 | 2020-03-28 16:39:56 | jackass | 1 | 69583 | 2 | 1.220 | 57035.2 |
199 | 2020-03-28 11:36:35 | jackass | 1 | 69583 | 2 | 1.123 | 61961.7 |
198 | 2020-03-24 09:56:17 | jackass | 1 | 69583 | 2 | 1.173 | 59320.5 |
197 | 2020-03-23 22:36:15 | jackass | 1 | 69583 | 2 | 1.030 | 67556.3 |
196 | 2020-03-20 02:22:25 | jackass | 1 | 69583 | 2 | 1.170 | 59472.6 |
195 | 2020-03-18 21:24:21 | jackass | 1 | 69583 | 2 | 1.076 | 64668.2 |
194 | 2020-02-25 01:34:37 | jackass | 1 | 69583 | 2 | 1.890 | 36816.4 |