History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"excerptor"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
186 | 2024-05-03 09:39:39 | excerptor | 1 | 81242 | 3 | 1.453 | 55913.3 |
185 | 2024-05-02 23:27:50 | excerptor | 3 | 148641 | 31 | 14.280 | 10409.0 |
184 | 2024-05-02 02:19:22 | excerptor | 1 | 81242 | 3 | 2.733 | 29726.3 |
183 | 2024-04-28 20:51:15 | excerptor | 3 | 148641 | 31 | 7.780 | 19105.5 |
182 | 2024-04-28 14:29:23 | excerptor | 1 | 81242 | 3 | 1.310 | 62016.8 |
181 | 2024-04-24 17:26:40 | excerptor | 1 | 81242 | 3 | 1.266 | 64172.2 |
180 | 2024-04-16 08:42:22 | excerptor | 2 | 121436 | 9 | 13.923 | 8722.0 |
179 | 2024-04-16 08:08:42 | excerptor | 1 | 81242 | 3 | 1.470 | 55266.7 |
178 | 2024-04-11 15:03:26 | excerptor | 2 | 121436 | 9 | 13.860 | 8761.6 |
177 | 2024-04-11 14:11:26 | excerptor | 1 | 81242 | 3 | 1.186 | 68500.8 |
176 | 2024-04-08 06:29:36 | excerptor | 4 | 165329 | 145 | 41.363 | 3997.0 |
175 | 2024-04-08 01:43:01 | excerptor | 4 | 165329 | 145 | 33.863 | 4882.3 |
174 | 2024-04-08 01:42:53 | excerptor | 3 | 148641 | 31 | 26.673 | 5572.7 |
173 | 2024-04-07 23:22:03 | excerptor | 1 | 81242 | 3 | 5.546 | 14648.8 |
172 | 2024-04-06 13:39:08 | excerptor | 4 | 165329 | 145 | 39.423 | 4193.7 |
171 | 2024-04-06 13:39:03 | excerptor | 3 | 148641 | 31 | 15.250 | 9747.0 |
170 | 2024-04-06 13:39:04 | excerptor | 2 | 121436 | 9 | 4.060 | 29910.3 |
169 | 2024-04-06 13:38:24 | excerptor | 1 | 81242 | 3 | 3.360 | 24179.2 |
168 | 2024-03-28 21:50:16 | excerptor | 1 | 81242 | 3 | 1.533 | 52995.4 |
167 | 2024-03-20 14:20:56 | excerptor | 1 | 81242 | 3 | 1.233 | 65889.7 |
166 | 2024-03-12 03:59:48 | excerptor | 1 | 81242 | 3 | 4.263 | 19057.5 |
165 | 2024-03-08 22:19:55 | excerptor | 1 | 81242 | 3 | 1.486 | 54671.6 |
164 | 2024-03-08 10:47:39 | excerptor | 4 | 165329 | 145 | 28.596 | 5781.5 |
163 | 2024-03-05 10:24:50 | excerptor | 1 | 81242 | 3 | 2.283 | 35585.6 |
162 | 2024-03-04 15:07:16 | excerptor | 4 | 165329 | 145 | 24.360 | 6786.9 |
161 | 2024-03-03 17:14:27 | excerptor | 4 | 165329 | 145 | 46.940 | 3522.1 |
160 | 2024-03-03 17:14:26 | excerptor | 2 | 121436 | 9 | 14.000 | 8674.0 |
159 | 2024-03-03 17:14:27 | excerptor | 3 | 148641 | 31 | 8.233 | 18054.3 |
158 | 2024-03-03 17:12:32 | excerptor | 1 | 81242 | 3 | 1.423 | 57092.1 |
157 | 2024-02-22 16:51:54 | excerptor | 1 | 81242 | 3 | 3.080 | 26377.3 |
156 | 2024-02-17 00:28:46 | excerptor | 1 | 81242 | 3 | 1.530 | 53099.3 |
155 | 2024-02-06 17:09:12 | excerptor | 1 | 81242 | 3 | 1.516 | 53589.7 |
154 | 2024-02-02 18:54:51 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
153 | 2024-01-31 11:27:39 | excerptor | 1 | 81242 | 3 | 1.313 | 61875.1 |
152 | 2024-01-27 11:29:05 | excerptor | 1 | 81242 | 3 | 1.266 | 64172.2 |
151 | 2024-01-09 12:45:16 | excerptor | 1 | 81242 | 3 | 1.403 | 57905.9 |
150 | 2023-12-31 04:07:54 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
149 | 2023-12-13 11:42:18 | excerptor | 3 | 148641 | 31 | 6.233 | 23847.4 |
148 | 2023-11-30 08:55:01 | excerptor | 1 | 81242 | 3 | 1.280 | 63470.3 |
147 | 2023-11-07 10:24:52 | excerptor | 1 | 81242 | 3 | 1.423 | 57092.1 |
146 | 2023-10-06 01:21:56 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
145 | 2023-09-14 22:57:53 | excerptor | 1 | 81242 | 3 | 1.420 | 57212.7 |
144 | 2023-09-12 22:13:37 | excerptor | 3 | 148641 | 31 | 5.936 | 25040.6 |
143 | 2023-06-26 04:05:39 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
142 | 2023-06-09 16:36:59 | excerptor | 3 | 148641 | 31 | 6.576 | 22603.6 |
141 | 2023-05-27 05:14:44 | excerptor | 1 | 81242 | 3 | 1.216 | 66810.9 |
140 | 2023-04-23 18:16:50 | excerptor | 1 | 81242 | 3 | 1.330 | 61084.2 |
139 | 2023-04-07 07:06:47 | excerptor | 1 | 81242 | 3 | 1.280 | 63470.3 |
138 | 2023-03-12 18:57:43 | excerptor | 3 | 148641 | 31 | 5.940 | 25023.7 |
137 | 2023-01-24 04:30:10 | excerptor | 1 | 81242 | 3 | 1.296 | 62686.7 |
136 | 2023-01-20 05:01:26 | excerptor | 1 | 81242 | 3 | 1.190 | 68270.6 |
135 | 2022-12-16 01:19:23 | excerptor | 3 | 148641 | 31 | 6.530 | 22762.8 |
134 | 2022-11-16 01:38:50 | excerptor | 1 | 81242 | 3 | 1.216 | 66810.9 |
133 | 2022-09-11 01:30:27 | excerptor | 1 | 81242 | 3 | 1.190 | 68270.6 |
132 | 2022-08-07 20:35:32 | excerptor | 3 | 148641 | 31 | 5.920 | 25108.3 |
131 | 2022-07-19 02:51:13 | excerptor | 1 | 81242 | 3 | 1.203 | 67532.8 |
130 | 2022-07-07 07:34:05 | excerptor | 1 | 81242 | 3 | 1.263 | 64324.6 |
129 | 2022-05-16 10:28:25 | excerptor | 1 | 81242 | 3 | 1.656 | 49059.2 |
128 | 2022-04-24 10:09:48 | excerptor | 1 | 81242 | 3 | 1.360 | 59736.8 |
127 | 2022-03-21 22:32:55 | excerptor | 3 | 148641 | 31 | 6.593 | 22545.3 |
126 | 2022-03-09 21:22:36 | excerptor | 1 | 81242 | 3 | 1.326 | 61268.5 |
125 | 2021-12-23 03:22:05 | excerptor | 1 | 81242 | 3 | 1.283 | 63321.9 |
124 | 2021-12-20 07:07:20 | excerptor | 1 | 81242 | 3 | 1.406 | 57782.4 |
123 | 2021-10-25 07:13:24 | excerptor | 1 | 81242 | 3 | 1.420 | 57212.7 |
122 | 2021-10-23 06:38:39 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
121 | 2021-08-30 15:02:32 | excerptor | 1 | 81242 | 3 | 1.360 | 59736.8 |
120 | 2021-05-13 06:17:05 | excerptor | 1 | 81242 | 3 | 1.203 | 67532.8 |
119 | 2021-05-09 16:47:48 | excerptor | 1 | 81242 | 3 | 1.423 | 57092.1 |
118 | 2021-04-10 20:31:29 | excerptor | 4 | 165329 | 145 | 16.673 | 9916.0 |
117 | 2021-02-26 16:49:07 | excerptor | 3 | 148641 | 31 | 6.283 | 23657.6 |
116 | 2021-02-18 03:09:49 | excerptor | 4 | 165329 | 145 | 10.453 | 15816.4 |
115 | 2021-02-04 04:07:08 | excerptor | 1 | 81242 | 3 | 1.263 | 64324.6 |
114 | 2020-11-02 16:35:05 | excerptor | 1 | 81242 | 3 | 1.266 | 64172.2 |
113 | 2020-10-29 07:14:58 | excerptor | 1 | 81242 | 3 | 1.343 | 60492.9 |
112 | 2020-07-17 13:16:48 | excerptor | 1 | 81242 | 3 | 2.483 | 32719.3 |
111 | 2020-04-06 10:19:23 | excerptor | 1 | 81242 | 3 | 1.250 | 64993.6 |
110 | 2020-03-26 07:59:04 | excerptor | 1 | 81242 | 3 | 1.423 | 57092.1 |
109 | 2020-03-25 04:24:23 | excerptor | 1 | 81242 | 3 | 1.250 | 64993.6 |
108 | 2020-02-18 13:34:26 | excerptor | 1 | 81242 | 3 | 4.033 | 20144.3 |
107 | 2020-02-10 03:14:35 | excerptor | 1 | 81242 | 3 | 3.080 | 26377.3 |
106 | 2020-02-08 18:48:00 | excerptor | 1 | 81242 | 3 | 1.516 | 53589.7 |
105 | 2020-02-04 09:23:55 | excerptor | 1 | 81242 | 3 | 1.470 | 55266.7 |
104 | 2020-02-04 09:07:51 | excerptor | 3 | 148641 | 31 | 6.830 | 21763.0 |
103 | 2020-02-04 08:59:23 | excerptor | 2 | 121436 | 9 | 3.530 | 34401.1 |
102 | 2020-02-04 05:48:44 | excerptor | 1 | 81242 | 3 | 2.453 | 33119.4 |
101 | 2020-01-31 13:09:22 | excerptor | 1 | 81242 | 3 | 1.546 | 52549.8 |
100 | 2020-01-19 10:52:16 | excerptor | 1 | 81242 | 3 | 1.486 | 54671.6 |
99 | 2020-01-11 22:37:49 | excerptor | 1 | 81242 | 3 | 1.330 | 61084.2 |
98 | 2020-01-11 21:41:34 | excerptor | 1 | 81242 | 3 | 2.403 | 33808.6 |
97 | 2020-01-06 18:08:55 | excerptor | 1 | 81242 | 3 | 4.610 | 17623.0 |
96 | 2019-12-23 04:52:05 | excerptor | 1 | 81242 | 3 | 1.390 | 58447.5 |
95 | 2019-09-22 04:37:46 | excerptor | 1 | 81242 | 3 | 1.310 | 62016.8 |
94 | 2019-06-16 07:25:36 | excerptor | 1 | 81242 | 3 | 1.483 | 54782.2 |
93 | 2019-02-25 18:30:11 | excerptor | 1 | 81242 | 3 | 1.386 | 58616.2 |
92 | 2018-10-30 22:00:06 | excerptor | 1 | 81242 | 3 | 1.330 | 61084.2 |
91 | 2018-07-20 17:16:17 | excerptor | 1 | 81242 | 3 | 1.210 | 67142.1 |
90 | 2018-06-05 21:44:14 | excerptor | 1 | 81242 | 3 | 1.246 | 65202.2 |
89 | 2018-03-23 20:14:48 | excerptor | 1 | 81242 | 3 | 2.126 | 38213.5 |
88 | 2017-12-19 14:25:55 | excerptor | 1 | 81242 | 3 | 2.060 | 39437.9 |
87 | 2017-11-10 16:26:59 | excerptor | 1 | 81242 | 3 | 1.850 | 43914.6 |