History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sapsucker"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
187 | 2024-04-08 15:24:56 | sapsucker | 1 | 81242 | 2 | 1.703 | 47705.2 |
186 | 2024-04-06 05:15:48 | sapsucker | 1 | 81242 | 2 | 1.280 | 63470.3 |
185 | 2024-03-16 12:28:59 | sapsucker | 3 | 148641 | 15 | 24.516 | 6063.0 |
184 | 2024-03-16 12:29:04 | sapsucker | 2 | 121436 | 2 | 13.330 | 9110.0 |
183 | 2024-03-16 12:28:32 | sapsucker | 1 | 81242 | 2 | 3.186 | 25499.7 |
182 | 2024-03-04 22:38:00 | sapsucker | 4 | 165329 | 165 | 29.156 | 5670.5 |
181 | 2024-03-04 20:50:04 | sapsucker | 1 | 81242 | 2 | 3.156 | 25742.1 |
180 | 2024-03-03 17:14:24 | sapsucker | 4 | 165329 | 165 | 16.783 | 9851.0 |
179 | 2024-03-03 17:14:24 | sapsucker | 3 | 148641 | 15 | 15.330 | 9696.1 |
178 | 2024-03-03 17:14:20 | sapsucker | 2 | 121436 | 2 | 5.143 | 23611.9 |
177 | 2024-03-03 17:12:46 | sapsucker | 1 | 81242 | 2 | 1.313 | 61875.1 |
176 | 2024-02-29 09:14:03 | sapsucker | 1 | 81242 | 2 | 1.500 | 54161.3 |
175 | 2024-02-28 21:21:17 | sapsucker | 1 | 81242 | 2 | 4.673 | 17385.4 |
174 | 2024-02-28 21:17:27 | sapsucker | 1 | 81242 | 2 | 1.483 | 54782.2 |
173 | 2024-01-29 21:03:51 | sapsucker | 1 | 81242 | 2 | 1.410 | 57618.4 |
172 | 2024-01-29 21:01:25 | sapsucker | 1 | 81242 | 2 | 1.420 | 57212.7 |
171 | 2024-01-29 11:22:48 | sapsucker | 1 | 81242 | 2 | 2.653 | 30622.7 |
170 | 2023-11-25 12:36:26 | sapsucker | 1 | 81242 | 2 | 1.500 | 54161.3 |
169 | 2023-10-28 20:23:53 | sapsucker | 1 | 81242 | 2 | 1.560 | 52078.2 |
168 | 2023-09-10 18:36:51 | sapsucker | 1 | 81242 | 2 | 1.360 | 59736.8 |
167 | 2023-06-24 19:52:25 | sapsucker | 1 | 81242 | 2 | 1.296 | 62686.7 |
166 | 2023-04-06 05:50:03 | sapsucker | 1 | 81242 | 2 | 1.330 | 61084.2 |
165 | 2023-01-21 10:16:28 | sapsucker | 1 | 81242 | 2 | 1.283 | 63321.9 |
164 | 2022-11-18 19:58:05 | sapsucker | 1 | 81242 | 2 | 1.296 | 62686.7 |
163 | 2022-07-13 11:16:41 | sapsucker | 1 | 81242 | 2 | 1.280 | 63470.3 |
162 | 2022-07-11 02:55:16 | sapsucker | 1 | 81242 | 2 | 1.310 | 62016.8 |
161 | 2020-10-24 11:22:27 | sapsucker | 1 | 81242 | 2 | 1.346 | 60358.1 |
160 | 2020-10-18 17:00:11 | sapsucker | 1 | 81242 | 2 | 1.330 | 61084.2 |
159 | 2020-10-12 00:08:54 | sapsucker | 1 | 81242 | 2 | 1.390 | 58447.5 |
158 | 2020-08-17 10:54:22 | sapsucker | 1 | 81242 | 2 | 1.420 | 57212.7 |
157 | 2020-04-03 05:23:28 | sapsucker | 1 | 81242 | 2 | 1.343 | 60492.9 |
156 | 2020-03-28 06:21:44 | sapsucker | 1 | 81242 | 2 | 1.720 | 47233.7 |
155 | 2020-02-29 18:24:47 | sapsucker | 1 | 81242 | 2 | 1.656 | 49059.2 |
154 | 2020-02-28 04:55:50 | sapsucker | 1 | 81242 | 2 | 1.560 | 52078.2 |
153 | 2020-02-28 02:33:23 | sapsucker | 1 | 81242 | 2 | 1.626 | 49964.3 |
152 | 2020-02-10 19:33:53 | sapsucker | 1 | 81242 | 2 | 1.486 | 54671.6 |
151 | 2020-02-08 15:38:20 | sapsucker | 1 | 81242 | 2 | 1.376 | 59042.2 |
150 | 2020-02-05 19:59:44 | sapsucker | 1 | 81242 | 2 | 1.593 | 50999.4 |
149 | 2020-01-19 10:27:34 | sapsucker | 3 | 148641 | 15 | 14.906 | 9971.9 |
148 | 2020-01-18 15:42:32 | sapsucker | 3 | 148641 | 15 | 7.546 | 19698.0 |
147 | 2020-01-18 11:17:36 | sapsucker | 1 | 81242 | 2 | 3.390 | 23965.2 |
146 | 2020-01-11 14:55:11 | sapsucker | 1 | 81242 | 2 | 1.283 | 63321.9 |
145 | 2020-01-08 01:17:23 | sapsucker | 1 | 81242 | 2 | 1.483 | 54782.2 |
144 | 2019-11-30 00:44:10 | sapsucker | 1 | 81242 | 2 | 1.406 | 57782.4 |
143 | 2019-07-05 08:19:37 | sapsucker | 1 | 81242 | 2 | 1.306 | 62206.7 |
142 | 2019-06-25 07:13:27 | sapsucker | 1 | 81242 | 2 | 1.330 | 61084.2 |
141 | 2019-06-20 13:39:23 | sapsucker | 1 | 81242 | 2 | 1.346 | 60358.1 |
140 | 2017-12-12 05:37:47 | sapsucker | 1 | 81242 | 2 | 1.956 | 41534.8 |
139 | 2017-05-20 03:06:31 | sapsucker | 1 | 81242 | 2 | 1.820 | 44638.5 |
138 | 2017-05-14 06:41:27 | sapsucker | 1 | 81242 | 2 | 1.636 | 49658.9 |
137 | 2016-12-10 16:51:17 | sapsucker | 1 | 81242 | 2 | 1.833 | 44321.9 |
136 | 2016-12-10 10:10:48 | sapsucker | 1 | 81242 | 2 | 2.953 | 27511.7 |
135 | 2016-10-20 10:20:07 | sapsucker | 4 | 165329 | 165 | 18.550 | 8912.6 |
134 | 2016-10-18 06:44:41 | sapsucker | 4 | 165329 | 165 | 19.816 | 8343.2 |
133 | 2016-09-19 06:04:48 | sapsucker | 4 | 165329 | 165 | 20.703 | 7985.8 |
132 | 2016-09-18 17:44:03 | sapsucker | 1 | 81242 | 2 | 1.766 | 46003.4 |
131 | 2016-08-22 08:05:06 | sapsucker | 4 | 165329 | 165 | 23.453 | 7049.4 |
130 | 2016-08-02 11:36:04 | sapsucker | 4 | 165329 | 165 | 18.613 | 8882.4 |
129 | 2016-07-31 22:27:10 | sapsucker | 3 | 148641 | 15 | 11.940 | 12449.0 |
128 | 2016-07-28 22:17:22 | sapsucker | 4 | 165329 | 165 | 33.426 | 4946.1 |
127 | 2016-07-22 23:56:37 | sapsucker | 4 | 165329 | 165 | 18.686 | 8847.7 |
126 | 2016-07-19 15:39:43 | sapsucker | 4 | 165329 | 165 | 16.046 | 10303.4 |
125 | 2016-07-17 19:04:35 | sapsucker | 4 | 165329 | 165 | 20.686 | 7992.3 |
124 | 2016-07-14 01:11:32 | sapsucker | 4 | 165329 | 165 | 17.973 | 9198.7 |
123 | 2016-07-11 23:48:55 | sapsucker | 4 | 165329 | 165 | 22.526 | 7339.5 |
122 | 2016-07-02 18:14:30 | sapsucker | 4 | 165329 | 165 | 23.150 | 7141.6 |
121 | 2016-07-01 21:22:52 | sapsucker | 4 | 165329 | 165 | 22.926 | 7211.4 |
120 | 2016-06-10 08:49:12 | sapsucker | 4 | 165329 | 165 | 21.946 | 7533.4 |
119 | 2016-06-09 07:53:57 | sapsucker | 4 | 165329 | 165 | 30.910 | 5348.7 |
118 | 2016-05-29 20:52:18 | sapsucker | 1 | 81242 | 2 | 1.446 | 56184.0 |
117 | 2016-05-23 14:34:42 | sapsucker | 4 | 165329 | 165 | 46.960 | 3520.6 |
116 | 2016-05-17 19:19:47 | sapsucker | 4 | 165329 | 165 | 16.870 | 9800.2 |
115 | 2016-05-15 21:01:20 | sapsucker | 4 | 165329 | 165 | 11.986 | 13793.5 |
114 | 2016-05-15 11:29:47 | sapsucker | 4 | 165329 | 165 | 24.073 | 6867.8 |
113 | 2016-05-09 20:40:18 | sapsucker | 4 | 165329 | 165 | 13.083 | 12636.9 |
112 | 2016-05-09 05:34:16 | sapsucker | 1 | 81242 | 2 | 1.540 | 52754.5 |
111 | 2016-05-07 12:33:00 | sapsucker | 4 | 165329 | 165 | 13.023 | 12695.2 |
110 | 2016-04-29 17:06:27 | sapsucker | 4 | 165329 | 165 | 13.326 | 12406.5 |
109 | 2016-04-25 04:09:56 | sapsucker | 1 | 81242 | 2 | 6.440 | 12615.2 |
108 | 2016-04-23 05:54:34 | sapsucker | 4 | 165329 | 165 | 41.640 | 3970.4 |
107 | 2016-04-17 00:14:15 | sapsucker | 4 | 165329 | 165 | 38.590 | 4284.2 |
106 | 2016-04-15 11:57:45 | sapsucker | 1 | 81242 | 2 | 6.453 | 12589.8 |
105 | 2016-04-14 05:13:57 | sapsucker | 4 | 165329 | 165 | 17.226 | 9597.6 |
104 | 2016-04-14 01:29:49 | sapsucker | 1 | 81242 | 2 | 2.466 | 32944.8 |
103 | 2016-04-11 12:14:55 | sapsucker | 4 | 165329 | 165 | 24.080 | 6865.8 |
102 | 2016-04-11 04:07:25 | sapsucker | 1 | 81242 | 2 | 1.953 | 41598.6 |
101 | 2016-04-08 04:10:45 | sapsucker | 4 | 165329 | 165 | 42.740 | 3868.2 |
100 | 2016-04-06 17:37:06 | sapsucker | 4 | 165329 | 165 | 20.966 | 7885.6 |
99 | 2016-04-05 15:03:10 | sapsucker | 1 | 81242 | 2 | 1.956 | 41534.8 |
98 | 2016-03-30 16:27:37 | sapsucker | 4 | 165329 | 165 | 37.476 | 4411.6 |
97 | 2016-03-29 21:16:03 | sapsucker | 4 | 165329 | 165 | 34.373 | 4809.9 |
96 | 2016-03-28 11:32:13 | sapsucker | 4 | 165329 | 165 | 21.776 | 7592.3 |
95 | 2016-03-09 19:03:57 | sapsucker | 1 | 81242 | 2 | 1.396 | 58196.3 |
94 | 2016-03-09 13:05:27 | sapsucker | 2 | 121436 | 2 | 3.540 | 34304.0 |
93 | 2016-02-28 13:26:54 | sapsucker | 3 | 148641 | 15 | 8.043 | 18480.8 |
92 | 2016-02-28 13:22:06 | sapsucker | 2 | 121436 | 2 | 7.186 | 16899.0 |
91 | 2016-02-15 21:04:52 | sapsucker | 4 | 165329 | 165 | 17.196 | 9614.4 |
90 | 2016-01-10 06:14:44 | sapsucker | 1 | 81242 | 2 | 1.560 | 52078.2 |
89 | 2015-12-29 09:29:39 | sapsucker | 1 | 81242 | 2 | 1.466 | 55417.5 |
88 | 2015-12-25 14:21:36 | sapsucker | 4 | 165329 | 165 | 14.606 | 11319.3 |