History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"superstar"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
252 | 2024-04-28 22:37:31 | superstar | 2 | 121436 | 10 | 3.876 | 31330.2 |
251 | 2024-04-24 20:42:42 | superstar | 1 | 81242 | 2 | 1.610 | 50460.9 |
250 | 2024-04-18 21:11:58 | superstar | 1 | 81242 | 2 | 1.343 | 60492.9 |
249 | 2024-04-18 07:27:43 | superstar | 3 | 148641 | 47 | 25.143 | 5911.8 |
248 | 2024-04-17 14:29:37 | superstar | 2 | 121436 | 10 | 8.953 | 13563.7 |
247 | 2024-04-17 13:03:16 | superstar | 4 | 165329 | 258 | 20.780 | 7956.2 |
246 | 2024-04-16 20:55:27 | superstar | 4 | 165329 | 258 | 45.126 | 3663.7 |
245 | 2024-04-16 20:55:19 | superstar | 3 | 148641 | 47 | 23.783 | 6249.9 |
244 | 2024-04-16 16:57:41 | superstar | 2 | 121436 | 10 | 11.533 | 10529.4 |
243 | 2024-04-16 16:53:33 | superstar | 1 | 81242 | 2 | 7.313 | 11109.3 |
242 | 2024-04-16 16:53:02 | superstar | 3 | 148641 | 47 | 21.436 | 6934.2 |
241 | 2024-04-16 16:29:00 | superstar | 4 | 165329 | 258 | 38.203 | 4327.6 |
240 | 2024-04-16 06:05:25 | superstar | 4 | 165329 | 258 | 17.673 | 9354.9 |
239 | 2024-04-16 06:05:26 | superstar | 3 | 148641 | 47 | 13.186 | 11272.6 |
238 | 2024-04-16 06:05:27 | superstar | 2 | 121436 | 10 | 4.076 | 29792.9 |
237 | 2024-04-16 06:05:13 | superstar | 1 | 81242 | 2 | 1.436 | 56575.2 |
236 | 2024-04-12 22:21:42 | superstar | 1 | 81242 | 2 | 1.466 | 55417.5 |
235 | 2024-04-12 22:21:37 | superstar | 1 | 81242 | 2 | 1.486 | 54671.6 |
234 | 2024-04-05 20:17:30 | superstar | 1 | 81242 | 2 | 1.593 | 50999.4 |
233 | 2024-03-29 00:32:57 | superstar | 1 | 81242 | 2 | 3.330 | 24397.0 |
232 | 2024-03-15 05:52:32 | superstar | 2 | 121436 | 10 | 3.156 | 38477.8 |
231 | 2024-03-15 05:32:32 | superstar | 3 | 148641 | 47 | 11.720 | 12682.7 |
230 | 2024-03-13 01:29:29 | superstar | 3 | 148641 | 47 | 24.346 | 6105.4 |
229 | 2024-03-13 01:29:33 | superstar | 2 | 121436 | 10 | 8.376 | 14498.1 |
228 | 2024-03-13 01:29:16 | superstar | 1 | 81242 | 2 | 2.830 | 28707.4 |
227 | 2024-03-11 16:42:53 | superstar | 4 | 165329 | 258 | 24.123 | 6853.6 |
226 | 2024-03-10 06:29:02 | superstar | 4 | 165329 | 258 | 47.393 | 3488.5 |
225 | 2024-03-10 05:09:33 | superstar | 2 | 121436 | 10 | 13.156 | 9230.5 |
224 | 2024-03-10 05:06:48 | superstar | 3 | 148641 | 47 | 25.596 | 5807.2 |
223 | 2024-03-10 04:56:21 | superstar | 4 | 165329 | 258 | 30.550 | 5411.8 |
222 | 2024-03-10 00:14:15 | superstar | 3 | 148641 | 47 | 17.753 | 8372.7 |
221 | 2024-03-10 00:14:17 | superstar | 2 | 121436 | 10 | 15.376 | 7897.8 |
220 | 2024-03-10 00:09:10 | superstar | 1 | 81242 | 2 | 1.796 | 45235.0 |
219 | 2024-03-09 18:50:58 | superstar | 4 | 165329 | 258 | 24.753 | 6679.2 |
218 | 2024-03-09 03:33:24 | superstar | 1 | 81242 | 2 | 1.440 | 56418.1 |
217 | 2024-03-09 03:33:09 | superstar | 4 | 165329 | 258 | 13.733 | 12038.8 |
216 | 2024-03-09 03:33:11 | superstar | 3 | 148641 | 47 | 8.216 | 18091.7 |
215 | 2024-03-09 03:33:10 | superstar | 2 | 121436 | 10 | 3.970 | 30588.4 |
214 | 2024-03-09 03:33:03 | superstar | 1 | 81242 | 2 | 1.283 | 63321.9 |
213 | 2024-03-06 20:39:06 | superstar | 1 | 81242 | 2 | 1.733 | 46879.4 |
212 | 2024-03-01 10:49:57 | superstar | 3 | 148641 | 47 | 7.576 | 19620.0 |
211 | 2024-02-26 23:22:46 | superstar | 1 | 81242 | 2 | 1.453 | 55913.3 |
210 | 2024-02-10 11:50:23 | superstar | 3 | 148641 | 47 | 14.513 | 10241.9 |
209 | 2024-02-10 06:53:09 | superstar | 2 | 121436 | 10 | 7.423 | 16359.4 |
208 | 2024-02-08 12:22:36 | superstar | 3 | 148641 | 47 | 24.126 | 6161.0 |
207 | 2024-02-08 12:22:36 | superstar | 2 | 121436 | 10 | 12.486 | 9725.8 |
206 | 2024-02-07 23:22:19 | superstar | 4 | 165329 | 258 | 15.483 | 10678.1 |
205 | 2024-02-05 13:56:39 | superstar | 4 | 165329 | 258 | 15.706 | 10526.5 |
204 | 2024-02-04 17:57:53 | superstar | 2 | 121436 | 10 | 6.483 | 18731.5 |
203 | 2024-02-04 17:52:33 | superstar | 3 | 148641 | 47 | 9.076 | 16377.4 |
202 | 2024-02-03 05:37:30 | superstar | 2 | 121436 | 10 | 10.813 | 11230.6 |
201 | 2024-02-03 05:37:22 | superstar | 3 | 148641 | 47 | 13.000 | 11433.9 |
200 | 2024-02-02 22:07:24 | superstar | 1 | 81242 | 2 | 1.466 | 55417.5 |
199 | 2024-02-02 03:59:08 | superstar | 1 | 81242 | 2 | 1.420 | 57212.7 |
198 | 2024-01-02 16:58:55 | superstar | 4 | 165329 | 258 | 12.580 | 13142.2 |
197 | 2024-01-01 17:34:21 | superstar | 1 | 81242 | 2 | 1.440 | 56418.1 |
196 | 2023-12-30 06:52:53 | superstar | 4 | 165329 | 258 | 11.453 | 14435.4 |
195 | 2023-12-21 04:42:24 | superstar | 2 | 121436 | 10 | 4.046 | 30013.8 |
194 | 2023-11-29 19:30:02 | superstar | 1 | 81242 | 2 | 1.266 | 64172.2 |
193 | 2023-11-21 17:47:04 | superstar | 3 | 148641 | 47 | 6.330 | 23482.0 |
192 | 2023-11-12 15:13:31 | superstar | 4 | 165329 | 258 | 10.563 | 15651.7 |
191 | 2023-10-25 06:33:34 | superstar | 1 | 81242 | 2 | 1.376 | 59042.2 |
190 | 2023-09-21 17:14:46 | superstar | 2 | 121436 | 10 | 3.186 | 38115.5 |
189 | 2023-08-23 03:50:33 | superstar | 3 | 148641 | 47 | 6.203 | 23962.8 |
188 | 2023-08-20 02:49:53 | superstar | 1 | 81242 | 2 | 1.346 | 60358.1 |
187 | 2023-08-15 21:07:52 | superstar | 4 | 165329 | 258 | 10.750 | 15379.4 |
186 | 2023-06-28 03:00:56 | superstar | 2 | 121436 | 10 | 3.143 | 38637.0 |
185 | 2023-05-21 08:45:55 | superstar | 1 | 81242 | 2 | 1.250 | 64993.6 |
184 | 2023-05-02 15:43:31 | superstar | 3 | 148641 | 47 | 6.156 | 24145.7 |
183 | 2023-05-01 18:49:20 | superstar | 4 | 165329 | 258 | 11.783 | 14031.1 |
182 | 2023-03-21 01:22:41 | superstar | 2 | 121436 | 10 | 3.203 | 37913.2 |
181 | 2023-03-16 19:08:16 | superstar | 1 | 81242 | 2 | 1.970 | 41239.6 |
180 | 2023-02-07 18:22:06 | superstar | 3 | 148641 | 47 | 6.140 | 24208.6 |
179 | 2023-02-07 05:37:42 | superstar | 4 | 165329 | 258 | 10.486 | 15766.6 |
178 | 2023-01-03 06:24:35 | superstar | 1 | 81242 | 2 | 1.233 | 65889.7 |
177 | 2022-12-20 19:45:04 | superstar | 2 | 121436 | 10 | 3.033 | 40038.2 |
176 | 2022-11-20 19:59:55 | superstar | 4 | 165329 | 258 | 11.020 | 15002.6 |
175 | 2022-11-19 17:34:14 | superstar | 3 | 148641 | 47 | 7.063 | 21045.0 |
174 | 2022-09-24 04:56:53 | superstar | 1 | 81242 | 2 | 1.266 | 64172.2 |
173 | 2022-08-13 19:16:15 | superstar | 2 | 121436 | 10 | 3.140 | 38673.9 |
172 | 2022-06-24 20:21:26 | superstar | 4 | 165329 | 258 | 10.500 | 15745.6 |
171 | 2022-06-23 10:00:18 | superstar | 3 | 148641 | 47 | 6.266 | 23721.8 |
170 | 2022-05-11 02:29:33 | superstar | 1 | 81242 | 2 | 1.610 | 50460.9 |
169 | 2021-09-27 17:32:11 | superstar | 1 | 81242 | 2 | 1.280 | 63470.3 |
168 | 2021-09-27 03:31:14 | superstar | 1 | 81242 | 2 | 1.250 | 64993.6 |
167 | 2021-09-26 13:18:45 | superstar | 1 | 81242 | 2 | 1.280 | 63470.3 |
166 | 2021-09-21 22:56:26 | superstar | 1 | 81242 | 2 | 1.330 | 61084.2 |
165 | 2021-05-28 10:01:39 | superstar | 3 | 148641 | 47 | 6.326 | 23496.8 |
164 | 2021-05-02 16:30:33 | superstar | 3 | 148641 | 47 | 6.343 | 23433.9 |
163 | 2021-03-31 22:15:58 | superstar | 3 | 148641 | 47 | 6.893 | 21564.1 |
162 | 2021-03-24 07:14:41 | superstar | 1 | 81242 | 2 | 1.280 | 63470.3 |
161 | 2021-02-26 14:13:01 | superstar | 1 | 81242 | 2 | 1.263 | 64324.6 |
160 | 2021-01-15 20:52:55 | superstar | 3 | 148641 | 47 | 6.546 | 22707.1 |
159 | 2020-10-27 18:30:26 | superstar | 1 | 81242 | 2 | 1.966 | 41323.5 |
158 | 2020-10-27 14:46:17 | superstar | 3 | 148641 | 47 | 7.423 | 20024.4 |
157 | 2020-10-23 14:52:40 | superstar | 1 | 81242 | 2 | 1.686 | 48186.2 |
156 | 2020-09-26 12:19:00 | superstar | 1 | 81242 | 2 | 1.233 | 65889.7 |
155 | 2020-08-22 13:41:04 | superstar | 1 | 81242 | 2 | 1.500 | 54161.3 |
154 | 2020-03-26 12:29:38 | superstar | 4 | 165329 | 258 | 12.923 | 12793.4 |
153 | 2020-03-25 15:00:37 | superstar | 1 | 81242 | 2 | 4.406 | 18438.9 |