History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"lightings"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
208 | 2024-05-09 14:24:08 | lightings | 1 | 81242 | 5 | 1.483 | 54782.2 |
207 | 2024-05-07 02:57:27 | lightings | 1 | 81242 | 5 | 1.390 | 58447.5 |
206 | 2024-05-04 17:01:44 | lightings | 1 | 81242 | 5 | 1.453 | 55913.3 |
205 | 2024-05-01 19:06:15 | lightings | 1 | 81242 | 5 | 1.346 | 60358.1 |
204 | 2024-04-12 11:36:05 | lightings | 3 | 148641 | 101 | 11.266 | 13193.8 |
203 | 2024-04-08 07:37:42 | lightings | 1 | 81242 | 5 | 2.106 | 38576.4 |
202 | 2024-04-08 01:07:25 | lightings | 3 | 148641 | 101 | 10.483 | 14179.2 |
201 | 2024-04-04 05:27:16 | lightings | 1 | 81242 | 5 | 3.140 | 25873.2 |
200 | 2024-04-04 05:26:33 | lightings | 3 | 148641 | 101 | 22.250 | 6680.5 |
199 | 2024-04-04 05:26:34 | lightings | 2 | 121436 | 21 | 8.346 | 14550.2 |
198 | 2024-04-04 05:26:26 | lightings | 1 | 81242 | 5 | 1.500 | 54161.3 |
197 | 2024-03-05 19:08:35 | lightings | 3 | 148641 | 101 | 25.956 | 5726.7 |
196 | 2024-03-04 13:46:08 | lightings | 3 | 148641 | 101 | 28.423 | 5229.6 |
195 | 2024-03-04 13:46:10 | lightings | 2 | 121436 | 21 | 8.170 | 14863.6 |
194 | 2024-03-04 11:27:45 | lightings | 1 | 81242 | 5 | 1.423 | 57092.1 |
193 | 2024-02-29 05:40:43 | lightings | 1 | 81242 | 5 | 1.313 | 61875.1 |
192 | 2024-02-18 09:13:03 | lightings | 3 | 148641 | 101 | 11.016 | 13493.2 |
191 | 2024-02-04 11:37:43 | lightings | 3 | 148641 | 101 | 15.940 | 9325.0 |
190 | 2024-02-03 05:49:41 | lightings | 3 | 148641 | 101 | 17.390 | 8547.5 |
189 | 2024-02-03 05:49:46 | lightings | 2 | 121436 | 21 | 5.813 | 20890.4 |
188 | 2024-02-02 02:27:32 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
187 | 2024-01-29 13:52:22 | lightings | 1 | 81242 | 5 | 1.356 | 59913.0 |
186 | 2024-01-26 05:43:41 | lightings | 1 | 81242 | 5 | 1.360 | 59736.8 |
185 | 2024-01-02 07:08:43 | lightings | 1 | 81242 | 5 | 1.373 | 59171.2 |
184 | 2023-12-11 20:03:52 | lightings | 3 | 148641 | 101 | 5.796 | 25645.4 |
183 | 2023-11-22 04:54:07 | lightings | 1 | 81242 | 5 | 1.236 | 65729.8 |
182 | 2023-11-16 07:34:25 | lightings | 1 | 81242 | 5 | 1.546 | 52549.8 |
181 | 2023-11-06 23:23:57 | lightings | 1 | 81242 | 5 | 1.216 | 66810.9 |
180 | 2023-10-31 19:12:13 | lightings | 1 | 81242 | 5 | 1.423 | 57092.1 |
179 | 2023-10-27 02:52:49 | lightings | 1 | 81242 | 5 | 1.423 | 57092.1 |
178 | 2023-09-12 00:42:46 | lightings | 3 | 148641 | 101 | 5.796 | 25645.4 |
177 | 2023-09-08 04:56:11 | lightings | 1 | 81242 | 5 | 1.280 | 63470.3 |
176 | 2023-07-18 14:20:28 | lightings | 1 | 81242 | 5 | 1.216 | 66810.9 |
175 | 2023-07-14 18:13:28 | lightings | 1 | 81242 | 5 | 1.326 | 61268.5 |
174 | 2023-06-16 02:43:37 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
173 | 2023-06-12 23:04:21 | lightings | 3 | 148641 | 101 | 5.673 | 26201.5 |
172 | 2023-03-30 21:37:32 | lightings | 1 | 81242 | 5 | 1.313 | 61875.1 |
171 | 2023-03-26 22:50:37 | lightings | 1 | 81242 | 5 | 1.343 | 60492.9 |
170 | 2023-03-15 21:58:32 | lightings | 3 | 148641 | 101 | 6.860 | 21667.8 |
169 | 2023-01-15 03:24:00 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
168 | 2022-12-19 13:01:55 | lightings | 3 | 148641 | 101 | 5.750 | 25850.6 |
167 | 2022-12-02 00:04:27 | lightings | 1 | 81242 | 5 | 1.453 | 55913.3 |
166 | 2022-11-28 16:57:51 | lightings | 1 | 81242 | 5 | 1.266 | 64172.2 |
165 | 2022-11-07 02:17:20 | lightings | 1 | 81242 | 5 | 1.360 | 59736.8 |
164 | 2022-09-20 00:42:27 | lightings | 1 | 81242 | 5 | 1.326 | 61268.5 |
163 | 2022-08-17 13:32:30 | lightings | 3 | 148641 | 101 | 5.813 | 25570.4 |
162 | 2022-08-16 02:16:08 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
161 | 2022-08-14 21:07:35 | lightings | 1 | 81242 | 5 | 1.300 | 62493.8 |
160 | 2022-08-06 08:41:10 | lightings | 1 | 81242 | 5 | 1.330 | 61084.2 |
159 | 2022-07-29 05:20:00 | lightings | 1 | 81242 | 5 | 1.250 | 64993.6 |
158 | 2022-07-29 04:59:54 | lightings | 1 | 81242 | 5 | 1.440 | 56418.1 |
157 | 2022-07-25 18:43:21 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
156 | 2022-07-18 15:32:05 | lightings | 1 | 81242 | 5 | 1.283 | 63321.9 |
155 | 2022-07-17 20:16:07 | lightings | 1 | 81242 | 5 | 1.170 | 69437.6 |
154 | 2022-07-10 12:44:50 | lightings | 2 | 121436 | 21 | 3.030 | 40077.9 |
153 | 2022-07-10 10:22:08 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
152 | 2022-07-03 01:54:21 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
151 | 2022-07-02 19:41:34 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
150 | 2022-06-28 02:20:31 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
149 | 2022-03-31 06:53:02 | lightings | 1 | 81242 | 5 | 1.310 | 62016.8 |
148 | 2022-02-24 14:24:58 | lightings | 1 | 81242 | 5 | 1.250 | 64993.6 |
147 | 2021-12-15 17:28:14 | lightings | 1 | 81242 | 5 | 1.360 | 59736.8 |
146 | 2021-12-13 15:35:48 | lightings | 1 | 81242 | 5 | 1.420 | 57212.7 |
145 | 2021-12-10 09:00:26 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
144 | 2021-08-27 10:25:15 | lightings | 1 | 81242 | 5 | 1.373 | 59171.2 |
143 | 2021-08-24 02:46:04 | lightings | 1 | 81242 | 5 | 1.310 | 62016.8 |
142 | 2021-05-20 01:51:55 | lightings | 1 | 81242 | 5 | 1.360 | 59736.8 |
141 | 2021-02-17 07:21:46 | lightings | 1 | 81242 | 5 | 1.343 | 60492.9 |
140 | 2020-12-24 21:39:17 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
139 | 2020-11-13 01:15:07 | lightings | 1 | 81242 | 5 | 1.266 | 64172.2 |
138 | 2020-11-02 10:27:12 | lightings | 1 | 81242 | 5 | 1.406 | 57782.4 |
137 | 2020-08-24 23:50:53 | lightings | 1 | 81242 | 5 | 1.330 | 61084.2 |
136 | 2020-08-06 06:24:31 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
135 | 2020-08-03 19:34:54 | lightings | 1 | 81242 | 5 | 1.376 | 59042.2 |
134 | 2020-05-04 19:44:49 | lightings | 1 | 81242 | 5 | 1.220 | 66591.8 |
133 | 2020-03-21 22:41:04 | lightings | 1 | 81242 | 5 | 1.360 | 59736.8 |
132 | 2020-02-23 11:29:04 | lightings | 1 | 81242 | 5 | 1.516 | 53589.7 |
131 | 2020-02-19 18:43:25 | lightings | 1 | 81242 | 5 | 1.420 | 57212.7 |
130 | 2020-02-15 01:31:20 | lightings | 1 | 81242 | 5 | 4.406 | 18438.9 |
129 | 2020-02-13 15:48:57 | lightings | 1 | 81242 | 5 | 1.530 | 53099.3 |
128 | 2020-02-05 10:58:23 | lightings | 1 | 81242 | 5 | 1.483 | 54782.2 |
127 | 2020-02-05 02:30:50 | lightings | 1 | 81242 | 5 | 2.780 | 29223.7 |
126 | 2020-02-02 13:31:34 | lightings | 1 | 81242 | 5 | 1.203 | 67532.8 |
125 | 2020-01-30 13:58:17 | lightings | 1 | 81242 | 5 | 1.343 | 60492.9 |
124 | 2020-01-26 18:55:47 | lightings | 1 | 81242 | 5 | 2.953 | 27511.7 |
123 | 2020-01-22 10:36:54 | lightings | 1 | 81242 | 5 | 3.360 | 24179.2 |
122 | 2020-01-22 09:45:22 | lightings | 1 | 81242 | 5 | 1.450 | 56029.0 |
121 | 2020-01-16 07:08:32 | lightings | 1 | 81242 | 5 | 1.436 | 56575.2 |
120 | 2020-01-12 00:12:51 | lightings | 1 | 81242 | 5 | 1.563 | 51978.2 |
119 | 2020-01-09 18:27:00 | lightings | 1 | 81242 | 5 | 1.373 | 59171.2 |
118 | 2019-12-31 17:44:47 | lightings | 1 | 81242 | 5 | 1.296 | 62686.7 |
117 | 2019-12-30 19:26:21 | lightings | 1 | 81242 | 5 | 1.623 | 50056.7 |
116 | 2019-10-29 11:27:37 | lightings | 1 | 81242 | 5 | 1.326 | 61268.5 |
115 | 2019-07-31 12:29:58 | lightings | 1 | 81242 | 5 | 1.370 | 59300.7 |
114 | 2019-04-27 09:40:53 | lightings | 1 | 81242 | 5 | 1.313 | 61875.1 |
113 | 2019-01-13 13:28:00 | lightings | 1 | 81242 | 5 | 1.166 | 69675.8 |
112 | 2019-01-09 02:11:59 | lightings | 1 | 81242 | 5 | 1.416 | 57374.3 |
111 | 2019-01-04 11:41:27 | lightings | 1 | 81242 | 5 | 1.243 | 65359.6 |
110 | 2019-01-01 03:43:03 | lightings | 1 | 81242 | 5 | 1.453 | 55913.3 |
109 | 2018-12-29 07:10:24 | lightings | 1 | 81242 | 5 | 1.150 | 70645.2 |