History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subgenre"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
216 | 2024-05-03 16:59:56 | subgenre | 4 | 161609 | 469 | 15.000 | 10773.9 |
215 | 2024-04-30 08:17:25 | subgenre | 4 | 161609 | 469 | 16.423 | 9840.4 |
214 | 2024-04-20 23:03:24 | subgenre | 3 | 146162 | 46 | 23.080 | 6332.8 |
213 | 2024-04-16 06:17:09 | subgenre | 4 | 161609 | 469 | 15.360 | 10521.4 |
212 | 2024-04-09 23:10:38 | subgenre | 1 | 82945 | 2 | 3.343 | 24811.5 |
211 | 2024-04-09 21:38:19 | subgenre | 2 | 121059 | 7 | 4.123 | 29361.9 |
210 | 2024-04-08 00:15:33 | subgenre | 4 | 161609 | 469 | 42.143 | 3834.8 |
209 | 2024-04-06 14:34:40 | subgenre | 3 | 146162 | 46 | 13.533 | 10800.4 |
208 | 2024-04-06 01:47:13 | subgenre | 4 | 161609 | 469 | 26.563 | 6084.0 |
207 | 2024-04-05 15:10:37 | subgenre | 3 | 146162 | 46 | 10.453 | 13982.8 |
206 | 2024-04-05 05:34:58 | subgenre | 3 | 146162 | 46 | 13.753 | 10627.6 |
205 | 2024-04-05 02:08:17 | subgenre | 4 | 161609 | 469 | 22.423 | 7207.3 |
204 | 2024-04-03 19:16:44 | subgenre | 4 | 161609 | 469 | 39.033 | 4140.3 |
203 | 2024-04-03 16:37:01 | subgenre | 4 | 161609 | 469 | 30.096 | 5369.8 |
202 | 2024-04-03 16:37:02 | subgenre | 3 | 146162 | 46 | 13.640 | 10715.7 |
201 | 2024-04-03 16:36:53 | subgenre | 4 | 161609 | 469 | 17.736 | 9111.9 |
200 | 2024-04-03 16:37:04 | subgenre | 2 | 121059 | 7 | 5.703 | 21227.2 |
199 | 2024-04-03 16:36:50 | subgenre | 3 | 146162 | 46 | 16.030 | 9118.0 |
198 | 2024-04-03 16:36:57 | subgenre | 1 | 82945 | 2 | 1.780 | 46598.3 |
197 | 2024-04-03 16:36:54 | subgenre | 1 | 82945 | 2 | 3.173 | 26140.9 |
196 | 2024-04-03 16:36:49 | subgenre | 2 | 121059 | 7 | 4.346 | 27855.3 |
195 | 2024-03-09 20:58:27 | subgenre | 1 | 82945 | 2 | 3.313 | 25036.2 |
194 | 2024-03-06 00:27:10 | subgenre | 1 | 82945 | 2 | 4.170 | 19890.9 |
193 | 2024-02-29 15:28:50 | subgenre | 4 | 161609 | 469 | 26.300 | 6144.8 |
192 | 2024-02-29 15:28:46 | subgenre | 3 | 146162 | 46 | 9.110 | 16044.1 |
191 | 2024-02-29 15:28:40 | subgenre | 2 | 121059 | 7 | 6.733 | 17979.9 |
190 | 2024-02-29 15:28:12 | subgenre | 1 | 82945 | 2 | 2.936 | 28251.0 |
189 | 2024-02-28 12:58:33 | subgenre | 1 | 82945 | 2 | 1.670 | 49667.7 |
188 | 2024-02-24 19:05:51 | subgenre | 4 | 161609 | 469 | 16.610 | 9729.6 |
187 | 2024-02-24 19:05:50 | subgenre | 1 | 82945 | 2 | 1.423 | 58288.8 |
186 | 2024-02-18 11:34:07 | subgenre | 3 | 146162 | 46 | 24.673 | 5924.0 |
185 | 2024-02-18 11:34:09 | subgenre | 2 | 121059 | 7 | 4.593 | 26357.3 |
184 | 2024-02-18 05:06:05 | subgenre | 1 | 82945 | 2 | 1.593 | 52068.4 |
183 | 2024-02-10 05:32:13 | subgenre | 4 | 161609 | 469 | 23.266 | 6946.1 |
182 | 2024-02-08 23:37:58 | subgenre | 1 | 82945 | 2 | 1.530 | 54212.4 |
181 | 2024-01-31 19:54:40 | subgenre | 1 | 82945 | 2 | 1.453 | 57085.3 |
180 | 2024-01-31 19:54:04 | subgenre | 4 | 161609 | 469 | 11.173 | 14464.2 |
179 | 2024-01-31 19:54:00 | subgenre | 2 | 121059 | 7 | 3.716 | 32577.8 |
178 | 2024-01-30 21:36:03 | subgenre | 2 | 121059 | 7 | 3.640 | 33258.0 |
177 | 2024-01-30 21:35:35 | subgenre | 3 | 146162 | 46 | 7.750 | 18859.6 |
176 | 2024-01-30 19:11:55 | subgenre | 2 | 121059 | 7 | 3.796 | 31891.2 |
175 | 2024-01-30 19:11:43 | subgenre | 3 | 146162 | 46 | 7.736 | 18893.7 |
174 | 2024-01-30 15:07:27 | subgenre | 3 | 146162 | 46 | 11.656 | 12539.6 |
173 | 2023-12-18 00:32:54 | subgenre | 3 | 146162 | 46 | 6.236 | 23438.4 |
172 | 2023-12-12 06:10:14 | subgenre | 4 | 161609 | 469 | 11.736 | 13770.4 |
171 | 2023-12-11 10:05:56 | subgenre | 2 | 121059 | 7 | 3.140 | 38553.8 |
170 | 2023-12-08 05:04:57 | subgenre | 1 | 82945 | 2 | 1.313 | 63172.1 |
169 | 2023-11-25 04:11:27 | subgenre | 1 | 82945 | 2 | 1.283 | 64649.3 |
168 | 2023-11-06 11:12:36 | subgenre | 1 | 82945 | 2 | 1.470 | 56425.2 |
167 | 2023-09-23 13:16:51 | subgenre | 1 | 82945 | 2 | 1.313 | 63172.1 |
166 | 2023-09-19 23:13:15 | subgenre | 4 | 161609 | 469 | 10.940 | 14772.3 |
165 | 2023-09-19 00:27:51 | subgenre | 3 | 146162 | 46 | 6.063 | 24107.2 |
164 | 2023-09-11 15:52:48 | subgenre | 4 | 161609 | 469 | 12.203 | 13243.4 |
163 | 2023-09-10 06:26:08 | subgenre | 2 | 121059 | 7 | 3.110 | 38925.7 |
162 | 2023-08-24 04:06:28 | subgenre | 4 | 161609 | 469 | 10.406 | 15530.4 |
161 | 2023-07-21 03:19:08 | subgenre | 1 | 82945 | 2 | 1.280 | 64800.8 |
160 | 2023-07-09 15:04:54 | subgenre | 1 | 82945 | 2 | 1.326 | 62552.8 |
159 | 2023-07-07 19:24:36 | subgenre | 4 | 161609 | 469 | 10.453 | 15460.5 |
158 | 2023-06-27 20:56:28 | subgenre | 3 | 146162 | 46 | 7.076 | 20656.0 |
157 | 2023-06-02 14:26:55 | subgenre | 4 | 161609 | 469 | 13.513 | 11959.5 |
156 | 2023-06-01 21:42:55 | subgenre | 2 | 121059 | 7 | 3.173 | 38152.9 |
155 | 2023-04-21 14:52:59 | subgenre | 1 | 82945 | 2 | 1.296 | 64000.8 |
154 | 2023-03-21 00:18:13 | subgenre | 3 | 146162 | 46 | 6.016 | 24295.5 |
153 | 2023-03-10 15:19:37 | subgenre | 4 | 161609 | 469 | 10.170 | 15890.8 |
152 | 2023-03-09 16:19:44 | subgenre | 2 | 121059 | 7 | 3.093 | 39139.7 |
151 | 2023-03-02 12:02:59 | subgenre | 1 | 82945 | 2 | 1.280 | 64800.8 |
150 | 2023-02-26 21:58:02 | subgenre | 1 | 82945 | 2 | 1.420 | 58412.0 |
149 | 2023-02-12 12:28:21 | subgenre | 1 | 82945 | 2 | 1.313 | 63172.1 |
148 | 2022-12-20 18:39:39 | subgenre | 3 | 146162 | 46 | 5.970 | 24482.7 |
147 | 2022-12-14 21:35:59 | subgenre | 4 | 161609 | 469 | 10.253 | 15762.1 |
146 | 2022-12-13 14:15:34 | subgenre | 2 | 121059 | 7 | 3.186 | 37997.2 |
145 | 2022-12-11 00:41:49 | subgenre | 1 | 82945 | 2 | 1.393 | 59544.1 |
144 | 2022-10-19 18:45:57 | subgenre | 1 | 82945 | 2 | 1.313 | 63172.1 |
143 | 2022-09-30 18:58:27 | subgenre | 1 | 82945 | 2 | 1.280 | 64800.8 |
142 | 2022-08-17 10:13:58 | subgenre | 3 | 146162 | 46 | 6.170 | 23689.1 |
141 | 2022-08-15 00:23:18 | subgenre | 3 | 146162 | 46 | 6.063 | 24107.2 |
140 | 2022-08-14 19:07:29 | subgenre | 1 | 82945 | 2 | 1.626 | 51011.7 |
139 | 2022-08-03 23:54:31 | subgenre | 4 | 161609 | 469 | 12.686 | 12739.2 |
138 | 2022-07-31 02:23:11 | subgenre | 2 | 121059 | 7 | 3.140 | 38553.8 |
137 | 2022-07-28 17:19:52 | subgenre | 2 | 121059 | 7 | 3.233 | 37444.8 |
136 | 2022-05-28 11:18:15 | subgenre | 1 | 82945 | 2 | 1.373 | 60411.5 |
135 | 2022-05-18 14:30:26 | subgenre | 1 | 82945 | 2 | 1.436 | 57761.1 |
134 | 2022-04-05 20:22:40 | subgenre | 1 | 82945 | 2 | 1.406 | 58993.6 |
133 | 2022-04-03 16:10:15 | subgenre | 1 | 82945 | 2 | 1.283 | 64649.3 |
132 | 2022-03-21 04:35:32 | subgenre | 2 | 121059 | 7 | 3.106 | 38975.9 |
131 | 2022-03-17 16:21:11 | subgenre | 3 | 146162 | 46 | 7.673 | 19048.9 |
130 | 2022-03-07 15:40:24 | subgenre | 4 | 161609 | 469 | 12.733 | 12692.1 |
129 | 2022-01-23 15:18:15 | subgenre | 1 | 82945 | 2 | 1.300 | 63803.8 |
128 | 2022-01-18 03:06:46 | subgenre | 1 | 82945 | 2 | 1.610 | 51518.6 |
127 | 2021-09-24 12:28:03 | subgenre | 1 | 82945 | 2 | 1.280 | 64800.8 |
126 | 2020-12-17 04:57:19 | subgenre | 1 | 82945 | 2 | 1.326 | 62552.8 |
125 | 2020-11-05 03:22:18 | subgenre | 1 | 82945 | 2 | 2.156 | 38471.7 |
124 | 2020-11-02 10:58:23 | subgenre | 1 | 82945 | 2 | 1.563 | 53067.8 |
123 | 2020-10-30 12:34:28 | subgenre | 1 | 82945 | 2 | 1.343 | 61761.0 |
122 | 2020-04-02 06:32:10 | subgenre | 1 | 82945 | 2 | 1.513 | 54821.5 |
121 | 2020-03-23 01:12:20 | subgenre | 1 | 82945 | 2 | 1.640 | 50576.2 |
120 | 2020-03-04 14:27:45 | subgenre | 1 | 82945 | 2 | 1.733 | 47862.1 |
119 | 2020-02-26 05:05:05 | subgenre | 4 | 161609 | 469 | 14.470 | 11168.6 |
118 | 2020-02-24 00:26:15 | subgenre | 1 | 82945 | 2 | 1.593 | 52068.4 |
117 | 2020-02-23 05:41:15 | subgenre | 4 | 161609 | 469 | 13.640 | 11848.2 |