History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"sternposts"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
173 | 2024-04-26 23:24:16 | sternposts | 2 | 108824 | 3 | 3.466 | 31397.6 |
172 | 2024-04-10 13:54:02 | sternposts | 3 | 140603 | 12 | 28.360 | 4957.8 |
171 | 2024-04-10 13:53:54 | sternposts | 4 | 161450 | 82 | 34.253 | 4713.5 |
170 | 2024-04-10 13:53:57 | sternposts | 2 | 108824 | 3 | 13.750 | 7914.5 |
169 | 2024-04-10 13:20:44 | sternposts | 1 | 67641 | 2 | 1.200 | 56367.5 |
168 | 2024-04-06 05:32:47 | sternposts | 1 | 67641 | 2 | 1.420 | 47634.5 |
167 | 2024-04-03 22:27:48 | sternposts | 4 | 161450 | 82 | 42.096 | 3835.3 |
166 | 2024-04-03 12:26:28 | sternposts | 3 | 140603 | 12 | 15.186 | 9258.7 |
165 | 2024-03-31 17:44:03 | sternposts | 3 | 140603 | 12 | 30.266 | 4645.6 |
164 | 2024-03-31 17:43:59 | sternposts | 4 | 161450 | 82 | 30.346 | 5320.3 |
163 | 2024-03-31 17:44:00 | sternposts | 4 | 161450 | 82 | 18.203 | 8869.4 |
162 | 2024-03-31 17:44:04 | sternposts | 2 | 108824 | 3 | 9.000 | 12091.6 |
161 | 2024-03-31 15:31:09 | sternposts | 1 | 67641 | 2 | 1.420 | 47634.5 |
160 | 2024-03-30 00:42:07 | sternposts | 1 | 67641 | 2 | 1.310 | 51634.4 |
159 | 2024-03-28 03:39:02 | sternposts | 1 | 67641 | 2 | 1.110 | 60937.8 |
158 | 2024-03-02 19:09:53 | sternposts | 4 | 161450 | 82 | 36.736 | 4394.9 |
157 | 2024-03-02 08:54:07 | sternposts | 1 | 67641 | 2 | 1.203 | 56226.9 |
156 | 2024-02-29 08:03:32 | sternposts | 1 | 67641 | 2 | 1.156 | 58513.0 |
155 | 2024-02-28 20:08:00 | sternposts | 1 | 67641 | 2 | 1.123 | 60232.4 |
154 | 2024-02-27 08:19:30 | sternposts | 4 | 161450 | 82 | 12.033 | 13417.3 |
153 | 2024-02-27 08:19:17 | sternposts | 4 | 161450 | 82 | 11.203 | 14411.3 |
152 | 2024-02-26 21:43:26 | sternposts | 1 | 67641 | 2 | 1.186 | 57032.9 |
151 | 2024-02-26 07:03:49 | sternposts | 4 | 161450 | 82 | 33.940 | 4756.9 |
150 | 2024-02-25 20:52:38 | sternposts | 5 | 173545 | 718 | 23.343 | 7434.6 |
149 | 2024-02-25 20:52:37 | sternposts | 4 | 161450 | 82 | 15.826 | 10201.6 |
148 | 2024-02-23 12:28:36 | sternposts | 5 | 173545 | 718 | 22.343 | 7767.3 |
147 | 2024-02-23 12:28:39 | sternposts | 3 | 140603 | 12 | 14.343 | 9802.9 |
146 | 2024-02-23 12:28:38 | sternposts | 4 | 161450 | 82 | 14.063 | 11480.5 |
145 | 2024-02-23 12:28:40 | sternposts | 2 | 108824 | 3 | 7.453 | 14601.4 |
144 | 2024-02-23 07:20:37 | sternposts | 1 | 67641 | 2 | 2.530 | 26735.6 |
143 | 2024-01-29 16:01:54 | sternposts | 1 | 67641 | 2 | 1.140 | 59334.2 |
142 | 2024-01-26 00:36:13 | sternposts | 1 | 67641 | 2 | 1.143 | 59178.5 |
141 | 2024-01-23 23:00:24 | sternposts | 1 | 67641 | 2 | 1.126 | 60071.9 |
140 | 2024-01-22 16:56:19 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
139 | 2023-11-22 03:27:09 | sternposts | 5 | 173545 | 718 | 15.250 | 11380.0 |
138 | 2023-11-20 14:29:49 | sternposts | 1 | 67641 | 2 | 1.060 | 63812.3 |
137 | 2023-10-15 03:14:57 | sternposts | 1 | 67641 | 2 | 1.030 | 65670.9 |
136 | 2023-10-08 12:25:51 | sternposts | 1 | 67641 | 2 | 1.126 | 60071.9 |
135 | 2023-09-13 21:00:20 | sternposts | 5 | 173545 | 718 | 36.390 | 4769.0 |
134 | 2023-09-05 21:27:00 | sternposts | 1 | 67641 | 2 | 1.190 | 56841.2 |
133 | 2023-08-22 01:48:07 | sternposts | 5 | 173545 | 718 | 16.253 | 10677.7 |
132 | 2023-07-05 09:21:37 | sternposts | 1 | 67641 | 2 | 1.186 | 57032.9 |
131 | 2023-06-10 17:37:40 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
130 | 2023-05-06 01:39:13 | sternposts | 5 | 173545 | 718 | 15.110 | 11485.4 |
129 | 2023-03-29 18:40:19 | sternposts | 1 | 67641 | 2 | 1.110 | 60937.8 |
128 | 2023-02-14 04:43:27 | sternposts | 5 | 173545 | 718 | 16.983 | 10218.7 |
127 | 2023-02-02 04:29:13 | sternposts | 1 | 67641 | 2 | 1.126 | 60071.9 |
126 | 2023-01-12 06:18:20 | sternposts | 1 | 67641 | 2 | 0.983 | 68810.8 |
125 | 2022-11-24 07:13:03 | sternposts | 5 | 173545 | 718 | 15.173 | 11437.8 |
124 | 2022-10-30 16:25:10 | sternposts | 1 | 67641 | 2 | 0.986 | 68601.4 |
123 | 2022-09-01 20:58:37 | sternposts | 5 | 173545 | 718 | 17.720 | 9793.7 |
122 | 2022-08-30 10:05:48 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
121 | 2022-06-19 23:17:16 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
120 | 2022-05-20 03:02:05 | sternposts | 1 | 67641 | 2 | 1.033 | 65480.2 |
119 | 2022-05-08 00:06:39 | sternposts | 5 | 173545 | 718 | 25.610 | 6776.5 |
118 | 2022-03-10 05:17:57 | sternposts | 1 | 67641 | 2 | 1.093 | 61885.6 |
117 | 2022-03-05 18:27:28 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
116 | 2021-10-03 16:54:39 | sternposts | 1 | 67641 | 2 | 1.126 | 60071.9 |
115 | 2021-06-17 21:10:37 | sternposts | 1 | 67641 | 2 | 2.390 | 28301.7 |
114 | 2021-03-15 01:08:43 | sternposts | 1 | 67641 | 2 | 1.140 | 59334.2 |
113 | 2021-02-27 11:38:52 | sternposts | 1 | 67641 | 2 | 1.033 | 65480.2 |
112 | 2021-01-31 05:25:18 | sternposts | 1 | 67641 | 2 | 1.110 | 60937.8 |
111 | 2021-01-28 13:36:45 | sternposts | 4 | 161450 | 82 | 11.313 | 14271.2 |
110 | 2021-01-26 18:18:46 | sternposts | 5 | 173545 | 718 | 16.266 | 10669.2 |
109 | 2021-01-03 07:33:57 | sternposts | 1 | 67641 | 2 | 1.013 | 66773.0 |
108 | 2020-12-12 00:37:14 | sternposts | 1 | 67641 | 2 | 1.123 | 60232.4 |
107 | 2020-09-30 23:28:36 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
106 | 2020-09-09 13:11:05 | sternposts | 1 | 67641 | 2 | 1.033 | 65480.2 |
105 | 2020-09-01 18:49:43 | sternposts | 1 | 67641 | 2 | 1.046 | 64666.3 |
104 | 2020-07-10 19:31:02 | sternposts | 1 | 67641 | 2 | 1.140 | 59334.2 |
103 | 2020-06-17 20:34:56 | sternposts | 1 | 67641 | 2 | 1.123 | 60232.4 |
102 | 2020-04-26 22:41:25 | sternposts | 1 | 67641 | 2 | 1.203 | 56226.9 |
101 | 2020-03-24 22:52:13 | sternposts | 1 | 67641 | 2 | 1.283 | 52721.0 |
100 | 2020-03-15 18:44:28 | sternposts | 1 | 67641 | 2 | 1.030 | 65670.9 |
99 | 2020-02-18 21:37:35 | sternposts | 1 | 67641 | 2 | 2.606 | 25955.9 |
98 | 2020-02-17 17:59:09 | sternposts | 1 | 67641 | 2 | 2.626 | 25758.2 |
97 | 2020-02-17 16:37:37 | sternposts | 1 | 67641 | 2 | 1.203 | 56226.9 |
96 | 2020-02-10 15:34:44 | sternposts | 1 | 67641 | 2 | 1.346 | 50253.3 |
95 | 2020-02-06 10:34:49 | sternposts | 1 | 67641 | 2 | 1.330 | 50857.9 |
94 | 2020-01-25 18:42:19 | sternposts | 1 | 67641 | 2 | 2.610 | 25916.1 |
93 | 2020-01-18 06:42:34 | sternposts | 1 | 67641 | 2 | 2.233 | 30291.5 |
92 | 2020-01-10 05:02:42 | sternposts | 1 | 67641 | 2 | 1.206 | 56087.1 |
91 | 2020-01-07 15:35:17 | sternposts | 1 | 67641 | 2 | 2.703 | 25024.4 |
90 | 2020-01-05 12:38:06 | sternposts | 1 | 67641 | 2 | 1.000 | 67641.0 |
89 | 2020-01-03 04:49:15 | sternposts | 1 | 67641 | 2 | 1.500 | 45094.0 |
88 | 2019-11-17 03:20:21 | sternposts | 1 | 67641 | 2 | 1.093 | 61885.6 |
87 | 2019-10-06 23:52:03 | sternposts | 1 | 67641 | 2 | 0.956 | 70754.2 |
86 | 2019-07-01 02:45:11 | sternposts | 1 | 67641 | 2 | 1.010 | 66971.3 |
85 | 2019-06-29 02:45:23 | sternposts | 1 | 67641 | 2 | 1.063 | 63632.2 |
84 | 2019-06-27 02:50:11 | sternposts | 1 | 67641 | 2 | 1.020 | 66314.7 |
83 | 2019-06-18 06:15:01 | sternposts | 1 | 67641 | 2 | 1.200 | 56367.5 |
82 | 2019-06-18 05:39:10 | sternposts | 1 | 67641 | 2 | 1.100 | 61491.8 |
81 | 2019-06-11 21:11:36 | sternposts | 1 | 67641 | 2 | 1.136 | 59543.1 |
80 | 2019-02-08 16:43:40 | sternposts | 1 | 67641 | 2 | 1.120 | 60393.8 |
79 | 2018-10-07 22:26:33 | sternposts | 1 | 67641 | 2 | 1.466 | 46139.8 |
78 | 2018-09-23 23:42:42 | sternposts | 1 | 67641 | 2 | 1.150 | 58818.3 |
77 | 2018-06-21 17:55:18 | sternposts | 1 | 67641 | 2 | 2.436 | 27767.2 |
76 | 2018-06-20 02:50:11 | sternposts | 1 | 67641 | 2 | 1.260 | 53683.3 |
75 | 2018-05-14 13:06:54 | sternposts | 5 | 173545 | 718 | 18.840 | 9211.5 |
74 | 2018-03-14 00:53:02 | sternposts | 1 | 67641 | 2 | 1.420 | 47634.5 |