History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"shellfish"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
200 | 2024-04-11 11:11:09 | shellfish | 1 | 81242 | 2 | 1.250 | 64993.6 |
199 | 2024-04-10 02:43:27 | shellfish | 1 | 81242 | 2 | 1.546 | 52549.8 |
198 | 2024-03-31 22:46:04 | shellfish | 1 | 81242 | 2 | 1.906 | 42624.3 |
197 | 2024-03-31 22:36:26 | shellfish | 4 | 165329 | 196 | 30.033 | 5504.9 |
196 | 2024-03-31 22:36:26 | shellfish | 3 | 148641 | 30 | 17.563 | 8463.3 |
195 | 2024-03-31 22:36:26 | shellfish | 2 | 121436 | 7 | 12.346 | 9836.1 |
194 | 2024-03-31 22:31:44 | shellfish | 1 | 81242 | 2 | 3.546 | 22910.9 |
193 | 2024-03-12 09:40:13 | shellfish | 3 | 148641 | 30 | 25.656 | 5793.6 |
192 | 2024-03-12 09:40:11 | shellfish | 2 | 121436 | 7 | 12.690 | 9569.4 |
191 | 2024-03-12 09:39:56 | shellfish | 4 | 165329 | 196 | 26.173 | 6316.8 |
190 | 2024-03-12 06:06:33 | shellfish | 1 | 81242 | 2 | 2.546 | 31909.7 |
189 | 2024-03-09 19:42:52 | shellfish | 1 | 81242 | 2 | 1.500 | 54161.3 |
188 | 2024-03-09 18:54:22 | shellfish | 3 | 148641 | 30 | 27.860 | 5335.3 |
187 | 2024-03-09 18:54:24 | shellfish | 2 | 121436 | 7 | 16.253 | 7471.6 |
186 | 2024-03-09 18:54:23 | shellfish | 3 | 148641 | 30 | 9.156 | 16234.3 |
185 | 2024-03-09 18:29:06 | shellfish | 1 | 81242 | 2 | 2.170 | 37438.7 |
184 | 2024-02-28 04:16:19 | shellfish | 1 | 81242 | 2 | 3.530 | 23014.7 |
183 | 2024-02-21 02:45:18 | shellfish | 3 | 148641 | 30 | 34.923 | 4256.2 |
182 | 2024-02-21 02:45:20 | shellfish | 2 | 121436 | 7 | 4.360 | 27852.3 |
181 | 2024-02-20 19:35:01 | shellfish | 1 | 81242 | 2 | 1.576 | 51549.5 |
180 | 2024-02-20 12:51:49 | shellfish | 1 | 81242 | 2 | 4.876 | 16661.6 |
179 | 2024-02-08 09:46:17 | shellfish | 1 | 81242 | 2 | 6.123 | 13268.3 |
178 | 2024-02-02 07:33:35 | shellfish | 1 | 81242 | 2 | 1.250 | 64993.6 |
177 | 2024-01-28 11:26:07 | shellfish | 1 | 81242 | 2 | 1.376 | 59042.2 |
176 | 2024-01-24 21:39:59 | shellfish | 4 | 165329 | 196 | 11.923 | 13866.4 |
175 | 2024-01-16 04:11:50 | shellfish | 1 | 81242 | 2 | 1.450 | 56029.0 |
174 | 2024-01-13 03:58:03 | shellfish | 1 | 81242 | 2 | 1.440 | 56418.1 |
173 | 2024-01-09 14:50:46 | shellfish | 1 | 81242 | 2 | 1.313 | 61875.1 |
172 | 2023-12-01 06:54:16 | shellfish | 1 | 81242 | 2 | 1.373 | 59171.2 |
171 | 2023-11-19 13:44:48 | shellfish | 1 | 81242 | 2 | 1.466 | 55417.5 |
170 | 2023-11-19 04:49:00 | shellfish | 4 | 165329 | 196 | 21.220 | 7791.2 |
169 | 2023-11-04 05:11:49 | shellfish | 1 | 81242 | 2 | 1.280 | 63470.3 |
168 | 2023-11-03 00:48:25 | shellfish | 4 | 165329 | 196 | 10.860 | 15223.7 |
167 | 2023-09-10 16:58:03 | shellfish | 1 | 81242 | 2 | 1.533 | 52995.4 |
166 | 2023-08-26 13:55:46 | shellfish | 1 | 81242 | 2 | 1.483 | 54782.2 |
165 | 2023-08-10 13:00:54 | shellfish | 4 | 165329 | 196 | 11.076 | 14926.8 |
164 | 2023-05-31 17:25:47 | shellfish | 1 | 81242 | 2 | 1.203 | 67532.8 |
163 | 2023-04-23 22:16:33 | shellfish | 4 | 165329 | 196 | 10.440 | 15836.1 |
162 | 2023-04-07 22:32:17 | shellfish | 1 | 81242 | 2 | 1.233 | 65889.7 |
161 | 2023-03-25 15:02:22 | shellfish | 1 | 81242 | 2 | 1.216 | 66810.9 |
160 | 2023-01-28 17:54:25 | shellfish | 4 | 165329 | 196 | 10.140 | 16304.6 |
159 | 2023-01-09 11:18:45 | shellfish | 1 | 81242 | 2 | 1.346 | 60358.1 |
158 | 2022-11-19 06:58:10 | shellfish | 1 | 81242 | 2 | 1.376 | 59042.2 |
157 | 2022-11-10 11:47:47 | shellfish | 4 | 165329 | 196 | 10.860 | 15223.7 |
156 | 2022-10-13 05:12:10 | shellfish | 1 | 81242 | 2 | 1.406 | 57782.4 |
155 | 2022-06-12 23:23:45 | shellfish | 1 | 81242 | 2 | 1.233 | 65889.7 |
154 | 2022-06-12 05:22:17 | shellfish | 4 | 165329 | 196 | 11.173 | 14797.2 |
153 | 2022-05-28 18:32:59 | shellfish | 1 | 81242 | 2 | 1.220 | 66591.8 |
152 | 2022-05-26 12:43:54 | shellfish | 1 | 81242 | 2 | 1.233 | 65889.7 |
151 | 2022-01-02 09:30:33 | shellfish | 1 | 81242 | 2 | 1.453 | 55913.3 |
150 | 2021-08-28 04:02:43 | shellfish | 1 | 81242 | 2 | 1.250 | 64993.6 |
149 | 2021-04-30 06:01:16 | shellfish | 1 | 81242 | 2 | 2.513 | 32328.7 |
148 | 2021-01-18 09:17:32 | shellfish | 1 | 81242 | 2 | 1.296 | 62686.7 |
147 | 2021-01-08 14:20:39 | shellfish | 1 | 81242 | 2 | 1.250 | 64993.6 |
146 | 2020-11-12 18:29:32 | shellfish | 1 | 81242 | 2 | 1.623 | 50056.7 |
145 | 2020-10-28 23:50:49 | shellfish | 1 | 81242 | 2 | 1.330 | 61084.2 |
144 | 2020-10-14 09:58:52 | shellfish | 1 | 81242 | 2 | 1.266 | 64172.2 |
143 | 2020-10-08 19:47:26 | shellfish | 1 | 81242 | 2 | 1.296 | 62686.7 |
142 | 2020-09-27 06:54:10 | shellfish | 1 | 81242 | 2 | 1.373 | 59171.2 |
141 | 2020-08-29 17:45:58 | shellfish | 1 | 81242 | 2 | 1.313 | 61875.1 |
140 | 2020-08-28 07:41:02 | shellfish | 1 | 81242 | 2 | 1.313 | 61875.1 |
139 | 2020-06-17 01:38:16 | shellfish | 1 | 81242 | 2 | 1.406 | 57782.4 |
138 | 2020-03-27 05:51:25 | shellfish | 1 | 81242 | 2 | 2.970 | 27354.2 |
137 | 2020-02-26 19:35:37 | shellfish | 1 | 81242 | 2 | 1.390 | 58447.5 |
136 | 2020-02-18 04:33:41 | shellfish | 1 | 81242 | 2 | 1.530 | 53099.3 |
135 | 2020-02-08 15:02:13 | shellfish | 1 | 81242 | 2 | 3.186 | 25499.7 |
134 | 2020-02-04 17:24:33 | shellfish | 1 | 81242 | 2 | 4.716 | 17226.9 |
133 | 2020-02-03 17:23:14 | shellfish | 1 | 81242 | 2 | 1.406 | 57782.4 |
132 | 2020-02-03 16:19:17 | shellfish | 1 | 81242 | 2 | 2.483 | 32719.3 |
131 | 2020-01-25 09:16:24 | shellfish | 1 | 81242 | 2 | 1.640 | 49537.8 |
130 | 2020-01-17 19:55:49 | shellfish | 1 | 81242 | 2 | 3.216 | 25261.8 |
129 | 2020-01-07 21:35:57 | shellfish | 1 | 81242 | 2 | 1.466 | 55417.5 |
128 | 2020-01-04 18:35:51 | shellfish | 1 | 81242 | 2 | 1.453 | 55913.3 |
127 | 2019-11-24 21:53:05 | shellfish | 1 | 81242 | 2 | 1.360 | 59736.8 |
126 | 2019-10-05 05:24:51 | shellfish | 1 | 81242 | 2 | 1.226 | 66265.9 |
125 | 2019-09-18 09:55:50 | shellfish | 1 | 81242 | 2 | 1.240 | 65517.7 |
124 | 2019-09-10 01:25:48 | shellfish | 1 | 81242 | 2 | 1.180 | 68849.2 |
123 | 2019-08-26 03:20:56 | shellfish | 1 | 81242 | 2 | 1.200 | 67701.7 |
122 | 2019-05-07 13:47:07 | shellfish | 1 | 81242 | 2 | 1.436 | 56575.2 |
121 | 2019-02-13 03:13:22 | shellfish | 1 | 81242 | 2 | 1.300 | 62493.8 |
120 | 2019-02-02 00:37:44 | shellfish | 1 | 81242 | 2 | 1.386 | 58616.2 |
119 | 2019-01-28 11:20:22 | shellfish | 1 | 81242 | 2 | 1.323 | 61407.4 |
118 | 2019-01-05 05:23:00 | shellfish | 1 | 81242 | 2 | 1.390 | 58447.5 |
117 | 2019-01-01 21:21:27 | shellfish | 1 | 81242 | 2 | 1.216 | 66810.9 |
116 | 2018-10-17 14:00:05 | shellfish | 1 | 81242 | 2 | 1.240 | 65517.7 |
115 | 2018-09-22 09:20:50 | shellfish | 1 | 81242 | 2 | 1.230 | 66050.4 |
114 | 2018-09-13 11:18:32 | shellfish | 1 | 81242 | 2 | 1.503 | 54053.2 |
113 | 2018-08-17 23:50:47 | shellfish | 1 | 81242 | 2 | 1.270 | 63970.1 |
112 | 2018-07-09 00:52:02 | shellfish | 1 | 81242 | 2 | 1.590 | 51095.6 |
111 | 2018-07-08 23:50:37 | shellfish | 1 | 81242 | 2 | 1.376 | 59042.2 |
110 | 2018-06-23 05:06:01 | shellfish | 1 | 81242 | 2 | 1.406 | 57782.4 |
109 | 2018-06-20 15:51:05 | shellfish | 1 | 81242 | 2 | 3.020 | 26901.3 |
108 | 2018-06-20 12:17:08 | shellfish | 1 | 81242 | 2 | 1.623 | 50056.7 |
107 | 2018-04-07 06:00:40 | shellfish | 1 | 81242 | 2 | 1.700 | 47789.4 |
106 | 2018-04-07 05:58:51 | shellfish | 1 | 81242 | 2 | 3.366 | 24136.1 |
105 | 2018-02-20 09:41:43 | shellfish | 1 | 81242 | 2 | 1.956 | 41534.8 |
104 | 2017-09-07 01:57:24 | shellfish | 1 | 81242 | 2 | 1.673 | 48560.7 |
103 | 2017-07-01 12:02:08 | shellfish | 1 | 81242 | 2 | 1.653 | 49148.2 |
102 | 2017-06-22 14:41:43 | shellfish | 1 | 81242 | 2 | 1.743 | 46610.4 |
101 | 2017-06-04 00:04:30 | shellfish | 1 | 81242 | 2 | 2.203 | 36877.9 |