History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"stickit"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
282 | 2024-05-02 21:32:35 | stickit | 1 | 69583 | 1 | 1.250 | 55666.4 |
281 | 2024-05-02 05:10:48 | stickit | 1 | 69583 | 1 | 1.216 | 57222.9 |
280 | 2024-04-30 19:31:21 | stickit | 3 | 134027 | 150 | 11.516 | 11638.3 |
279 | 2024-04-27 11:44:26 | stickit | 3 | 134027 | 150 | 7.186 | 18651.1 |
278 | 2024-04-26 06:54:30 | stickit | 3 | 134027 | 150 | 15.753 | 8508.0 |
277 | 2024-04-25 10:46:56 | stickit | 3 | 134027 | 150 | 15.160 | 8840.8 |
276 | 2024-04-23 03:55:26 | stickit | 3 | 134027 | 150 | 15.173 | 8833.3 |
275 | 2024-04-18 07:32:14 | stickit | 3 | 134027 | 150 | 21.956 | 6104.3 |
274 | 2024-04-13 00:01:10 | stickit | 3 | 134027 | 150 | 13.220 | 10138.2 |
273 | 2024-04-05 13:50:39 | stickit | 1 | 69583 | 1 | 3.530 | 19711.9 |
272 | 2024-03-30 06:51:23 | stickit | 1 | 69583 | 1 | 1.670 | 41666.5 |
271 | 2024-03-29 09:50:44 | stickit | 3 | 134027 | 150 | 6.750 | 19855.9 |
270 | 2024-03-29 07:58:07 | stickit | 1 | 69583 | 1 | 2.800 | 24851.1 |
269 | 2024-03-26 02:23:25 | stickit | 2 | 107671 | 20 | 4.233 | 25436.1 |
268 | 2024-03-25 05:11:46 | stickit | 2 | 107671 | 20 | 2.936 | 36672.7 |
267 | 2024-03-25 05:11:33 | stickit | 3 | 134027 | 150 | 6.750 | 19855.9 |
266 | 2024-03-23 08:35:39 | stickit | 3 | 134027 | 150 | 25.956 | 5163.6 |
265 | 2024-03-22 07:17:21 | stickit | 3 | 134027 | 150 | 6.660 | 20124.2 |
264 | 2024-03-22 07:17:23 | stickit | 2 | 107671 | 20 | 3.216 | 33479.8 |
263 | 2024-03-22 07:17:17 | stickit | 1 | 69583 | 1 | 1.266 | 54962.9 |
262 | 2024-02-28 08:42:25 | stickit | 3 | 134027 | 150 | 12.953 | 10347.2 |
261 | 2024-02-28 02:44:03 | stickit | 1 | 69583 | 1 | 3.153 | 22068.8 |
260 | 2024-02-26 10:13:24 | stickit | 2 | 107671 | 20 | 6.986 | 15412.4 |
259 | 2024-02-26 10:13:12 | stickit | 3 | 134027 | 150 | 7.470 | 17942.0 |
258 | 2024-02-22 13:10:13 | stickit | 2 | 107671 | 20 | 10.140 | 10618.4 |
257 | 2024-02-22 03:27:32 | stickit | 3 | 134027 | 150 | 15.720 | 8525.9 |
256 | 2024-02-21 21:52:46 | stickit | 1 | 69583 | 1 | 1.220 | 57035.2 |
255 | 2024-02-21 18:03:55 | stickit | 2 | 107671 | 20 | 7.923 | 13589.7 |
254 | 2024-02-20 07:53:49 | stickit | 2 | 107671 | 20 | 29.893 | 3601.9 |
253 | 2024-02-20 07:53:48 | stickit | 3 | 134027 | 150 | 19.423 | 6900.4 |
252 | 2024-02-19 20:40:26 | stickit | 1 | 69583 | 1 | 1.983 | 35089.8 |
251 | 2024-01-29 10:35:56 | stickit | 2 | 107671 | 20 | 3.420 | 31482.7 |
250 | 2024-01-14 02:42:47 | stickit | 1 | 69583 | 1 | 1.216 | 57222.9 |
249 | 2024-01-12 07:02:59 | stickit | 3 | 134027 | 150 | 6.856 | 19548.9 |
248 | 2024-01-12 07:02:58 | stickit | 2 | 107671 | 20 | 3.250 | 33129.5 |
247 | 2023-12-14 00:34:39 | stickit | 3 | 134027 | 150 | 5.750 | 23309.0 |
246 | 2023-12-09 15:40:33 | stickit | 1 | 69583 | 1 | 1.156 | 60192.9 |
245 | 2023-12-05 00:46:20 | stickit | 1 | 69583 | 1 | 1.096 | 63488.1 |
244 | 2023-12-01 02:04:51 | stickit | 2 | 107671 | 20 | 3.220 | 33438.2 |
243 | 2023-11-17 04:34:19 | stickit | 1 | 69583 | 1 | 1.236 | 56296.9 |
242 | 2023-11-09 01:44:56 | stickit | 2 | 107671 | 20 | 3.173 | 33933.5 |
241 | 2023-10-15 11:49:42 | stickit | 1 | 69583 | 1 | 1.266 | 54962.9 |
240 | 2023-10-15 10:30:42 | stickit | 1 | 69583 | 1 | 1.170 | 59472.6 |
239 | 2023-09-26 21:59:41 | stickit | 1 | 69583 | 1 | 1.203 | 57841.2 |
238 | 2023-09-19 01:17:48 | stickit | 1 | 69583 | 1 | 1.080 | 64428.7 |
237 | 2023-09-12 00:03:00 | stickit | 3 | 134027 | 150 | 10.970 | 12217.6 |
236 | 2023-09-11 18:15:50 | stickit | 3 | 134027 | 150 | 5.750 | 23309.0 |
235 | 2023-09-05 01:48:44 | stickit | 3 | 134027 | 150 | 6.893 | 19443.9 |
234 | 2023-08-12 14:29:08 | stickit | 2 | 107671 | 20 | 2.873 | 37476.9 |
233 | 2023-07-02 05:28:13 | stickit | 3 | 134027 | 150 | 5.753 | 23296.9 |
232 | 2023-06-01 19:23:24 | stickit | 1 | 69583 | 1 | 1.186 | 58670.3 |
231 | 2023-05-31 10:36:14 | stickit | 3 | 134027 | 150 | 5.766 | 23244.4 |
230 | 2023-05-17 05:50:26 | stickit | 3 | 134027 | 150 | 6.423 | 20866.7 |
229 | 2023-04-24 00:41:43 | stickit | 2 | 107671 | 20 | 3.283 | 32796.5 |
228 | 2023-03-27 15:42:14 | stickit | 3 | 134027 | 150 | 6.093 | 21996.9 |
227 | 2023-03-09 04:38:48 | stickit | 3 | 134027 | 150 | 5.936 | 22578.7 |
226 | 2023-02-27 23:43:58 | stickit | 3 | 134027 | 150 | 5.656 | 23696.4 |
225 | 2023-01-28 15:17:26 | stickit | 2 | 107671 | 20 | 3.063 | 35152.1 |
224 | 2023-01-26 18:53:58 | stickit | 1 | 69583 | 1 | 1.170 | 59472.6 |
223 | 2023-01-08 03:51:55 | stickit | 3 | 134027 | 150 | 5.703 | 23501.1 |
222 | 2022-12-14 09:23:21 | stickit | 3 | 134027 | 150 | 5.623 | 23835.5 |
221 | 2022-11-29 07:46:03 | stickit | 1 | 69583 | 1 | 1.076 | 64668.2 |
220 | 2022-11-10 18:33:36 | stickit | 2 | 107671 | 20 | 2.856 | 37699.9 |
219 | 2022-09-10 01:15:04 | stickit | 1 | 69583 | 1 | 1.093 | 63662.4 |
218 | 2022-08-02 10:24:48 | stickit | 3 | 134027 | 150 | 5.796 | 23124.1 |
217 | 2022-07-25 05:15:18 | stickit | 1 | 69583 | 1 | 1.110 | 62687.4 |
216 | 2022-07-22 21:01:12 | stickit | 1 | 69583 | 1 | 1.203 | 57841.2 |
215 | 2022-06-12 05:37:17 | stickit | 2 | 107671 | 20 | 2.813 | 38276.2 |
214 | 2022-04-06 05:23:22 | stickit | 1 | 69583 | 1 | 1.190 | 58473.1 |
213 | 2022-04-06 03:09:05 | stickit | 1 | 69583 | 1 | 1.190 | 58473.1 |
212 | 2021-11-29 07:50:25 | stickit | 1 | 69583 | 1 | 1.186 | 58670.3 |
211 | 2021-08-09 15:47:55 | stickit | 1 | 69583 | 1 | 1.250 | 55666.4 |
210 | 2021-07-20 15:58:35 | stickit | 2 | 107671 | 20 | 3.250 | 33129.5 |
209 | 2021-07-17 03:05:19 | stickit | 2 | 107671 | 20 | 6.550 | 16438.3 |
208 | 2021-06-07 12:27:34 | stickit | 2 | 107671 | 20 | 2.890 | 37256.4 |
207 | 2021-06-05 17:30:06 | stickit | 1 | 69583 | 1 | 1.250 | 55666.4 |
206 | 2021-05-17 11:52:59 | stickit | 2 | 107671 | 20 | 2.890 | 37256.4 |
205 | 2021-05-11 16:34:46 | stickit | 1 | 69583 | 1 | 1.093 | 63662.4 |
204 | 2021-05-06 08:27:17 | stickit | 2 | 107671 | 20 | 3.640 | 29579.9 |
203 | 2021-04-26 00:24:19 | stickit | 2 | 107671 | 20 | 2.813 | 38276.2 |
202 | 2021-04-20 23:20:53 | stickit | 1 | 69583 | 1 | 1.220 | 57035.2 |
201 | 2021-04-10 11:28:26 | stickit | 1 | 69583 | 1 | 1.250 | 55666.4 |
200 | 2021-04-05 17:03:05 | stickit | 1 | 69583 | 1 | 1.280 | 54361.7 |
199 | 2021-02-16 00:41:55 | stickit | 1 | 69583 | 1 | 1.283 | 54234.6 |
198 | 2021-02-13 09:48:16 | stickit | 2 | 107671 | 20 | 2.826 | 38100.1 |
197 | 2021-01-24 21:29:01 | stickit | 1 | 69583 | 1 | 1.126 | 61796.6 |
196 | 2021-01-19 21:49:07 | stickit | 2 | 107671 | 20 | 2.873 | 37476.9 |
195 | 2021-01-03 17:19:27 | stickit | 1 | 69583 | 1 | 1.076 | 64668.2 |
194 | 2020-12-26 17:09:11 | stickit | 1 | 69583 | 1 | 1.110 | 62687.4 |
193 | 2020-12-20 11:33:07 | stickit | 2 | 107671 | 20 | 2.840 | 37912.3 |
192 | 2020-10-28 08:47:27 | stickit | 1 | 69583 | 1 | 1.266 | 54962.9 |
191 | 2020-10-27 23:59:13 | stickit | 1 | 69583 | 1 | 1.236 | 56296.9 |
190 | 2020-10-26 06:34:36 | stickit | 2 | 107671 | 20 | 3.233 | 33303.7 |
189 | 2020-10-23 22:26:41 | stickit | 1 | 69583 | 1 | 1.126 | 61796.6 |
188 | 2020-10-10 15:32:36 | stickit | 1 | 69583 | 1 | 1.096 | 63488.1 |
187 | 2020-10-05 21:46:31 | stickit | 2 | 107671 | 20 | 2.843 | 37872.3 |
186 | 2020-10-01 22:40:38 | stickit | 1 | 69583 | 1 | 1.250 | 55666.4 |
185 | 2020-09-30 07:39:11 | stickit | 2 | 107671 | 20 | 2.846 | 37832.4 |
184 | 2020-09-01 21:18:16 | stickit | 2 | 107671 | 20 | 2.923 | 36835.8 |
183 | 2020-08-28 23:05:30 | stickit | 2 | 107671 | 20 | 3.283 | 32796.5 |