History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hotspurs"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
183 | 2024-04-04 01:51:29 | hotspurs | 3 | 146162 | 22 | 21.126 | 6918.6 |
182 | 2024-03-30 06:14:26 | hotspurs | 4 | 161609 | 405 | 27.690 | 5836.4 |
181 | 2024-03-29 21:07:30 | hotspurs | 1 | 82945 | 2 | 1.530 | 54212.4 |
180 | 2024-03-29 21:07:11 | hotspurs | 2 | 121059 | 3 | 4.236 | 28578.6 |
179 | 2024-03-29 09:49:53 | hotspurs | 3 | 146162 | 22 | 14.263 | 10247.6 |
178 | 2024-03-29 01:58:04 | hotspurs | 4 | 161609 | 405 | 29.173 | 5539.7 |
177 | 2024-03-28 23:27:27 | hotspurs | 4 | 161609 | 405 | 14.360 | 11254.1 |
176 | 2024-03-28 23:27:28 | hotspurs | 3 | 146162 | 22 | 8.453 | 17291.1 |
175 | 2024-03-28 23:27:33 | hotspurs | 1 | 82945 | 2 | 1.623 | 51106.0 |
174 | 2024-03-28 23:27:26 | hotspurs | 2 | 121059 | 3 | 4.186 | 28920.0 |
173 | 2024-03-28 23:27:24 | hotspurs | 1 | 82945 | 2 | 1.610 | 51518.6 |
172 | 2024-03-09 20:23:20 | hotspurs | 1 | 82945 | 2 | 1.686 | 49196.3 |
171 | 2024-03-05 02:04:45 | hotspurs | 3 | 146162 | 22 | 24.436 | 5981.4 |
170 | 2024-03-04 20:21:13 | hotspurs | 4 | 161609 | 405 | 15.686 | 10302.8 |
169 | 2024-03-03 13:56:13 | hotspurs | 3 | 146162 | 22 | 11.076 | 13196.3 |
168 | 2024-03-02 00:02:15 | hotspurs | 2 | 121059 | 3 | 8.653 | 13990.4 |
167 | 2024-03-01 16:47:16 | hotspurs | 4 | 161609 | 405 | 16.483 | 9804.6 |
166 | 2024-02-29 06:25:08 | hotspurs | 2 | 121059 | 3 | 4.203 | 28803.0 |
165 | 2024-02-27 22:40:17 | hotspurs | 4 | 161609 | 405 | 27.456 | 5886.1 |
164 | 2024-02-27 22:40:07 | hotspurs | 2 | 121059 | 3 | 8.546 | 14165.6 |
163 | 2024-02-27 22:39:18 | hotspurs | 3 | 146162 | 22 | 7.920 | 18454.8 |
162 | 2024-02-27 20:18:01 | hotspurs | 4 | 161609 | 405 | 13.096 | 12340.3 |
161 | 2024-02-27 20:18:01 | hotspurs | 3 | 146162 | 22 | 7.533 | 19402.9 |
160 | 2024-02-27 20:17:59 | hotspurs | 2 | 121059 | 3 | 3.720 | 32542.7 |
159 | 2024-02-27 20:17:58 | hotspurs | 1 | 82945 | 2 | 1.410 | 58826.2 |
158 | 2024-02-18 07:29:52 | hotspurs | 1 | 82945 | 2 | 3.186 | 26034.2 |
157 | 2024-02-09 18:45:19 | hotspurs | 4 | 161609 | 405 | 13.893 | 11632.4 |
156 | 2024-02-09 18:45:18 | hotspurs | 3 | 146162 | 22 | 14.250 | 10257.0 |
155 | 2024-02-08 01:00:43 | hotspurs | 3 | 146162 | 22 | 24.780 | 5898.4 |
154 | 2024-02-01 20:04:57 | hotspurs | 1 | 82945 | 2 | 1.233 | 67270.9 |
153 | 2024-01-31 08:39:31 | hotspurs | 1 | 82945 | 2 | 1.436 | 57761.1 |
152 | 2024-01-27 13:58:31 | hotspurs | 2 | 121059 | 3 | 3.656 | 33112.4 |
151 | 2024-01-27 13:58:19 | hotspurs | 3 | 146162 | 22 | 7.330 | 19940.2 |
150 | 2024-01-26 11:31:11 | hotspurs | 4 | 161609 | 405 | 11.203 | 14425.5 |
149 | 2024-01-26 08:56:07 | hotspurs | 3 | 146162 | 22 | 16.236 | 9002.3 |
148 | 2024-01-26 08:56:03 | hotspurs | 4 | 161609 | 405 | 13.953 | 11582.4 |
147 | 2024-01-26 08:55:59 | hotspurs | 2 | 121059 | 3 | 3.766 | 32145.2 |
146 | 2024-01-13 06:20:51 | hotspurs | 1 | 82945 | 2 | 1.280 | 64800.8 |
145 | 2024-01-05 07:16:42 | hotspurs | 1 | 82945 | 2 | 1.436 | 57761.1 |
144 | 2023-11-26 20:52:48 | hotspurs | 1 | 82945 | 2 | 1.470 | 56425.2 |
143 | 2023-11-26 17:38:10 | hotspurs | 1 | 82945 | 2 | 1.283 | 64649.3 |
142 | 2023-11-24 14:09:05 | hotspurs | 1 | 82945 | 2 | 1.406 | 58993.6 |
141 | 2023-09-12 01:32:34 | hotspurs | 1 | 82945 | 2 | 1.263 | 65673.0 |
140 | 2023-06-25 00:13:51 | hotspurs | 1 | 82945 | 2 | 1.250 | 66356.0 |
139 | 2023-04-06 12:16:19 | hotspurs | 1 | 82945 | 2 | 1.263 | 65673.0 |
138 | 2023-01-19 19:54:13 | hotspurs | 1 | 82945 | 2 | 1.216 | 68211.3 |
137 | 2022-11-17 11:55:34 | hotspurs | 1 | 82945 | 2 | 1.533 | 54106.3 |
136 | 2022-07-07 15:56:03 | hotspurs | 1 | 82945 | 2 | 1.266 | 65517.4 |
135 | 2021-07-01 16:09:45 | hotspurs | 1 | 82945 | 2 | 1.423 | 58288.8 |
134 | 2021-05-28 11:59:01 | hotspurs | 1 | 82945 | 2 | 1.516 | 54713.1 |
133 | 2021-04-13 16:34:21 | hotspurs | 1 | 82945 | 2 | 2.686 | 30880.5 |
132 | 2021-03-17 11:19:03 | hotspurs | 1 | 82945 | 2 | 1.406 | 58993.6 |
131 | 2021-01-04 05:14:49 | hotspurs | 1 | 82945 | 2 | 1.250 | 66356.0 |
130 | 2020-12-30 11:20:45 | hotspurs | 1 | 82945 | 2 | 1.343 | 61761.0 |
129 | 2020-12-27 01:45:54 | hotspurs | 1 | 82945 | 2 | 1.326 | 62552.8 |
128 | 2020-12-02 00:40:51 | hotspurs | 1 | 82945 | 2 | 1.250 | 66356.0 |
127 | 2020-11-28 02:13:31 | hotspurs | 1 | 82945 | 2 | 1.283 | 64649.3 |
126 | 2020-11-23 13:12:52 | hotspurs | 1 | 82945 | 2 | 1.310 | 63316.8 |
125 | 2020-11-13 02:36:26 | hotspurs | 1 | 82945 | 2 | 1.263 | 65673.0 |
124 | 2020-03-28 05:09:41 | hotspurs | 1 | 82945 | 2 | 1.436 | 57761.1 |
123 | 2020-03-24 22:27:25 | hotspurs | 1 | 82945 | 2 | 1.453 | 57085.3 |
122 | 2020-03-12 02:41:14 | hotspurs | 1 | 82945 | 2 | 2.080 | 39877.4 |
121 | 2020-03-06 09:28:27 | hotspurs | 1 | 82945 | 2 | 1.263 | 65673.0 |
120 | 2020-02-09 12:34:53 | hotspurs | 1 | 82945 | 2 | 1.440 | 57600.7 |
119 | 2020-02-02 10:21:05 | hotspurs | 1 | 82945 | 2 | 1.610 | 51518.6 |
118 | 2020-01-31 16:28:41 | hotspurs | 1 | 82945 | 2 | 1.516 | 54713.1 |
117 | 2020-01-27 06:07:51 | hotspurs | 1 | 82945 | 2 | 1.530 | 54212.4 |
116 | 2020-01-19 12:16:52 | hotspurs | 1 | 82945 | 2 | 1.266 | 65517.4 |
115 | 2020-01-14 09:00:26 | hotspurs | 1 | 82945 | 2 | 4.156 | 19957.9 |
114 | 2020-01-01 21:10:19 | hotspurs | 1 | 82945 | 2 | 1.500 | 55296.7 |
113 | 2019-12-31 02:22:23 | hotspurs | 1 | 82945 | 2 | 1.593 | 52068.4 |
112 | 2019-12-08 10:05:16 | hotspurs | 1 | 82945 | 2 | 1.313 | 63172.1 |
111 | 2019-09-06 10:22:57 | hotspurs | 1 | 82945 | 2 | 1.393 | 59544.1 |
110 | 2019-08-25 11:17:44 | hotspurs | 1 | 82945 | 2 | 1.176 | 70531.5 |
109 | 2019-08-15 16:08:39 | hotspurs | 1 | 82945 | 2 | 1.190 | 69701.7 |
108 | 2019-08-11 00:50:54 | hotspurs | 1 | 82945 | 2 | 1.316 | 63028.1 |
107 | 2019-08-08 15:03:00 | hotspurs | 1 | 82945 | 2 | 1.200 | 69120.8 |
106 | 2019-08-03 14:05:42 | hotspurs | 1 | 82945 | 2 | 1.273 | 65157.1 |
105 | 2019-07-25 09:24:37 | hotspurs | 1 | 82945 | 2 | 1.183 | 70114.1 |
104 | 2019-07-23 09:15:50 | hotspurs | 1 | 82945 | 2 | 1.320 | 62837.1 |
103 | 2019-07-19 15:45:50 | hotspurs | 1 | 82945 | 2 | 1.226 | 67655.0 |
102 | 2019-07-18 17:19:30 | hotspurs | 1 | 82945 | 2 | 1.213 | 68380.0 |
101 | 2019-07-14 19:54:45 | hotspurs | 1 | 82945 | 2 | 1.266 | 65517.4 |
100 | 2019-07-13 16:07:43 | hotspurs | 1 | 82945 | 2 | 1.243 | 66729.7 |
99 | 2019-07-11 10:35:40 | hotspurs | 1 | 82945 | 2 | 1.260 | 65829.4 |
98 | 2019-07-09 10:29:12 | hotspurs | 1 | 82945 | 2 | 1.256 | 66039.0 |
97 | 2019-07-07 05:53:37 | hotspurs | 1 | 82945 | 2 | 1.433 | 57882.1 |
96 | 2019-07-04 05:48:36 | hotspurs | 1 | 82945 | 2 | 1.260 | 65829.4 |
95 | 2019-07-02 09:42:49 | hotspurs | 1 | 82945 | 2 | 1.306 | 63510.7 |
94 | 2019-06-30 09:41:03 | hotspurs | 1 | 82945 | 2 | 1.233 | 67270.9 |
93 | 2019-06-28 09:39:51 | hotspurs | 1 | 82945 | 2 | 1.463 | 56695.1 |
92 | 2019-06-26 09:42:18 | hotspurs | 1 | 82945 | 2 | 1.403 | 59119.7 |
91 | 2019-06-24 18:31:32 | hotspurs | 1 | 82945 | 2 | 1.316 | 63028.1 |
90 | 2019-06-22 19:04:56 | hotspurs | 1 | 82945 | 2 | 1.263 | 65673.0 |
89 | 2019-06-17 19:20:10 | hotspurs | 1 | 82945 | 2 | 1.353 | 61304.5 |
88 | 2019-06-15 20:43:32 | hotspurs | 1 | 82945 | 2 | 1.236 | 67107.6 |
87 | 2019-06-14 04:03:25 | hotspurs | 1 | 82945 | 2 | 1.346 | 61623.3 |
86 | 2019-06-12 08:21:36 | hotspurs | 1 | 82945 | 2 | 1.286 | 64498.4 |
85 | 2019-06-08 16:31:42 | hotspurs | 1 | 82945 | 2 | 1.456 | 56967.7 |
84 | 2019-06-06 09:32:26 | hotspurs | 1 | 82945 | 2 | 1.406 | 58993.6 |