History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"agreement"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
243 | 2024-05-17 17:47:04 | agreement | 4 | 165329 | 262 | 39.583 | 4176.8 |
242 | 2024-05-12 09:19:52 | agreement | 3 | 148641 | 25 | 18.936 | 7849.7 |
241 | 2024-05-12 09:19:52 | agreement | 2 | 121436 | 2 | 9.610 | 12636.4 |
240 | 2024-05-12 09:05:48 | agreement | 1 | 81242 | 2 | 3.250 | 24997.5 |
239 | 2024-05-09 23:10:49 | agreement | 1 | 81242 | 2 | 1.453 | 55913.3 |
238 | 2024-05-07 21:52:48 | agreement | 3 | 148641 | 25 | 19.796 | 7508.6 |
237 | 2024-05-07 03:29:09 | agreement | 1 | 81242 | 2 | 1.546 | 52549.8 |
236 | 2024-05-03 17:13:13 | agreement | 4 | 165329 | 262 | 15.250 | 10841.2 |
235 | 2024-05-03 13:36:55 | agreement | 4 | 165329 | 262 | 14.720 | 11231.6 |
234 | 2024-05-03 12:03:23 | agreement | 1 | 81242 | 2 | 1.343 | 60492.9 |
233 | 2024-05-03 10:29:02 | agreement | 3 | 148641 | 25 | 9.843 | 15101.2 |
232 | 2024-05-03 10:22:00 | agreement | 4 | 165329 | 262 | 26.906 | 6144.7 |
231 | 2024-05-03 10:22:00 | agreement | 2 | 121436 | 2 | 7.966 | 15244.3 |
230 | 2024-05-03 09:49:19 | agreement | 1 | 81242 | 2 | 1.530 | 53099.3 |
229 | 2024-04-07 21:43:45 | agreement | 3 | 148641 | 25 | 28.673 | 5184.0 |
228 | 2024-04-06 11:32:22 | agreement | 3 | 148641 | 25 | 19.686 | 7550.6 |
227 | 2024-04-06 11:32:27 | agreement | 2 | 121436 | 2 | 5.610 | 21646.3 |
226 | 2024-04-06 11:31:59 | agreement | 1 | 81242 | 2 | 3.250 | 24997.5 |
225 | 2024-04-02 19:46:03 | agreement | 4 | 165329 | 262 | 36.046 | 4586.6 |
224 | 2024-04-01 12:19:03 | agreement | 4 | 165329 | 262 | 36.533 | 4525.5 |
223 | 2024-04-01 12:19:03 | agreement | 3 | 148641 | 25 | 23.500 | 6325.1 |
222 | 2024-04-01 12:19:03 | agreement | 2 | 121436 | 2 | 9.766 | 12434.6 |
221 | 2024-04-01 12:15:11 | agreement | 1 | 81242 | 2 | 1.376 | 59042.2 |
220 | 2024-03-27 13:14:00 | agreement | 2 | 121436 | 2 | 10.453 | 11617.3 |
219 | 2024-03-27 05:45:45 | agreement | 1 | 81242 | 2 | 1.513 | 53696.0 |
218 | 2024-03-17 16:21:15 | agreement | 1 | 81242 | 2 | 1.593 | 50999.4 |
217 | 2024-03-14 10:13:07 | agreement | 3 | 148641 | 25 | 7.550 | 19687.5 |
216 | 2024-03-06 14:45:53 | agreement | 1 | 81242 | 2 | 1.376 | 59042.2 |
215 | 2024-03-05 04:13:28 | agreement | 4 | 165329 | 262 | 15.580 | 10611.6 |
214 | 2024-03-04 10:07:45 | agreement | 3 | 148641 | 25 | 10.563 | 14071.9 |
213 | 2024-03-03 16:19:45 | agreement | 3 | 148641 | 25 | 26.233 | 5666.2 |
212 | 2024-03-03 06:12:33 | agreement | 4 | 165329 | 262 | 20.813 | 7943.5 |
211 | 2024-03-02 08:14:56 | agreement | 4 | 165329 | 262 | 14.830 | 11148.3 |
210 | 2024-03-02 08:14:59 | agreement | 3 | 148641 | 25 | 11.720 | 12682.7 |
209 | 2024-03-02 08:14:57 | agreement | 2 | 121436 | 2 | 3.953 | 30720.0 |
208 | 2024-03-02 08:14:29 | agreement | 1 | 81242 | 2 | 4.513 | 18001.8 |
207 | 2024-02-28 09:33:15 | agreement | 1 | 81242 | 2 | 4.703 | 17274.5 |
206 | 2024-02-03 20:18:02 | agreement | 1 | 81242 | 2 | 1.330 | 61084.2 |
205 | 2024-01-29 20:30:51 | agreement | 1 | 81242 | 2 | 1.470 | 55266.7 |
204 | 2024-01-27 05:31:31 | agreement | 1 | 81242 | 2 | 1.186 | 68500.8 |
203 | 2023-12-03 14:12:30 | agreement | 1 | 81242 | 2 | 1.233 | 65889.7 |
202 | 2023-11-27 23:19:20 | agreement | 3 | 148641 | 25 | 6.390 | 23261.5 |
201 | 2023-11-22 22:10:13 | agreement | 1 | 81242 | 2 | 1.220 | 66591.8 |
200 | 2023-10-24 04:26:39 | agreement | 1 | 81242 | 2 | 1.420 | 57212.7 |
199 | 2023-09-09 16:20:16 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
198 | 2023-08-28 11:00:58 | agreement | 3 | 148641 | 25 | 6.890 | 21573.4 |
197 | 2023-07-30 19:56:42 | agreement | 1 | 81242 | 2 | 1.373 | 59171.2 |
196 | 2023-06-13 16:54:33 | agreement | 1 | 81242 | 2 | 1.220 | 66591.8 |
195 | 2023-05-14 16:01:17 | agreement | 3 | 148641 | 25 | 6.266 | 23721.8 |
194 | 2023-04-11 11:08:06 | agreement | 1 | 81242 | 2 | 1.330 | 61084.2 |
193 | 2023-03-30 14:40:48 | agreement | 1 | 81242 | 2 | 1.373 | 59171.2 |
192 | 2023-02-20 23:55:47 | agreement | 3 | 148641 | 25 | 7.156 | 20771.5 |
191 | 2023-01-13 00:35:23 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
190 | 2022-12-22 11:38:57 | agreement | 1 | 81242 | 2 | 1.466 | 55417.5 |
189 | 2022-12-04 14:16:07 | agreement | 3 | 148641 | 25 | 5.936 | 25040.6 |
188 | 2022-10-20 08:33:48 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
187 | 2022-08-22 07:31:18 | agreement | 1 | 81242 | 2 | 1.373 | 59171.2 |
186 | 2022-08-18 18:26:27 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
185 | 2022-07-14 20:42:09 | agreement | 3 | 148641 | 25 | 6.296 | 23608.8 |
184 | 2022-06-10 16:57:51 | agreement | 1 | 81242 | 2 | 1.220 | 66591.8 |
183 | 2022-04-14 19:42:21 | agreement | 1 | 81242 | 2 | 1.263 | 64324.6 |
182 | 2022-03-10 21:37:07 | agreement | 3 | 148641 | 25 | 7.500 | 19818.8 |
181 | 2022-03-10 21:36:58 | agreement | 3 | 148641 | 25 | 7.080 | 20994.5 |
180 | 2022-03-07 14:00:52 | agreement | 1 | 81242 | 2 | 1.500 | 54161.3 |
179 | 2021-12-17 10:00:12 | agreement | 1 | 81242 | 2 | 1.423 | 57092.1 |
178 | 2021-09-06 22:28:35 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
177 | 2021-06-16 09:40:58 | agreement | 1 | 81242 | 2 | 1.233 | 65889.7 |
176 | 2021-06-05 22:30:10 | agreement | 1 | 81242 | 2 | 1.390 | 58447.5 |
175 | 2021-06-02 18:20:10 | agreement | 1 | 81242 | 2 | 1.516 | 53589.7 |
174 | 2021-05-23 21:50:26 | agreement | 2 | 121436 | 2 | 3.156 | 38477.8 |
173 | 2021-05-01 03:01:05 | agreement | 1 | 81242 | 2 | 1.470 | 55266.7 |
172 | 2021-04-26 22:28:50 | agreement | 2 | 121436 | 2 | 3.653 | 33242.8 |
171 | 2021-03-27 00:47:13 | agreement | 1 | 81242 | 2 | 1.233 | 65889.7 |
170 | 2021-02-28 04:46:22 | agreement | 1 | 81242 | 2 | 1.343 | 60492.9 |
169 | 2021-02-05 06:07:59 | agreement | 2 | 121436 | 2 | 3.250 | 37364.9 |
168 | 2021-01-30 11:21:01 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
167 | 2021-01-10 08:19:22 | agreement | 1 | 81242 | 2 | 2.403 | 33808.6 |
166 | 2020-11-23 15:06:28 | agreement | 1 | 81242 | 2 | 1.203 | 67532.8 |
165 | 2020-11-16 15:41:52 | agreement | 1 | 81242 | 2 | 1.280 | 63470.3 |
164 | 2020-11-16 14:31:39 | agreement | 1 | 81242 | 2 | 1.250 | 64993.6 |
163 | 2020-08-12 17:27:28 | agreement | 1 | 81242 | 2 | 1.596 | 50903.5 |
162 | 2020-05-08 14:50:18 | agreement | 1 | 81242 | 2 | 1.546 | 52549.8 |
161 | 2020-03-22 09:01:43 | agreement | 1 | 81242 | 2 | 1.440 | 56418.1 |
160 | 2020-02-29 00:35:16 | agreement | 1 | 81242 | 2 | 1.486 | 54671.6 |
159 | 2020-02-27 03:45:14 | agreement | 1 | 81242 | 2 | 1.766 | 46003.4 |
158 | 2020-02-25 06:11:58 | agreement | 1 | 81242 | 2 | 1.326 | 61268.5 |
157 | 2020-02-11 05:45:15 | agreement | 1 | 81242 | 2 | 1.530 | 53099.3 |
156 | 2020-02-06 01:03:09 | agreement | 1 | 81242 | 2 | 1.516 | 53589.7 |
155 | 2020-02-05 21:39:01 | agreement | 1 | 81242 | 2 | 4.596 | 17676.7 |
154 | 2020-01-31 16:44:14 | agreement | 1 | 81242 | 2 | 1.263 | 64324.6 |
153 | 2020-01-30 19:48:52 | agreement | 1 | 81242 | 2 | 2.983 | 27235.0 |
152 | 2020-01-27 18:36:49 | agreement | 1 | 81242 | 2 | 3.736 | 21745.7 |
151 | 2020-01-20 17:34:15 | agreement | 1 | 81242 | 2 | 1.970 | 41239.6 |
150 | 2020-01-16 18:45:39 | agreement | 1 | 81242 | 2 | 1.500 | 54161.3 |
149 | 2020-01-07 20:08:52 | agreement | 1 | 81242 | 2 | 1.360 | 59736.8 |
148 | 2020-01-03 07:08:34 | agreement | 1 | 81242 | 2 | 1.470 | 55266.7 |
147 | 2019-11-02 06:05:31 | agreement | 1 | 81242 | 2 | 1.233 | 65889.7 |
146 | 2019-08-01 02:34:19 | agreement | 1 | 81242 | 2 | 1.343 | 60492.9 |
145 | 2019-06-02 19:19:52 | agreement | 1 | 81242 | 2 | 1.220 | 66591.8 |
144 | 2019-05-28 11:36:20 | agreement | 1 | 81242 | 2 | 1.353 | 60045.8 |