History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"prefight"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
230 | 2024-04-30 12:08:59 | prefight | 1 | 82945 | 3 | 1.686 | 49196.3 |
229 | 2024-04-29 18:31:13 | prefight | 1 | 82945 | 3 | 1.580 | 52496.8 |
228 | 2024-04-28 15:39:28 | prefight | 1 | 82945 | 3 | 1.436 | 57761.1 |
227 | 2024-04-10 03:36:40 | prefight | 2 | 121059 | 10 | 10.000 | 12105.9 |
226 | 2024-04-10 03:36:32 | prefight | 1 | 82945 | 3 | 3.173 | 26140.9 |
225 | 2024-04-08 10:38:01 | prefight | 4 | 161609 | 472 | 18.890 | 8555.3 |
224 | 2024-04-07 14:35:16 | prefight | 4 | 161609 | 472 | 23.690 | 6821.8 |
223 | 2024-04-07 07:27:07 | prefight | 3 | 146162 | 68 | 22.016 | 6638.9 |
222 | 2024-04-06 11:44:57 | prefight | 4 | 161609 | 472 | 16.546 | 9767.3 |
221 | 2024-04-05 21:40:31 | prefight | 1 | 82945 | 3 | 2.000 | 41472.5 |
220 | 2024-04-05 21:33:27 | prefight | 3 | 146162 | 68 | 7.720 | 18932.9 |
219 | 2024-04-05 21:33:24 | prefight | 2 | 121059 | 10 | 4.173 | 29010.1 |
218 | 2024-04-05 12:49:47 | prefight | 4 | 161609 | 472 | 20.126 | 8029.9 |
217 | 2024-04-01 17:00:33 | prefight | 3 | 146162 | 68 | 20.673 | 7070.2 |
216 | 2024-04-01 14:32:42 | prefight | 4 | 161609 | 472 | 29.876 | 5409.3 |
215 | 2024-04-01 14:14:49 | prefight | 4 | 161609 | 472 | 28.750 | 5621.2 |
214 | 2024-04-01 14:14:46 | prefight | 3 | 146162 | 68 | 17.156 | 8519.6 |
213 | 2024-04-01 14:14:48 | prefight | 2 | 121059 | 10 | 7.563 | 16006.7 |
212 | 2024-04-01 14:14:41 | prefight | 1 | 82945 | 3 | 3.330 | 24908.4 |
211 | 2024-04-01 00:32:52 | prefight | 1 | 82945 | 3 | 3.283 | 25265.0 |
210 | 2024-03-30 12:09:28 | prefight | 1 | 82945 | 3 | 1.486 | 55817.6 |
209 | 2024-03-30 09:25:23 | prefight | 1 | 82945 | 3 | 4.783 | 17341.6 |
208 | 2024-03-08 03:42:02 | prefight | 2 | 121059 | 10 | 4.140 | 29241.3 |
207 | 2024-03-07 11:34:15 | prefight | 3 | 146162 | 68 | 18.250 | 8008.9 |
206 | 2024-03-07 06:02:29 | prefight | 4 | 161609 | 472 | 15.373 | 10512.5 |
205 | 2024-03-06 16:42:14 | prefight | 1 | 82945 | 3 | 1.436 | 57761.1 |
204 | 2024-03-06 13:23:22 | prefight | 3 | 146162 | 68 | 13.623 | 10729.1 |
203 | 2024-03-06 11:01:35 | prefight | 4 | 161609 | 472 | 30.096 | 5369.8 |
202 | 2024-03-05 15:02:32 | prefight | 2 | 121059 | 10 | 3.910 | 30961.4 |
201 | 2024-03-05 14:58:36 | prefight | 3 | 146162 | 68 | 7.283 | 20068.9 |
200 | 2024-03-05 02:36:37 | prefight | 4 | 161609 | 472 | 17.080 | 9461.9 |
199 | 2024-03-04 22:16:33 | prefight | 4 | 161609 | 472 | 59.456 | 2718.1 |
198 | 2024-03-02 06:43:54 | prefight | 4 | 161609 | 472 | 13.876 | 11646.7 |
197 | 2024-03-02 06:43:51 | prefight | 3 | 146162 | 68 | 14.783 | 9887.2 |
196 | 2024-03-02 06:43:52 | prefight | 2 | 121059 | 10 | 4.406 | 27475.9 |
195 | 2024-03-02 06:41:52 | prefight | 4 | 161609 | 472 | 29.723 | 5437.2 |
194 | 2024-03-02 06:41:56 | prefight | 2 | 121059 | 10 | 7.470 | 16206.0 |
193 | 2024-03-02 06:41:54 | prefight | 3 | 146162 | 68 | 8.860 | 16496.8 |
192 | 2024-03-02 06:41:50 | prefight | 1 | 82945 | 3 | 1.593 | 52068.4 |
191 | 2024-03-01 16:59:07 | prefight | 1 | 82945 | 3 | 3.313 | 25036.2 |
190 | 2024-02-29 05:43:31 | prefight | 1 | 82945 | 3 | 2.920 | 28405.8 |
189 | 2024-02-07 10:30:23 | prefight | 2 | 121059 | 10 | 4.750 | 25486.1 |
188 | 2024-02-05 03:17:43 | prefight | 2 | 121059 | 10 | 4.750 | 25486.1 |
187 | 2024-02-05 03:17:35 | prefight | 3 | 146162 | 68 | 8.093 | 18060.3 |
186 | 2024-01-31 00:34:15 | prefight | 2 | 121059 | 10 | 3.373 | 35890.6 |
185 | 2024-01-31 00:33:55 | prefight | 3 | 146162 | 68 | 7.766 | 18820.8 |
184 | 2024-01-30 22:57:47 | prefight | 4 | 161609 | 472 | 13.796 | 11714.2 |
183 | 2024-01-30 20:27:07 | prefight | 2 | 121059 | 10 | 3.686 | 32842.9 |
182 | 2024-01-30 20:25:15 | prefight | 3 | 146162 | 68 | 8.923 | 16380.4 |
181 | 2024-01-30 15:30:35 | prefight | 1 | 82945 | 3 | 1.483 | 55930.5 |
180 | 2024-01-30 15:20:35 | prefight | 4 | 161609 | 472 | 13.593 | 11889.1 |
179 | 2024-01-30 15:19:59 | prefight | 4 | 161609 | 472 | 13.266 | 12182.2 |
178 | 2024-01-30 15:20:07 | prefight | 2 | 121059 | 10 | 4.186 | 28920.0 |
177 | 2024-01-30 15:20:03 | prefight | 3 | 146162 | 68 | 7.796 | 18748.3 |
176 | 2024-01-05 21:58:37 | prefight | 1 | 82945 | 3 | 1.440 | 57600.7 |
175 | 2023-12-30 13:36:27 | prefight | 1 | 82945 | 3 | 1.423 | 58288.8 |
174 | 2023-12-08 17:21:40 | prefight | 1 | 82945 | 3 | 1.500 | 55296.7 |
173 | 2023-11-18 15:24:16 | prefight | 1 | 82945 | 3 | 1.423 | 58288.8 |
172 | 2023-11-04 10:21:24 | prefight | 1 | 82945 | 3 | 1.563 | 53067.8 |
171 | 2023-10-30 09:49:09 | prefight | 1 | 82945 | 3 | 1.330 | 62364.7 |
170 | 2023-10-29 14:24:05 | prefight | 1 | 82945 | 3 | 1.423 | 58288.8 |
169 | 2023-10-21 05:09:02 | prefight | 4 | 161609 | 472 | 14.486 | 11156.2 |
168 | 2023-10-18 08:23:13 | prefight | 4 | 161609 | 472 | 30.876 | 5234.1 |
167 | 2023-10-17 15:53:36 | prefight | 2 | 121059 | 10 | 9.030 | 13406.3 |
166 | 2023-10-16 14:49:55 | prefight | 4 | 161609 | 472 | 12.986 | 12444.9 |
165 | 2023-10-16 14:49:56 | prefight | 3 | 146162 | 68 | 7.580 | 19282.6 |
164 | 2023-10-11 00:26:29 | prefight | 1 | 82945 | 3 | 1.983 | 41828.0 |
163 | 2023-10-07 00:54:00 | prefight | 1 | 82945 | 3 | 1.406 | 58993.6 |
162 | 2023-10-03 18:28:25 | prefight | 1 | 82945 | 3 | 1.406 | 58993.6 |
161 | 2023-09-29 15:38:27 | prefight | 1 | 82945 | 3 | 1.326 | 62552.8 |
160 | 2023-08-23 04:55:10 | prefight | 1 | 82945 | 3 | 1.313 | 63172.1 |
159 | 2023-05-31 11:03:17 | prefight | 1 | 82945 | 3 | 1.266 | 65517.4 |
158 | 2023-05-28 00:36:08 | prefight | 1 | 82945 | 3 | 2.530 | 32784.6 |
157 | 2023-05-25 18:41:46 | prefight | 1 | 82945 | 3 | 1.343 | 61761.0 |
156 | 2023-03-20 14:30:27 | prefight | 1 | 82945 | 3 | 1.313 | 63172.1 |
155 | 2023-02-01 08:49:11 | prefight | 1 | 82945 | 3 | 1.390 | 59672.7 |
154 | 2023-01-06 03:26:07 | prefight | 1 | 82945 | 3 | 1.280 | 64800.8 |
153 | 2022-10-07 07:17:18 | prefight | 1 | 82945 | 3 | 1.283 | 64649.3 |
152 | 2022-10-03 18:16:09 | prefight | 1 | 82945 | 3 | 1.280 | 64800.8 |
151 | 2022-10-01 15:24:16 | prefight | 1 | 82945 | 3 | 1.313 | 63172.1 |
150 | 2022-05-23 21:20:25 | prefight | 1 | 82945 | 3 | 1.330 | 62364.7 |
149 | 2022-05-20 11:18:34 | prefight | 1 | 82945 | 3 | 1.420 | 58412.0 |
148 | 2022-05-16 23:00:33 | prefight | 1 | 82945 | 3 | 1.326 | 62552.8 |
147 | 2022-05-16 18:48:15 | prefight | 1 | 82945 | 3 | 1.486 | 55817.6 |
146 | 2022-05-16 05:28:35 | prefight | 1 | 82945 | 3 | 1.283 | 64649.3 |
145 | 2022-05-10 15:22:05 | prefight | 1 | 82945 | 3 | 1.686 | 49196.3 |
144 | 2022-02-06 22:02:43 | prefight | 1 | 82945 | 3 | 1.390 | 59672.7 |
143 | 2022-01-22 03:52:13 | prefight | 1 | 82945 | 3 | 1.313 | 63172.1 |
142 | 2022-01-14 13:49:55 | prefight | 1 | 82945 | 3 | 1.546 | 53651.4 |
141 | 2021-12-19 13:09:22 | prefight | 1 | 82945 | 3 | 1.563 | 53067.8 |
140 | 2021-12-17 12:08:26 | prefight | 1 | 82945 | 3 | 1.500 | 55296.7 |
139 | 2021-09-29 16:15:59 | prefight | 1 | 82945 | 3 | 1.346 | 61623.3 |
138 | 2021-06-23 09:53:01 | prefight | 1 | 82945 | 3 | 1.486 | 55817.6 |
137 | 2021-06-20 04:39:17 | prefight | 1 | 82945 | 3 | 1.546 | 53651.4 |
136 | 2021-05-18 06:00:52 | prefight | 1 | 82945 | 3 | 1.470 | 56425.2 |
135 | 2021-04-28 07:56:11 | prefight | 1 | 82945 | 3 | 1.296 | 64000.8 |
134 | 2021-03-17 15:17:28 | prefight | 1 | 82945 | 3 | 1.296 | 64000.8 |
133 | 2021-01-30 15:17:50 | prefight | 1 | 82945 | 3 | 1.310 | 63316.8 |
132 | 2021-01-11 11:33:44 | prefight | 1 | 82945 | 3 | 1.313 | 63172.1 |
131 | 2020-12-11 02:54:02 | prefight | 1 | 82945 | 3 | 1.283 | 64649.3 |