History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"violation"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
211 | 2024-04-30 09:52:51 | violation | 1 | 81242 | 2 | 1.940 | 41877.3 |
210 | 2024-04-26 09:11:13 | violation | 1 | 81242 | 2 | 1.500 | 54161.3 |
209 | 2024-04-19 20:32:11 | violation | 3 | 148641 | 132 | 20.390 | 7289.9 |
208 | 2024-04-19 20:32:10 | violation | 2 | 121436 | 17 | 7.360 | 16499.5 |
207 | 2024-04-19 10:58:45 | violation | 3 | 148641 | 132 | 30.363 | 4895.5 |
206 | 2024-04-19 10:58:45 | violation | 2 | 121436 | 17 | 4.186 | 29010.0 |
205 | 2024-04-19 09:49:12 | violation | 1 | 81242 | 2 | 1.410 | 57618.4 |
204 | 2024-04-13 05:56:41 | violation | 1 | 81242 | 2 | 1.483 | 54782.2 |
203 | 2024-04-07 18:35:14 | violation | 1 | 81242 | 2 | 1.530 | 53099.3 |
202 | 2024-04-05 02:53:04 | violation | 1 | 81242 | 2 | 1.546 | 52549.8 |
201 | 2024-03-29 01:35:21 | violation | 1 | 81242 | 2 | 1.453 | 55913.3 |
200 | 2024-03-14 21:27:23 | violation | 3 | 148641 | 132 | 12.030 | 12355.9 |
199 | 2024-03-14 21:27:14 | violation | 2 | 121436 | 17 | 12.530 | 9691.6 |
198 | 2024-03-14 17:49:32 | violation | 3 | 148641 | 132 | 26.470 | 5615.5 |
197 | 2024-03-14 17:49:30 | violation | 2 | 121436 | 17 | 12.736 | 9534.9 |
196 | 2024-03-14 13:07:54 | violation | 1 | 81242 | 2 | 1.203 | 67532.8 |
195 | 2024-03-14 04:31:48 | violation | 3 | 148641 | 132 | 23.613 | 6294.9 |
194 | 2024-03-14 04:31:49 | violation | 2 | 121436 | 17 | 4.890 | 24833.5 |
193 | 2024-03-14 04:26:26 | violation | 1 | 81242 | 2 | 2.580 | 31489.1 |
192 | 2024-03-07 11:52:54 | violation | 1 | 81242 | 2 | 3.110 | 26122.8 |
191 | 2024-03-05 22:38:56 | violation | 1 | 81242 | 2 | 1.516 | 53589.7 |
190 | 2024-02-29 13:46:09 | violation | 1 | 81242 | 2 | 1.563 | 51978.2 |
189 | 2024-02-27 17:42:41 | violation | 1 | 81242 | 2 | 1.406 | 57782.4 |
188 | 2024-02-13 13:14:42 | violation | 2 | 121436 | 17 | 11.393 | 10658.8 |
187 | 2024-02-13 12:07:07 | violation | 3 | 148641 | 132 | 26.690 | 5569.2 |
186 | 2024-02-12 13:42:51 | violation | 3 | 148641 | 132 | 17.923 | 8293.3 |
185 | 2024-02-12 13:42:50 | violation | 2 | 121436 | 17 | 10.173 | 11937.1 |
184 | 2024-02-12 08:24:03 | violation | 1 | 81242 | 2 | 1.186 | 68500.8 |
183 | 2024-01-31 05:27:08 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
182 | 2024-01-20 13:48:47 | violation | 1 | 81242 | 2 | 1.296 | 62686.7 |
181 | 2024-01-20 07:20:23 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
180 | 2024-01-04 06:14:09 | violation | 1 | 81242 | 2 | 1.203 | 67532.8 |
179 | 2023-11-18 17:59:21 | violation | 1 | 81242 | 2 | 1.233 | 65889.7 |
178 | 2023-11-14 22:59:24 | violation | 1 | 81242 | 2 | 1.610 | 50460.9 |
177 | 2023-11-13 21:01:04 | violation | 1 | 81242 | 2 | 1.406 | 57782.4 |
176 | 2023-10-06 11:10:21 | violation | 1 | 81242 | 2 | 1.296 | 62686.7 |
175 | 2023-09-20 03:29:04 | violation | 1 | 81242 | 2 | 1.220 | 66591.8 |
174 | 2023-09-03 08:47:17 | violation | 1 | 81242 | 2 | 1.186 | 68500.8 |
173 | 2023-06-07 13:52:21 | violation | 1 | 81242 | 2 | 1.186 | 68500.8 |
172 | 2023-05-20 19:07:43 | violation | 1 | 81242 | 2 | 1.173 | 69260.0 |
171 | 2023-03-27 02:38:41 | violation | 1 | 81242 | 2 | 1.170 | 69437.6 |
170 | 2023-01-24 10:31:18 | violation | 1 | 81242 | 2 | 1.296 | 62686.7 |
169 | 2023-01-10 19:18:24 | violation | 1 | 81242 | 2 | 1.156 | 70278.5 |
168 | 2022-10-16 18:32:36 | violation | 1 | 81242 | 2 | 1.173 | 69260.0 |
167 | 2022-09-25 16:55:53 | violation | 1 | 81242 | 2 | 2.483 | 32719.3 |
166 | 2022-09-18 21:13:15 | violation | 1 | 81242 | 2 | 1.190 | 68270.6 |
165 | 2022-08-24 01:57:25 | violation | 1 | 81242 | 2 | 1.250 | 64993.6 |
164 | 2022-07-20 14:45:42 | violation | 3 | 148641 | 132 | 6.110 | 24327.5 |
163 | 2022-06-07 22:37:29 | violation | 1 | 81242 | 2 | 1.203 | 67532.8 |
162 | 2022-05-23 02:02:20 | violation | 1 | 81242 | 2 | 1.216 | 66810.9 |
161 | 2022-01-28 10:31:05 | violation | 1 | 81242 | 2 | 1.330 | 61084.2 |
160 | 2021-10-14 23:44:19 | violation | 1 | 81242 | 2 | 1.453 | 55913.3 |
159 | 2021-08-07 23:09:49 | violation | 1 | 81242 | 2 | 1.250 | 64993.6 |
158 | 2021-07-14 00:33:55 | violation | 1 | 81242 | 2 | 1.186 | 68500.8 |
157 | 2021-04-10 17:57:27 | violation | 1 | 81242 | 2 | 1.373 | 59171.2 |
156 | 2020-12-25 00:04:48 | violation | 1 | 81242 | 2 | 1.266 | 64172.2 |
155 | 2020-12-14 10:48:02 | violation | 3 | 148641 | 132 | 6.220 | 23897.3 |
154 | 2020-10-18 03:19:47 | violation | 3 | 148641 | 132 | 6.016 | 24707.6 |
153 | 2020-09-17 08:32:49 | violation | 1 | 81242 | 2 | 1.266 | 64172.2 |
152 | 2020-08-20 01:24:54 | violation | 3 | 148641 | 132 | 6.623 | 22443.2 |
151 | 2020-05-29 11:06:05 | violation | 1 | 81242 | 2 | 1.406 | 57782.4 |
150 | 2020-03-26 19:05:44 | violation | 1 | 81242 | 2 | 1.343 | 60492.9 |
149 | 2020-03-22 03:35:00 | violation | 1 | 81242 | 2 | 1.280 | 63470.3 |
148 | 2020-02-23 18:31:56 | violation | 1 | 81242 | 2 | 1.483 | 54782.2 |
147 | 2020-02-23 05:41:16 | violation | 1 | 81242 | 2 | 2.860 | 28406.3 |
146 | 2020-02-22 19:31:05 | violation | 1 | 81242 | 2 | 1.486 | 54671.6 |
145 | 2020-02-19 19:12:37 | violation | 1 | 81242 | 2 | 2.826 | 28748.1 |
144 | 2020-02-18 17:29:19 | violation | 1 | 81242 | 2 | 1.530 | 53099.3 |
143 | 2020-02-10 15:36:44 | violation | 1 | 81242 | 2 | 1.563 | 51978.2 |
142 | 2020-02-08 09:30:44 | violation | 1 | 81242 | 2 | 1.360 | 59736.8 |
141 | 2020-01-27 16:21:00 | violation | 1 | 81242 | 2 | 1.203 | 67532.8 |
140 | 2020-01-27 02:16:25 | violation | 1 | 81242 | 2 | 3.906 | 20799.3 |
139 | 2020-01-25 08:37:22 | violation | 1 | 81242 | 2 | 1.450 | 56029.0 |
138 | 2020-01-22 05:29:41 | violation | 1 | 81242 | 2 | 3.220 | 25230.4 |
137 | 2020-01-16 19:38:58 | violation | 3 | 148641 | 132 | 7.203 | 20636.0 |
136 | 2020-01-16 14:15:46 | violation | 3 | 148641 | 132 | 14.890 | 9982.6 |
135 | 2020-01-16 13:05:51 | violation | 2 | 121436 | 17 | 3.216 | 37760.0 |
134 | 2020-01-16 11:58:05 | violation | 3 | 148641 | 132 | 12.390 | 11996.9 |
133 | 2020-01-16 11:57:37 | violation | 2 | 121436 | 17 | 3.873 | 31354.5 |
132 | 2020-01-16 09:36:06 | violation | 1 | 81242 | 2 | 1.436 | 56575.2 |
131 | 2020-01-16 08:34:01 | violation | 1 | 81242 | 2 | 1.423 | 57092.1 |
130 | 2020-01-16 07:34:08 | violation | 1 | 81242 | 2 | 1.343 | 60492.9 |
129 | 2020-01-01 10:02:52 | violation | 1 | 81242 | 2 | 1.420 | 57212.7 |
128 | 2019-12-31 00:46:51 | violation | 1 | 81242 | 2 | 1.420 | 57212.7 |
127 | 2019-11-24 08:59:43 | violation | 1 | 81242 | 2 | 1.296 | 62686.7 |
126 | 2019-08-25 14:01:31 | violation | 1 | 81242 | 2 | 1.170 | 69437.6 |
125 | 2019-05-16 12:03:01 | violation | 1 | 81242 | 2 | 1.356 | 59913.0 |
124 | 2019-05-15 19:12:40 | violation | 3 | 148641 | 132 | 6.596 | 22535.0 |
123 | 2019-04-24 02:59:03 | violation | 3 | 148641 | 132 | 6.283 | 23657.6 |
122 | 2019-04-16 08:32:52 | violation | 3 | 148641 | 132 | 6.220 | 23897.3 |
121 | 2019-04-08 11:23:05 | violation | 3 | 148641 | 132 | 6.020 | 24691.2 |
120 | 2019-04-02 22:21:21 | violation | 3 | 148641 | 132 | 6.273 | 23695.4 |
119 | 2019-03-09 11:34:20 | violation | 3 | 148641 | 132 | 6.420 | 23152.8 |
118 | 2019-02-21 00:11:49 | violation | 1 | 81242 | 2 | 1.340 | 60628.4 |
117 | 2019-02-18 11:13:56 | violation | 3 | 148641 | 132 | 7.036 | 21125.8 |
116 | 2019-02-10 18:05:02 | violation | 3 | 148641 | 132 | 6.600 | 22521.4 |
115 | 2019-02-04 21:57:08 | violation | 3 | 148641 | 132 | 7.920 | 18767.8 |
114 | 2019-02-04 08:14:14 | violation | 3 | 148641 | 132 | 10.946 | 13579.5 |
113 | 2019-01-29 04:45:00 | violation | 1 | 81242 | 2 | 1.183 | 68674.6 |
112 | 2019-01-25 10:40:07 | violation | 1 | 81242 | 2 | 1.340 | 60628.4 |