History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hotspur"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
202 | 2024-04-13 19:04:04 | hotspur | 1 | 69583 | 2 | 4.530 | 15360.5 |
201 | 2024-03-28 23:27:17 | hotspur | 1 | 69583 | 2 | 1.343 | 51811.6 |
200 | 2024-03-28 10:42:10 | hotspur | 1 | 69583 | 2 | 1.060 | 65644.3 |
199 | 2024-03-02 00:02:04 | hotspur | 2 | 107671 | 3 | 4.343 | 24791.8 |
198 | 2024-03-01 23:57:32 | hotspur | 3 | 134027 | 26 | 7.126 | 18808.2 |
197 | 2024-02-29 22:33:41 | hotspur | 1 | 69583 | 2 | 1.250 | 55666.4 |
196 | 2024-02-29 06:25:33 | hotspur | 1 | 69583 | 2 | 1.063 | 65459.1 |
195 | 2024-02-29 06:25:05 | hotspur | 2 | 107671 | 3 | 5.940 | 18126.4 |
194 | 2024-02-29 06:24:13 | hotspur | 3 | 134027 | 26 | 7.483 | 17910.9 |
193 | 2024-02-25 10:27:34 | hotspur | 3 | 134027 | 26 | 29.363 | 4564.5 |
192 | 2024-02-22 06:43:39 | hotspur | 4 | 151207 | 535 | 18.110 | 8349.4 |
191 | 2024-02-21 22:03:36 | hotspur | 4 | 151207 | 535 | 13.736 | 11008.1 |
190 | 2024-02-18 09:50:03 | hotspur | 4 | 151207 | 535 | 35.830 | 4220.1 |
189 | 2024-02-18 07:29:50 | hotspur | 2 | 107671 | 3 | 5.580 | 19295.9 |
188 | 2024-02-18 02:27:27 | hotspur | 3 | 134027 | 26 | 7.410 | 18087.3 |
187 | 2024-02-17 04:25:29 | hotspur | 4 | 151207 | 535 | 38.190 | 3959.3 |
186 | 2024-02-16 09:21:50 | hotspur | 4 | 151207 | 535 | 14.266 | 10599.1 |
185 | 2024-02-16 07:00:34 | hotspur | 4 | 151207 | 535 | 16.453 | 9190.2 |
184 | 2024-02-16 07:00:35 | hotspur | 3 | 134027 | 26 | 10.813 | 12395.0 |
183 | 2024-02-16 07:00:33 | hotspur | 2 | 107671 | 3 | 5.846 | 18417.9 |
182 | 2024-02-16 05:15:30 | hotspur | 1 | 69583 | 2 | 1.283 | 54234.6 |
181 | 2023-12-08 06:05:46 | hotspur | 1 | 69583 | 2 | 1.266 | 54962.9 |
180 | 2023-12-03 05:33:49 | hotspur | 1 | 69583 | 2 | 1.876 | 37091.2 |
179 | 2023-11-26 23:52:32 | hotspur | 1 | 69583 | 2 | 1.063 | 65459.1 |
178 | 2023-10-21 12:26:26 | hotspur | 1 | 69583 | 2 | 1.686 | 41271.1 |
177 | 2023-09-21 15:37:48 | hotspur | 1 | 69583 | 2 | 1.143 | 60877.5 |
176 | 2023-07-14 20:36:30 | hotspur | 1 | 69583 | 2 | 1.203 | 57841.2 |
175 | 2023-05-25 01:51:18 | hotspur | 1 | 69583 | 2 | 1.030 | 67556.3 |
174 | 2023-05-21 17:56:50 | hotspur | 1 | 69583 | 2 | 1.220 | 57035.2 |
173 | 2023-04-18 22:30:30 | hotspur | 1 | 69583 | 2 | 1.033 | 67360.1 |
172 | 2023-02-03 00:56:03 | hotspur | 1 | 69583 | 2 | 1.173 | 59320.5 |
171 | 2022-12-26 16:31:47 | hotspur | 1 | 69583 | 2 | 1.050 | 66269.5 |
170 | 2022-12-01 05:59:27 | hotspur | 1 | 69583 | 2 | 1.030 | 67556.3 |
169 | 2022-07-15 21:29:53 | hotspur | 1 | 69583 | 2 | 1.046 | 66522.9 |
168 | 2022-06-17 19:49:11 | hotspur | 1 | 69583 | 2 | 1.170 | 59472.6 |
167 | 2022-05-11 18:32:50 | hotspur | 1 | 69583 | 2 | 1.110 | 62687.4 |
166 | 2022-01-19 01:23:46 | hotspur | 1 | 69583 | 2 | 1.046 | 66522.9 |
165 | 2022-01-15 19:00:16 | hotspur | 1 | 69583 | 2 | 1.236 | 56296.9 |
164 | 2022-01-12 11:54:50 | hotspur | 1 | 69583 | 2 | 1.220 | 57035.2 |
163 | 2021-08-31 19:43:10 | hotspur | 1 | 69583 | 2 | 1.126 | 61796.6 |
162 | 2021-05-16 08:01:38 | hotspur | 3 | 134027 | 26 | 10.080 | 13296.3 |
161 | 2021-05-14 03:52:22 | hotspur | 2 | 107671 | 3 | 3.390 | 31761.4 |
160 | 2021-05-04 06:47:54 | hotspur | 1 | 69583 | 2 | 1.296 | 53690.6 |
159 | 2021-04-30 16:57:33 | hotspur | 1 | 69583 | 2 | 1.250 | 55666.4 |
158 | 2021-04-13 04:15:37 | hotspur | 2 | 107671 | 3 | 5.643 | 19080.5 |
157 | 2021-03-19 03:50:10 | hotspur | 3 | 134027 | 26 | 6.140 | 21828.5 |
156 | 2021-03-10 21:04:32 | hotspur | 1 | 69583 | 2 | 1.126 | 61796.6 |
155 | 2021-02-21 23:33:56 | hotspur | 3 | 134027 | 26 | 5.876 | 22809.2 |
154 | 2021-01-26 23:08:43 | hotspur | 2 | 107671 | 3 | 2.890 | 37256.4 |
153 | 2021-01-21 20:28:06 | hotspur | 1 | 69583 | 2 | 1.080 | 64428.7 |
152 | 2020-12-07 12:09:53 | hotspur | 1 | 69583 | 2 | 1.063 | 65459.1 |
151 | 2020-11-09 10:38:48 | hotspur | 3 | 134027 | 26 | 6.016 | 22278.4 |
150 | 2020-11-09 01:05:41 | hotspur | 1 | 69583 | 2 | 1.203 | 57841.2 |
149 | 2020-11-07 07:06:58 | hotspur | 2 | 107671 | 3 | 3.236 | 33272.9 |
148 | 2020-10-21 04:07:02 | hotspur | 1 | 69583 | 2 | 1.220 | 57035.2 |
147 | 2020-10-07 02:14:22 | hotspur | 1 | 69583 | 2 | 1.110 | 62687.4 |
146 | 2020-09-06 02:28:58 | hotspur | 1 | 69583 | 2 | 1.186 | 58670.3 |
145 | 2020-07-31 22:06:01 | hotspur | 1 | 69583 | 2 | 1.203 | 57841.2 |
144 | 2020-04-16 20:25:37 | hotspur | 1 | 69583 | 2 | 1.126 | 61796.6 |
143 | 2020-03-29 17:52:31 | hotspur | 1 | 69583 | 2 | 1.280 | 54361.7 |
142 | 2020-03-29 06:09:52 | hotspur | 4 | 151207 | 535 | 12.250 | 12343.4 |
141 | 2020-03-28 14:09:38 | hotspur | 4 | 151207 | 535 | 13.436 | 11253.9 |
140 | 2020-03-23 07:47:13 | hotspur | 4 | 151207 | 535 | 13.703 | 11034.6 |
139 | 2020-03-22 10:07:06 | hotspur | 4 | 151207 | 535 | 11.800 | 12814.2 |
138 | 2020-03-22 06:44:36 | hotspur | 1 | 69583 | 2 | 1.076 | 64668.2 |
137 | 2020-03-22 02:07:56 | hotspur | 4 | 151207 | 535 | 16.110 | 9385.9 |
136 | 2020-03-05 21:28:20 | hotspur | 4 | 151207 | 535 | 17.906 | 8444.5 |
135 | 2020-02-28 06:46:06 | hotspur | 4 | 151207 | 535 | 27.940 | 5411.8 |
134 | 2020-02-23 00:28:27 | hotspur | 4 | 151207 | 535 | 14.220 | 10633.4 |
133 | 2020-02-22 18:34:05 | hotspur | 4 | 151207 | 535 | 12.220 | 12373.7 |
132 | 2020-02-17 04:43:47 | hotspur | 1 | 69583 | 2 | 1.406 | 49490.0 |
131 | 2020-02-10 15:35:49 | hotspur | 1 | 69583 | 2 | 2.953 | 23563.5 |
130 | 2020-02-08 07:46:29 | hotspur | 1 | 69583 | 2 | 2.736 | 25432.4 |
129 | 2020-02-05 15:32:57 | hotspur | 1 | 69583 | 2 | 2.686 | 25905.8 |
128 | 2020-01-30 09:09:54 | hotspur | 1 | 69583 | 2 | 2.390 | 29114.2 |
127 | 2020-01-30 01:27:56 | hotspur | 1 | 69583 | 2 | 1.220 | 57035.2 |
126 | 2020-01-25 02:03:22 | hotspur | 4 | 151207 | 535 | 15.750 | 9600.4 |
125 | 2020-01-24 17:36:04 | hotspur | 4 | 151207 | 535 | 12.140 | 12455.3 |
124 | 2020-01-24 15:30:06 | hotspur | 3 | 134027 | 26 | 7.563 | 17721.4 |
123 | 2020-01-24 13:26:16 | hotspur | 4 | 151207 | 535 | 19.970 | 7571.7 |
122 | 2020-01-24 12:00:49 | hotspur | 4 | 151207 | 535 | 29.850 | 5065.6 |
121 | 2020-01-24 10:09:31 | hotspur | 4 | 151207 | 535 | 18.110 | 8349.4 |
120 | 2020-01-24 05:56:44 | hotspur | 2 | 107671 | 3 | 6.690 | 16094.3 |
119 | 2020-01-24 05:56:07 | hotspur | 3 | 134027 | 26 | 6.156 | 21771.8 |
118 | 2020-01-24 05:54:54 | hotspur | 4 | 151207 | 535 | 30.813 | 4907.2 |
117 | 2020-01-24 02:50:22 | hotspur | 1 | 69583 | 2 | 2.593 | 26834.9 |
116 | 2020-01-10 04:59:03 | hotspur | 1 | 69583 | 2 | 1.296 | 53690.6 |
115 | 2020-01-03 04:04:23 | hotspur | 1 | 69583 | 2 | 1.376 | 50569.0 |
114 | 2020-01-01 12:11:24 | hotspur | 1 | 69583 | 2 | 1.140 | 61037.7 |
113 | 2019-12-27 03:49:46 | hotspur | 1 | 69583 | 2 | 2.530 | 27503.2 |
112 | 2019-09-26 12:04:06 | hotspur | 1 | 69583 | 2 | 0.973 | 71513.9 |
111 | 2019-06-14 08:07:20 | hotspur | 1 | 69583 | 2 | 1.206 | 57697.3 |
110 | 2019-03-05 18:25:42 | hotspur | 1 | 69583 | 2 | 1.023 | 68018.6 |
109 | 2019-02-11 05:46:03 | hotspur | 1 | 69583 | 2 | 1.006 | 69168.0 |
108 | 2018-10-02 05:26:31 | hotspur | 1 | 69583 | 2 | 1.203 | 57841.2 |
107 | 2018-10-02 00:15:14 | hotspur | 1 | 69583 | 2 | 1.053 | 66080.7 |
106 | 2018-10-02 00:12:36 | hotspur | 1 | 69583 | 2 | 1.053 | 66080.7 |
105 | 2018-09-19 05:41:43 | hotspur | 1 | 69583 | 2 | 1.053 | 66080.7 |
104 | 2018-09-13 16:20:04 | hotspur | 1 | 69583 | 2 | 1.300 | 53525.4 |
103 | 2018-09-12 00:05:06 | hotspur | 1 | 69583 | 2 | 1.043 | 66714.3 |