History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"bookplate"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
189 | 2024-05-02 01:04:18 | bookplate | 1 | 81242 | 2 | 3.170 | 25628.4 |
188 | 2024-04-30 12:28:49 | bookplate | 4 | 165329 | 146 | 17.330 | 9540.0 |
187 | 2024-04-27 12:19:59 | bookplate | 1 | 81242 | 2 | 2.123 | 38267.5 |
186 | 2024-04-20 23:59:08 | bookplate | 4 | 165329 | 146 | 48.130 | 3435.1 |
185 | 2024-04-18 18:37:16 | bookplate | 2 | 121436 | 3 | 6.766 | 17948.0 |
184 | 2024-04-18 18:36:41 | bookplate | 1 | 81242 | 2 | 1.593 | 50999.4 |
183 | 2024-04-18 18:35:52 | bookplate | 3 | 148641 | 16 | 14.673 | 10130.2 |
182 | 2024-04-17 01:04:04 | bookplate | 4 | 165329 | 146 | 17.110 | 9662.7 |
181 | 2024-04-16 08:40:39 | bookplate | 4 | 165329 | 146 | 38.863 | 4254.1 |
180 | 2024-04-16 08:40:38 | bookplate | 3 | 148641 | 16 | 22.673 | 6555.9 |
179 | 2024-04-16 08:40:39 | bookplate | 2 | 121436 | 3 | 13.613 | 8920.6 |
178 | 2024-04-16 08:13:57 | bookplate | 1 | 81242 | 2 | 1.890 | 42985.2 |
177 | 2024-04-08 09:05:37 | bookplate | 2 | 121436 | 3 | 15.376 | 7897.8 |
176 | 2024-04-08 06:58:28 | bookplate | 1 | 81242 | 2 | 3.576 | 22718.7 |
175 | 2024-03-31 07:13:08 | bookplate | 4 | 165329 | 146 | 40.440 | 4088.3 |
174 | 2024-03-31 07:13:03 | bookplate | 3 | 148641 | 16 | 17.030 | 8728.2 |
173 | 2024-03-31 06:17:43 | bookplate | 3 | 148641 | 16 | 21.566 | 6892.4 |
172 | 2024-03-31 06:17:43 | bookplate | 4 | 165329 | 146 | 18.500 | 8936.7 |
171 | 2024-03-31 06:17:38 | bookplate | 2 | 121436 | 3 | 6.406 | 18956.6 |
170 | 2024-03-31 06:09:29 | bookplate | 1 | 81242 | 2 | 1.656 | 49059.2 |
169 | 2024-03-30 14:41:44 | bookplate | 1 | 81242 | 2 | 4.780 | 16996.2 |
168 | 2024-03-19 22:16:53 | bookplate | 1 | 81242 | 2 | 1.440 | 56418.1 |
167 | 2024-03-16 03:25:33 | bookplate | 3 | 148641 | 16 | 24.926 | 5963.3 |
166 | 2024-03-15 22:11:32 | bookplate | 4 | 165329 | 146 | 30.206 | 5473.4 |
165 | 2024-03-15 16:14:34 | bookplate | 3 | 148641 | 16 | 15.080 | 9856.8 |
164 | 2024-03-15 16:14:24 | bookplate | 2 | 121436 | 3 | 8.313 | 14608.0 |
163 | 2024-03-15 16:13:15 | bookplate | 1 | 81242 | 2 | 1.390 | 58447.5 |
162 | 2024-03-15 08:25:10 | bookplate | 4 | 165329 | 146 | 48.486 | 3409.8 |
161 | 2024-03-15 08:25:07 | bookplate | 3 | 148641 | 16 | 21.343 | 6964.4 |
160 | 2024-03-15 08:25:09 | bookplate | 2 | 121436 | 3 | 10.640 | 11413.2 |
159 | 2024-03-15 07:40:44 | bookplate | 1 | 81242 | 2 | 1.420 | 57212.7 |
158 | 2024-02-27 11:32:59 | bookplate | 1 | 81242 | 2 | 1.266 | 64172.2 |
157 | 2024-02-26 04:39:00 | bookplate | 1 | 81242 | 2 | 1.580 | 51419.0 |
156 | 2024-02-20 02:53:50 | bookplate | 4 | 165329 | 146 | 41.706 | 3964.2 |
155 | 2024-02-12 15:35:33 | bookplate | 4 | 165329 | 146 | 35.130 | 4706.2 |
154 | 2024-02-11 04:27:08 | bookplate | 4 | 165329 | 146 | 28.876 | 5725.5 |
153 | 2024-02-11 04:27:10 | bookplate | 3 | 148641 | 16 | 18.080 | 8221.3 |
152 | 2024-02-06 17:46:46 | bookplate | 1 | 81242 | 2 | 2.780 | 29223.7 |
151 | 2024-01-26 01:01:11 | bookplate | 1 | 81242 | 2 | 2.860 | 28406.3 |
150 | 2024-01-14 16:39:24 | bookplate | 3 | 148641 | 16 | 6.860 | 21667.8 |
149 | 2024-01-03 02:18:28 | bookplate | 1 | 81242 | 2 | 1.420 | 57212.7 |
148 | 2023-12-14 01:02:07 | bookplate | 1 | 81242 | 2 | 1.376 | 59042.2 |
147 | 2023-12-02 21:47:34 | bookplate | 3 | 148641 | 16 | 7.750 | 19179.5 |
146 | 2023-11-29 19:57:13 | bookplate | 1 | 81242 | 2 | 1.343 | 60492.9 |
145 | 2023-10-25 08:19:26 | bookplate | 1 | 81242 | 2 | 1.220 | 66591.8 |
144 | 2023-10-23 15:32:51 | bookplate | 3 | 148641 | 16 | 6.080 | 24447.5 |
143 | 2023-08-19 23:23:26 | bookplate | 1 | 81242 | 2 | 1.233 | 65889.7 |
142 | 2023-08-02 17:58:48 | bookplate | 3 | 148641 | 16 | 5.906 | 25167.8 |
141 | 2023-05-23 04:37:43 | bookplate | 1 | 81242 | 2 | 1.216 | 66810.9 |
140 | 2023-04-09 20:42:19 | bookplate | 3 | 148641 | 16 | 5.796 | 25645.4 |
139 | 2023-03-18 09:12:09 | bookplate | 1 | 81242 | 2 | 1.330 | 61084.2 |
138 | 2023-01-15 01:56:34 | bookplate | 3 | 148641 | 16 | 6.516 | 22811.7 |
137 | 2023-01-06 03:24:25 | bookplate | 1 | 81242 | 2 | 1.186 | 68500.8 |
136 | 2022-10-19 02:42:33 | bookplate | 3 | 148641 | 16 | 5.780 | 25716.4 |
135 | 2022-09-29 23:36:48 | bookplate | 1 | 81242 | 2 | 1.250 | 64993.6 |
134 | 2022-05-20 22:53:21 | bookplate | 3 | 148641 | 16 | 6.016 | 24707.6 |
133 | 2022-05-11 14:19:27 | bookplate | 1 | 81242 | 2 | 1.500 | 54161.3 |
132 | 2022-05-09 11:54:01 | bookplate | 1 | 81242 | 2 | 1.623 | 50056.7 |
131 | 2021-04-08 09:49:37 | bookplate | 1 | 81242 | 2 | 1.233 | 65889.7 |
130 | 2021-03-11 14:22:22 | bookplate | 3 | 148641 | 16 | 6.450 | 23045.1 |
129 | 2021-01-23 08:10:36 | bookplate | 1 | 81242 | 2 | 1.216 | 66810.9 |
128 | 2021-01-22 12:07:24 | bookplate | 3 | 148641 | 16 | 6.093 | 24395.4 |
127 | 2020-12-23 18:53:51 | bookplate | 3 | 148641 | 16 | 5.923 | 25095.6 |
126 | 2020-11-03 13:19:08 | bookplate | 1 | 81242 | 2 | 1.326 | 61268.5 |
125 | 2020-03-26 11:25:46 | bookplate | 1 | 81242 | 2 | 1.436 | 56575.2 |
124 | 2020-03-10 12:28:29 | bookplate | 1 | 81242 | 2 | 1.266 | 64172.2 |
123 | 2020-02-23 06:26:02 | bookplate | 1 | 81242 | 2 | 3.046 | 26671.7 |
122 | 2020-02-08 01:56:48 | bookplate | 1 | 81242 | 2 | 4.373 | 18578.1 |
121 | 2020-02-06 02:13:16 | bookplate | 1 | 81242 | 2 | 1.486 | 54671.6 |
120 | 2020-02-04 23:49:47 | bookplate | 1 | 81242 | 2 | 1.500 | 54161.3 |
119 | 2020-01-30 20:39:07 | bookplate | 1 | 81242 | 2 | 1.580 | 51419.0 |
118 | 2020-01-30 16:36:21 | bookplate | 1 | 81242 | 2 | 1.470 | 55266.7 |
117 | 2020-01-22 19:11:01 | bookplate | 1 | 81242 | 2 | 1.610 | 50460.9 |
116 | 2020-01-06 08:08:46 | bookplate | 1 | 81242 | 2 | 1.420 | 57212.7 |
115 | 2020-01-04 22:46:10 | bookplate | 1 | 81242 | 2 | 4.436 | 18314.2 |
114 | 2019-12-01 18:32:18 | bookplate | 1 | 81242 | 2 | 1.280 | 63470.3 |
113 | 2019-08-30 08:16:32 | bookplate | 1 | 81242 | 2 | 1.293 | 62832.2 |
112 | 2019-05-18 05:04:18 | bookplate | 1 | 81242 | 2 | 1.226 | 66265.9 |
111 | 2019-02-10 16:29:47 | bookplate | 1 | 81242 | 2 | 1.223 | 66428.5 |
110 | 2019-01-20 18:21:18 | bookplate | 1 | 81242 | 2 | 1.226 | 66265.9 |
109 | 2018-09-18 05:58:12 | bookplate | 1 | 81242 | 2 | 1.430 | 56812.6 |
108 | 2018-08-19 07:40:08 | bookplate | 1 | 81242 | 2 | 1.366 | 59474.4 |
107 | 2018-06-18 12:55:32 | bookplate | 1 | 81242 | 2 | 1.396 | 58196.3 |
106 | 2018-06-16 20:24:21 | bookplate | 1 | 81242 | 2 | 1.413 | 57496.1 |
105 | 2017-12-06 20:34:54 | bookplate | 1 | 81242 | 2 | 1.686 | 48186.2 |
104 | 2017-11-18 06:07:02 | bookplate | 1 | 81242 | 2 | 1.693 | 47987.0 |
103 | 2017-10-27 06:28:20 | bookplate | 1 | 81242 | 2 | 1.810 | 44885.1 |
102 | 2017-10-24 10:09:37 | bookplate | 1 | 81242 | 2 | 2.123 | 38267.5 |
101 | 2017-10-15 12:20:26 | bookplate | 1 | 81242 | 2 | 1.736 | 46798.4 |
100 | 2017-06-12 19:02:33 | bookplate | 1 | 81242 | 2 | 1.626 | 49964.3 |
99 | 2017-04-23 05:27:04 | bookplate | 1 | 81242 | 2 | 1.550 | 52414.2 |
98 | 2017-03-21 01:54:01 | bookplate | 1 | 81242 | 2 | 1.853 | 43843.5 |
97 | 2017-03-05 06:43:42 | bookplate | 1 | 81242 | 2 | 2.126 | 38213.5 |
96 | 2016-12-10 17:16:57 | bookplate | 1 | 81242 | 2 | 1.753 | 46344.6 |
95 | 2016-12-09 01:28:26 | bookplate | 1 | 81242 | 2 | 1.750 | 46424.0 |
94 | 2016-11-24 07:02:39 | bookplate | 1 | 81242 | 2 | 1.870 | 43444.9 |
93 | 2016-11-23 21:27:36 | bookplate | 1 | 81242 | 2 | 1.733 | 46879.4 |
92 | 2016-11-22 22:52:03 | bookplate | 1 | 81242 | 2 | 1.953 | 41598.6 |
91 | 2016-11-14 17:03:49 | bookplate | 2 | 121436 | 3 | 10.460 | 11609.6 |
90 | 2016-11-13 23:59:14 | bookplate | 4 | 165329 | 146 | 14.160 | 11675.8 |