History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"songlike"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
229 | 2024-05-04 21:16:25 | songlike | 1 | 82945 | 3 | 1.686 | 49196.3 |
228 | 2024-05-03 12:24:44 | songlike | 1 | 82945 | 3 | 1.796 | 46183.2 |
227 | 2024-04-09 17:52:48 | songlike | 3 | 146162 | 169 | 15.720 | 9297.8 |
226 | 2024-04-09 17:52:34 | songlike | 2 | 121059 | 17 | 4.733 | 25577.6 |
225 | 2024-04-08 10:19:50 | songlike | 2 | 121059 | 17 | 11.356 | 10660.4 |
224 | 2024-04-08 04:59:15 | songlike | 1 | 82945 | 3 | 1.563 | 53067.8 |
223 | 2024-04-07 20:53:48 | songlike | 3 | 146162 | 169 | 30.143 | 4849.0 |
222 | 2024-04-07 09:28:20 | songlike | 3 | 146162 | 169 | 29.456 | 4962.0 |
221 | 2024-04-03 23:15:42 | songlike | 3 | 146162 | 169 | 17.470 | 8366.5 |
220 | 2024-04-03 23:15:54 | songlike | 1 | 82945 | 3 | 3.500 | 23698.6 |
219 | 2024-04-03 23:15:41 | songlike | 2 | 121059 | 17 | 7.313 | 16553.9 |
218 | 2024-04-03 23:15:39 | songlike | 1 | 82945 | 3 | 3.530 | 23497.2 |
217 | 2024-03-31 19:43:28 | songlike | 1 | 82945 | 3 | 1.720 | 48223.8 |
216 | 2024-03-30 02:25:37 | songlike | 1 | 82945 | 3 | 3.326 | 24938.4 |
215 | 2024-03-08 02:37:13 | songlike | 3 | 146162 | 169 | 14.720 | 9929.5 |
214 | 2024-03-07 22:39:41 | songlike | 2 | 121059 | 17 | 4.126 | 29340.5 |
213 | 2024-03-07 22:39:29 | songlike | 3 | 146162 | 169 | 8.140 | 17956.0 |
212 | 2024-03-06 01:27:40 | songlike | 2 | 121059 | 17 | 10.453 | 11581.3 |
211 | 2024-03-06 01:11:26 | songlike | 1 | 82945 | 3 | 1.606 | 51646.9 |
210 | 2024-03-05 10:52:08 | songlike | 2 | 121059 | 17 | 4.203 | 28803.0 |
209 | 2024-03-05 10:51:56 | songlike | 3 | 146162 | 169 | 7.373 | 19824.0 |
208 | 2024-03-04 22:22:11 | songlike | 3 | 146162 | 169 | 13.610 | 10739.3 |
207 | 2024-03-04 20:52:03 | songlike | 3 | 146162 | 169 | 11.250 | 12992.2 |
206 | 2024-03-04 20:52:10 | songlike | 1 | 82945 | 3 | 3.173 | 26140.9 |
205 | 2024-03-04 20:52:01 | songlike | 2 | 121059 | 17 | 4.203 | 28803.0 |
204 | 2024-03-04 20:51:56 | songlike | 1 | 82945 | 3 | 1.563 | 53067.8 |
203 | 2024-02-07 01:41:17 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
202 | 2024-02-03 20:13:50 | songlike | 1 | 82945 | 3 | 1.313 | 63172.1 |
201 | 2024-02-03 20:06:46 | songlike | 1 | 82945 | 3 | 1.360 | 60989.0 |
200 | 2024-02-03 20:06:06 | songlike | 1 | 82945 | 3 | 1.296 | 64000.8 |
199 | 2024-02-03 20:00:10 | songlike | 1 | 82945 | 3 | 1.296 | 64000.8 |
198 | 2024-01-31 14:41:39 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
197 | 2024-01-31 00:39:47 | songlike | 3 | 146162 | 169 | 10.923 | 13381.1 |
196 | 2024-01-30 20:37:44 | songlike | 2 | 121059 | 17 | 4.890 | 24756.4 |
195 | 2024-01-29 22:16:23 | songlike | 3 | 146162 | 169 | 10.233 | 14283.4 |
194 | 2024-01-29 15:56:31 | songlike | 2 | 121059 | 17 | 3.953 | 30624.6 |
193 | 2024-01-29 15:56:27 | songlike | 3 | 146162 | 169 | 7.546 | 19369.5 |
192 | 2024-01-29 15:56:23 | songlike | 1 | 82945 | 3 | 1.483 | 55930.5 |
191 | 2024-01-04 18:39:58 | songlike | 1 | 82945 | 3 | 1.406 | 58993.6 |
190 | 2023-12-27 01:27:45 | songlike | 1 | 82945 | 3 | 1.436 | 57761.1 |
189 | 2023-12-17 06:28:02 | songlike | 1 | 82945 | 3 | 1.486 | 55817.6 |
188 | 2023-11-27 08:12:21 | songlike | 1 | 82945 | 3 | 1.373 | 60411.5 |
187 | 2023-10-14 21:08:45 | songlike | 1 | 82945 | 3 | 1.483 | 55930.5 |
186 | 2023-09-29 06:33:27 | songlike | 1 | 82945 | 3 | 1.330 | 62364.7 |
185 | 2023-09-25 09:46:35 | songlike | 1 | 82945 | 3 | 1.313 | 63172.1 |
184 | 2023-09-13 19:23:14 | songlike | 1 | 82945 | 3 | 1.313 | 63172.1 |
183 | 2023-09-13 15:40:53 | songlike | 1 | 82945 | 3 | 1.563 | 53067.8 |
182 | 2023-06-16 15:54:49 | songlike | 1 | 82945 | 3 | 2.610 | 31779.7 |
181 | 2023-05-19 13:20:20 | songlike | 1 | 82945 | 3 | 1.283 | 64649.3 |
180 | 2023-05-16 03:36:42 | songlike | 1 | 82945 | 3 | 1.326 | 62552.8 |
179 | 2023-03-31 06:26:50 | songlike | 1 | 82945 | 3 | 1.436 | 57761.1 |
178 | 2023-01-13 14:09:52 | songlike | 1 | 82945 | 3 | 1.296 | 64000.8 |
177 | 2023-01-11 21:45:50 | songlike | 1 | 82945 | 3 | 1.293 | 64149.3 |
176 | 2022-11-04 12:18:27 | songlike | 2 | 121059 | 17 | 3.560 | 34005.3 |
175 | 2022-10-31 14:06:38 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
174 | 2022-08-24 02:06:11 | songlike | 1 | 82945 | 3 | 1.436 | 57761.1 |
173 | 2022-07-12 15:20:56 | songlike | 3 | 146162 | 169 | 7.170 | 20385.2 |
172 | 2022-06-20 09:30:58 | songlike | 1 | 82945 | 3 | 1.296 | 64000.8 |
171 | 2022-05-19 03:44:26 | songlike | 1 | 82945 | 3 | 1.343 | 61761.0 |
170 | 2022-05-16 03:42:46 | songlike | 2 | 121059 | 17 | 3.703 | 32692.1 |
169 | 2022-04-02 15:10:04 | songlike | 1 | 82945 | 3 | 1.313 | 63172.1 |
168 | 2022-02-23 13:20:08 | songlike | 1 | 82945 | 3 | 2.093 | 39629.7 |
167 | 2022-02-21 09:52:28 | songlike | 1 | 82945 | 3 | 1.406 | 58993.6 |
166 | 2021-12-25 06:22:11 | songlike | 1 | 82945 | 3 | 3.220 | 25759.3 |
165 | 2021-12-02 18:25:45 | songlike | 1 | 82945 | 3 | 1.486 | 55817.6 |
164 | 2021-08-13 00:24:20 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
163 | 2021-05-24 10:14:37 | songlike | 2 | 121059 | 17 | 3.266 | 37066.4 |
162 | 2021-05-21 02:13:09 | songlike | 1 | 82945 | 3 | 1.580 | 52496.8 |
161 | 2021-05-02 04:13:07 | songlike | 1 | 82945 | 3 | 1.563 | 53067.8 |
160 | 2021-04-30 20:24:04 | songlike | 1 | 82945 | 3 | 3.016 | 27501.7 |
159 | 2021-04-27 13:54:59 | songlike | 2 | 121059 | 17 | 3.436 | 35232.5 |
158 | 2021-03-27 15:41:48 | songlike | 2 | 121059 | 17 | 3.390 | 35710.6 |
157 | 2021-02-02 10:00:43 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
156 | 2021-01-16 08:29:25 | songlike | 1 | 82945 | 3 | 1.453 | 57085.3 |
155 | 2021-01-10 23:01:51 | songlike | 2 | 121059 | 17 | 3.250 | 37248.9 |
154 | 2021-01-06 14:33:24 | songlike | 1 | 82945 | 3 | 1.360 | 60989.0 |
153 | 2020-12-12 12:34:40 | songlike | 2 | 121059 | 17 | 3.313 | 36540.6 |
152 | 2020-12-08 19:38:43 | songlike | 1 | 82945 | 3 | 1.326 | 62552.8 |
151 | 2020-11-07 06:26:05 | songlike | 3 | 146162 | 169 | 7.483 | 19532.5 |
150 | 2020-11-06 13:45:21 | songlike | 2 | 121059 | 17 | 3.750 | 32282.4 |
149 | 2020-10-08 14:16:51 | songlike | 1 | 82945 | 3 | 1.296 | 64000.8 |
148 | 2020-10-06 11:28:50 | songlike | 1 | 82945 | 3 | 1.580 | 52496.8 |
147 | 2020-09-04 23:38:38 | songlike | 1 | 82945 | 3 | 1.423 | 58288.8 |
146 | 2020-08-28 05:27:17 | songlike | 1 | 82945 | 3 | 1.373 | 60411.5 |
145 | 2020-08-09 07:38:42 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
144 | 2020-08-01 16:16:53 | songlike | 1 | 82945 | 3 | 1.453 | 57085.3 |
143 | 2020-07-30 13:27:05 | songlike | 1 | 82945 | 3 | 1.500 | 55296.7 |
142 | 2020-06-12 10:52:20 | songlike | 1 | 82945 | 3 | 1.356 | 61168.9 |
141 | 2020-03-22 22:04:51 | songlike | 1 | 82945 | 3 | 1.513 | 54821.5 |
140 | 2020-03-01 07:32:48 | songlike | 1 | 82945 | 3 | 1.436 | 57761.1 |
139 | 2020-02-25 03:20:07 | songlike | 1 | 82945 | 3 | 1.533 | 54106.3 |
138 | 2020-02-24 10:23:18 | songlike | 1 | 82945 | 3 | 1.610 | 51518.6 |
137 | 2020-02-17 03:49:38 | songlike | 1 | 82945 | 3 | 1.610 | 51518.6 |
136 | 2020-02-14 23:38:39 | songlike | 1 | 82945 | 3 | 1.516 | 54713.1 |
135 | 2020-02-14 17:48:28 | songlike | 1 | 82945 | 3 | 3.310 | 25058.9 |
134 | 2020-02-03 20:16:01 | songlike | 1 | 82945 | 3 | 2.203 | 37650.9 |
133 | 2020-02-03 17:30:36 | songlike | 1 | 82945 | 3 | 4.190 | 19795.9 |
132 | 2020-01-23 12:04:16 | songlike | 1 | 82945 | 3 | 3.703 | 22399.4 |
131 | 2020-01-23 08:22:16 | songlike | 1 | 82945 | 3 | 4.576 | 18126.1 |
130 | 2020-01-22 07:52:21 | songlike | 1 | 82945 | 3 | 1.750 | 47397.1 |