History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"reception"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
282 | 2024-04-27 20:29:03 | reception | 3 | 148641 | 98 | 16.843 | 8825.1 |
281 | 2024-04-27 17:51:13 | reception | 2 | 121436 | 18 | 4.000 | 30359.0 |
280 | 2024-04-18 20:42:23 | reception | 1 | 81242 | 3 | 1.440 | 56418.1 |
279 | 2024-04-17 16:12:30 | reception | 3 | 148641 | 98 | 10.376 | 14325.5 |
278 | 2024-04-16 15:08:31 | reception | 3 | 148641 | 98 | 6.923 | 21470.6 |
277 | 2024-04-11 09:13:29 | reception | 1 | 81242 | 3 | 1.436 | 56575.2 |
276 | 2024-04-10 05:20:26 | reception | 1 | 81242 | 3 | 2.076 | 39133.9 |
275 | 2024-04-08 15:39:57 | reception | 2 | 121436 | 18 | 4.030 | 30133.0 |
274 | 2024-03-30 21:05:58 | reception | 1 | 81242 | 3 | 1.593 | 50999.4 |
273 | 2024-03-28 06:26:59 | reception | 1 | 81242 | 3 | 1.483 | 54782.2 |
272 | 2024-03-07 13:21:42 | reception | 1 | 81242 | 3 | 1.296 | 62686.7 |
271 | 2024-02-27 19:29:16 | reception | 1 | 81242 | 3 | 1.310 | 62016.8 |
270 | 2024-02-13 14:01:01 | reception | 4 | 165329 | 518 | 43.846 | 3770.7 |
269 | 2024-02-08 15:40:42 | reception | 4 | 165329 | 518 | 29.423 | 5619.0 |
268 | 2024-02-07 23:54:18 | reception | 3 | 148641 | 98 | 11.016 | 13493.2 |
267 | 2024-02-07 19:08:27 | reception | 3 | 148641 | 98 | 51.190 | 2903.7 |
266 | 2024-02-07 19:08:20 | reception | 4 | 165329 | 518 | 27.300 | 6056.0 |
265 | 2024-02-07 19:08:33 | reception | 2 | 121436 | 18 | 8.576 | 14160.0 |
264 | 2024-02-07 13:37:03 | reception | 1 | 81242 | 3 | 3.153 | 25766.6 |
263 | 2024-01-31 04:44:03 | reception | 1 | 81242 | 3 | 1.483 | 54782.2 |
262 | 2024-01-28 16:16:28 | reception | 1 | 81242 | 3 | 1.233 | 65889.7 |
261 | 2024-01-09 05:56:46 | reception | 1 | 81242 | 3 | 1.360 | 59736.8 |
260 | 2023-12-23 19:07:41 | reception | 1 | 81242 | 3 | 1.283 | 63321.9 |
259 | 2023-12-15 19:05:33 | reception | 3 | 148641 | 98 | 7.936 | 18730.0 |
258 | 2023-12-10 06:14:51 | reception | 2 | 121436 | 18 | 3.813 | 31847.9 |
257 | 2023-11-23 16:21:15 | reception | 4 | 165329 | 518 | 13.500 | 12246.6 |
256 | 2023-11-23 16:21:17 | reception | 3 | 148641 | 98 | 8.796 | 16898.7 |
255 | 2023-11-23 16:21:09 | reception | 2 | 121436 | 18 | 3.326 | 36511.1 |
254 | 2023-11-09 06:38:16 | reception | 1 | 81242 | 3 | 1.360 | 59736.8 |
253 | 2023-11-03 05:09:41 | reception | 1 | 81242 | 3 | 1.263 | 64324.6 |
252 | 2023-10-13 07:58:13 | reception | 1 | 81242 | 3 | 1.313 | 61875.1 |
251 | 2023-10-09 19:33:27 | reception | 1 | 81242 | 3 | 1.456 | 55798.1 |
250 | 2023-10-04 02:33:36 | reception | 1 | 81242 | 3 | 1.296 | 62686.7 |
249 | 2023-09-14 04:01:01 | reception | 3 | 148641 | 98 | 8.046 | 18473.9 |
248 | 2023-09-08 07:07:37 | reception | 2 | 121436 | 18 | 3.656 | 33215.5 |
247 | 2023-08-25 19:35:42 | reception | 1 | 81242 | 3 | 1.266 | 64172.2 |
246 | 2023-06-19 14:08:00 | reception | 1 | 81242 | 3 | 1.483 | 54782.2 |
245 | 2023-06-05 10:08:07 | reception | 3 | 148641 | 98 | 6.626 | 22433.0 |
244 | 2023-05-31 04:19:18 | reception | 1 | 81242 | 3 | 1.233 | 65889.7 |
243 | 2023-05-23 05:54:01 | reception | 2 | 121436 | 18 | 3.156 | 38477.8 |
242 | 2023-03-24 22:30:30 | reception | 1 | 81242 | 3 | 1.390 | 58447.5 |
241 | 2023-03-08 23:55:21 | reception | 3 | 148641 | 98 | 6.186 | 24028.6 |
240 | 2023-03-01 11:38:50 | reception | 2 | 121436 | 18 | 3.440 | 35301.2 |
239 | 2023-02-21 18:05:56 | reception | 1 | 81242 | 3 | 1.266 | 64172.2 |
238 | 2023-01-09 07:00:43 | reception | 1 | 81242 | 3 | 1.250 | 64993.6 |
237 | 2022-12-14 06:35:19 | reception | 3 | 148641 | 98 | 7.190 | 20673.3 |
236 | 2022-12-08 23:38:49 | reception | 2 | 121436 | 18 | 3.126 | 38847.1 |
235 | 2022-10-28 14:29:01 | reception | 1 | 81242 | 3 | 1.233 | 65889.7 |
234 | 2022-10-19 02:53:01 | reception | 1 | 81242 | 3 | 1.266 | 64172.2 |
233 | 2022-07-31 23:23:46 | reception | 3 | 148641 | 98 | 6.860 | 21667.8 |
232 | 2022-07-15 18:43:21 | reception | 2 | 121436 | 18 | 4.046 | 30013.8 |
231 | 2022-07-05 06:59:09 | reception | 1 | 81242 | 3 | 1.313 | 61875.1 |
230 | 2022-06-09 02:56:07 | reception | 1 | 81242 | 3 | 1.313 | 61875.1 |
229 | 2022-03-11 07:02:17 | reception | 2 | 121436 | 18 | 3.893 | 31193.4 |
228 | 2022-03-11 03:17:36 | reception | 1 | 81242 | 3 | 1.860 | 43678.5 |
227 | 2022-02-16 18:20:20 | reception | 1 | 81242 | 3 | 1.266 | 64172.2 |
226 | 2021-12-22 20:23:48 | reception | 1 | 81242 | 3 | 1.593 | 50999.4 |
225 | 2021-12-22 04:24:58 | reception | 1 | 81242 | 3 | 1.563 | 51978.2 |
224 | 2021-11-24 02:46:02 | reception | 1 | 81242 | 3 | 3.936 | 20640.8 |
223 | 2021-11-15 04:06:31 | reception | 1 | 81242 | 3 | 1.343 | 60492.9 |
222 | 2021-08-14 11:14:45 | reception | 1 | 81242 | 3 | 1.296 | 62686.7 |
221 | 2021-05-10 05:36:51 | reception | 1 | 81242 | 3 | 1.516 | 53589.7 |
220 | 2021-05-06 20:03:40 | reception | 1 | 81242 | 3 | 2.983 | 27235.0 |
219 | 2021-04-24 23:19:59 | reception | 1 | 81242 | 3 | 1.503 | 54053.2 |
218 | 2021-03-26 19:34:47 | reception | 1 | 81242 | 3 | 1.466 | 55417.5 |
217 | 2021-01-31 15:59:18 | reception | 1 | 81242 | 3 | 1.300 | 62493.8 |
216 | 2021-01-10 02:29:21 | reception | 1 | 81242 | 3 | 1.266 | 64172.2 |
215 | 2020-10-29 09:10:55 | reception | 1 | 81242 | 3 | 1.440 | 56418.1 |
214 | 2020-09-28 10:38:01 | reception | 1 | 81242 | 3 | 1.313 | 61875.1 |
213 | 2020-08-28 06:21:54 | reception | 1 | 81242 | 3 | 1.280 | 63470.3 |
212 | 2020-08-27 21:51:30 | reception | 1 | 81242 | 3 | 1.376 | 59042.2 |
211 | 2020-08-24 04:19:06 | reception | 1 | 81242 | 3 | 1.330 | 61084.2 |
210 | 2020-08-13 15:32:35 | reception | 1 | 81242 | 3 | 1.403 | 57905.9 |
209 | 2020-07-27 23:32:39 | reception | 1 | 81242 | 3 | 1.343 | 60492.9 |
208 | 2020-06-02 12:01:52 | reception | 1 | 81242 | 3 | 2.940 | 27633.3 |
207 | 2020-04-22 12:36:55 | reception | 1 | 81242 | 3 | 1.326 | 61268.5 |
206 | 2020-03-25 05:22:15 | reception | 1 | 81242 | 3 | 1.500 | 54161.3 |
205 | 2020-03-22 16:18:51 | reception | 1 | 81242 | 3 | 2.533 | 32073.4 |
204 | 2020-02-23 19:13:45 | reception | 1 | 81242 | 3 | 1.576 | 51549.5 |
203 | 2020-02-23 18:12:23 | reception | 1 | 81242 | 3 | 1.533 | 52995.4 |
202 | 2020-02-22 19:21:18 | reception | 1 | 81242 | 3 | 2.486 | 32679.8 |
201 | 2020-02-22 11:57:35 | reception | 1 | 81242 | 3 | 1.610 | 50460.9 |
200 | 2020-02-20 13:28:34 | reception | 1 | 81242 | 3 | 4.203 | 19329.5 |
199 | 2020-02-08 02:29:16 | reception | 1 | 81242 | 3 | 2.500 | 32496.8 |
198 | 2020-01-29 05:36:14 | reception | 1 | 81242 | 3 | 1.580 | 51419.0 |
197 | 2020-01-28 19:28:51 | reception | 1 | 81242 | 3 | 1.610 | 50460.9 |
196 | 2020-01-28 00:10:47 | reception | 1 | 81242 | 3 | 3.406 | 23852.6 |
195 | 2020-01-27 08:34:51 | reception | 1 | 81242 | 3 | 1.440 | 56418.1 |
194 | 2020-01-27 06:19:13 | reception | 1 | 81242 | 3 | 1.513 | 53696.0 |
193 | 2020-01-22 13:07:42 | reception | 1 | 81242 | 3 | 3.986 | 20381.8 |
192 | 2020-01-22 01:01:11 | reception | 1 | 81242 | 3 | 4.966 | 16359.6 |
191 | 2020-01-17 04:22:12 | reception | 1 | 81242 | 3 | 2.966 | 27391.1 |
190 | 2020-01-15 21:57:54 | reception | 1 | 81242 | 3 | 3.220 | 25230.4 |
189 | 2020-01-15 21:11:47 | reception | 1 | 81242 | 3 | 1.610 | 50460.9 |
188 | 2020-01-01 16:59:03 | reception | 1 | 81242 | 3 | 1.826 | 44491.8 |
187 | 2020-01-01 07:07:05 | reception | 1 | 81242 | 3 | 1.423 | 57092.1 |
186 | 2019-10-23 10:13:11 | reception | 1 | 81242 | 3 | 1.500 | 54161.3 |
185 | 2019-07-25 14:18:10 | reception | 1 | 81242 | 3 | 1.260 | 64477.8 |
184 | 2019-07-23 15:56:25 | reception | 1 | 81242 | 3 | 1.250 | 64993.6 |
183 | 2019-06-09 17:37:11 | reception | 1 | 81242 | 3 | 1.446 | 56184.0 |