History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"fusiliers"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
249 | 2024-04-26 05:44:59 | fusiliers | 1 | 81242 | 3 | 1.360 | 59736.8 |
248 | 2024-04-26 00:04:25 | fusiliers | 4 | 165329 | 688 | 33.376 | 4953.5 |
247 | 2024-04-25 13:27:42 | fusiliers | 1 | 81242 | 3 | 1.643 | 49447.4 |
246 | 2024-04-25 02:52:29 | fusiliers | 4 | 165329 | 688 | 51.033 | 3239.6 |
245 | 2024-04-21 22:44:42 | fusiliers | 4 | 165329 | 688 | 39.940 | 4139.4 |
244 | 2024-04-11 03:31:09 | fusiliers | 1 | 81242 | 3 | 2.983 | 27235.0 |
243 | 2024-04-09 23:37:06 | fusiliers | 4 | 165329 | 688 | 42.706 | 3871.3 |
242 | 2024-04-09 23:37:08 | fusiliers | 3 | 148641 | 52 | 14.436 | 10296.6 |
241 | 2024-04-09 23:37:09 | fusiliers | 2 | 121436 | 4 | 10.310 | 11778.5 |
240 | 2024-04-09 22:59:40 | fusiliers | 1 | 81242 | 3 | 1.936 | 41963.8 |
239 | 2024-03-28 14:51:57 | fusiliers | 1 | 81242 | 3 | 1.250 | 64993.6 |
238 | 2024-03-22 02:54:07 | fusiliers | 3 | 148641 | 52 | 15.750 | 9437.5 |
237 | 2024-03-22 02:54:09 | fusiliers | 2 | 121436 | 4 | 6.283 | 19327.7 |
236 | 2024-03-22 02:33:05 | fusiliers | 1 | 81242 | 3 | 1.440 | 56418.1 |
235 | 2024-03-22 01:20:35 | fusiliers | 1 | 81242 | 3 | 2.940 | 27633.3 |
234 | 2024-03-21 20:36:46 | fusiliers | 4 | 165329 | 688 | 20.953 | 7890.5 |
233 | 2024-03-19 13:50:43 | fusiliers | 4 | 165329 | 688 | 36.770 | 4496.3 |
232 | 2024-03-18 23:12:03 | fusiliers | 3 | 148641 | 52 | 15.906 | 9345.0 |
231 | 2024-03-18 23:05:07 | fusiliers | 2 | 121436 | 4 | 16.800 | 7228.3 |
230 | 2024-03-18 21:38:54 | fusiliers | 1 | 81242 | 3 | 3.140 | 25873.2 |
229 | 2024-03-18 10:13:58 | fusiliers | 4 | 165329 | 688 | 38.660 | 4276.5 |
228 | 2024-03-18 10:14:01 | fusiliers | 3 | 148641 | 52 | 15.346 | 9686.0 |
227 | 2024-03-18 10:13:59 | fusiliers | 2 | 121436 | 4 | 10.033 | 12103.7 |
226 | 2024-03-18 08:09:06 | fusiliers | 1 | 81242 | 3 | 1.313 | 61875.1 |
225 | 2024-03-10 18:04:24 | fusiliers | 1 | 81242 | 3 | 2.436 | 33350.6 |
224 | 2024-03-08 22:00:12 | fusiliers | 1 | 81242 | 3 | 1.390 | 58447.5 |
223 | 2024-02-27 06:47:18 | fusiliers | 1 | 81242 | 3 | 1.470 | 55266.7 |
222 | 2024-02-19 01:19:32 | fusiliers | 1 | 81242 | 3 | 1.513 | 53696.0 |
221 | 2024-02-19 01:01:13 | fusiliers | 4 | 165329 | 688 | 35.660 | 4636.3 |
220 | 2024-02-18 05:13:23 | fusiliers | 4 | 165329 | 688 | 26.203 | 6309.5 |
219 | 2024-02-17 20:14:26 | fusiliers | 3 | 148641 | 52 | 7.110 | 20905.9 |
218 | 2024-02-17 20:14:26 | fusiliers | 2 | 121436 | 4 | 3.420 | 35507.6 |
217 | 2024-02-17 20:13:53 | fusiliers | 4 | 165329 | 688 | 13.500 | 12246.6 |
216 | 2024-02-17 17:59:42 | fusiliers | 2 | 121436 | 4 | 3.296 | 36843.4 |
215 | 2024-02-17 14:32:06 | fusiliers | 1 | 81242 | 3 | 1.250 | 64993.6 |
214 | 2024-02-14 21:22:56 | fusiliers | 1 | 81242 | 3 | 1.423 | 57092.1 |
213 | 2024-02-01 12:32:24 | fusiliers | 1 | 81242 | 3 | 1.190 | 68270.6 |
212 | 2024-01-25 17:38:47 | fusiliers | 1 | 81242 | 3 | 2.686 | 30246.5 |
211 | 2024-01-20 00:20:46 | fusiliers | 2 | 121436 | 4 | 3.030 | 40077.9 |
210 | 2024-01-15 12:07:18 | fusiliers | 1 | 81242 | 3 | 1.296 | 62686.7 |
209 | 2024-01-14 18:27:12 | fusiliers | 1 | 81242 | 3 | 1.390 | 58447.5 |
208 | 2024-01-11 03:58:09 | fusiliers | 1 | 81242 | 3 | 1.250 | 64993.6 |
207 | 2023-12-21 09:00:56 | fusiliers | 4 | 165329 | 688 | 10.703 | 15447.0 |
206 | 2023-12-18 08:15:42 | fusiliers | 1 | 81242 | 3 | 1.203 | 67532.8 |
205 | 2023-11-15 20:43:41 | fusiliers | 2 | 121436 | 4 | 3.220 | 37713.0 |
204 | 2023-11-09 04:34:16 | fusiliers | 1 | 81242 | 3 | 1.190 | 68270.6 |
203 | 2023-10-14 00:39:05 | fusiliers | 1 | 81242 | 3 | 1.373 | 59171.2 |
202 | 2023-10-06 04:31:46 | fusiliers | 1 | 81242 | 3 | 1.593 | 50999.4 |
201 | 2023-10-04 21:34:21 | fusiliers | 4 | 165329 | 688 | 15.220 | 10862.6 |
200 | 2023-10-04 13:39:45 | fusiliers | 1 | 81242 | 3 | 1.406 | 57782.4 |
199 | 2023-10-01 06:09:44 | fusiliers | 4 | 165329 | 688 | 12.673 | 13045.8 |
198 | 2023-09-30 01:40:38 | fusiliers | 1 | 81242 | 3 | 1.220 | 66591.8 |
197 | 2023-09-28 04:10:24 | fusiliers | 4 | 165329 | 688 | 12.750 | 12967.0 |
196 | 2023-09-20 13:40:18 | fusiliers | 4 | 165329 | 688 | 10.250 | 16129.7 |
195 | 2023-09-08 08:27:15 | fusiliers | 1 | 81242 | 3 | 1.216 | 66810.9 |
194 | 2023-08-17 18:28:47 | fusiliers | 2 | 121436 | 4 | 3.000 | 40478.7 |
193 | 2023-06-20 14:24:48 | fusiliers | 4 | 165329 | 688 | 11.500 | 14376.4 |
192 | 2023-05-11 22:03:00 | fusiliers | 1 | 81242 | 3 | 1.173 | 69260.0 |
191 | 2023-04-30 14:16:48 | fusiliers | 2 | 121436 | 4 | 2.970 | 40887.5 |
190 | 2023-04-30 01:29:47 | fusiliers | 1 | 81242 | 3 | 1.186 | 68500.8 |
189 | 2023-03-18 16:06:44 | fusiliers | 4 | 165329 | 688 | 11.970 | 13811.9 |
188 | 2023-02-18 23:26:48 | fusiliers | 1 | 81242 | 3 | 1.170 | 69437.6 |
187 | 2023-02-04 09:19:47 | fusiliers | 2 | 121436 | 4 | 3.500 | 34696.0 |
186 | 2023-01-15 00:03:07 | fusiliers | 1 | 81242 | 3 | 1.250 | 64993.6 |
185 | 2022-12-20 19:34:28 | fusiliers | 4 | 165329 | 688 | 10.046 | 16457.2 |
184 | 2022-12-15 20:38:34 | fusiliers | 1 | 81242 | 3 | 1.173 | 69260.0 |
183 | 2022-12-10 14:26:24 | fusiliers | 4 | 165329 | 688 | 12.610 | 13110.9 |
182 | 2022-12-03 13:11:44 | fusiliers | 4 | 165329 | 688 | 12.233 | 13515.0 |
181 | 2022-11-17 07:41:22 | fusiliers | 2 | 121436 | 4 | 2.953 | 41122.9 |
180 | 2022-11-15 23:32:16 | fusiliers | 4 | 165329 | 688 | 12.156 | 13600.6 |
179 | 2022-11-14 12:25:49 | fusiliers | 3 | 148641 | 52 | 6.860 | 21667.8 |
178 | 2022-11-09 08:35:33 | fusiliers | 4 | 165329 | 688 | 11.236 | 14714.2 |
177 | 2022-11-08 13:33:04 | fusiliers | 4 | 165329 | 688 | 11.656 | 14184.0 |
176 | 2022-10-05 22:06:25 | fusiliers | 3 | 148641 | 52 | 6.016 | 24707.6 |
175 | 2022-10-01 14:20:07 | fusiliers | 4 | 165329 | 688 | 10.420 | 15866.5 |
174 | 2022-09-29 16:17:13 | fusiliers | 3 | 148641 | 52 | 6.016 | 24707.6 |
173 | 2022-09-13 00:14:15 | fusiliers | 1 | 81242 | 3 | 1.173 | 69260.0 |
172 | 2022-09-10 03:33:26 | fusiliers | 4 | 165329 | 688 | 10.970 | 15071.0 |
171 | 2022-08-24 17:59:00 | fusiliers | 1 | 81242 | 3 | 1.186 | 68500.8 |
170 | 2022-08-22 09:26:26 | fusiliers | 1 | 81242 | 3 | 1.296 | 62686.7 |
169 | 2022-08-21 12:03:27 | fusiliers | 3 | 148641 | 52 | 6.423 | 23142.0 |
168 | 2022-08-13 15:20:25 | fusiliers | 4 | 165329 | 688 | 10.250 | 16129.7 |
167 | 2022-06-30 06:48:11 | fusiliers | 3 | 148641 | 52 | 5.940 | 25023.7 |
166 | 2022-06-20 21:20:48 | fusiliers | 2 | 121436 | 4 | 3.016 | 40263.9 |
165 | 2022-04-30 02:10:03 | fusiliers | 1 | 81242 | 3 | 1.186 | 68500.8 |
164 | 2022-04-08 06:35:44 | fusiliers | 1 | 81242 | 3 | 1.220 | 66591.8 |
163 | 2022-02-17 11:35:18 | fusiliers | 2 | 121436 | 4 | 3.236 | 37526.6 |
162 | 2022-01-22 18:08:10 | fusiliers | 1 | 81242 | 3 | 1.406 | 57782.4 |
161 | 2022-01-06 13:56:52 | fusiliers | 1 | 81242 | 3 | 1.546 | 52549.8 |
160 | 2021-12-21 10:39:08 | fusiliers | 1 | 81242 | 3 | 2.906 | 27956.6 |
159 | 2021-09-17 15:47:15 | fusiliers | 1 | 81242 | 3 | 1.373 | 59171.2 |
158 | 2021-06-14 06:24:55 | fusiliers | 1 | 81242 | 3 | 1.343 | 60492.9 |
157 | 2021-03-11 10:43:52 | fusiliers | 1 | 81242 | 3 | 1.216 | 66810.9 |
156 | 2020-12-04 04:36:22 | fusiliers | 1 | 81242 | 3 | 1.220 | 66591.8 |
155 | 2020-11-04 08:11:17 | fusiliers | 1 | 81242 | 3 | 1.296 | 62686.7 |
154 | 2020-09-16 21:52:51 | fusiliers | 1 | 81242 | 3 | 1.203 | 67532.8 |
153 | 2020-09-01 17:13:44 | fusiliers | 1 | 81242 | 3 | 1.233 | 65889.7 |
152 | 2020-08-21 10:02:25 | fusiliers | 1 | 81242 | 3 | 1.296 | 62686.7 |
151 | 2020-07-31 12:00:52 | fusiliers | 1 | 81242 | 3 | 1.343 | 60492.9 |
150 | 2020-05-21 20:53:50 | fusiliers | 1 | 81242 | 3 | 1.266 | 64172.2 |