History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wiseguys"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
249 | 2024-04-18 23:33:27 | wiseguys | 2 | 121059 | 2 | 13.206 | 9167.0 |
248 | 2024-04-18 22:57:32 | wiseguys | 1 | 82945 | 2 | 1.203 | 68948.5 |
247 | 2024-04-10 23:02:30 | wiseguys | 3 | 146162 | 14 | 7.923 | 18447.8 |
246 | 2024-04-10 23:02:28 | wiseguys | 2 | 121059 | 2 | 5.296 | 22858.6 |
245 | 2024-04-10 23:02:28 | wiseguys | 1 | 82945 | 2 | 2.936 | 28251.0 |
244 | 2024-04-10 19:28:18 | wiseguys | 4 | 161609 | 247 | 29.360 | 5504.4 |
243 | 2024-04-10 13:01:45 | wiseguys | 4 | 161609 | 247 | 32.016 | 5047.8 |
242 | 2024-04-09 04:58:56 | wiseguys | 3 | 146162 | 14 | 26.266 | 5564.7 |
241 | 2024-04-08 02:55:33 | wiseguys | 3 | 146162 | 14 | 15.093 | 9684.1 |
240 | 2024-04-08 02:55:31 | wiseguys | 2 | 121059 | 2 | 3.940 | 30725.6 |
239 | 2024-04-08 02:55:15 | wiseguys | 4 | 161609 | 247 | 18.750 | 8619.1 |
238 | 2024-04-08 02:55:28 | wiseguys | 1 | 82945 | 2 | 1.530 | 54212.4 |
237 | 2024-04-07 13:13:22 | wiseguys | 4 | 161609 | 247 | 42.956 | 3762.2 |
236 | 2024-04-07 13:13:52 | wiseguys | 1 | 82945 | 2 | 5.046 | 16437.8 |
235 | 2024-04-07 13:13:23 | wiseguys | 3 | 146162 | 14 | 28.733 | 5086.9 |
234 | 2024-04-07 13:13:17 | wiseguys | 4 | 161609 | 247 | 23.813 | 6786.6 |
233 | 2024-04-07 13:13:18 | wiseguys | 3 | 146162 | 14 | 20.410 | 7161.3 |
232 | 2024-04-07 13:13:24 | wiseguys | 2 | 121059 | 2 | 13.686 | 8845.5 |
231 | 2024-04-07 13:13:20 | wiseguys | 2 | 121059 | 2 | 8.546 | 14165.6 |
230 | 2024-04-07 13:13:17 | wiseguys | 1 | 82945 | 2 | 1.826 | 45424.4 |
229 | 2024-04-07 13:13:12 | wiseguys | 1 | 82945 | 2 | 2.516 | 32967.0 |
228 | 2024-03-30 18:52:14 | wiseguys | 1 | 82945 | 2 | 2.016 | 41143.4 |
227 | 2024-03-15 09:47:13 | wiseguys | 1 | 82945 | 2 | 3.330 | 24908.4 |
226 | 2024-03-06 09:17:24 | wiseguys | 3 | 146162 | 14 | 16.686 | 8759.6 |
225 | 2024-03-05 19:07:46 | wiseguys | 4 | 161609 | 247 | 35.486 | 4554.2 |
224 | 2024-03-05 17:05:04 | wiseguys | 4 | 161609 | 247 | 23.233 | 6956.0 |
223 | 2024-03-05 13:54:15 | wiseguys | 2 | 121059 | 2 | 3.720 | 32542.7 |
222 | 2024-03-05 13:52:00 | wiseguys | 3 | 146162 | 14 | 7.016 | 20832.7 |
221 | 2024-03-05 13:51:56 | wiseguys | 1 | 82945 | 2 | 1.546 | 53651.4 |
220 | 2024-03-04 16:53:03 | wiseguys | 4 | 161609 | 247 | 32.503 | 4972.1 |
219 | 2024-03-04 09:45:08 | wiseguys | 4 | 161609 | 247 | 17.516 | 9226.4 |
218 | 2024-03-04 00:54:12 | wiseguys | 4 | 161609 | 247 | 31.173 | 5184.3 |
217 | 2024-03-03 18:20:13 | wiseguys | 2 | 121059 | 2 | 3.530 | 34294.3 |
216 | 2024-03-03 18:20:08 | wiseguys | 1 | 82945 | 2 | 1.236 | 67107.6 |
215 | 2024-03-03 18:13:21 | wiseguys | 4 | 161609 | 247 | 12.970 | 12460.2 |
214 | 2024-03-03 10:05:34 | wiseguys | 4 | 161609 | 247 | 14.046 | 11505.7 |
213 | 2024-03-01 14:57:29 | wiseguys | 3 | 146162 | 14 | 12.110 | 12069.5 |
212 | 2024-02-29 07:38:49 | wiseguys | 2 | 121059 | 2 | 3.530 | 34294.3 |
211 | 2024-02-29 07:38:45 | wiseguys | 3 | 146162 | 14 | 7.030 | 20791.2 |
210 | 2024-02-29 07:37:20 | wiseguys | 1 | 82945 | 2 | 1.393 | 59544.1 |
209 | 2024-02-28 13:22:05 | wiseguys | 1 | 82945 | 2 | 1.410 | 58826.2 |
208 | 2024-02-22 18:42:26 | wiseguys | 2 | 121059 | 2 | 3.873 | 31257.2 |
207 | 2024-02-22 08:51:40 | wiseguys | 3 | 146162 | 14 | 7.610 | 19206.6 |
206 | 2024-02-18 21:24:43 | wiseguys | 3 | 146162 | 14 | 6.296 | 23215.1 |
205 | 2024-02-01 02:35:40 | wiseguys | 4 | 161609 | 247 | 14.390 | 11230.6 |
204 | 2024-02-01 00:06:16 | wiseguys | 4 | 161609 | 247 | 17.063 | 9471.3 |
203 | 2024-01-31 18:54:52 | wiseguys | 1 | 82945 | 2 | 1.266 | 65517.4 |
202 | 2024-01-31 18:54:40 | wiseguys | 4 | 161609 | 247 | 12.376 | 13058.3 |
201 | 2024-01-31 18:54:44 | wiseguys | 2 | 121059 | 2 | 3.970 | 30493.5 |
200 | 2024-01-31 18:54:36 | wiseguys | 3 | 146162 | 14 | 7.483 | 19532.5 |
199 | 2024-01-30 19:10:07 | wiseguys | 1 | 82945 | 2 | 1.436 | 57761.1 |
198 | 2024-01-23 01:18:27 | wiseguys | 2 | 121059 | 2 | 3.906 | 30993.1 |
197 | 2024-01-17 08:29:31 | wiseguys | 3 | 146162 | 14 | 7.453 | 19611.2 |
196 | 2024-01-14 01:47:02 | wiseguys | 3 | 146162 | 14 | 7.236 | 20199.3 |
195 | 2023-12-21 21:50:01 | wiseguys | 1 | 82945 | 2 | 1.503 | 55186.3 |
194 | 2023-11-23 05:12:21 | wiseguys | 4 | 161609 | 247 | 11.390 | 14188.7 |
193 | 2023-11-16 11:02:01 | wiseguys | 3 | 146162 | 14 | 6.263 | 23337.4 |
192 | 2023-11-02 05:40:13 | wiseguys | 2 | 121059 | 2 | 3.173 | 38152.9 |
191 | 2023-10-09 10:35:03 | wiseguys | 1 | 82945 | 2 | 1.423 | 58288.8 |
190 | 2023-08-24 01:20:08 | wiseguys | 4 | 161609 | 247 | 10.563 | 15299.5 |
189 | 2023-08-18 18:13:32 | wiseguys | 3 | 146162 | 14 | 6.063 | 24107.2 |
188 | 2023-08-09 20:52:55 | wiseguys | 2 | 121059 | 2 | 3.110 | 38925.7 |
187 | 2023-08-04 17:30:06 | wiseguys | 1 | 82945 | 2 | 1.423 | 58288.8 |
186 | 2023-05-08 16:59:23 | wiseguys | 4 | 161609 | 247 | 10.156 | 15912.7 |
185 | 2023-05-02 07:57:33 | wiseguys | 3 | 146162 | 14 | 6.890 | 21213.6 |
184 | 2023-05-01 10:12:46 | wiseguys | 1 | 82945 | 2 | 1.406 | 58993.6 |
183 | 2023-04-19 00:27:44 | wiseguys | 2 | 121059 | 2 | 2.986 | 40542.2 |
182 | 2023-04-05 14:13:45 | wiseguys | 1 | 82945 | 2 | 1.203 | 68948.5 |
181 | 2023-02-22 01:18:51 | wiseguys | 1 | 82945 | 2 | 1.373 | 60411.5 |
180 | 2023-02-08 15:32:28 | wiseguys | 4 | 161609 | 247 | 10.140 | 15937.8 |
179 | 2023-02-05 21:53:34 | wiseguys | 3 | 146162 | 14 | 10.753 | 13592.7 |
178 | 2023-01-21 22:47:42 | wiseguys | 2 | 121059 | 2 | 3.453 | 35059.1 |
177 | 2022-12-19 13:52:58 | wiseguys | 1 | 82945 | 2 | 1.203 | 68948.5 |
176 | 2022-11-20 08:18:37 | wiseguys | 4 | 161609 | 247 | 10.250 | 15766.7 |
175 | 2022-11-15 23:45:35 | wiseguys | 3 | 146162 | 14 | 5.970 | 24482.7 |
174 | 2022-11-02 09:39:35 | wiseguys | 2 | 121059 | 2 | 3.186 | 37997.2 |
173 | 2022-08-28 17:17:55 | wiseguys | 1 | 82945 | 2 | 1.216 | 68211.3 |
172 | 2022-06-25 02:49:35 | wiseguys | 4 | 161609 | 247 | 10.313 | 15670.4 |
171 | 2022-06-19 01:31:01 | wiseguys | 3 | 146162 | 14 | 6.453 | 22650.2 |
170 | 2022-06-16 20:05:00 | wiseguys | 3 | 146162 | 14 | 6.000 | 24360.3 |
169 | 2022-05-11 03:25:46 | wiseguys | 2 | 121059 | 2 | 4.140 | 29241.3 |
168 | 2022-04-23 01:23:43 | wiseguys | 1 | 82945 | 2 | 1.733 | 47862.1 |
167 | 2022-04-17 17:25:26 | wiseguys | 1 | 82945 | 2 | 1.216 | 68211.3 |
166 | 2022-02-20 00:28:29 | wiseguys | 3 | 146162 | 14 | 6.890 | 21213.6 |
165 | 2022-01-17 17:52:21 | wiseguys | 1 | 82945 | 2 | 1.373 | 60411.5 |
164 | 2022-01-15 15:10:26 | wiseguys | 1 | 82945 | 2 | 1.626 | 51011.7 |
163 | 2021-11-20 06:51:12 | wiseguys | 1 | 82945 | 2 | 1.233 | 67270.9 |
162 | 2021-11-13 13:41:44 | wiseguys | 1 | 82945 | 2 | 1.313 | 63172.1 |
161 | 2021-10-05 10:02:50 | wiseguys | 1 | 82945 | 2 | 1.406 | 58993.6 |
160 | 2021-09-11 11:24:17 | wiseguys | 1 | 82945 | 2 | 1.343 | 61761.0 |
159 | 2021-08-31 22:20:50 | wiseguys | 1 | 82945 | 2 | 1.376 | 60279.8 |
158 | 2021-08-16 15:33:18 | wiseguys | 1 | 82945 | 2 | 1.220 | 67987.7 |
157 | 2021-04-24 03:55:08 | wiseguys | 1 | 82945 | 2 | 1.423 | 58288.8 |
156 | 2021-04-08 01:00:40 | wiseguys | 1 | 82945 | 2 | 1.250 | 66356.0 |
155 | 2021-03-12 06:11:54 | wiseguys | 1 | 82945 | 2 | 1.296 | 64000.8 |
154 | 2021-02-25 17:48:32 | wiseguys | 2 | 121059 | 2 | 3.046 | 39743.6 |
153 | 2021-01-23 01:40:27 | wiseguys | 1 | 82945 | 2 | 1.233 | 67270.9 |
152 | 2020-12-24 12:10:39 | wiseguys | 1 | 82945 | 2 | 1.283 | 64649.3 |
151 | 2020-12-23 08:21:02 | wiseguys | 1 | 82945 | 2 | 1.250 | 66356.0 |
150 | 2020-10-23 23:30:55 | wiseguys | 1 | 82945 | 2 | 1.373 | 60411.5 |