History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violater"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
216 | 2024-05-11 14:22:18 | violater | 3 | 146162 | 138 | 27.686 | 5279.3 |
215 | 2024-05-11 05:39:56 | violater | 3 | 146162 | 138 | 15.250 | 9584.4 |
214 | 2024-05-11 05:39:58 | violater | 2 | 121059 | 11 | 4.153 | 29149.8 |
213 | 2024-05-11 05:39:48 | violater | 1 | 82945 | 6 | 3.236 | 25632.0 |
212 | 2024-05-11 05:39:39 | violater | 2 | 121059 | 11 | 4.190 | 28892.4 |
211 | 2024-05-11 05:39:34 | violater | 1 | 82945 | 6 | 3.360 | 24686.0 |
210 | 2024-05-01 14:20:34 | violater | 1 | 82945 | 6 | 2.780 | 29836.3 |
209 | 2024-04-30 15:29:37 | violater | 1 | 82945 | 6 | 1.310 | 63316.8 |
208 | 2024-04-05 07:43:27 | violater | 3 | 146162 | 138 | 10.953 | 13344.5 |
207 | 2024-04-01 02:50:15 | violater | 2 | 121059 | 11 | 9.986 | 12122.9 |
206 | 2024-04-01 02:49:54 | violater | 3 | 146162 | 138 | 7.703 | 18974.7 |
205 | 2024-03-31 13:35:14 | violater | 2 | 121059 | 11 | 8.313 | 14562.6 |
204 | 2024-03-31 12:21:04 | violater | 1 | 82945 | 6 | 3.153 | 26306.7 |
203 | 2024-03-31 00:17:57 | violater | 3 | 146162 | 138 | 14.033 | 10415.6 |
202 | 2024-03-30 22:40:56 | violater | 2 | 121059 | 11 | 3.876 | 31233.0 |
201 | 2024-03-30 22:40:37 | violater | 3 | 146162 | 138 | 8.200 | 17824.6 |
200 | 2024-03-30 10:56:47 | violater | 3 | 146162 | 138 | 7.906 | 18487.5 |
199 | 2024-03-30 10:56:47 | violater | 2 | 121059 | 11 | 6.250 | 19369.4 |
198 | 2024-03-28 23:44:00 | violater | 1 | 82945 | 6 | 4.783 | 17341.6 |
197 | 2024-03-16 17:59:51 | violater | 3 | 146162 | 138 | 13.843 | 10558.5 |
196 | 2024-03-07 14:28:17 | violater | 1 | 82945 | 6 | 1.233 | 67270.9 |
195 | 2024-03-01 00:21:49 | violater | 1 | 82945 | 6 | 1.376 | 60279.8 |
194 | 2024-02-29 03:07:23 | violater | 2 | 121059 | 11 | 3.343 | 36212.7 |
193 | 2024-02-29 03:07:03 | violater | 3 | 146162 | 138 | 7.233 | 20207.7 |
192 | 2024-02-28 22:11:02 | violater | 3 | 146162 | 138 | 9.673 | 15110.3 |
191 | 2024-02-18 06:29:01 | violater | 1 | 82945 | 6 | 8.016 | 10347.4 |
190 | 2023-12-28 00:28:44 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
189 | 2023-12-20 00:48:00 | violater | 1 | 82945 | 6 | 1.373 | 60411.5 |
188 | 2023-12-14 23:58:58 | violater | 1 | 82945 | 6 | 1.356 | 61168.9 |
187 | 2023-12-04 00:24:19 | violater | 1 | 82945 | 6 | 1.360 | 60989.0 |
186 | 2023-11-28 18:49:19 | violater | 3 | 146162 | 138 | 6.343 | 23043.0 |
185 | 2023-11-03 00:13:33 | violater | 1 | 82945 | 6 | 1.266 | 65517.4 |
184 | 2023-10-07 13:00:34 | violater | 1 | 82945 | 6 | 1.220 | 67987.7 |
183 | 2023-09-23 09:12:53 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
182 | 2023-08-28 22:49:04 | violater | 3 | 146162 | 138 | 6.236 | 23438.4 |
181 | 2023-08-04 04:10:42 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
180 | 2023-05-12 14:18:38 | violater | 3 | 146162 | 138 | 6.236 | 23438.4 |
179 | 2023-05-02 04:47:06 | violater | 1 | 82945 | 6 | 1.263 | 65673.0 |
178 | 2023-02-23 11:13:01 | violater | 1 | 82945 | 6 | 1.203 | 68948.5 |
177 | 2023-02-17 12:46:17 | violater | 3 | 146162 | 138 | 6.000 | 24360.3 |
176 | 2022-12-21 22:43:26 | violater | 1 | 82945 | 6 | 1.220 | 67987.7 |
175 | 2022-11-27 21:50:58 | violater | 3 | 146162 | 138 | 6.393 | 22862.8 |
174 | 2022-09-04 22:38:07 | violater | 1 | 82945 | 6 | 1.250 | 66356.0 |
173 | 2022-09-02 19:08:15 | violater | 1 | 82945 | 6 | 1.406 | 58993.6 |
172 | 2022-07-04 23:54:34 | violater | 3 | 146162 | 138 | 6.283 | 23263.1 |
171 | 2022-06-06 16:07:21 | violater | 1 | 82945 | 6 | 1.283 | 64649.3 |
170 | 2022-04-23 20:30:13 | violater | 1 | 82945 | 6 | 1.236 | 67107.6 |
169 | 2022-04-11 15:00:11 | violater | 1 | 82945 | 6 | 1.360 | 60989.0 |
168 | 2022-01-13 21:21:13 | violater | 1 | 82945 | 6 | 1.233 | 67270.9 |
167 | 2022-01-11 17:38:45 | violater | 1 | 82945 | 6 | 1.436 | 57761.1 |
166 | 2021-11-22 04:30:19 | violater | 1 | 82945 | 6 | 1.250 | 66356.0 |
165 | 2021-05-22 16:40:32 | violater | 1 | 82945 | 6 | 1.420 | 58412.0 |
164 | 2021-04-30 12:09:46 | violater | 1 | 82945 | 6 | 1.263 | 65673.0 |
163 | 2021-04-23 15:29:24 | violater | 1 | 82945 | 6 | 1.436 | 57761.1 |
162 | 2021-03-25 18:12:24 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
161 | 2021-02-27 23:03:53 | violater | 1 | 82945 | 6 | 1.360 | 60989.0 |
160 | 2021-02-02 16:39:04 | violater | 3 | 146162 | 138 | 13.470 | 10850.9 |
159 | 2021-01-08 23:48:10 | violater | 1 | 82945 | 6 | 1.263 | 65673.0 |
158 | 2020-11-04 21:35:57 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
157 | 2020-10-26 15:19:05 | violater | 1 | 82945 | 6 | 1.453 | 57085.3 |
156 | 2020-10-21 10:58:50 | violater | 1 | 82945 | 6 | 1.266 | 65517.4 |
155 | 2020-10-20 20:41:27 | violater | 1 | 82945 | 6 | 1.220 | 67987.7 |
154 | 2020-03-25 08:55:17 | violater | 1 | 82945 | 6 | 1.406 | 58993.6 |
153 | 2020-03-23 06:46:32 | violater | 1 | 82945 | 6 | 1.530 | 54212.4 |
152 | 2020-03-15 02:21:05 | violater | 1 | 82945 | 6 | 1.390 | 59672.7 |
151 | 2020-03-04 13:50:06 | violater | 1 | 82945 | 6 | 1.456 | 56967.7 |
150 | 2020-03-01 01:19:44 | violater | 1 | 82945 | 6 | 2.720 | 30494.5 |
149 | 2020-02-24 00:44:36 | violater | 1 | 82945 | 6 | 2.003 | 41410.4 |
148 | 2020-02-19 14:39:42 | violater | 1 | 82945 | 6 | 3.046 | 27230.8 |
147 | 2020-02-19 03:26:51 | violater | 1 | 82945 | 6 | 1.453 | 57085.3 |
146 | 2020-02-12 22:20:34 | violater | 1 | 82945 | 6 | 1.643 | 50483.9 |
145 | 2020-02-05 18:53:26 | violater | 1 | 82945 | 6 | 4.516 | 18366.9 |
144 | 2020-01-30 03:09:11 | violater | 1 | 82945 | 6 | 1.440 | 57600.7 |
143 | 2020-01-27 00:03:19 | violater | 1 | 82945 | 6 | 1.530 | 54212.4 |
142 | 2020-01-21 23:44:01 | violater | 1 | 82945 | 6 | 1.423 | 58288.8 |
141 | 2020-01-21 04:35:49 | violater | 1 | 82945 | 6 | 3.390 | 24467.6 |
140 | 2020-01-18 22:05:34 | violater | 1 | 82945 | 6 | 1.406 | 58993.6 |
139 | 2020-01-08 19:44:27 | violater | 1 | 82945 | 6 | 1.360 | 60989.0 |
138 | 2020-01-05 05:26:16 | violater | 1 | 82945 | 6 | 1.576 | 52630.1 |
137 | 2020-01-02 05:41:30 | violater | 1 | 82945 | 6 | 1.580 | 52496.8 |
136 | 2019-12-31 04:36:47 | violater | 1 | 82945 | 6 | 2.780 | 29836.3 |
135 | 2019-12-06 11:19:14 | violater | 1 | 82945 | 6 | 1.236 | 67107.6 |
134 | 2019-09-07 10:45:09 | violater | 1 | 82945 | 6 | 1.116 | 74323.5 |
133 | 2019-07-23 03:58:14 | violater | 1 | 82945 | 6 | 1.343 | 61761.0 |
132 | 2019-06-01 14:47:20 | violater | 1 | 82945 | 6 | 1.273 | 65157.1 |
131 | 2019-02-10 19:44:56 | violater | 1 | 82945 | 6 | 1.193 | 69526.4 |
130 | 2019-01-17 02:28:22 | violater | 1 | 82945 | 6 | 1.186 | 69936.8 |
129 | 2019-01-05 21:40:55 | violater | 1 | 82945 | 6 | 1.283 | 64649.3 |
128 | 2018-12-06 12:37:02 | violater | 1 | 82945 | 6 | 1.183 | 70114.1 |
127 | 2018-11-23 06:49:10 | violater | 1 | 82945 | 6 | 1.183 | 70114.1 |
126 | 2018-10-18 13:20:16 | violater | 1 | 82945 | 6 | 1.426 | 58166.2 |
125 | 2018-10-16 16:45:08 | violater | 1 | 82945 | 6 | 1.283 | 64649.3 |
124 | 2018-09-13 05:53:29 | violater | 1 | 82945 | 6 | 1.250 | 66356.0 |
123 | 2018-09-11 12:00:54 | violater | 1 | 82945 | 6 | 1.200 | 69120.8 |
122 | 2018-09-03 01:08:43 | violater | 1 | 82945 | 6 | 1.330 | 62364.7 |
121 | 2018-08-27 01:44:23 | violater | 1 | 82945 | 6 | 1.183 | 70114.1 |
120 | 2018-08-03 14:03:24 | violater | 1 | 82945 | 6 | 1.423 | 58288.8 |
119 | 2018-07-28 10:01:21 | violater | 1 | 82945 | 6 | 1.196 | 69352.0 |
118 | 2018-07-26 13:49:29 | violater | 1 | 82945 | 6 | 1.336 | 62084.6 |
117 | 2018-07-23 04:37:17 | violater | 1 | 82945 | 6 | 1.470 | 56425.2 |