History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"perchance"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
273 | 2024-05-02 11:54:18 | perchance | 1 | 81242 | 1 | 2.830 | 28707.4 |
272 | 2024-04-29 13:03:05 | perchance | 1 | 81242 | 1 | 1.470 | 55266.7 |
271 | 2024-04-26 06:15:52 | perchance | 1 | 81242 | 1 | 2.076 | 39133.9 |
270 | 2024-04-19 05:34:59 | perchance | 1 | 81242 | 1 | 1.610 | 50460.9 |
269 | 2024-04-10 15:31:28 | perchance | 2 | 121436 | 3 | 4.623 | 26267.8 |
268 | 2024-04-10 14:33:27 | perchance | 1 | 81242 | 1 | 1.500 | 54161.3 |
267 | 2024-04-01 07:25:39 | perchance | 2 | 121436 | 3 | 4.860 | 24986.8 |
266 | 2024-04-01 05:49:33 | perchance | 1 | 81242 | 1 | 1.453 | 55913.3 |
265 | 2024-03-27 10:16:41 | perchance | 2 | 121436 | 3 | 8.283 | 14660.9 |
264 | 2024-03-27 10:06:57 | perchance | 3 | 148641 | 34 | 8.706 | 17073.4 |
263 | 2024-03-27 08:20:19 | perchance | 3 | 148641 | 34 | 14.296 | 10397.4 |
262 | 2024-03-26 20:10:02 | perchance | 4 | 165329 | 254 | 41.143 | 4018.4 |
261 | 2024-03-26 20:09:36 | perchance | 3 | 148641 | 34 | 19.720 | 7537.6 |
260 | 2024-03-26 14:18:10 | perchance | 4 | 165329 | 254 | 38.893 | 4250.9 |
259 | 2024-03-26 06:29:05 | perchance | 4 | 165329 | 254 | 16.860 | 9806.0 |
258 | 2024-03-26 03:58:50 | perchance | 4 | 165329 | 254 | 30.756 | 5375.5 |
257 | 2024-03-26 03:58:48 | perchance | 2 | 121436 | 3 | 12.516 | 9702.5 |
256 | 2024-03-26 03:58:41 | perchance | 3 | 148641 | 34 | 18.033 | 8242.7 |
255 | 2024-03-26 02:52:53 | perchance | 1 | 81242 | 1 | 2.860 | 28406.3 |
254 | 2024-03-25 03:24:07 | perchance | 1 | 81242 | 1 | 1.280 | 63470.3 |
253 | 2024-03-24 17:44:40 | perchance | 1 | 81242 | 1 | 1.296 | 62686.7 |
252 | 2024-02-27 13:00:03 | perchance | 1 | 81242 | 1 | 1.326 | 61268.5 |
251 | 2024-02-14 01:31:34 | perchance | 1 | 81242 | 1 | 3.703 | 21939.5 |
250 | 2024-02-05 11:08:29 | perchance | 1 | 81242 | 1 | 1.516 | 53589.7 |
249 | 2024-01-29 19:54:06 | perchance | 1 | 81242 | 1 | 1.453 | 55913.3 |
248 | 2024-01-26 18:26:31 | perchance | 1 | 81242 | 1 | 1.390 | 58447.5 |
247 | 2024-01-08 16:02:26 | perchance | 1 | 81242 | 1 | 1.456 | 55798.1 |
246 | 2023-11-27 14:19:49 | perchance | 1 | 81242 | 1 | 1.470 | 55266.7 |
245 | 2023-11-16 16:52:36 | perchance | 1 | 81242 | 1 | 1.280 | 63470.3 |
244 | 2023-10-14 06:53:57 | perchance | 1 | 81242 | 1 | 1.296 | 62686.7 |
243 | 2023-09-27 23:22:58 | perchance | 1 | 81242 | 1 | 1.453 | 55913.3 |
242 | 2023-09-12 05:38:55 | perchance | 1 | 81242 | 1 | 1.423 | 57092.1 |
241 | 2023-07-07 13:22:25 | perchance | 1 | 81242 | 1 | 1.250 | 64993.6 |
240 | 2023-06-26 04:37:49 | perchance | 1 | 81242 | 1 | 1.373 | 59171.2 |
239 | 2023-04-07 13:09:24 | perchance | 1 | 81242 | 1 | 1.250 | 64993.6 |
238 | 2023-02-28 12:54:29 | perchance | 1 | 81242 | 1 | 1.280 | 63470.3 |
237 | 2023-01-29 10:16:09 | perchance | 1 | 81242 | 1 | 1.406 | 57782.4 |
236 | 2022-11-26 04:36:45 | perchance | 1 | 81242 | 1 | 1.266 | 64172.2 |
235 | 2022-10-21 09:45:12 | perchance | 1 | 81242 | 1 | 1.606 | 50586.6 |
234 | 2022-10-17 19:36:39 | perchance | 1 | 81242 | 1 | 1.263 | 64324.6 |
233 | 2022-08-29 12:33:01 | perchance | 4 | 165329 | 254 | 11.283 | 14652.9 |
232 | 2022-07-21 10:08:38 | perchance | 1 | 81242 | 1 | 1.263 | 64324.6 |
231 | 2022-06-16 06:19:22 | perchance | 1 | 81242 | 1 | 1.250 | 64993.6 |
230 | 2022-03-16 13:35:14 | perchance | 1 | 81242 | 1 | 1.453 | 55913.3 |
229 | 2022-02-04 14:55:15 | perchance | 1 | 81242 | 1 | 1.360 | 59736.8 |
228 | 2022-01-10 17:15:29 | perchance | 1 | 81242 | 1 | 1.343 | 60492.9 |
227 | 2021-10-30 14:07:31 | perchance | 1 | 81242 | 1 | 1.283 | 63321.9 |
226 | 2021-10-29 12:45:20 | perchance | 1 | 81242 | 1 | 1.393 | 58321.6 |
225 | 2021-10-27 21:12:52 | perchance | 1 | 81242 | 1 | 1.326 | 61268.5 |
224 | 2021-10-11 23:05:25 | perchance | 1 | 81242 | 1 | 1.490 | 54524.8 |
223 | 2021-09-19 12:39:20 | perchance | 1 | 81242 | 1 | 2.810 | 28911.7 |
222 | 2021-09-18 18:42:59 | perchance | 1 | 81242 | 1 | 1.373 | 59171.2 |
221 | 2021-09-11 20:06:14 | perchance | 1 | 81242 | 1 | 1.376 | 59042.2 |
220 | 2021-07-10 13:29:21 | perchance | 1 | 81242 | 1 | 1.330 | 61084.2 |
219 | 2021-05-08 04:21:56 | perchance | 2 | 121436 | 3 | 7.753 | 15663.1 |
218 | 2021-04-21 05:21:35 | perchance | 3 | 148641 | 34 | 6.440 | 23080.9 |
217 | 2021-04-06 17:44:38 | perchance | 1 | 81242 | 1 | 1.543 | 52652.0 |
216 | 2021-04-06 13:39:00 | perchance | 2 | 121436 | 3 | 3.970 | 30588.4 |
215 | 2021-04-02 13:45:01 | perchance | 1 | 81242 | 1 | 1.420 | 57212.7 |
214 | 2021-01-21 19:50:44 | perchance | 2 | 121436 | 3 | 3.280 | 37023.2 |
213 | 2021-01-05 23:10:30 | perchance | 3 | 148641 | 34 | 6.720 | 22119.2 |
212 | 2021-01-03 09:20:05 | perchance | 1 | 81242 | 1 | 1.283 | 63321.9 |
211 | 2020-12-10 13:16:07 | perchance | 1 | 81242 | 1 | 1.313 | 61875.1 |
210 | 2020-11-13 17:49:58 | perchance | 3 | 148641 | 34 | 6.643 | 22375.6 |
209 | 2020-11-09 09:05:28 | perchance | 3 | 148641 | 34 | 6.453 | 23034.4 |
208 | 2020-11-05 23:44:27 | perchance | 2 | 121436 | 3 | 3.563 | 34082.5 |
207 | 2020-11-01 12:41:32 | perchance | 2 | 121436 | 3 | 3.733 | 32530.4 |
206 | 2020-10-31 18:44:41 | perchance | 1 | 81242 | 1 | 1.343 | 60492.9 |
205 | 2020-10-17 10:50:42 | perchance | 1 | 81242 | 1 | 2.653 | 30622.7 |
204 | 2020-09-24 17:09:03 | perchance | 1 | 81242 | 1 | 2.610 | 31127.2 |
203 | 2020-08-28 05:43:36 | perchance | 1 | 81242 | 1 | 1.343 | 60492.9 |
202 | 2020-08-24 17:08:15 | perchance | 1 | 81242 | 1 | 1.280 | 63470.3 |
201 | 2020-08-06 11:47:04 | perchance | 1 | 81242 | 1 | 1.343 | 60492.9 |
200 | 2020-05-14 07:32:19 | perchance | 1 | 81242 | 1 | 1.360 | 59736.8 |
199 | 2020-03-26 23:29:01 | perchance | 4 | 165329 | 254 | 12.093 | 13671.5 |
198 | 2020-03-26 20:17:48 | perchance | 4 | 165329 | 254 | 13.220 | 12506.0 |
197 | 2020-03-26 06:39:27 | perchance | 4 | 165329 | 254 | 13.516 | 12232.1 |
196 | 2020-03-23 14:42:30 | perchance | 1 | 81242 | 1 | 2.686 | 30246.5 |
195 | 2020-02-27 06:21:19 | perchance | 1 | 81242 | 1 | 2.296 | 35384.1 |
194 | 2020-02-27 03:00:14 | perchance | 1 | 81242 | 1 | 2.703 | 30056.2 |
193 | 2020-02-26 13:12:56 | perchance | 1 | 81242 | 1 | 1.533 | 52995.4 |
192 | 2020-02-24 08:25:25 | perchance | 4 | 165329 | 254 | 13.483 | 12262.0 |
191 | 2020-02-20 12:39:05 | perchance | 4 | 165329 | 254 | 19.390 | 8526.5 |
190 | 2020-02-20 00:43:52 | perchance | 4 | 165329 | 254 | 15.296 | 10808.6 |
189 | 2020-02-11 01:59:26 | perchance | 4 | 165329 | 254 | 19.033 | 8686.4 |
188 | 2020-02-10 18:02:40 | perchance | 4 | 165329 | 254 | 15.986 | 10342.1 |
187 | 2020-02-05 19:30:46 | perchance | 1 | 81242 | 1 | 1.533 | 52995.4 |
186 | 2020-02-05 12:20:00 | perchance | 1 | 81242 | 1 | 1.686 | 48186.2 |
185 | 2020-02-05 12:12:08 | perchance | 4 | 165329 | 254 | 19.970 | 8278.9 |
184 | 2020-02-05 12:09:29 | perchance | 3 | 148641 | 34 | 10.373 | 14329.6 |
183 | 2020-02-05 12:05:34 | perchance | 2 | 121436 | 3 | 5.763 | 21071.7 |
182 | 2020-02-05 07:04:02 | perchance | 1 | 81242 | 1 | 3.123 | 26014.1 |
181 | 2020-01-30 08:09:32 | perchance | 1 | 81242 | 1 | 2.640 | 30773.5 |
180 | 2020-01-28 06:36:05 | perchance | 1 | 81242 | 1 | 2.156 | 37681.8 |
179 | 2020-01-25 15:26:33 | perchance | 4 | 165329 | 254 | 14.593 | 11329.3 |
178 | 2020-01-25 10:37:21 | perchance | 4 | 165329 | 254 | 27.033 | 6115.8 |
177 | 2020-01-25 05:36:01 | perchance | 4 | 165329 | 254 | 15.640 | 10570.9 |
176 | 2020-01-24 17:59:42 | perchance | 1 | 81242 | 1 | 2.920 | 27822.6 |
175 | 2020-01-20 00:27:42 | perchance | 1 | 81242 | 1 | 1.483 | 54782.2 |
174 | 2020-01-16 14:07:10 | perchance | 4 | 165329 | 254 | 14.546 | 11365.9 |