History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"guardsman"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
196 | 2024-05-11 02:54:15 | guardsman | 4 | 165329 | 138 | 36.736 | 4500.5 |
195 | 2024-05-11 00:03:46 | guardsman | 4 | 165329 | 138 | 23.376 | 7072.6 |
194 | 2024-05-10 12:43:15 | guardsman | 4 | 165329 | 138 | 36.456 | 4535.0 |
193 | 2024-05-10 12:43:14 | guardsman | 3 | 148641 | 24 | 17.250 | 8616.9 |
192 | 2024-05-10 12:43:13 | guardsman | 2 | 121436 | 4 | 8.626 | 14077.9 |
191 | 2024-05-10 12:40:49 | guardsman | 1 | 81242 | 2 | 4.643 | 17497.7 |
190 | 2024-05-02 13:57:39 | guardsman | 1 | 81242 | 2 | 2.860 | 28406.3 |
189 | 2024-04-30 18:32:20 | guardsman | 1 | 81242 | 2 | 1.766 | 46003.4 |
188 | 2024-04-30 18:27:47 | guardsman | 1 | 81242 | 2 | 2.766 | 29371.7 |
187 | 2024-04-22 04:54:00 | guardsman | 1 | 81242 | 2 | 3.186 | 25499.7 |
186 | 2024-04-13 05:52:24 | guardsman | 1 | 81242 | 2 | 1.313 | 61875.1 |
185 | 2024-04-08 16:48:19 | guardsman | 1 | 81242 | 2 | 2.030 | 40020.7 |
184 | 2024-04-01 13:11:27 | guardsman | 1 | 81242 | 2 | 1.546 | 52549.8 |
183 | 2024-04-01 06:12:08 | guardsman | 3 | 148641 | 24 | 9.640 | 15419.2 |
182 | 2024-03-31 18:09:17 | guardsman | 4 | 165329 | 138 | 26.563 | 6224.0 |
181 | 2024-03-31 11:52:09 | guardsman | 4 | 165329 | 138 | 41.063 | 4026.2 |
180 | 2024-03-31 11:52:11 | guardsman | 3 | 148641 | 24 | 16.516 | 8999.8 |
179 | 2024-03-31 11:52:12 | guardsman | 2 | 121436 | 4 | 9.436 | 12869.4 |
178 | 2024-03-31 11:19:34 | guardsman | 1 | 81242 | 2 | 1.593 | 50999.4 |
177 | 2024-03-15 10:33:31 | guardsman | 4 | 165329 | 138 | 37.673 | 4388.5 |
176 | 2024-03-13 18:29:50 | guardsman | 4 | 165329 | 138 | 15.626 | 10580.4 |
175 | 2024-03-07 00:10:14 | guardsman | 4 | 165329 | 138 | 10.796 | 15313.9 |
174 | 2024-02-28 05:54:20 | guardsman | 1 | 81242 | 2 | 1.266 | 64172.2 |
173 | 2024-02-27 09:57:54 | guardsman | 1 | 81242 | 2 | 1.453 | 55913.3 |
172 | 2024-02-17 18:42:47 | guardsman | 4 | 165329 | 138 | 15.050 | 10985.3 |
171 | 2024-02-17 18:42:49 | guardsman | 3 | 148641 | 24 | 11.206 | 13264.4 |
170 | 2024-02-17 18:42:45 | guardsman | 2 | 121436 | 4 | 8.093 | 15005.1 |
169 | 2024-02-17 16:55:19 | guardsman | 1 | 81242 | 2 | 1.376 | 59042.2 |
168 | 2024-02-12 00:16:51 | guardsman | 4 | 165329 | 138 | 46.063 | 3589.2 |
167 | 2024-01-29 02:58:38 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
166 | 2024-01-24 17:30:09 | guardsman | 4 | 165329 | 138 | 16.716 | 9890.5 |
165 | 2024-01-24 17:30:10 | guardsman | 3 | 148641 | 24 | 8.500 | 17487.2 |
164 | 2024-01-24 17:30:13 | guardsman | 2 | 121436 | 4 | 4.060 | 29910.3 |
163 | 2024-01-24 16:52:14 | guardsman | 1 | 81242 | 2 | 1.313 | 61875.1 |
162 | 2024-01-11 03:44:42 | guardsman | 1 | 81242 | 2 | 1.330 | 61084.2 |
161 | 2023-12-23 03:13:38 | guardsman | 1 | 81242 | 2 | 1.326 | 61268.5 |
160 | 2023-11-30 15:12:19 | guardsman | 1 | 81242 | 2 | 1.313 | 61875.1 |
159 | 2023-11-27 03:31:07 | guardsman | 4 | 165329 | 138 | 11.673 | 14163.4 |
158 | 2023-11-03 05:46:42 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
157 | 2023-08-26 15:12:56 | guardsman | 4 | 165329 | 138 | 12.376 | 13358.8 |
156 | 2023-08-26 03:28:17 | guardsman | 1 | 81242 | 2 | 1.373 | 59171.2 |
155 | 2023-07-30 01:39:32 | guardsman | 1 | 81242 | 2 | 1.233 | 65889.7 |
154 | 2023-05-30 18:35:10 | guardsman | 1 | 81242 | 2 | 1.296 | 62686.7 |
153 | 2023-05-14 03:32:58 | guardsman | 4 | 165329 | 138 | 10.280 | 16082.6 |
152 | 2023-03-22 07:01:00 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
151 | 2023-03-16 20:38:14 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
150 | 2023-02-20 14:19:52 | guardsman | 4 | 165329 | 138 | 10.466 | 15796.8 |
149 | 2023-01-08 23:15:21 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
148 | 2022-12-02 23:52:31 | guardsman | 4 | 165329 | 138 | 12.203 | 13548.2 |
147 | 2022-10-28 03:11:40 | guardsman | 1 | 81242 | 2 | 1.173 | 69260.0 |
146 | 2022-10-17 06:47:07 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
145 | 2022-06-08 12:30:22 | guardsman | 1 | 81242 | 2 | 1.203 | 67532.8 |
144 | 2022-06-08 03:19:11 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
143 | 2022-06-04 21:14:26 | guardsman | 1 | 81242 | 2 | 1.203 | 67532.8 |
142 | 2022-04-13 23:29:31 | guardsman | 4 | 165329 | 138 | 10.736 | 15399.5 |
141 | 2022-02-13 14:38:43 | guardsman | 1 | 81242 | 2 | 1.233 | 65889.7 |
140 | 2022-01-21 04:27:32 | guardsman | 1 | 81242 | 2 | 1.233 | 65889.7 |
139 | 2022-01-17 22:04:04 | guardsman | 1 | 81242 | 2 | 1.280 | 63470.3 |
138 | 2022-01-14 15:13:03 | guardsman | 1 | 81242 | 2 | 1.330 | 61084.2 |
137 | 2021-12-09 08:13:49 | guardsman | 1 | 81242 | 2 | 1.266 | 64172.2 |
136 | 2021-12-07 06:01:38 | guardsman | 1 | 81242 | 2 | 1.326 | 61268.5 |
135 | 2021-10-14 13:57:44 | guardsman | 1 | 81242 | 2 | 1.203 | 67532.8 |
134 | 2021-09-19 04:56:42 | guardsman | 1 | 81242 | 2 | 1.330 | 61084.2 |
133 | 2021-09-06 08:27:28 | guardsman | 1 | 81242 | 2 | 1.310 | 62016.8 |
132 | 2021-09-04 03:08:04 | guardsman | 1 | 81242 | 2 | 1.220 | 66591.8 |
131 | 2021-08-19 17:34:10 | guardsman | 1 | 81242 | 2 | 1.203 | 67532.8 |
130 | 2021-08-17 13:46:54 | guardsman | 1 | 81242 | 2 | 1.406 | 57782.4 |
129 | 2021-06-21 13:10:25 | guardsman | 3 | 148641 | 24 | 6.330 | 23482.0 |
128 | 2021-06-08 13:39:08 | guardsman | 1 | 81242 | 2 | 1.360 | 59736.8 |
127 | 2021-05-06 00:18:44 | guardsman | 1 | 81242 | 2 | 1.360 | 59736.8 |
126 | 2021-05-03 11:17:08 | guardsman | 4 | 165329 | 138 | 13.576 | 12178.0 |
125 | 2021-04-02 01:35:37 | guardsman | 3 | 148641 | 24 | 7.576 | 19620.0 |
124 | 2021-04-01 17:17:47 | guardsman | 4 | 165329 | 138 | 12.716 | 13001.7 |
123 | 2021-03-06 07:05:04 | guardsman | 1 | 81242 | 2 | 1.343 | 60492.9 |
122 | 2021-03-06 06:52:06 | guardsman | 1 | 81242 | 2 | 1.203 | 67532.8 |
121 | 2021-03-03 01:10:13 | guardsman | 1 | 81242 | 2 | 1.170 | 69437.6 |
120 | 2021-02-17 06:56:33 | guardsman | 2 | 121436 | 4 | 3.030 | 40077.9 |
119 | 2021-02-12 11:20:52 | guardsman | 1 | 81242 | 2 | 1.220 | 66591.8 |
118 | 2021-02-10 15:50:42 | guardsman | 3 | 148641 | 24 | 6.313 | 23545.2 |
117 | 2021-02-10 07:43:26 | guardsman | 4 | 165329 | 138 | 11.733 | 14090.9 |
116 | 2021-01-19 10:04:28 | guardsman | 1 | 81242 | 2 | 1.330 | 61084.2 |
115 | 2020-11-22 09:45:12 | guardsman | 3 | 148641 | 24 | 6.046 | 24585.0 |
114 | 2020-11-12 23:57:31 | guardsman | 1 | 81242 | 2 | 1.300 | 62493.8 |
113 | 2020-10-28 11:25:20 | guardsman | 3 | 148641 | 24 | 6.580 | 22589.8 |
112 | 2020-10-28 04:21:17 | guardsman | 4 | 165329 | 138 | 15.186 | 10886.9 |
111 | 2020-10-04 00:52:01 | guardsman | 1 | 81242 | 2 | 1.186 | 68500.8 |
110 | 2020-07-17 14:56:11 | guardsman | 1 | 81242 | 2 | 1.390 | 58447.5 |
109 | 2020-04-06 12:28:03 | guardsman | 1 | 81242 | 2 | 1.280 | 63470.3 |
108 | 2020-03-27 00:12:40 | guardsman | 1 | 81242 | 2 | 2.953 | 27511.7 |
107 | 2020-02-29 18:58:24 | guardsman | 1 | 81242 | 2 | 1.466 | 55417.5 |
106 | 2020-02-27 04:44:20 | guardsman | 4 | 165329 | 138 | 14.076 | 11745.5 |
105 | 2020-02-27 02:54:16 | guardsman | 4 | 165329 | 138 | 14.626 | 11303.8 |
104 | 2020-02-25 23:48:26 | guardsman | 4 | 165329 | 138 | 28.113 | 5880.9 |
103 | 2020-02-25 23:09:48 | guardsman | 4 | 165329 | 138 | 26.236 | 6301.6 |
102 | 2020-02-25 12:33:37 | guardsman | 4 | 165329 | 138 | 13.313 | 12418.6 |
101 | 2020-02-25 01:48:20 | guardsman | 4 | 165329 | 138 | 18.076 | 9146.3 |
100 | 2020-02-14 12:43:09 | guardsman | 1 | 81242 | 2 | 2.813 | 28880.9 |
99 | 2020-02-04 10:49:46 | guardsman | 3 | 148641 | 24 | 8.660 | 17164.1 |
98 | 2020-02-04 10:44:01 | guardsman | 4 | 165329 | 138 | 15.830 | 10444.0 |
97 | 2020-02-04 10:16:35 | guardsman | 2 | 121436 | 4 | 5.843 | 20783.2 |