History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"mansion"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
276 | 2024-05-11 01:01:43 | mansion | 1 | 69583 | 2 | 1.626 | 42794.0 |
275 | 2024-03-20 14:21:23 | mansion | 1 | 69583 | 2 | 1.106 | 62914.1 |
274 | 2024-03-03 04:22:58 | mansion | 1 | 69583 | 2 | 1.080 | 64428.7 |
273 | 2024-02-26 10:13:00 | mansion | 3 | 134027 | 234 | 9.686 | 13837.2 |
272 | 2024-02-22 21:21:41 | mansion | 2 | 107671 | 21 | 3.533 | 30475.8 |
271 | 2024-02-22 21:21:22 | mansion | 3 | 134027 | 234 | 7.470 | 17942.0 |
270 | 2024-02-20 00:02:48 | mansion | 3 | 134027 | 234 | 20.550 | 6522.0 |
269 | 2024-02-19 09:46:26 | mansion | 3 | 134027 | 234 | 7.436 | 18024.1 |
268 | 2024-01-19 17:26:44 | mansion | 2 | 107671 | 21 | 2.923 | 36835.8 |
267 | 2024-01-12 00:56:52 | mansion | 3 | 134027 | 234 | 6.733 | 19906.0 |
266 | 2024-01-12 00:56:50 | mansion | 2 | 107671 | 21 | 3.140 | 34290.1 |
265 | 2023-12-10 12:55:54 | mansion | 1 | 69583 | 2 | 1.063 | 65459.1 |
264 | 2023-11-18 02:41:27 | mansion | 3 | 134027 | 234 | 7.893 | 16980.5 |
263 | 2023-11-17 05:26:06 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
262 | 2023-11-13 21:17:46 | mansion | 1 | 69583 | 2 | 1.110 | 62687.4 |
261 | 2023-10-30 14:57:47 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
260 | 2023-10-29 08:37:09 | mansion | 2 | 107671 | 21 | 3.296 | 32667.2 |
259 | 2023-10-14 19:15:24 | mansion | 1 | 69583 | 2 | 1.250 | 55666.4 |
258 | 2023-09-29 09:42:51 | mansion | 1 | 69583 | 2 | 2.266 | 30707.4 |
257 | 2023-09-24 09:36:13 | mansion | 1 | 69583 | 2 | 1.156 | 60192.9 |
256 | 2023-09-18 23:37:16 | mansion | 1 | 69583 | 2 | 1.186 | 58670.3 |
255 | 2023-08-20 04:16:01 | mansion | 3 | 134027 | 234 | 6.156 | 21771.8 |
254 | 2023-08-07 11:18:40 | mansion | 2 | 107671 | 21 | 2.923 | 36835.8 |
253 | 2023-07-14 14:16:24 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
252 | 2023-07-07 00:59:45 | mansion | 1 | 69583 | 2 | 2.313 | 30083.4 |
251 | 2023-05-03 13:50:44 | mansion | 3 | 134027 | 234 | 5.970 | 22450.1 |
250 | 2023-04-17 04:52:03 | mansion | 1 | 69583 | 2 | 1.170 | 59472.6 |
249 | 2023-04-15 22:10:22 | mansion | 2 | 107671 | 21 | 2.953 | 36461.6 |
248 | 2023-03-20 01:40:53 | mansion | 1 | 69583 | 2 | 1.203 | 57841.2 |
247 | 2023-03-16 18:43:47 | mansion | 1 | 69583 | 2 | 1.076 | 64668.2 |
246 | 2023-02-10 01:56:44 | mansion | 3 | 134027 | 234 | 5.783 | 23176.0 |
245 | 2023-02-08 08:15:16 | mansion | 3 | 134027 | 234 | 7.030 | 19065.0 |
244 | 2023-02-07 04:35:25 | mansion | 1 | 69583 | 2 | 1.170 | 59472.6 |
243 | 2023-01-19 17:52:16 | mansion | 2 | 107671 | 21 | 2.903 | 37089.6 |
242 | 2022-12-28 20:42:05 | mansion | 1 | 69583 | 2 | 1.046 | 66522.9 |
241 | 2022-12-04 06:20:50 | mansion | 1 | 69583 | 2 | 1.216 | 57222.9 |
240 | 2022-11-21 22:27:31 | mansion | 1 | 69583 | 2 | 1.156 | 60192.9 |
239 | 2022-11-21 00:46:06 | mansion | 1 | 69583 | 2 | 1.126 | 61796.6 |
238 | 2022-11-20 02:32:06 | mansion | 3 | 134027 | 234 | 5.893 | 22743.4 |
237 | 2022-10-29 18:31:47 | mansion | 2 | 107671 | 21 | 2.920 | 36873.6 |
236 | 2022-09-17 18:31:52 | mansion | 1 | 69583 | 2 | 1.093 | 63662.4 |
235 | 2022-09-12 11:48:08 | mansion | 1 | 69583 | 2 | 1.156 | 60192.9 |
234 | 2022-08-15 11:11:54 | mansion | 1 | 69583 | 2 | 1.186 | 58670.3 |
233 | 2022-08-14 23:15:51 | mansion | 1 | 69583 | 2 | 1.173 | 59320.5 |
232 | 2022-08-14 04:31:10 | mansion | 1 | 69583 | 2 | 2.563 | 27149.0 |
231 | 2022-07-31 15:47:06 | mansion | 1 | 69583 | 2 | 1.186 | 58670.3 |
230 | 2022-07-29 07:25:14 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
229 | 2022-07-29 02:55:07 | mansion | 1 | 69583 | 2 | 1.080 | 64428.7 |
228 | 2022-05-25 14:05:56 | mansion | 2 | 107671 | 21 | 3.110 | 34620.9 |
227 | 2022-05-07 08:02:52 | mansion | 3 | 134027 | 234 | 5.936 | 22578.7 |
226 | 2022-04-07 01:46:25 | mansion | 1 | 69583 | 2 | 1.250 | 55666.4 |
225 | 2022-03-19 14:08:06 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
224 | 2022-03-17 11:30:01 | mansion | 1 | 69583 | 2 | 1.326 | 52475.9 |
223 | 2022-01-09 02:25:10 | mansion | 3 | 134027 | 234 | 6.076 | 22058.4 |
222 | 2021-12-25 12:55:42 | mansion | 1 | 69583 | 2 | 1.096 | 63488.1 |
221 | 2021-12-23 10:35:32 | mansion | 1 | 69583 | 2 | 1.313 | 52995.4 |
220 | 2021-12-19 22:31:07 | mansion | 1 | 69583 | 2 | 1.326 | 52475.9 |
219 | 2021-10-28 08:27:03 | mansion | 1 | 69583 | 2 | 1.376 | 50569.0 |
218 | 2021-09-29 08:34:16 | mansion | 1 | 69583 | 2 | 1.470 | 47335.4 |
217 | 2021-09-12 16:41:29 | mansion | 1 | 69583 | 2 | 1.076 | 64668.2 |
216 | 2021-07-25 08:39:03 | mansion | 1 | 69583 | 2 | 1.080 | 64428.7 |
215 | 2021-06-12 12:45:03 | mansion | 1 | 69583 | 2 | 1.266 | 54962.9 |
214 | 2021-05-15 07:57:35 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
213 | 2021-04-30 17:56:23 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
212 | 2021-04-14 10:06:05 | mansion | 1 | 69583 | 2 | 1.203 | 57841.2 |
211 | 2021-03-13 02:47:16 | mansion | 1 | 69583 | 2 | 1.283 | 54234.6 |
210 | 2021-01-27 23:57:31 | mansion | 1 | 69583 | 2 | 1.093 | 63662.4 |
209 | 2020-12-30 10:16:50 | mansion | 1 | 69583 | 2 | 1.080 | 64428.7 |
208 | 2020-12-09 23:13:22 | mansion | 1 | 69583 | 2 | 1.220 | 57035.2 |
207 | 2020-10-23 15:56:00 | mansion | 1 | 69583 | 2 | 1.076 | 64668.2 |
206 | 2020-10-22 15:58:10 | mansion | 1 | 69583 | 2 | 1.203 | 57841.2 |
205 | 2020-09-21 05:22:50 | mansion | 1 | 69583 | 2 | 1.200 | 57985.8 |
204 | 2020-09-13 19:58:43 | mansion | 1 | 69583 | 2 | 1.076 | 64668.2 |
203 | 2020-09-03 07:04:00 | mansion | 1 | 69583 | 2 | 1.280 | 54361.7 |
202 | 2020-08-22 17:36:43 | mansion | 1 | 69583 | 2 | 1.216 | 57222.9 |
201 | 2020-08-04 18:38:30 | mansion | 1 | 69583 | 2 | 1.186 | 58670.3 |
200 | 2020-07-20 09:52:14 | mansion | 1 | 69583 | 2 | 1.283 | 54234.6 |
199 | 2020-05-26 05:54:32 | mansion | 1 | 69583 | 2 | 1.110 | 62687.4 |
198 | 2020-03-29 07:12:01 | mansion | 1 | 69583 | 2 | 2.670 | 26061.0 |
197 | 2020-03-29 01:50:39 | mansion | 1 | 69583 | 2 | 1.263 | 55093.4 |
196 | 2020-03-24 01:53:29 | mansion | 1 | 69583 | 2 | 2.000 | 34791.5 |
195 | 2020-03-22 10:21:49 | mansion | 1 | 69583 | 2 | 1.343 | 51811.6 |
194 | 2020-03-20 21:25:12 | mansion | 1 | 69583 | 2 | 1.106 | 62914.1 |
193 | 2020-02-28 15:41:47 | mansion | 1 | 69583 | 2 | 1.393 | 49951.9 |
192 | 2020-02-23 18:42:52 | mansion | 1 | 69583 | 2 | 2.763 | 25183.9 |
191 | 2020-02-23 00:21:56 | mansion | 1 | 69583 | 2 | 2.576 | 27012.0 |
190 | 2020-02-15 11:54:44 | mansion | 1 | 69583 | 2 | 1.283 | 54234.6 |
189 | 2020-02-06 01:25:04 | mansion | 1 | 69583 | 2 | 1.440 | 48321.5 |
188 | 2020-02-05 21:40:56 | mansion | 1 | 69583 | 2 | 1.406 | 49490.0 |
187 | 2020-02-05 04:19:42 | mansion | 1 | 69583 | 2 | 1.420 | 49002.1 |
186 | 2020-02-01 06:37:29 | mansion | 1 | 69583 | 2 | 1.310 | 53116.8 |
185 | 2020-01-28 18:03:58 | mansion | 1 | 69583 | 2 | 1.250 | 55666.4 |
184 | 2020-01-23 14:11:32 | mansion | 1 | 69583 | 2 | 2.343 | 29698.3 |
183 | 2020-01-15 23:18:27 | mansion | 1 | 69583 | 2 | 2.080 | 33453.4 |
182 | 2020-01-15 07:32:27 | mansion | 1 | 69583 | 2 | 1.266 | 54962.9 |
181 | 2020-01-12 13:25:32 | mansion | 1 | 69583 | 2 | 1.326 | 52475.9 |
180 | 2020-01-08 03:08:22 | mansion | 1 | 69583 | 2 | 1.216 | 57222.9 |
179 | 2019-12-28 06:26:38 | mansion | 1 | 69583 | 2 | 1.080 | 64428.7 |
178 | 2019-12-27 04:21:43 | mansion | 1 | 69583 | 2 | 2.733 | 25460.3 |
177 | 2019-12-27 02:51:09 | mansion | 1 | 69583 | 2 | 1.640 | 42428.7 |