History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"recapped"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
238 | 2024-04-27 12:07:03 | recapped | 1 | 82945 | 3 | 2.326 | 35659.9 |
237 | 2024-04-12 23:51:16 | recapped | 1 | 82945 | 3 | 3.110 | 26670.4 |
236 | 2024-03-30 01:10:17 | recapped | 1 | 82945 | 3 | 2.580 | 32149.2 |
235 | 2024-03-04 21:46:02 | recapped | 1 | 82945 | 3 | 3.983 | 20824.8 |
234 | 2024-02-27 21:56:01 | recapped | 3 | 146162 | 220 | 8.266 | 17682.3 |
233 | 2024-02-27 05:07:00 | recapped | 3 | 146162 | 220 | 9.780 | 14945.0 |
232 | 2024-02-14 20:43:07 | recapped | 3 | 146162 | 220 | 13.830 | 10568.5 |
231 | 2024-02-05 02:43:58 | recapped | 3 | 146162 | 220 | 9.093 | 16074.1 |
230 | 2024-02-05 01:12:15 | recapped | 3 | 146162 | 220 | 9.953 | 14685.2 |
229 | 2024-01-30 22:21:24 | recapped | 1 | 82945 | 3 | 1.626 | 51011.7 |
228 | 2024-01-28 06:09:45 | recapped | 1 | 82945 | 3 | 1.283 | 64649.3 |
227 | 2024-01-27 10:15:45 | recapped | 3 | 146162 | 220 | 11.890 | 12292.9 |
226 | 2024-01-24 10:58:23 | recapped | 1 | 82945 | 3 | 1.313 | 63172.1 |
225 | 2024-01-23 01:19:37 | recapped | 3 | 146162 | 220 | 12.390 | 11796.8 |
224 | 2024-01-23 01:19:37 | recapped | 2 | 121059 | 22 | 4.203 | 28803.0 |
223 | 2024-01-05 15:05:13 | recapped | 3 | 146162 | 220 | 7.936 | 18417.6 |
222 | 2024-01-05 15:05:10 | recapped | 2 | 121059 | 22 | 4.220 | 28687.0 |
221 | 2023-12-25 06:33:36 | recapped | 3 | 146162 | 220 | 6.376 | 22923.8 |
220 | 2023-12-09 07:20:24 | recapped | 1 | 82945 | 3 | 1.533 | 54106.3 |
219 | 2023-11-21 04:52:38 | recapped | 1 | 82945 | 3 | 1.330 | 62364.7 |
218 | 2023-11-20 04:30:12 | recapped | 1 | 82945 | 3 | 1.360 | 60989.0 |
217 | 2023-11-14 15:52:47 | recapped | 1 | 82945 | 3 | 1.280 | 64800.8 |
216 | 2023-11-04 15:30:39 | recapped | 1 | 82945 | 3 | 1.310 | 63316.8 |
215 | 2023-11-01 06:54:16 | recapped | 1 | 82945 | 3 | 1.436 | 57761.1 |
214 | 2023-10-17 03:50:16 | recapped | 1 | 82945 | 3 | 1.486 | 55817.6 |
213 | 2023-09-29 11:49:21 | recapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
212 | 2023-09-26 04:19:33 | recapped | 3 | 146162 | 220 | 7.563 | 19325.9 |
211 | 2023-09-16 23:30:58 | recapped | 1 | 82945 | 3 | 1.516 | 54713.1 |
210 | 2023-09-06 22:33:08 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
209 | 2023-07-04 18:43:48 | recapped | 3 | 146162 | 220 | 8.310 | 17588.7 |
208 | 2023-06-13 12:42:06 | recapped | 1 | 82945 | 3 | 1.483 | 55930.5 |
207 | 2023-06-11 03:19:12 | recapped | 1 | 82945 | 3 | 1.283 | 64649.3 |
206 | 2023-05-17 13:51:59 | recapped | 1 | 82945 | 3 | 1.486 | 55817.6 |
205 | 2023-03-31 23:03:26 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
204 | 2023-03-30 11:53:55 | recapped | 1 | 82945 | 3 | 1.420 | 58412.0 |
203 | 2023-03-25 12:34:53 | recapped | 3 | 146162 | 220 | 6.813 | 21453.4 |
202 | 2023-01-17 03:15:56 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
201 | 2023-01-13 00:35:33 | recapped | 1 | 82945 | 3 | 1.266 | 65517.4 |
200 | 2023-01-05 04:22:07 | recapped | 3 | 146162 | 220 | 14.936 | 9785.9 |
199 | 2022-12-24 00:06:29 | recapped | 3 | 146162 | 220 | 6.296 | 23215.1 |
198 | 2022-11-28 16:22:48 | recapped | 3 | 146162 | 220 | 7.576 | 19292.8 |
197 | 2022-11-22 01:19:19 | recapped | 3 | 146162 | 220 | 6.560 | 22280.8 |
196 | 2022-11-21 16:23:01 | recapped | 3 | 146162 | 220 | 6.610 | 22112.3 |
195 | 2022-10-24 14:09:53 | recapped | 1 | 82945 | 3 | 1.440 | 57600.7 |
194 | 2022-10-12 10:43:38 | recapped | 3 | 146162 | 220 | 6.986 | 20922.1 |
193 | 2022-10-07 08:24:23 | recapped | 3 | 146162 | 220 | 6.393 | 22862.8 |
192 | 2022-09-07 20:38:08 | recapped | 1 | 82945 | 3 | 1.373 | 60411.5 |
191 | 2022-08-23 10:26:40 | recapped | 3 | 146162 | 220 | 6.376 | 22923.8 |
190 | 2022-06-14 02:16:37 | recapped | 1 | 82945 | 3 | 1.280 | 64800.8 |
189 | 2022-05-19 21:23:41 | recapped | 1 | 82945 | 3 | 1.466 | 56579.1 |
188 | 2022-04-28 12:46:35 | recapped | 1 | 82945 | 3 | 1.890 | 43886.2 |
187 | 2022-03-10 23:12:41 | recapped | 1 | 82945 | 3 | 1.936 | 42843.5 |
186 | 2022-01-01 23:36:10 | recapped | 1 | 82945 | 3 | 1.330 | 62364.7 |
185 | 2021-09-13 01:17:44 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
184 | 2021-06-08 21:19:45 | recapped | 1 | 82945 | 3 | 1.450 | 57203.4 |
183 | 2021-05-26 14:31:01 | recapped | 1 | 82945 | 3 | 1.466 | 56579.1 |
182 | 2021-04-30 17:54:31 | recapped | 1 | 82945 | 3 | 1.486 | 55817.6 |
181 | 2021-03-30 02:24:03 | recapped | 1 | 82945 | 3 | 1.453 | 57085.3 |
180 | 2021-03-06 14:42:58 | recapped | 1 | 82945 | 3 | 1.420 | 58412.0 |
179 | 2021-03-03 10:04:14 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
178 | 2021-01-13 17:33:55 | recapped | 1 | 82945 | 3 | 1.330 | 62364.7 |
177 | 2020-11-23 02:06:17 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
176 | 2020-11-10 02:23:31 | recapped | 1 | 82945 | 3 | 1.390 | 59672.7 |
175 | 2020-10-21 05:01:34 | recapped | 1 | 82945 | 3 | 1.280 | 64800.8 |
174 | 2020-10-16 08:44:02 | recapped | 1 | 82945 | 3 | 1.406 | 58993.6 |
173 | 2020-09-30 22:25:10 | recapped | 1 | 82945 | 3 | 1.436 | 57761.1 |
172 | 2020-09-08 04:49:46 | recapped | 1 | 82945 | 3 | 1.393 | 59544.1 |
171 | 2020-08-06 11:55:29 | recapped | 1 | 82945 | 3 | 1.813 | 45750.1 |
170 | 2020-07-19 00:43:27 | recapped | 1 | 82945 | 3 | 1.376 | 60279.8 |
169 | 2020-05-01 21:37:22 | recapped | 1 | 82945 | 3 | 1.330 | 62364.7 |
168 | 2020-03-28 13:24:25 | recapped | 1 | 82945 | 3 | 1.563 | 53067.8 |
167 | 2020-03-24 02:33:09 | recapped | 1 | 82945 | 3 | 1.560 | 53169.9 |
166 | 2020-03-04 15:05:49 | recapped | 1 | 82945 | 3 | 3.076 | 26965.2 |
165 | 2020-03-02 21:30:35 | recapped | 1 | 82945 | 3 | 3.406 | 24352.6 |
164 | 2020-02-24 09:02:41 | recapped | 1 | 82945 | 3 | 1.610 | 51518.6 |
163 | 2020-02-22 19:19:59 | recapped | 1 | 82945 | 3 | 1.733 | 47862.1 |
162 | 2020-02-21 14:16:56 | recapped | 1 | 82945 | 3 | 3.403 | 24374.1 |
161 | 2020-02-17 19:14:01 | recapped | 1 | 82945 | 3 | 1.593 | 52068.4 |
160 | 2020-02-07 08:25:39 | recapped | 1 | 82945 | 3 | 2.063 | 40206.0 |
159 | 2020-01-30 14:12:43 | recapped | 1 | 82945 | 3 | 2.890 | 28700.7 |
158 | 2020-01-27 19:52:21 | recapped | 1 | 82945 | 3 | 1.626 | 51011.7 |
157 | 2020-01-27 01:06:46 | recapped | 1 | 82945 | 3 | 1.483 | 55930.5 |
156 | 2020-01-24 19:20:28 | recapped | 1 | 82945 | 3 | 3.156 | 26281.7 |
155 | 2020-01-21 16:56:36 | recapped | 1 | 82945 | 3 | 1.686 | 49196.3 |
154 | 2020-01-15 21:35:01 | recapped | 1 | 82945 | 3 | 1.623 | 51106.0 |
153 | 2020-01-11 08:26:19 | recapped | 1 | 82945 | 3 | 1.296 | 64000.8 |
152 | 2020-01-11 07:29:11 | recapped | 1 | 82945 | 3 | 1.606 | 51646.9 |
151 | 2020-01-07 13:50:20 | recapped | 1 | 82945 | 3 | 1.530 | 54212.4 |
150 | 2019-12-30 02:03:04 | recapped | 1 | 82945 | 3 | 1.563 | 53067.8 |
149 | 2019-12-29 08:04:16 | recapped | 1 | 82945 | 3 | 1.686 | 49196.3 |
148 | 2019-10-26 12:42:03 | recapped | 1 | 82945 | 3 | 1.436 | 57761.1 |
147 | 2019-08-10 15:03:28 | recapped | 1 | 82945 | 3 | 1.260 | 65829.4 |
146 | 2019-08-10 14:42:06 | recapped | 1 | 82945 | 3 | 1.250 | 66356.0 |
145 | 2019-07-31 13:56:00 | recapped | 1 | 82945 | 3 | 1.330 | 62364.7 |
144 | 2019-07-27 06:56:50 | recapped | 1 | 82945 | 3 | 1.270 | 65311.0 |
143 | 2019-07-25 11:17:41 | recapped | 1 | 82945 | 3 | 1.336 | 62084.6 |
142 | 2019-07-21 02:20:22 | recapped | 1 | 82945 | 3 | 1.270 | 65311.0 |
141 | 2019-07-19 02:19:02 | recapped | 1 | 82945 | 3 | 1.276 | 65003.9 |
140 | 2019-07-12 09:05:29 | recapped | 1 | 82945 | 3 | 1.343 | 61761.0 |
139 | 2019-07-11 06:32:49 | recapped | 1 | 82945 | 3 | 1.283 | 64649.3 |