History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"penlight"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
226 | 2024-04-27 17:49:41 | penlight | 3 | 146162 | 56 | 7.550 | 19359.2 |
225 | 2024-04-18 23:57:41 | penlight | 3 | 146162 | 56 | 19.876 | 7353.7 |
224 | 2024-04-12 20:42:04 | penlight | 3 | 146162 | 56 | 12.076 | 12103.5 |
223 | 2024-04-11 11:38:22 | penlight | 2 | 121059 | 9 | 3.483 | 34757.1 |
222 | 2024-04-11 11:35:43 | penlight | 3 | 146162 | 56 | 8.420 | 17358.9 |
221 | 2024-04-10 06:27:36 | penlight | 3 | 146162 | 56 | 8.970 | 16294.5 |
220 | 2024-04-10 06:27:37 | penlight | 2 | 121059 | 9 | 4.140 | 29241.3 |
219 | 2024-04-10 06:27:34 | penlight | 1 | 82945 | 2 | 1.593 | 52068.4 |
218 | 2024-04-06 11:37:45 | penlight | 4 | 161609 | 385 | 50.720 | 3186.3 |
217 | 2024-04-05 20:29:14 | penlight | 1 | 82945 | 2 | 3.156 | 26281.7 |
216 | 2024-04-05 17:50:47 | penlight | 4 | 161609 | 385 | 14.313 | 11291.1 |
215 | 2024-04-03 15:59:27 | penlight | 4 | 161609 | 385 | 39.063 | 4137.1 |
214 | 2024-04-01 10:55:57 | penlight | 4 | 161609 | 385 | 45.626 | 3542.0 |
213 | 2024-04-01 10:55:48 | penlight | 4 | 161609 | 385 | 40.723 | 3968.5 |
212 | 2024-04-01 10:56:04 | penlight | 2 | 121059 | 9 | 12.686 | 9542.7 |
211 | 2024-04-01 10:56:00 | penlight | 3 | 146162 | 56 | 13.563 | 10776.5 |
210 | 2024-04-01 10:55:50 | penlight | 2 | 121059 | 9 | 11.173 | 10835.0 |
209 | 2024-04-01 10:55:49 | penlight | 3 | 146162 | 56 | 9.346 | 15639.0 |
208 | 2024-04-01 10:55:46 | penlight | 1 | 82945 | 2 | 4.920 | 16858.7 |
207 | 2024-04-01 10:55:37 | penlight | 1 | 82945 | 2 | 4.906 | 16906.8 |
206 | 2024-03-30 09:26:48 | penlight | 1 | 82945 | 2 | 3.313 | 25036.2 |
205 | 2024-03-29 12:01:35 | penlight | 1 | 82945 | 2 | 2.623 | 31622.2 |
204 | 2024-03-28 18:04:19 | penlight | 1 | 82945 | 2 | 3.236 | 25632.0 |
203 | 2024-03-12 05:00:19 | penlight | 2 | 121059 | 9 | 4.516 | 26806.7 |
202 | 2024-03-12 04:59:51 | penlight | 3 | 146162 | 56 | 8.643 | 16911.0 |
201 | 2024-03-08 03:41:01 | penlight | 3 | 146162 | 56 | 7.360 | 19859.0 |
200 | 2024-03-08 03:41:03 | penlight | 2 | 121059 | 9 | 3.920 | 30882.4 |
199 | 2024-03-08 03:41:00 | penlight | 1 | 82945 | 2 | 1.330 | 62364.7 |
198 | 2024-03-07 07:32:39 | penlight | 4 | 161609 | 385 | 27.343 | 5910.4 |
197 | 2024-03-06 14:11:48 | penlight | 1 | 82945 | 2 | 5.126 | 16181.2 |
196 | 2024-03-06 13:53:07 | penlight | 4 | 161609 | 385 | 23.596 | 6849.0 |
195 | 2024-03-02 06:41:02 | penlight | 2 | 121059 | 9 | 4.143 | 29220.1 |
194 | 2024-02-29 19:56:16 | penlight | 2 | 121059 | 9 | 3.920 | 30882.4 |
193 | 2024-02-29 19:55:09 | penlight | 3 | 146162 | 56 | 7.763 | 18828.0 |
192 | 2024-02-29 16:32:27 | penlight | 4 | 161609 | 385 | 18.376 | 8794.6 |
191 | 2024-02-29 14:57:42 | penlight | 1 | 82945 | 2 | 1.500 | 55296.7 |
190 | 2024-02-29 14:48:02 | penlight | 2 | 121059 | 9 | 3.686 | 32842.9 |
189 | 2024-02-29 14:47:15 | penlight | 4 | 161609 | 385 | 17.390 | 9293.2 |
188 | 2024-02-29 14:47:18 | penlight | 3 | 146162 | 56 | 7.843 | 18636.0 |
187 | 2024-02-29 05:49:20 | penlight | 1 | 82945 | 2 | 1.516 | 54713.1 |
186 | 2024-02-28 05:04:14 | penlight | 1 | 82945 | 2 | 1.686 | 49196.3 |
185 | 2024-02-21 01:15:21 | penlight | 1 | 82945 | 2 | 1.970 | 42104.1 |
184 | 2024-02-06 21:11:34 | penlight | 2 | 121059 | 9 | 8.236 | 14698.8 |
183 | 2024-02-06 21:11:02 | penlight | 3 | 146162 | 56 | 7.050 | 20732.2 |
182 | 2024-02-04 10:58:10 | penlight | 4 | 161609 | 385 | 16.640 | 9712.1 |
181 | 2024-02-04 02:51:19 | penlight | 4 | 161609 | 385 | 14.046 | 11505.7 |
180 | 2024-01-30 09:06:19 | penlight | 1 | 82945 | 2 | 1.453 | 57085.3 |
179 | 2024-01-29 00:08:04 | penlight | 4 | 161609 | 385 | 13.283 | 12166.6 |
178 | 2024-01-27 08:23:45 | penlight | 3 | 146162 | 56 | 7.640 | 19131.2 |
177 | 2024-01-27 06:14:43 | penlight | 4 | 161609 | 385 | 20.876 | 7741.4 |
176 | 2024-01-27 06:14:47 | penlight | 2 | 121059 | 9 | 3.966 | 30524.2 |
175 | 2024-01-27 06:11:07 | penlight | 4 | 161609 | 385 | 16.063 | 10060.9 |
174 | 2024-01-27 06:10:11 | penlight | 2 | 121059 | 9 | 3.843 | 31501.2 |
173 | 2024-01-27 06:08:31 | penlight | 3 | 146162 | 56 | 8.233 | 17753.2 |
172 | 2024-01-27 06:02:43 | penlight | 3 | 146162 | 56 | 8.280 | 17652.4 |
171 | 2024-01-19 04:29:08 | penlight | 1 | 82945 | 2 | 1.326 | 62552.8 |
170 | 2024-01-09 16:16:36 | penlight | 1 | 82945 | 2 | 1.423 | 58288.8 |
169 | 2023-12-30 20:00:16 | penlight | 3 | 146162 | 56 | 6.580 | 22213.1 |
168 | 2023-12-20 14:41:59 | penlight | 1 | 82945 | 2 | 1.343 | 61761.0 |
167 | 2023-12-05 18:04:38 | penlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
166 | 2023-11-24 22:49:33 | penlight | 4 | 161609 | 385 | 16.796 | 9621.9 |
165 | 2023-11-21 12:13:56 | penlight | 4 | 161609 | 385 | 13.766 | 11739.7 |
164 | 2023-11-20 07:38:53 | penlight | 4 | 161609 | 385 | 11.486 | 14070.1 |
163 | 2023-11-08 21:30:47 | penlight | 4 | 161609 | 385 | 11.313 | 14285.2 |
162 | 2023-11-05 23:26:30 | penlight | 1 | 82945 | 2 | 1.500 | 55296.7 |
161 | 2023-11-01 00:17:20 | penlight | 1 | 82945 | 2 | 1.406 | 58993.6 |
160 | 2023-10-14 09:25:41 | penlight | 3 | 146162 | 56 | 7.046 | 20744.0 |
159 | 2023-10-12 10:06:40 | penlight | 4 | 161609 | 385 | 11.940 | 13535.1 |
158 | 2023-10-12 10:06:33 | penlight | 2 | 121059 | 9 | 3.720 | 32542.7 |
157 | 2023-10-10 13:07:58 | penlight | 1 | 82945 | 2 | 1.486 | 55817.6 |
156 | 2023-10-04 14:56:21 | penlight | 3 | 146162 | 56 | 6.923 | 21112.5 |
155 | 2023-09-20 17:37:27 | penlight | 1 | 82945 | 2 | 1.343 | 61761.0 |
154 | 2023-09-14 16:12:46 | penlight | 1 | 82945 | 2 | 1.483 | 55930.5 |
153 | 2023-09-14 16:06:01 | penlight | 4 | 161609 | 385 | 19.826 | 8151.4 |
152 | 2023-09-14 16:06:05 | penlight | 3 | 146162 | 56 | 9.393 | 15560.7 |
151 | 2023-08-27 17:34:36 | penlight | 1 | 82945 | 2 | 1.313 | 63172.1 |
150 | 2023-08-13 07:05:01 | penlight | 4 | 161609 | 385 | 10.936 | 14777.7 |
149 | 2023-07-16 06:56:48 | penlight | 3 | 146162 | 56 | 7.453 | 19611.2 |
148 | 2023-07-14 13:18:49 | penlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
147 | 2023-04-27 18:55:22 | penlight | 4 | 161609 | 385 | 14.796 | 10922.5 |
146 | 2023-04-22 02:55:44 | penlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
145 | 2023-04-19 22:37:01 | penlight | 1 | 82945 | 2 | 1.453 | 57085.3 |
144 | 2023-04-17 23:56:00 | penlight | 1 | 82945 | 2 | 1.280 | 64800.8 |
143 | 2023-03-30 22:16:22 | penlight | 3 | 146162 | 56 | 6.890 | 21213.6 |
142 | 2023-03-23 20:31:50 | penlight | 1 | 82945 | 2 | 1.410 | 58826.2 |
141 | 2023-02-09 16:04:03 | penlight | 1 | 82945 | 2 | 1.453 | 57085.3 |
140 | 2023-02-02 11:28:56 | penlight | 4 | 161609 | 385 | 12.626 | 12799.7 |
139 | 2022-12-28 01:28:20 | penlight | 3 | 146162 | 56 | 6.826 | 21412.5 |
138 | 2022-12-08 22:45:45 | penlight | 1 | 82945 | 2 | 1.263 | 65673.0 |
137 | 2022-12-06 00:41:42 | penlight | 1 | 82945 | 2 | 1.266 | 65517.4 |
136 | 2022-11-14 13:29:44 | penlight | 4 | 161609 | 385 | 13.390 | 12069.4 |
135 | 2022-08-29 20:11:46 | penlight | 3 | 146162 | 56 | 6.373 | 22934.6 |
134 | 2022-08-07 17:59:47 | penlight | 1 | 82945 | 2 | 1.313 | 63172.1 |
133 | 2022-07-29 13:27:05 | penlight | 1 | 82945 | 2 | 1.283 | 64649.3 |
132 | 2022-07-26 03:24:48 | penlight | 1 | 82945 | 2 | 1.423 | 58288.8 |
131 | 2022-06-16 01:31:51 | penlight | 4 | 161609 | 385 | 11.173 | 14464.2 |
130 | 2022-04-11 13:04:51 | penlight | 1 | 82945 | 2 | 1.296 | 64000.8 |
129 | 2022-03-28 04:26:14 | penlight | 1 | 82945 | 2 | 1.500 | 55296.7 |
128 | 2021-11-30 17:45:22 | penlight | 1 | 82945 | 2 | 1.530 | 54212.4 |
127 | 2021-08-24 06:17:13 | penlight | 1 | 82945 | 2 | 1.296 | 64000.8 |