History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"unopened"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
226 | 2024-05-23 00:03:03 | unopened | 3 | 146162 | 122 | 16.190 | 9027.9 |
225 | 2024-05-18 11:50:03 | unopened | 3 | 146162 | 122 | 13.640 | 10715.7 |
224 | 2024-05-17 09:20:51 | unopened | 1 | 82945 | 1 | 3.376 | 24569.0 |
223 | 2024-05-15 00:19:31 | unopened | 3 | 146162 | 122 | 19.346 | 7555.2 |
222 | 2024-05-14 03:19:07 | unopened | 3 | 146162 | 122 | 8.110 | 18022.4 |
221 | 2024-05-11 06:55:08 | unopened | 3 | 146162 | 122 | 19.550 | 7476.3 |
220 | 2024-05-10 05:14:30 | unopened | 1 | 82945 | 1 | 2.110 | 39310.4 |
219 | 2024-05-09 15:38:50 | unopened | 3 | 146162 | 122 | 22.910 | 6379.8 |
218 | 2024-05-09 05:45:16 | unopened | 3 | 146162 | 122 | 14.733 | 9920.7 |
217 | 2024-05-09 05:45:15 | unopened | 1 | 82945 | 1 | 1.466 | 56579.1 |
216 | 2024-05-07 23:31:04 | unopened | 2 | 121059 | 7 | 12.863 | 9411.4 |
215 | 2024-05-07 12:39:34 | unopened | 1 | 82945 | 1 | 4.873 | 17021.3 |
214 | 2024-05-07 12:39:22 | unopened | 2 | 121059 | 7 | 11.656 | 10386.0 |
213 | 2024-04-16 11:32:40 | unopened | 2 | 121059 | 7 | 4.563 | 26530.6 |
212 | 2024-04-16 11:32:12 | unopened | 1 | 82945 | 1 | 1.393 | 59544.1 |
211 | 2024-04-13 14:39:21 | unopened | 2 | 121059 | 7 | 5.106 | 23709.2 |
210 | 2024-04-13 09:45:45 | unopened | 2 | 121059 | 7 | 3.640 | 33258.0 |
209 | 2024-04-13 09:45:41 | unopened | 1 | 82945 | 1 | 1.360 | 60989.0 |
208 | 2024-04-13 09:45:29 | unopened | 3 | 146162 | 122 | 7.330 | 19940.2 |
207 | 2024-04-09 18:02:18 | unopened | 3 | 146162 | 122 | 15.233 | 9595.1 |
206 | 2024-04-09 11:27:21 | unopened | 3 | 146162 | 122 | 26.580 | 5498.9 |
205 | 2024-04-09 02:17:16 | unopened | 3 | 146162 | 122 | 7.236 | 20199.3 |
204 | 2024-04-09 02:17:11 | unopened | 1 | 82945 | 1 | 1.530 | 54212.4 |
203 | 2024-03-20 23:20:42 | unopened | 3 | 146162 | 122 | 25.063 | 5831.8 |
202 | 2024-03-18 21:39:28 | unopened | 3 | 146162 | 122 | 13.906 | 10510.7 |
201 | 2024-03-13 16:23:12 | unopened | 2 | 121059 | 7 | 7.970 | 15189.3 |
200 | 2024-03-13 16:23:10 | unopened | 2 | 121059 | 7 | 4.156 | 29128.7 |
199 | 2024-03-13 16:23:05 | unopened | 1 | 82945 | 1 | 2.923 | 28376.7 |
198 | 2024-03-13 16:22:50 | unopened | 3 | 146162 | 122 | 7.436 | 19656.0 |
197 | 2024-03-09 20:54:43 | unopened | 3 | 146162 | 122 | 22.936 | 6372.6 |
196 | 2024-03-09 06:12:14 | unopened | 3 | 146162 | 122 | 15.326 | 9536.9 |
195 | 2024-03-09 00:32:24 | unopened | 3 | 146162 | 122 | 18.953 | 7711.8 |
194 | 2024-03-09 00:32:13 | unopened | 2 | 121059 | 7 | 5.890 | 20553.3 |
193 | 2024-03-08 23:23:24 | unopened | 1 | 82945 | 1 | 1.516 | 54713.1 |
192 | 2024-03-08 04:18:11 | unopened | 1 | 82945 | 1 | 4.703 | 17636.6 |
191 | 2024-03-01 15:43:03 | unopened | 1 | 82945 | 1 | 4.673 | 17749.8 |
190 | 2024-02-06 16:26:30 | unopened | 3 | 146162 | 122 | 11.263 | 12977.2 |
189 | 2024-02-06 14:38:55 | unopened | 2 | 121059 | 7 | 3.703 | 32692.1 |
188 | 2024-02-06 14:38:43 | unopened | 3 | 146162 | 122 | 8.970 | 16294.5 |
187 | 2024-02-06 04:14:26 | unopened | 3 | 146162 | 122 | 7.423 | 19690.4 |
186 | 2024-02-06 04:14:22 | unopened | 2 | 121059 | 7 | 5.063 | 23910.5 |
185 | 2024-02-06 04:14:18 | unopened | 1 | 82945 | 1 | 1.546 | 53651.4 |
184 | 2024-02-05 11:48:42 | unopened | 1 | 82945 | 1 | 4.593 | 18059.0 |
183 | 2024-02-05 11:47:58 | unopened | 1 | 82945 | 1 | 3.220 | 25759.3 |
182 | 2024-01-10 13:38:46 | unopened | 1 | 82945 | 1 | 1.263 | 65673.0 |
181 | 2024-01-06 14:38:37 | unopened | 1 | 82945 | 1 | 1.376 | 60279.8 |
180 | 2023-11-28 14:53:42 | unopened | 1 | 82945 | 1 | 1.283 | 64649.3 |
179 | 2023-11-15 03:32:50 | unopened | 1 | 82945 | 1 | 1.373 | 60411.5 |
178 | 2023-09-14 08:58:07 | unopened | 1 | 82945 | 1 | 1.216 | 68211.3 |
177 | 2023-08-24 22:49:14 | unopened | 1 | 82945 | 1 | 1.220 | 67987.7 |
176 | 2023-07-05 04:53:50 | unopened | 1 | 82945 | 1 | 1.373 | 60411.5 |
175 | 2023-04-23 00:13:51 | unopened | 1 | 82945 | 1 | 1.343 | 61761.0 |
174 | 2023-04-11 18:25:49 | unopened | 1 | 82945 | 1 | 1.216 | 68211.3 |
173 | 2023-02-04 15:50:25 | unopened | 1 | 82945 | 1 | 1.203 | 68948.5 |
172 | 2022-12-16 04:01:42 | unopened | 1 | 82945 | 1 | 1.296 | 64000.8 |
171 | 2022-12-03 14:43:05 | unopened | 1 | 82945 | 1 | 1.390 | 59672.7 |
170 | 2022-07-30 10:40:31 | unopened | 1 | 82945 | 1 | 1.233 | 67270.9 |
169 | 2022-03-11 20:40:45 | unopened | 1 | 82945 | 1 | 1.250 | 66356.0 |
168 | 2021-11-11 10:28:25 | unopened | 1 | 82945 | 1 | 1.376 | 60279.8 |
167 | 2021-07-18 15:19:46 | unopened | 1 | 82945 | 1 | 1.406 | 58993.6 |
166 | 2021-04-26 17:46:31 | unopened | 1 | 82945 | 1 | 1.516 | 54713.1 |
165 | 2021-04-15 22:42:38 | unopened | 1 | 82945 | 1 | 1.546 | 53651.4 |
164 | 2021-04-12 02:32:52 | unopened | 1 | 82945 | 1 | 1.250 | 66356.0 |
163 | 2021-03-26 22:46:28 | unopened | 1 | 82945 | 1 | 1.360 | 60989.0 |
162 | 2021-02-22 08:56:30 | unopened | 1 | 82945 | 1 | 1.423 | 58288.8 |
161 | 2020-12-18 17:11:25 | unopened | 1 | 82945 | 1 | 1.283 | 64649.3 |
160 | 2020-11-17 13:20:44 | unopened | 1 | 82945 | 1 | 1.296 | 64000.8 |
159 | 2020-11-09 18:43:25 | unopened | 1 | 82945 | 1 | 1.266 | 65517.4 |
158 | 2020-11-06 16:36:06 | unopened | 1 | 82945 | 1 | 1.453 | 57085.3 |
157 | 2020-08-28 23:10:14 | unopened | 1 | 82945 | 1 | 1.376 | 60279.8 |
156 | 2020-08-25 18:36:48 | unopened | 1 | 82945 | 1 | 1.266 | 65517.4 |
155 | 2020-05-18 04:43:13 | unopened | 1 | 82945 | 1 | 1.263 | 65673.0 |
154 | 2020-03-23 10:12:06 | unopened | 1 | 82945 | 1 | 1.440 | 57600.7 |
153 | 2020-03-06 01:27:29 | unopened | 1 | 82945 | 1 | 1.420 | 58412.0 |
152 | 2020-02-27 22:08:55 | unopened | 3 | 146162 | 122 | 8.750 | 16704.2 |
151 | 2020-02-27 18:08:20 | unopened | 3 | 146162 | 122 | 14.236 | 10267.1 |
150 | 2020-02-23 16:40:54 | unopened | 1 | 82945 | 1 | 1.610 | 51518.6 |
149 | 2020-02-22 21:34:51 | unopened | 1 | 82945 | 1 | 1.530 | 54212.4 |
148 | 2020-02-20 14:14:17 | unopened | 3 | 146162 | 122 | 19.613 | 7452.3 |
147 | 2020-02-19 03:04:36 | unopened | 1 | 82945 | 1 | 1.360 | 60989.0 |
146 | 2020-02-17 11:48:16 | unopened | 3 | 146162 | 122 | 14.123 | 10349.2 |
145 | 2020-02-15 07:52:58 | unopened | 1 | 82945 | 1 | 1.250 | 66356.0 |
144 | 2020-02-15 01:55:51 | unopened | 1 | 82945 | 1 | 1.546 | 53651.4 |
143 | 2020-02-04 15:06:23 | unopened | 1 | 82945 | 1 | 1.563 | 53067.8 |
142 | 2020-02-01 13:46:13 | unopened | 1 | 82945 | 1 | 3.220 | 25759.3 |
141 | 2020-01-29 01:03:06 | unopened | 1 | 82945 | 1 | 1.330 | 62364.7 |
140 | 2020-01-23 08:39:36 | unopened | 1 | 82945 | 1 | 1.390 | 59672.7 |
139 | 2020-01-22 13:05:09 | unopened | 3 | 146162 | 122 | 7.313 | 19986.6 |
138 | 2020-01-22 07:53:11 | unopened | 1 | 82945 | 1 | 1.546 | 53651.4 |
137 | 2020-01-21 19:18:25 | unopened | 3 | 146162 | 122 | 19.673 | 7429.6 |
136 | 2020-01-20 08:19:01 | unopened | 3 | 146162 | 122 | 11.923 | 12258.8 |
135 | 2020-01-19 22:38:16 | unopened | 3 | 146162 | 122 | 8.190 | 17846.4 |
134 | 2020-01-19 22:37:10 | unopened | 2 | 121059 | 7 | 3.436 | 35232.5 |
133 | 2020-01-19 15:20:02 | unopened | 1 | 82945 | 1 | 1.940 | 42755.2 |
132 | 2020-01-13 18:14:56 | unopened | 1 | 82945 | 1 | 1.343 | 61761.0 |
131 | 2020-01-03 01:44:03 | unopened | 1 | 82945 | 1 | 1.466 | 56579.1 |
130 | 2020-01-01 16:52:23 | unopened | 1 | 82945 | 1 | 1.576 | 52630.1 |
129 | 2019-11-15 10:21:51 | unopened | 1 | 82945 | 1 | 1.373 | 60411.5 |
128 | 2019-08-14 01:37:22 | unopened | 1 | 82945 | 1 | 1.386 | 59844.9 |
127 | 2019-07-25 02:24:34 | unopened | 1 | 82945 | 1 | 1.240 | 66891.1 |