History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"politicians"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
256 | 2024-04-19 23:34:09 | politicians | 3 | 121633 | 24 | 15.096 | 8057.3 |
255 | 2024-04-19 19:25:46 | politicians | 5 | 164607 | 338 | 53.690 | 3065.9 |
254 | 2024-04-19 19:25:51 | politicians | 4 | 148819 | 72 | 34.066 | 4368.5 |
253 | 2024-04-19 19:25:39 | politicians | 3 | 121633 | 24 | 10.783 | 11280.1 |
252 | 2024-04-19 07:04:04 | politicians | 5 | 164607 | 338 | 66.443 | 2477.4 |
251 | 2024-04-19 07:04:01 | politicians | 4 | 148819 | 72 | 24.783 | 6004.9 |
250 | 2024-04-19 04:58:44 | politicians | 5 | 164607 | 338 | 37.330 | 4409.5 |
249 | 2024-04-19 04:58:45 | politicians | 3 | 121633 | 24 | 25.330 | 4801.9 |
248 | 2024-04-19 04:58:45 | politicians | 4 | 148819 | 72 | 24.940 | 5967.1 |
247 | 2024-04-19 04:58:47 | politicians | 2 | 86808 | 4 | 7.906 | 10980.0 |
246 | 2024-04-19 03:07:59 | politicians | 1 | 49908 | 2 | 1.126 | 44323.3 |
245 | 2024-04-13 07:06:21 | politicians | 1 | 49908 | 2 | 0.936 | 53320.5 |
244 | 2024-04-13 02:01:17 | politicians | 1 | 49908 | 2 | 0.860 | 58032.6 |
243 | 2024-04-13 02:00:36 | politicians | 1 | 49908 | 2 | 1.796 | 27788.4 |
242 | 2024-03-29 15:00:53 | politicians | 2 | 86808 | 4 | 5.626 | 15429.8 |
241 | 2024-03-29 15:00:39 | politicians | 1 | 49908 | 2 | 1.953 | 25554.5 |
240 | 2024-03-11 14:53:26 | politicians | 4 | 148819 | 72 | 25.613 | 5810.3 |
239 | 2024-03-11 14:53:18 | politicians | 3 | 121633 | 24 | 11.236 | 10825.3 |
238 | 2024-03-09 23:17:24 | politicians | 4 | 148819 | 72 | 10.733 | 13865.6 |
237 | 2024-03-09 21:10:06 | politicians | 4 | 148819 | 72 | 36.206 | 4110.3 |
236 | 2024-03-09 21:10:05 | politicians | 3 | 121633 | 24 | 7.580 | 16046.6 |
235 | 2024-03-08 18:29:16 | politicians | 4 | 148819 | 72 | 12.686 | 11731.0 |
234 | 2024-03-08 11:05:43 | politicians | 4 | 148819 | 72 | 25.546 | 5825.5 |
233 | 2024-03-08 04:33:11 | politicians | 4 | 148819 | 72 | 36.330 | 4096.3 |
232 | 2024-03-08 04:33:14 | politicians | 3 | 121633 | 24 | 11.733 | 10366.7 |
231 | 2024-03-08 04:33:15 | politicians | 2 | 86808 | 4 | 8.220 | 10560.6 |
230 | 2024-03-08 04:33:03 | politicians | 1 | 49908 | 2 | 0.953 | 52369.4 |
229 | 2024-03-04 14:25:08 | politicians | 5 | 164607 | 338 | 20.546 | 8011.6 |
228 | 2024-03-04 10:48:56 | politicians | 5 | 164607 | 338 | 40.516 | 4062.8 |
227 | 2024-03-01 04:17:12 | politicians | 5 | 164607 | 338 | 17.953 | 9168.8 |
226 | 2024-02-15 05:54:39 | politicians | 4 | 148819 | 72 | 20.783 | 7160.6 |
225 | 2024-02-15 05:54:39 | politicians | 2 | 86808 | 4 | 2.796 | 31047.2 |
224 | 2024-02-15 05:31:59 | politicians | 1 | 49908 | 2 | 0.843 | 59202.8 |
223 | 2024-02-14 02:33:07 | politicians | 1 | 49908 | 2 | 1.623 | 30750.5 |
222 | 2024-02-13 11:27:26 | politicians | 2 | 86808 | 4 | 4.703 | 18458.0 |
221 | 2024-02-13 08:58:10 | politicians | 1 | 49908 | 2 | 0.890 | 56076.4 |
220 | 2024-02-11 20:47:22 | politicians | 3 | 121633 | 24 | 13.516 | 8999.2 |
219 | 2024-02-08 22:01:39 | politicians | 2 | 86808 | 4 | 5.686 | 15267.0 |
218 | 2024-02-08 21:53:48 | politicians | 1 | 49908 | 2 | 0.780 | 63984.6 |
217 | 2024-02-08 21:52:57 | politicians | 3 | 121633 | 24 | 9.956 | 12217.1 |
216 | 2024-02-08 17:03:54 | politicians | 2 | 86808 | 4 | 2.826 | 30717.6 |
215 | 2024-02-08 16:06:12 | politicians | 3 | 121633 | 24 | 19.436 | 6258.1 |
214 | 2024-02-08 14:32:56 | politicians | 1 | 49908 | 2 | 0.860 | 58032.6 |
213 | 2024-02-05 12:14:58 | politicians | 2 | 86808 | 4 | 9.376 | 9258.5 |
212 | 2024-02-03 13:16:58 | politicians | 4 | 148819 | 72 | 9.466 | 15721.4 |
211 | 2024-02-03 13:17:02 | politicians | 2 | 86808 | 4 | 2.470 | 35144.9 |
210 | 2024-02-03 13:16:54 | politicians | 3 | 121633 | 24 | 10.173 | 11956.5 |
209 | 2024-02-03 13:16:50 | politicians | 1 | 49908 | 2 | 0.890 | 56076.4 |
208 | 2024-02-03 06:30:17 | politicians | 5 | 164607 | 338 | 33.563 | 4904.4 |
207 | 2024-01-14 12:48:54 | politicians | 1 | 49908 | 2 | 0.843 | 59202.8 |
206 | 2024-01-10 13:29:25 | politicians | 1 | 49908 | 2 | 0.783 | 63739.5 |
205 | 2024-01-01 11:02:36 | politicians | 1 | 49908 | 2 | 0.766 | 65154.0 |
204 | 2023-12-21 06:08:42 | politicians | 5 | 164607 | 338 | 13.703 | 12012.5 |
203 | 2023-12-21 00:53:32 | politicians | 2 | 86808 | 4 | 2.123 | 40889.3 |
202 | 2023-12-11 18:48:45 | politicians | 1 | 49908 | 2 | 0.766 | 65154.0 |
201 | 2023-11-27 15:39:17 | politicians | 4 | 148819 | 72 | 8.876 | 16766.4 |
200 | 2023-11-03 06:45:35 | politicians | 1 | 49908 | 2 | 0.750 | 66544.0 |
199 | 2023-10-01 19:02:18 | politicians | 5 | 164607 | 338 | 13.080 | 12584.6 |
198 | 2023-09-27 02:57:17 | politicians | 5 | 164607 | 338 | 16.970 | 9699.9 |
197 | 2023-09-27 02:57:11 | politicians | 4 | 148819 | 72 | 9.330 | 15950.6 |
196 | 2023-09-27 02:57:13 | politicians | 2 | 86808 | 4 | 2.610 | 33259.8 |
195 | 2023-09-27 02:57:10 | politicians | 3 | 121633 | 24 | 5.280 | 23036.6 |
194 | 2023-09-23 09:26:57 | politicians | 2 | 86808 | 4 | 2.453 | 35388.5 |
193 | 2023-09-21 20:15:16 | politicians | 5 | 164607 | 338 | 13.750 | 11971.4 |
192 | 2023-09-19 17:20:09 | politicians | 1 | 49908 | 2 | 0.766 | 65154.0 |
191 | 2023-08-27 20:36:29 | politicians | 4 | 148819 | 72 | 8.250 | 18038.7 |
190 | 2023-08-25 00:35:54 | politicians | 1 | 49908 | 2 | 0.860 | 58032.6 |
189 | 2023-07-30 06:38:04 | politicians | 4 | 148819 | 72 | 9.296 | 16008.9 |
188 | 2023-07-09 10:16:59 | politicians | 5 | 164607 | 338 | 14.610 | 11266.7 |
187 | 2023-07-06 01:49:50 | politicians | 2 | 86808 | 4 | 2.046 | 42428.2 |
186 | 2023-06-30 13:50:57 | politicians | 5 | 164607 | 338 | 13.063 | 12601.0 |
185 | 2023-06-11 22:54:28 | politicians | 4 | 148819 | 72 | 9.486 | 15688.3 |
184 | 2023-05-29 10:03:21 | politicians | 5 | 164607 | 338 | 13.033 | 12630.0 |
183 | 2023-05-28 07:51:47 | politicians | 1 | 49908 | 2 | 0.763 | 65410.2 |
182 | 2023-05-11 12:14:45 | politicians | 4 | 148819 | 72 | 16.330 | 9113.2 |
181 | 2023-03-26 06:57:24 | politicians | 2 | 86808 | 4 | 2.046 | 42428.2 |
180 | 2023-03-25 02:14:20 | politicians | 1 | 49908 | 2 | 0.750 | 66544.0 |
179 | 2023-03-23 20:38:10 | politicians | 5 | 164607 | 338 | 12.936 | 12724.7 |
178 | 2023-03-04 10:17:38 | politicians | 1 | 49908 | 2 | 0.830 | 60130.1 |
177 | 2023-02-16 09:01:43 | politicians | 4 | 148819 | 72 | 17.080 | 8713.1 |
176 | 2023-01-15 11:50:25 | politicians | 5 | 164607 | 338 | 13.170 | 12498.6 |
175 | 2023-01-10 15:46:24 | politicians | 1 | 49908 | 2 | 0.750 | 66544.0 |
174 | 2022-12-24 05:53:10 | politicians | 2 | 86808 | 4 | 2.013 | 43123.7 |
173 | 2022-12-22 23:38:35 | politicians | 5 | 164607 | 338 | 12.970 | 12691.4 |
172 | 2022-12-18 08:35:27 | politicians | 5 | 164607 | 338 | 15.250 | 10793.9 |
171 | 2022-11-27 01:39:48 | politicians | 4 | 148819 | 72 | 8.063 | 18457.0 |
170 | 2022-11-24 20:19:18 | politicians | 5 | 164607 | 338 | 15.970 | 10307.3 |
169 | 2022-10-12 12:21:38 | politicians | 1 | 49908 | 2 | 0.750 | 66544.0 |
168 | 2022-09-17 01:32:19 | politicians | 5 | 164607 | 338 | 14.986 | 10984.1 |
167 | 2022-08-27 00:27:53 | politicians | 1 | 49908 | 2 | 0.763 | 65410.2 |
166 | 2022-08-26 06:54:20 | politicians | 2 | 86808 | 4 | 2.063 | 42078.5 |
165 | 2022-08-26 05:35:28 | politicians | 5 | 164607 | 338 | 13.046 | 12617.4 |
164 | 2022-07-13 22:34:53 | politicians | 3 | 121633 | 24 | 4.390 | 27706.8 |
163 | 2022-06-12 23:09:06 | politicians | 1 | 49908 | 2 | 0.843 | 59202.8 |
162 | 2022-06-09 11:37:21 | politicians | 1 | 49908 | 2 | 0.983 | 50771.1 |
161 | 2022-06-07 10:45:12 | politicians | 1 | 49908 | 2 | 0.780 | 63984.6 |
160 | 2022-05-29 16:37:44 | politicians | 1 | 49908 | 2 | 0.780 | 63984.6 |
159 | 2022-04-21 23:14:32 | politicians | 4 | 148819 | 72 | 9.846 | 15114.7 |
158 | 2022-04-09 19:50:46 | politicians | 2 | 86808 | 4 | 2.390 | 36321.3 |
157 | 2022-04-09 09:22:22 | politicians | 5 | 164607 | 338 | 13.016 | 12646.5 |