History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"preamble"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
209 | 2024-06-03 19:54:56 | preamble | 1 | 82945 | 3 | 4.656 | 17814.6 |
208 | 2024-06-02 08:20:24 | preamble | 1 | 82945 | 3 | 3.016 | 27501.7 |
207 | 2024-06-02 08:20:20 | preamble | 2 | 121059 | 6 | 4.126 | 29340.5 |
206 | 2024-05-15 09:37:33 | preamble | 3 | 146162 | 102 | 16.830 | 8684.6 |
205 | 2024-05-15 01:14:03 | preamble | 3 | 146162 | 102 | 24.986 | 5849.8 |
204 | 2024-05-13 11:59:10 | preamble | 3 | 146162 | 102 | 18.033 | 8105.3 |
203 | 2024-05-12 20:41:36 | preamble | 3 | 146162 | 102 | 8.360 | 17483.5 |
202 | 2024-05-12 20:41:37 | preamble | 2 | 121059 | 6 | 4.796 | 25241.7 |
201 | 2024-05-12 20:41:25 | preamble | 3 | 146162 | 102 | 9.096 | 16068.8 |
200 | 2024-05-12 20:41:32 | preamble | 1 | 82945 | 3 | 1.513 | 54821.5 |
199 | 2024-05-12 20:41:23 | preamble | 2 | 121059 | 6 | 3.936 | 30756.9 |
198 | 2024-05-12 20:41:21 | preamble | 1 | 82945 | 3 | 3.156 | 26281.7 |
197 | 2024-05-09 00:38:57 | preamble | 1 | 82945 | 3 | 4.953 | 16746.4 |
196 | 2024-05-08 06:45:02 | preamble | 1 | 82945 | 3 | 1.670 | 49667.7 |
195 | 2024-05-05 02:48:56 | preamble | 1 | 82945 | 3 | 1.440 | 57600.7 |
194 | 2024-04-12 19:35:25 | preamble | 3 | 146162 | 102 | 10.640 | 13737.0 |
193 | 2024-04-12 00:01:37 | preamble | 3 | 146162 | 102 | 24.313 | 6011.7 |
192 | 2024-04-11 13:52:40 | preamble | 2 | 121059 | 6 | 4.016 | 30144.2 |
191 | 2024-04-11 05:35:19 | preamble | 3 | 146162 | 102 | 7.766 | 18820.8 |
190 | 2024-04-10 06:28:57 | preamble | 3 | 146162 | 102 | 8.500 | 17195.5 |
189 | 2024-04-10 06:28:56 | preamble | 2 | 121059 | 6 | 3.986 | 30371.0 |
188 | 2024-04-10 06:28:54 | preamble | 1 | 82945 | 3 | 1.593 | 52068.4 |
187 | 2024-04-08 08:53:14 | preamble | 1 | 82945 | 3 | 6.216 | 13343.8 |
186 | 2024-04-07 12:22:31 | preamble | 1 | 82945 | 3 | 4.326 | 19173.6 |
185 | 2024-03-30 21:40:03 | preamble | 1 | 82945 | 3 | 3.376 | 24569.0 |
184 | 2024-03-07 09:20:50 | preamble | 3 | 146162 | 102 | 22.236 | 6573.2 |
183 | 2024-03-06 15:46:04 | preamble | 2 | 121059 | 6 | 9.250 | 13087.5 |
182 | 2024-03-06 08:12:45 | preamble | 3 | 146162 | 102 | 24.910 | 5867.6 |
181 | 2024-03-06 02:03:19 | preamble | 3 | 146162 | 102 | 19.626 | 7447.4 |
180 | 2024-03-05 20:14:13 | preamble | 3 | 146162 | 102 | 17.923 | 8155.0 |
179 | 2024-03-05 20:14:11 | preamble | 2 | 121059 | 6 | 13.423 | 9018.8 |
178 | 2024-03-05 19:43:47 | preamble | 1 | 82945 | 3 | 1.533 | 54106.3 |
177 | 2024-03-01 10:05:15 | preamble | 1 | 82945 | 3 | 3.360 | 24686.0 |
176 | 2024-01-30 00:53:39 | preamble | 1 | 82945 | 3 | 3.030 | 27374.6 |
175 | 2024-01-15 08:37:12 | preamble | 1 | 82945 | 3 | 1.500 | 55296.7 |
174 | 2024-01-14 20:34:58 | preamble | 1 | 82945 | 3 | 1.403 | 59119.7 |
173 | 2024-01-10 14:42:37 | preamble | 3 | 146162 | 102 | 8.093 | 18060.3 |
172 | 2024-01-10 14:42:36 | preamble | 2 | 121059 | 6 | 3.970 | 30493.5 |
171 | 2024-01-05 06:35:42 | preamble | 3 | 146162 | 102 | 6.783 | 21548.3 |
170 | 2024-01-05 06:35:39 | preamble | 2 | 121059 | 6 | 3.346 | 36180.2 |
169 | 2023-11-20 15:10:06 | preamble | 1 | 82945 | 3 | 1.360 | 60989.0 |
168 | 2023-11-16 22:42:08 | preamble | 1 | 82945 | 3 | 1.453 | 57085.3 |
167 | 2023-11-14 08:02:22 | preamble | 1 | 82945 | 3 | 1.296 | 64000.8 |
166 | 2023-11-10 04:25:55 | preamble | 1 | 82945 | 3 | 1.280 | 64800.8 |
165 | 2023-11-03 06:30:43 | preamble | 1 | 82945 | 3 | 1.313 | 63172.1 |
164 | 2023-10-18 08:57:59 | preamble | 1 | 82945 | 3 | 1.423 | 58288.8 |
163 | 2023-09-10 19:37:38 | preamble | 1 | 82945 | 3 | 1.453 | 57085.3 |
162 | 2023-09-08 07:07:19 | preamble | 1 | 82945 | 3 | 1.440 | 57600.7 |
161 | 2023-08-30 09:06:12 | preamble | 1 | 82945 | 3 | 1.546 | 53651.4 |
160 | 2023-06-01 14:44:10 | preamble | 1 | 82945 | 3 | 1.780 | 46598.3 |
159 | 2023-05-08 10:06:33 | preamble | 1 | 82945 | 3 | 1.280 | 64800.8 |
158 | 2023-03-24 14:05:42 | preamble | 1 | 82945 | 3 | 1.250 | 66356.0 |
157 | 2023-01-14 22:10:29 | preamble | 1 | 82945 | 3 | 1.390 | 59672.7 |
156 | 2023-01-09 09:16:39 | preamble | 1 | 82945 | 3 | 1.373 | 60411.5 |
155 | 2022-10-11 13:11:50 | preamble | 1 | 82945 | 3 | 1.283 | 64649.3 |
154 | 2022-09-09 08:06:50 | preamble | 1 | 82945 | 3 | 1.296 | 64000.8 |
153 | 2022-07-19 01:51:22 | preamble | 1 | 82945 | 3 | 1.343 | 61761.0 |
152 | 2022-05-25 01:28:18 | preamble | 1 | 82945 | 3 | 1.310 | 63316.8 |
151 | 2022-04-30 00:29:08 | preamble | 1 | 82945 | 3 | 1.280 | 64800.8 |
150 | 2022-01-06 12:36:03 | preamble | 1 | 82945 | 3 | 1.483 | 55930.5 |
149 | 2021-09-20 20:02:54 | preamble | 1 | 82945 | 3 | 1.420 | 58412.0 |
148 | 2020-11-29 20:47:53 | preamble | 1 | 82945 | 3 | 1.326 | 62552.8 |
147 | 2020-10-10 15:00:34 | preamble | 1 | 82945 | 3 | 1.280 | 64800.8 |
146 | 2020-03-24 04:44:10 | preamble | 1 | 82945 | 3 | 1.453 | 57085.3 |
145 | 2020-03-21 16:14:40 | preamble | 1 | 82945 | 3 | 1.593 | 52068.4 |
144 | 2020-03-10 05:51:57 | preamble | 1 | 82945 | 3 | 1.313 | 63172.1 |
143 | 2020-03-05 16:42:46 | preamble | 3 | 146162 | 102 | 7.423 | 19690.4 |
142 | 2020-03-04 09:32:16 | preamble | 3 | 146162 | 102 | 14.876 | 9825.4 |
141 | 2020-03-02 09:33:07 | preamble | 1 | 82945 | 3 | 1.470 | 56425.2 |
140 | 2020-02-24 08:17:22 | preamble | 1 | 82945 | 3 | 1.703 | 48705.2 |
139 | 2020-02-19 15:17:05 | preamble | 1 | 82945 | 3 | 1.530 | 54212.4 |
138 | 2020-02-15 05:47:46 | preamble | 1 | 82945 | 3 | 4.453 | 18626.8 |
137 | 2020-02-15 01:37:04 | preamble | 1 | 82945 | 3 | 2.653 | 31264.6 |
136 | 2020-02-09 23:20:35 | preamble | 3 | 146162 | 102 | 9.093 | 16074.1 |
135 | 2020-02-08 14:46:42 | preamble | 3 | 146162 | 102 | 9.440 | 15483.3 |
134 | 2020-02-04 01:42:09 | preamble | 1 | 82945 | 3 | 1.703 | 48705.2 |
133 | 2020-01-24 05:57:44 | preamble | 2 | 121059 | 6 | 3.876 | 31233.0 |
132 | 2020-01-24 02:41:17 | preamble | 1 | 82945 | 3 | 3.670 | 22600.8 |
131 | 2020-01-24 01:35:26 | preamble | 1 | 82945 | 3 | 1.610 | 51518.6 |
130 | 2020-01-23 04:13:24 | preamble | 1 | 82945 | 3 | 1.686 | 49196.3 |
129 | 2020-01-20 11:19:25 | preamble | 3 | 146162 | 102 | 22.656 | 6451.4 |
128 | 2020-01-20 00:23:53 | preamble | 2 | 121059 | 6 | 3.343 | 36212.7 |
127 | 2020-01-20 00:20:22 | preamble | 3 | 146162 | 102 | 8.376 | 17450.1 |
126 | 2020-01-19 18:57:24 | preamble | 1 | 82945 | 3 | 1.623 | 51106.0 |
125 | 2020-01-16 17:49:53 | preamble | 1 | 82945 | 3 | 1.593 | 52068.4 |
124 | 2020-01-02 16:14:14 | preamble | 1 | 82945 | 3 | 2.236 | 37095.3 |
123 | 2020-01-02 06:31:21 | preamble | 1 | 82945 | 3 | 1.546 | 53651.4 |
122 | 2019-12-04 09:41:13 | preamble | 1 | 82945 | 3 | 1.280 | 64800.8 |
121 | 2019-09-02 03:59:19 | preamble | 1 | 82945 | 3 | 1.236 | 67107.6 |
120 | 2019-06-02 12:20:57 | preamble | 1 | 82945 | 3 | 1.310 | 63316.8 |
119 | 2019-05-30 10:09:45 | preamble | 1 | 82945 | 3 | 1.286 | 64498.4 |
118 | 2019-02-21 03:48:42 | preamble | 1 | 82945 | 3 | 1.320 | 62837.1 |
117 | 2019-01-19 09:36:55 | preamble | 1 | 82945 | 3 | 1.270 | 65311.0 |
116 | 2019-01-02 12:38:07 | preamble | 1 | 82945 | 3 | 1.253 | 66197.1 |
115 | 2018-12-31 13:57:30 | preamble | 1 | 82945 | 3 | 1.260 | 65829.4 |
114 | 2018-12-29 16:00:11 | preamble | 1 | 82945 | 3 | 1.416 | 58577.0 |
113 | 2018-11-20 00:07:23 | preamble | 1 | 82945 | 3 | 1.240 | 66891.1 |
112 | 2018-11-10 11:01:22 | preamble | 1 | 82945 | 3 | 1.376 | 60279.8 |
111 | 2018-08-09 15:30:20 | preamble | 1 | 82945 | 3 | 1.543 | 53755.7 |
110 | 2018-07-23 02:45:11 | preamble | 1 | 82945 | 3 | 1.290 | 64298.4 |