History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trollops"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
263 | 2024-04-22 16:46:17 | trollops | 1 | 82945 | 3 | 1.546 | 53651.4 |
262 | 2024-04-07 17:12:13 | trollops | 1 | 82945 | 3 | 2.483 | 33405.2 |
261 | 2024-04-01 05:55:30 | trollops | 1 | 82945 | 3 | 1.670 | 49667.7 |
260 | 2024-03-31 12:49:49 | trollops | 1 | 82945 | 3 | 3.173 | 26140.9 |
259 | 2024-03-31 00:39:32 | trollops | 1 | 82945 | 3 | 2.030 | 40859.6 |
258 | 2024-03-11 06:44:13 | trollops | 4 | 161609 | 692 | 11.000 | 14691.7 |
257 | 2024-03-08 00:52:19 | trollops | 2 | 121059 | 13 | 5.126 | 23616.7 |
256 | 2024-03-08 00:51:52 | trollops | 1 | 82945 | 3 | 6.513 | 12735.3 |
255 | 2024-03-06 10:15:39 | trollops | 4 | 161609 | 692 | 26.313 | 6141.8 |
254 | 2024-03-04 03:48:42 | trollops | 3 | 146162 | 73 | 9.826 | 14875.0 |
253 | 2024-03-03 23:53:24 | trollops | 3 | 146162 | 73 | 17.813 | 8205.4 |
252 | 2024-03-02 15:49:51 | trollops | 4 | 161609 | 692 | 28.860 | 5599.8 |
251 | 2024-03-02 05:02:39 | trollops | 4 | 161609 | 692 | 21.613 | 7477.4 |
250 | 2024-03-02 05:02:25 | trollops | 3 | 146162 | 73 | 13.186 | 11084.6 |
249 | 2024-03-02 05:02:26 | trollops | 2 | 121059 | 13 | 4.390 | 27576.1 |
248 | 2024-03-01 17:17:49 | trollops | 2 | 121059 | 13 | 5.780 | 20944.5 |
247 | 2024-02-29 18:56:10 | trollops | 1 | 82945 | 3 | 1.516 | 54713.1 |
246 | 2024-02-29 02:31:27 | trollops | 1 | 82945 | 3 | 2.936 | 28251.0 |
245 | 2024-02-29 02:31:24 | trollops | 2 | 121059 | 13 | 5.623 | 21529.3 |
244 | 2024-02-29 02:31:19 | trollops | 3 | 146162 | 73 | 8.860 | 16496.8 |
243 | 2024-02-29 02:31:07 | trollops | 1 | 82945 | 3 | 1.516 | 54713.1 |
242 | 2024-02-04 13:24:54 | trollops | 4 | 161609 | 692 | 31.890 | 5067.7 |
241 | 2024-02-03 06:01:15 | trollops | 1 | 82945 | 3 | 4.173 | 19876.6 |
240 | 2024-01-31 23:46:20 | trollops | 2 | 121059 | 13 | 3.670 | 32986.1 |
239 | 2024-01-31 23:46:08 | trollops | 3 | 146162 | 73 | 7.843 | 18636.0 |
238 | 2024-01-31 10:29:03 | trollops | 4 | 161609 | 692 | 13.580 | 11900.5 |
237 | 2024-01-31 00:30:47 | trollops | 4 | 161609 | 692 | 18.936 | 8534.5 |
236 | 2024-01-30 20:39:39 | trollops | 4 | 161609 | 692 | 17.610 | 9177.1 |
235 | 2024-01-30 20:39:07 | trollops | 3 | 146162 | 73 | 12.440 | 11749.4 |
234 | 2024-01-30 20:39:11 | trollops | 2 | 121059 | 13 | 3.876 | 31233.0 |
233 | 2024-01-30 20:39:03 | trollops | 1 | 82945 | 3 | 2.780 | 29836.3 |
232 | 2024-01-02 12:28:43 | trollops | 1 | 82945 | 3 | 1.330 | 62364.7 |
231 | 2023-12-19 04:49:17 | trollops | 1 | 82945 | 3 | 1.390 | 59672.7 |
230 | 2023-12-02 18:57:13 | trollops | 1 | 82945 | 3 | 1.470 | 56425.2 |
229 | 2023-11-20 16:17:06 | trollops | 1 | 82945 | 3 | 1.326 | 62552.8 |
228 | 2023-11-02 03:48:27 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
227 | 2023-10-24 13:35:01 | trollops | 1 | 82945 | 3 | 1.263 | 65673.0 |
226 | 2023-10-19 05:51:44 | trollops | 1 | 82945 | 3 | 1.390 | 59672.7 |
225 | 2023-10-15 01:10:48 | trollops | 1 | 82945 | 3 | 1.250 | 66356.0 |
224 | 2023-09-14 03:39:25 | trollops | 1 | 82945 | 3 | 1.390 | 59672.7 |
223 | 2023-08-20 03:32:52 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
222 | 2023-05-23 02:05:31 | trollops | 1 | 82945 | 3 | 1.263 | 65673.0 |
221 | 2023-05-17 21:14:52 | trollops | 1 | 82945 | 3 | 1.263 | 65673.0 |
220 | 2023-04-24 12:51:18 | trollops | 1 | 82945 | 3 | 1.360 | 60989.0 |
219 | 2023-01-02 10:50:20 | trollops | 1 | 82945 | 3 | 1.360 | 60989.0 |
218 | 2022-12-31 20:13:27 | trollops | 1 | 82945 | 3 | 1.423 | 58288.8 |
217 | 2022-09-21 19:38:41 | trollops | 1 | 82945 | 3 | 1.280 | 64800.8 |
216 | 2022-07-28 08:08:16 | trollops | 1 | 82945 | 3 | 1.250 | 66356.0 |
215 | 2022-06-06 10:27:21 | trollops | 1 | 82945 | 3 | 1.420 | 58412.0 |
214 | 2022-05-06 16:01:02 | trollops | 1 | 82945 | 3 | 1.546 | 53651.4 |
213 | 2022-02-20 17:16:25 | trollops | 1 | 82945 | 3 | 1.283 | 64649.3 |
212 | 2021-10-01 02:31:08 | trollops | 1 | 82945 | 3 | 1.263 | 65673.0 |
211 | 2021-09-27 09:20:39 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
210 | 2021-09-27 01:29:42 | trollops | 1 | 82945 | 3 | 1.250 | 66356.0 |
209 | 2021-09-22 00:08:13 | trollops | 1 | 82945 | 3 | 1.406 | 58993.6 |
208 | 2021-07-31 04:37:09 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
207 | 2021-07-07 20:37:08 | trollops | 1 | 82945 | 3 | 1.470 | 56425.2 |
206 | 2021-06-18 12:33:32 | trollops | 1 | 82945 | 3 | 1.500 | 55296.7 |
205 | 2021-06-15 08:37:22 | trollops | 1 | 82945 | 3 | 1.406 | 58993.6 |
204 | 2021-05-15 23:17:21 | trollops | 1 | 82945 | 3 | 1.423 | 58288.8 |
203 | 2021-05-08 04:48:52 | trollops | 4 | 161609 | 692 | 11.186 | 14447.4 |
202 | 2021-03-25 20:07:53 | trollops | 1 | 82945 | 3 | 1.470 | 56425.2 |
201 | 2021-03-15 17:51:52 | trollops | 1 | 82945 | 3 | 1.390 | 59672.7 |
200 | 2021-01-15 16:14:06 | trollops | 4 | 161609 | 692 | 11.406 | 14168.8 |
199 | 2021-01-09 02:23:56 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
198 | 2020-11-21 09:51:18 | trollops | 1 | 82945 | 3 | 1.266 | 65517.4 |
197 | 2020-10-16 17:41:36 | trollops | 1 | 82945 | 3 | 2.686 | 30880.5 |
196 | 2020-10-16 14:40:50 | trollops | 1 | 82945 | 3 | 1.393 | 59544.1 |
195 | 2020-10-15 22:12:16 | trollops | 4 | 161609 | 692 | 11.266 | 14344.8 |
194 | 2020-09-06 09:42:17 | trollops | 1 | 82945 | 3 | 1.360 | 60989.0 |
193 | 2020-07-23 08:17:30 | trollops | 1 | 82945 | 3 | 1.420 | 58412.0 |
192 | 2020-07-15 11:18:57 | trollops | 1 | 82945 | 3 | 1.453 | 57085.3 |
191 | 2020-04-15 01:51:10 | trollops | 1 | 82945 | 3 | 1.343 | 61761.0 |
190 | 2020-03-29 17:56:59 | trollops | 1 | 82945 | 3 | 1.436 | 57761.1 |
189 | 2020-03-21 23:40:18 | trollops | 1 | 82945 | 3 | 1.423 | 58288.8 |
188 | 2020-02-28 23:25:48 | trollops | 1 | 82945 | 3 | 1.640 | 50576.2 |
187 | 2020-02-28 22:18:56 | trollops | 1 | 82945 | 3 | 1.390 | 59672.7 |
186 | 2020-02-26 05:41:30 | trollops | 1 | 82945 | 3 | 1.500 | 55296.7 |
185 | 2020-02-23 00:33:58 | trollops | 4 | 161609 | 692 | 28.956 | 5581.2 |
184 | 2020-02-20 07:35:08 | trollops | 1 | 82945 | 3 | 3.170 | 26165.6 |
183 | 2020-02-19 21:06:22 | trollops | 1 | 82945 | 3 | 1.546 | 53651.4 |
182 | 2020-02-19 07:02:38 | trollops | 3 | 146162 | 73 | 8.656 | 16885.6 |
181 | 2020-02-18 16:11:04 | trollops | 3 | 146162 | 73 | 20.250 | 7217.9 |
180 | 2020-02-15 02:12:04 | trollops | 4 | 161609 | 692 | 45.456 | 3555.3 |
179 | 2020-02-08 00:33:52 | trollops | 1 | 82945 | 3 | 3.076 | 26965.2 |
178 | 2020-02-04 05:01:35 | trollops | 1 | 82945 | 3 | 2.203 | 37650.9 |
177 | 2020-02-04 01:12:41 | trollops | 4 | 161609 | 692 | 11.893 | 13588.6 |
176 | 2020-02-04 00:16:34 | trollops | 1 | 82945 | 3 | 1.550 | 53512.9 |
175 | 2020-02-01 02:26:08 | trollops | 4 | 161609 | 692 | 10.906 | 14818.4 |
174 | 2020-01-27 03:51:50 | trollops | 1 | 82945 | 3 | 2.783 | 29804.2 |
173 | 2020-01-25 13:34:58 | trollops | 1 | 82945 | 3 | 1.953 | 42470.6 |
172 | 2020-01-25 05:56:14 | trollops | 4 | 161609 | 692 | 25.906 | 6238.3 |
171 | 2020-01-24 23:01:40 | trollops | 4 | 161609 | 692 | 45.706 | 3535.8 |
170 | 2020-01-24 16:25:31 | trollops | 4 | 161609 | 692 | 25.640 | 6303.0 |
169 | 2020-01-24 13:19:40 | trollops | 4 | 161609 | 692 | 17.250 | 9368.6 |
168 | 2020-01-24 11:55:02 | trollops | 4 | 161609 | 692 | 29.613 | 5457.4 |
167 | 2020-01-24 06:09:18 | trollops | 4 | 161609 | 692 | 23.596 | 6849.0 |
166 | 2020-01-24 06:07:12 | trollops | 2 | 121059 | 13 | 3.733 | 32429.4 |
165 | 2020-01-24 06:07:03 | trollops | 3 | 146162 | 73 | 8.143 | 17949.4 |
164 | 2020-01-24 01:00:37 | trollops | 1 | 82945 | 3 | 1.783 | 46519.9 |