History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"friends"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
245 | 2024-04-27 07:22:40 | friends | 1 | 69583 | 3 | 4.123 | 16876.8 |
244 | 2024-04-18 22:20:49 | friends | 3 | 134027 | 293 | 16.093 | 8328.3 |
243 | 2024-04-17 21:53:26 | friends | 3 | 134027 | 293 | 22.080 | 6070.1 |
242 | 2024-04-17 14:06:27 | friends | 3 | 134027 | 293 | 7.376 | 18170.7 |
241 | 2024-04-17 14:06:23 | friends | 2 | 107671 | 24 | 7.030 | 15315.9 |
240 | 2024-04-16 04:43:55 | friends | 2 | 107671 | 24 | 3.420 | 31482.7 |
239 | 2024-04-13 02:37:26 | friends | 1 | 69583 | 3 | 1.186 | 58670.3 |
238 | 2024-04-10 15:00:04 | friends | 1 | 69583 | 3 | 2.813 | 24736.2 |
237 | 2024-04-09 14:55:03 | friends | 2 | 107671 | 24 | 4.170 | 25820.4 |
236 | 2024-04-09 14:55:03 | friends | 1 | 69583 | 3 | 1.313 | 52995.4 |
235 | 2024-04-09 14:54:40 | friends | 3 | 134027 | 293 | 6.483 | 20673.6 |
234 | 2024-03-28 12:38:09 | friends | 1 | 69583 | 3 | 1.140 | 61037.7 |
233 | 2024-03-18 20:37:48 | friends | 3 | 134027 | 293 | 10.203 | 13136.0 |
232 | 2024-03-16 00:39:01 | friends | 3 | 134027 | 293 | 10.876 | 12323.2 |
231 | 2024-03-15 17:36:17 | friends | 2 | 107671 | 24 | 3.576 | 30109.3 |
230 | 2024-03-15 17:35:40 | friends | 3 | 134027 | 293 | 7.156 | 18729.3 |
229 | 2024-03-08 23:58:02 | friends | 2 | 107671 | 24 | 8.546 | 12599.0 |
228 | 2024-03-08 04:05:44 | friends | 3 | 134027 | 293 | 15.173 | 8833.3 |
227 | 2024-03-08 01:10:59 | friends | 2 | 107671 | 24 | 13.983 | 7700.1 |
226 | 2024-03-07 23:52:41 | friends | 3 | 134027 | 293 | 7.513 | 17839.3 |
225 | 2024-03-07 15:30:45 | friends | 3 | 134027 | 293 | 8.110 | 16526.1 |
224 | 2024-03-01 10:40:57 | friends | 1 | 69583 | 3 | 2.420 | 28753.3 |
223 | 2024-02-06 01:36:29 | friends | 2 | 107671 | 24 | 7.780 | 13839.5 |
222 | 2024-02-06 00:24:34 | friends | 3 | 134027 | 293 | 6.720 | 19944.5 |
221 | 2024-02-05 19:31:13 | friends | 2 | 107671 | 24 | 3.453 | 31181.9 |
220 | 2024-02-05 19:29:09 | friends | 3 | 134027 | 293 | 7.063 | 18975.9 |
219 | 2024-02-05 06:42:27 | friends | 3 | 134027 | 293 | 12.270 | 10923.1 |
218 | 2024-01-15 23:49:14 | friends | 3 | 134027 | 293 | 7.533 | 17792.0 |
217 | 2024-01-15 23:49:15 | friends | 2 | 107671 | 24 | 3.610 | 29825.8 |
216 | 2024-01-10 21:29:32 | friends | 3 | 134027 | 293 | 10.170 | 13178.7 |
215 | 2023-12-28 21:39:56 | friends | 1 | 69583 | 3 | 1.206 | 57697.3 |
214 | 2023-12-25 19:05:19 | friends | 1 | 69583 | 3 | 1.093 | 63662.4 |
213 | 2023-11-17 18:42:30 | friends | 1 | 69583 | 3 | 1.203 | 57841.2 |
212 | 2023-11-09 19:01:58 | friends | 1 | 69583 | 3 | 1.360 | 51164.0 |
211 | 2023-11-07 01:12:45 | friends | 1 | 69583 | 3 | 1.060 | 65644.3 |
210 | 2023-11-06 09:52:54 | friends | 1 | 69583 | 3 | 1.030 | 67556.3 |
209 | 2023-11-04 07:57:41 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
208 | 2023-10-31 14:13:53 | friends | 3 | 134027 | 293 | 8.110 | 16526.1 |
207 | 2023-10-20 01:34:11 | friends | 1 | 69583 | 3 | 2.470 | 28171.3 |
206 | 2023-10-20 01:24:12 | friends | 3 | 134027 | 293 | 7.420 | 18062.9 |
205 | 2023-10-19 09:09:32 | friends | 1 | 69583 | 3 | 1.080 | 64428.7 |
204 | 2023-10-14 18:48:09 | friends | 3 | 134027 | 293 | 6.436 | 20824.6 |
203 | 2023-10-09 09:46:37 | friends | 2 | 107671 | 24 | 3.436 | 31336.1 |
202 | 2023-10-09 09:46:30 | friends | 3 | 134027 | 293 | 7.076 | 18941.1 |
201 | 2023-10-03 15:38:40 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
200 | 2023-09-29 09:07:43 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
199 | 2023-09-27 23:53:24 | friends | 1 | 69583 | 3 | 1.030 | 67556.3 |
198 | 2023-08-14 09:09:51 | friends | 1 | 69583 | 3 | 1.190 | 58473.1 |
197 | 2023-07-14 23:10:37 | friends | 1 | 69583 | 3 | 1.220 | 57035.2 |
196 | 2023-07-11 08:11:36 | friends | 1 | 69583 | 3 | 1.190 | 58473.1 |
195 | 2023-05-12 19:31:31 | friends | 1 | 69583 | 3 | 1.156 | 60192.9 |
194 | 2023-03-23 15:54:14 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
193 | 2023-03-11 01:48:22 | friends | 1 | 69583 | 3 | 1.153 | 60349.5 |
192 | 2022-12-30 13:46:00 | friends | 1 | 69583 | 3 | 1.160 | 59985.3 |
191 | 2022-11-22 05:07:59 | friends | 1 | 69583 | 3 | 1.156 | 60192.9 |
190 | 2022-09-21 02:48:13 | friends | 1 | 69583 | 3 | 1.076 | 64668.2 |
189 | 2022-08-01 23:55:19 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
188 | 2022-04-30 23:13:32 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
187 | 2022-04-03 23:15:49 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
186 | 2022-01-22 04:08:23 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
185 | 2021-12-16 23:41:36 | friends | 1 | 69583 | 3 | 2.390 | 29114.2 |
184 | 2021-11-21 19:58:32 | friends | 1 | 69583 | 3 | 1.190 | 58473.1 |
183 | 2021-11-19 18:47:30 | friends | 1 | 69583 | 3 | 1.216 | 57222.9 |
182 | 2021-10-24 02:44:47 | friends | 1 | 69583 | 3 | 1.216 | 57222.9 |
181 | 2021-09-06 12:30:50 | friends | 1 | 69583 | 3 | 1.110 | 62687.4 |
180 | 2021-07-24 02:38:41 | friends | 1 | 69583 | 3 | 1.063 | 65459.1 |
179 | 2021-06-05 12:26:12 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
178 | 2021-05-14 03:03:40 | friends | 1 | 69583 | 3 | 1.186 | 58670.3 |
177 | 2021-03-16 21:34:57 | friends | 1 | 69583 | 3 | 1.030 | 67556.3 |
176 | 2021-03-03 08:03:00 | friends | 1 | 69583 | 3 | 1.156 | 60192.9 |
175 | 2021-02-19 21:24:31 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
174 | 2020-12-01 12:24:55 | friends | 1 | 69583 | 3 | 1.093 | 63662.4 |
173 | 2020-11-27 18:26:20 | friends | 1 | 69583 | 3 | 1.046 | 66522.9 |
172 | 2020-10-28 21:42:03 | friends | 1 | 69583 | 3 | 1.236 | 56296.9 |
171 | 2020-10-26 20:05:23 | friends | 1 | 69583 | 3 | 1.126 | 61796.6 |
170 | 2020-08-30 18:51:11 | friends | 1 | 69583 | 3 | 1.093 | 63662.4 |
169 | 2020-08-25 07:31:35 | friends | 1 | 69583 | 3 | 1.060 | 65644.3 |
168 | 2020-08-24 21:19:48 | friends | 1 | 69583 | 3 | 1.170 | 59472.6 |
167 | 2020-08-05 16:04:07 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
166 | 2020-05-20 09:36:18 | friends | 1 | 69583 | 3 | 1.063 | 65459.1 |
165 | 2020-04-21 22:05:56 | friends | 1 | 69583 | 3 | 1.033 | 67360.1 |
164 | 2020-03-25 14:58:44 | friends | 1 | 69583 | 3 | 1.280 | 54361.7 |
163 | 2020-03-25 02:04:05 | friends | 1 | 69583 | 3 | 2.016 | 34515.4 |
162 | 2020-03-21 08:34:39 | friends | 1 | 69583 | 3 | 1.233 | 56433.9 |
161 | 2020-02-23 10:44:53 | friends | 1 | 69583 | 3 | 1.546 | 45008.4 |
160 | 2020-02-19 06:33:09 | friends | 1 | 69583 | 3 | 1.373 | 50679.5 |
159 | 2020-02-17 10:14:56 | friends | 1 | 69583 | 3 | 1.060 | 65644.3 |
158 | 2020-02-15 13:36:03 | friends | 1 | 69583 | 3 | 3.373 | 20629.4 |
157 | 2020-02-12 05:39:23 | friends | 1 | 69583 | 3 | 1.173 | 59320.5 |
156 | 2020-02-10 15:34:15 | friends | 1 | 69583 | 3 | 2.343 | 29698.3 |
155 | 2020-02-02 22:40:30 | friends | 1 | 69583 | 3 | 1.313 | 52995.4 |
154 | 2020-01-30 13:52:02 | friends | 1 | 69583 | 3 | 1.216 | 57222.9 |
153 | 2020-01-26 11:41:21 | friends | 1 | 69583 | 3 | 2.656 | 26198.4 |
152 | 2020-01-20 20:15:54 | friends | 1 | 69583 | 3 | 1.313 | 52995.4 |
151 | 2020-01-20 16:05:19 | friends | 1 | 69583 | 3 | 1.373 | 50679.5 |
150 | 2020-01-15 09:50:57 | friends | 1 | 69583 | 3 | 1.233 | 56433.9 |
149 | 2020-01-15 08:17:48 | friends | 1 | 69583 | 3 | 2.670 | 26061.0 |
148 | 2020-01-11 09:30:51 | friends | 1 | 69583 | 3 | 1.906 | 36507.3 |
147 | 2020-01-11 08:40:38 | friends | 1 | 69583 | 3 | 1.216 | 57222.9 |
146 | 2020-01-02 05:39:27 | friends | 1 | 69583 | 3 | 1.263 | 55093.4 |