History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"asphalted"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
198 | 2024-03-20 03:51:00 | asphalted | 2 | 121436 | 5 | 11.720 | 10361.4 |
197 | 2024-03-20 01:57:14 | asphalted | 1 | 81242 | 1 | 2.876 | 28248.3 |
196 | 2024-03-12 09:47:05 | asphalted | 3 | 148641 | 24 | 8.626 | 17231.7 |
195 | 2024-03-08 08:53:30 | asphalted | 3 | 148641 | 24 | 23.096 | 6435.8 |
194 | 2024-03-08 08:53:22 | asphalted | 2 | 121436 | 5 | 8.470 | 14337.2 |
193 | 2024-03-05 04:07:56 | asphalted | 4 | 165329 | 336 | 20.890 | 7914.3 |
192 | 2024-03-03 18:46:02 | asphalted | 3 | 148641 | 24 | 8.956 | 16596.8 |
191 | 2024-03-03 18:45:30 | asphalted | 4 | 165329 | 336 | 23.206 | 7124.4 |
190 | 2024-03-03 18:45:27 | asphalted | 2 | 121436 | 5 | 7.780 | 15608.7 |
189 | 2024-03-03 18:11:11 | asphalted | 1 | 81242 | 1 | 1.373 | 59171.2 |
188 | 2024-03-01 01:35:17 | asphalted | 1 | 81242 | 1 | 1.436 | 56575.2 |
187 | 2024-02-29 05:40:18 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
186 | 2024-02-24 16:59:31 | asphalted | 1 | 81242 | 1 | 1.283 | 63321.9 |
185 | 2024-02-06 21:51:18 | asphalted | 1 | 81242 | 1 | 1.453 | 55913.3 |
184 | 2024-02-06 21:50:58 | asphalted | 3 | 148641 | 24 | 7.780 | 19105.5 |
183 | 2024-02-06 09:53:22 | asphalted | 1 | 81242 | 1 | 1.453 | 55913.3 |
182 | 2024-01-30 06:45:51 | asphalted | 1 | 81242 | 1 | 2.796 | 29056.5 |
181 | 2024-01-21 14:10:46 | asphalted | 3 | 148641 | 24 | 6.563 | 22648.3 |
180 | 2024-01-21 01:07:49 | asphalted | 4 | 165329 | 336 | 10.560 | 15656.2 |
179 | 2024-01-10 09:33:32 | asphalted | 2 | 121436 | 5 | 3.156 | 38477.8 |
178 | 2023-12-14 18:24:42 | asphalted | 1 | 81242 | 1 | 1.470 | 55266.7 |
177 | 2023-12-06 18:49:51 | asphalted | 1 | 81242 | 1 | 1.220 | 66591.8 |
176 | 2023-11-27 00:21:21 | asphalted | 1 | 81242 | 1 | 1.296 | 62686.7 |
175 | 2023-10-31 17:55:07 | asphalted | 4 | 165329 | 336 | 10.233 | 16156.5 |
174 | 2023-10-29 21:16:00 | asphalted | 3 | 148641 | 24 | 6.160 | 24130.0 |
173 | 2023-10-24 16:29:01 | asphalted | 1 | 81242 | 1 | 1.343 | 60492.9 |
172 | 2023-10-17 16:43:13 | asphalted | 2 | 121436 | 5 | 4.013 | 30260.7 |
171 | 2023-10-09 18:32:33 | asphalted | 1 | 81242 | 1 | 1.280 | 63470.3 |
170 | 2023-10-04 01:05:38 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
169 | 2023-09-30 20:34:33 | asphalted | 1 | 81242 | 1 | 1.373 | 59171.2 |
168 | 2023-09-19 23:43:03 | asphalted | 1 | 81242 | 1 | 1.233 | 65889.7 |
167 | 2023-08-09 00:27:50 | asphalted | 4 | 165329 | 336 | 10.140 | 16304.6 |
166 | 2023-08-07 17:53:28 | asphalted | 3 | 148641 | 24 | 7.203 | 20636.0 |
165 | 2023-07-29 07:20:47 | asphalted | 2 | 121436 | 5 | 3.063 | 39646.1 |
164 | 2023-07-12 20:01:30 | asphalted | 1 | 81242 | 1 | 1.283 | 63321.9 |
163 | 2023-05-28 11:12:18 | asphalted | 1 | 81242 | 1 | 1.343 | 60492.9 |
162 | 2023-04-22 09:45:16 | asphalted | 4 | 165329 | 336 | 11.283 | 14652.9 |
161 | 2023-04-18 06:37:55 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
160 | 2023-04-17 18:57:56 | asphalted | 3 | 148641 | 24 | 5.873 | 25309.2 |
159 | 2023-04-07 15:28:40 | asphalted | 2 | 121436 | 5 | 3.046 | 39867.4 |
158 | 2023-02-27 14:02:49 | asphalted | 4 | 165329 | 336 | 10.016 | 16506.5 |
157 | 2023-02-09 18:44:54 | asphalted | 1 | 81242 | 1 | 1.233 | 65889.7 |
156 | 2023-01-27 20:20:30 | asphalted | 3 | 148641 | 24 | 5.873 | 25309.2 |
155 | 2023-01-25 22:40:43 | asphalted | 4 | 165329 | 336 | 10.266 | 16104.5 |
154 | 2023-01-18 03:17:11 | asphalted | 1 | 81242 | 1 | 1.250 | 64993.6 |
153 | 2023-01-11 18:54:06 | asphalted | 2 | 121436 | 5 | 2.983 | 40709.4 |
152 | 2023-01-07 16:34:47 | asphalted | 4 | 165329 | 336 | 11.110 | 14881.1 |
151 | 2022-12-23 23:22:45 | asphalted | 4 | 165329 | 336 | 10.376 | 15933.8 |
150 | 2022-12-12 02:13:52 | asphalted | 4 | 165329 | 336 | 11.716 | 14111.4 |
149 | 2022-12-07 12:30:46 | asphalted | 1 | 81242 | 1 | 1.203 | 67532.8 |
148 | 2022-11-07 02:56:42 | asphalted | 4 | 165329 | 336 | 10.250 | 16129.7 |
147 | 2022-11-05 07:00:54 | asphalted | 3 | 148641 | 24 | 6.830 | 21763.0 |
146 | 2022-10-13 17:56:19 | asphalted | 2 | 121436 | 5 | 3.000 | 40478.7 |
145 | 2022-09-12 10:01:23 | asphalted | 1 | 81242 | 1 | 1.220 | 66591.8 |
144 | 2022-09-08 19:53:19 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
143 | 2022-08-09 07:51:59 | asphalted | 1 | 81242 | 1 | 1.220 | 66591.8 |
142 | 2022-05-15 03:44:38 | asphalted | 3 | 148641 | 24 | 6.250 | 23782.6 |
141 | 2022-05-15 03:19:13 | asphalted | 2 | 121436 | 5 | 3.110 | 39046.9 |
140 | 2022-05-03 17:01:30 | asphalted | 4 | 165329 | 336 | 12.813 | 12903.2 |
139 | 2022-04-19 13:35:03 | asphalted | 1 | 81242 | 1 | 1.440 | 56418.1 |
138 | 2022-04-18 20:24:20 | asphalted | 1 | 81242 | 1 | 1.393 | 58321.6 |
137 | 2021-12-14 17:01:10 | asphalted | 1 | 81242 | 1 | 1.266 | 64172.2 |
136 | 2021-08-18 13:01:54 | asphalted | 1 | 81242 | 1 | 1.250 | 64993.6 |
135 | 2021-05-04 08:49:28 | asphalted | 1 | 81242 | 1 | 1.420 | 57212.7 |
134 | 2021-04-30 19:15:45 | asphalted | 1 | 81242 | 1 | 1.436 | 56575.2 |
133 | 2021-03-25 05:43:23 | asphalted | 2 | 121436 | 5 | 3.703 | 32794.0 |
132 | 2021-02-03 14:08:52 | asphalted | 2 | 121436 | 5 | 3.173 | 38271.7 |
131 | 2021-01-09 10:48:54 | asphalted | 1 | 81242 | 1 | 1.406 | 57782.4 |
130 | 2021-01-02 08:34:40 | asphalted | 1 | 81242 | 1 | 1.250 | 64993.6 |
129 | 2020-10-25 20:05:20 | asphalted | 1 | 81242 | 1 | 1.233 | 65889.7 |
128 | 2020-10-21 21:27:02 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
127 | 2020-09-26 06:27:13 | asphalted | 1 | 81242 | 1 | 1.373 | 59171.2 |
126 | 2020-06-05 13:40:31 | asphalted | 1 | 81242 | 1 | 1.250 | 64993.6 |
125 | 2020-03-25 02:26:04 | asphalted | 1 | 81242 | 1 | 1.610 | 50460.9 |
124 | 2020-02-27 04:50:01 | asphalted | 1 | 81242 | 1 | 1.466 | 55417.5 |
123 | 2020-02-18 17:48:11 | asphalted | 1 | 81242 | 1 | 1.436 | 56575.2 |
122 | 2020-02-08 07:40:58 | asphalted | 1 | 81242 | 1 | 3.156 | 25742.1 |
121 | 2020-02-07 00:11:16 | asphalted | 1 | 81242 | 1 | 2.986 | 27207.6 |
120 | 2020-02-06 00:20:07 | asphalted | 1 | 81242 | 1 | 1.420 | 57212.7 |
119 | 2020-01-31 16:52:13 | asphalted | 1 | 81242 | 1 | 1.453 | 55913.3 |
118 | 2020-01-31 14:00:27 | asphalted | 1 | 81242 | 1 | 3.156 | 25742.1 |
117 | 2020-01-19 02:40:29 | asphalted | 1 | 81242 | 1 | 1.390 | 58447.5 |
116 | 2020-01-11 07:50:50 | asphalted | 1 | 81242 | 1 | 1.500 | 54161.3 |
115 | 2020-01-06 20:05:51 | asphalted | 1 | 81242 | 1 | 1.516 | 53589.7 |
114 | 2019-11-25 06:55:35 | asphalted | 1 | 81242 | 1 | 1.280 | 63470.3 |
113 | 2019-08-26 13:04:45 | asphalted | 1 | 81242 | 1 | 1.356 | 59913.0 |
112 | 2019-05-17 11:38:37 | asphalted | 1 | 81242 | 1 | 1.563 | 51978.2 |
111 | 2019-05-14 08:01:47 | asphalted | 1 | 81242 | 1 | 1.370 | 59300.7 |
110 | 2019-01-20 00:40:02 | asphalted | 1 | 81242 | 1 | 1.336 | 60809.9 |
109 | 2018-09-17 13:37:19 | asphalted | 1 | 81242 | 1 | 1.386 | 58616.2 |
108 | 2018-09-07 16:53:46 | asphalted | 1 | 81242 | 1 | 1.256 | 64683.1 |
107 | 2018-07-13 22:27:54 | asphalted | 3 | 148641 | 24 | 6.396 | 23239.7 |
106 | 2018-06-16 11:11:40 | asphalted | 1 | 81242 | 1 | 1.360 | 59736.8 |
105 | 2018-06-14 18:17:05 | asphalted | 1 | 81242 | 1 | 3.046 | 26671.7 |
104 | 2018-06-13 14:47:53 | asphalted | 1 | 81242 | 1 | 1.616 | 50273.5 |
103 | 2018-04-24 03:24:52 | asphalted | 1 | 81242 | 1 | 1.233 | 65889.7 |
102 | 2018-02-21 00:53:19 | asphalted | 1 | 81242 | 1 | 2.056 | 39514.6 |
101 | 2018-02-19 19:02:05 | asphalted | 1 | 81242 | 1 | 2.800 | 29015.0 |
100 | 2018-02-19 18:06:53 | asphalted | 1 | 81242 | 1 | 2.496 | 32548.9 |
99 | 2017-12-22 17:09:28 | asphalted | 1 | 81242 | 1 | 1.703 | 47705.2 |