History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"subfix"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
180 | 2024-03-08 22:22:11 | subfix | 3 | 112716 | 124 | 5.873 | 19192.2 |
179 | 2024-03-07 07:28:07 | subfix | 1 | 48755 | 2 | 2.953 | 16510.3 |
178 | 2024-03-06 23:55:44 | subfix | 3 | 112716 | 124 | 18.190 | 6196.6 |
177 | 2024-03-05 23:06:51 | subfix | 2 | 82551 | 7 | 7.593 | 10872.0 |
176 | 2024-03-05 23:03:09 | subfix | 3 | 112716 | 124 | 10.093 | 11167.7 |
175 | 2024-03-05 23:03:04 | subfix | 1 | 48755 | 2 | 3.000 | 16251.7 |
174 | 2024-02-04 21:18:02 | subfix | 1 | 48755 | 2 | 1.873 | 26030.4 |
173 | 2024-01-03 14:13:11 | subfix | 2 | 82551 | 7 | 2.186 | 37763.5 |
172 | 2023-12-25 07:21:01 | subfix | 1 | 48755 | 2 | 0.813 | 59969.2 |
171 | 2023-11-26 22:23:19 | subfix | 1 | 48755 | 2 | 0.876 | 55656.4 |
170 | 2023-11-24 11:54:46 | subfix | 3 | 112716 | 124 | 4.860 | 23192.6 |
169 | 2023-11-20 20:50:04 | subfix | 1 | 48755 | 2 | 1.640 | 29728.7 |
168 | 2023-11-05 20:54:29 | subfix | 1 | 48755 | 2 | 0.846 | 57630.0 |
167 | 2023-10-19 11:09:38 | subfix | 1 | 48755 | 2 | 0.780 | 62506.4 |
166 | 2023-10-17 04:59:17 | subfix | 1 | 48755 | 2 | 0.856 | 56956.8 |
165 | 2023-10-09 11:54:48 | subfix | 2 | 82551 | 7 | 2.156 | 38289.0 |
164 | 2023-09-29 13:23:16 | subfix | 1 | 48755 | 2 | 0.750 | 65006.7 |
163 | 2023-09-13 17:33:26 | subfix | 1 | 48755 | 2 | 1.516 | 32160.3 |
162 | 2023-09-12 08:54:17 | subfix | 1 | 48755 | 2 | 0.856 | 56956.8 |
161 | 2023-08-25 04:31:32 | subfix | 3 | 112716 | 124 | 4.580 | 24610.5 |
160 | 2023-07-20 08:15:07 | subfix | 2 | 82551 | 7 | 2.216 | 37252.3 |
159 | 2023-06-18 19:36:18 | subfix | 1 | 48755 | 2 | 0.830 | 58741.0 |
158 | 2023-05-09 02:44:15 | subfix | 3 | 112716 | 124 | 4.796 | 23502.1 |
157 | 2023-04-02 09:08:54 | subfix | 1 | 48755 | 2 | 0.750 | 65006.7 |
156 | 2023-04-01 22:13:51 | subfix | 2 | 82551 | 7 | 2.123 | 38884.1 |
155 | 2023-02-14 11:31:59 | subfix | 3 | 112716 | 124 | 4.530 | 24882.1 |
154 | 2023-01-13 08:30:58 | subfix | 1 | 48755 | 2 | 0.750 | 65006.7 |
153 | 2022-12-29 16:28:06 | subfix | 2 | 82551 | 7 | 2.173 | 37989.4 |
152 | 2022-11-25 16:45:20 | subfix | 3 | 112716 | 124 | 4.610 | 24450.3 |
151 | 2022-10-30 00:00:36 | subfix | 1 | 48755 | 2 | 0.733 | 66514.3 |
150 | 2022-09-01 09:14:29 | subfix | 1 | 48755 | 2 | 0.750 | 65006.7 |
149 | 2022-08-30 06:58:58 | subfix | 2 | 82551 | 7 | 2.140 | 38575.2 |
148 | 2022-06-18 15:51:16 | subfix | 1 | 48755 | 2 | 0.750 | 65006.7 |
147 | 2022-04-30 20:29:38 | subfix | 3 | 112716 | 124 | 4.593 | 24540.8 |
146 | 2022-02-21 19:21:06 | subfix | 1 | 48755 | 2 | 0.766 | 63648.8 |
145 | 2021-12-23 13:06:36 | subfix | 1 | 48755 | 2 | 0.843 | 57835.1 |
144 | 2021-07-24 15:51:48 | subfix | 1 | 48755 | 2 | 0.766 | 63648.8 |
143 | 2021-05-14 18:07:53 | subfix | 1 | 48755 | 2 | 0.923 | 52822.3 |
142 | 2021-04-13 19:21:36 | subfix | 1 | 48755 | 2 | 1.093 | 44606.6 |
141 | 2021-02-24 14:19:24 | subfix | 1 | 48755 | 2 | 1.170 | 41670.9 |
140 | 2021-02-20 10:44:48 | subfix | 1 | 48755 | 2 | 0.893 | 54596.9 |
139 | 2020-11-02 02:48:14 | subfix | 1 | 48755 | 2 | 0.813 | 59969.2 |
138 | 2020-10-29 15:39:33 | subfix | 1 | 48755 | 2 | 0.783 | 62266.9 |
137 | 2020-10-27 13:52:54 | subfix | 1 | 48755 | 2 | 0.780 | 62506.4 |
136 | 2020-10-23 08:22:26 | subfix | 1 | 48755 | 2 | 0.860 | 56691.9 |
135 | 2020-03-29 00:11:44 | subfix | 1 | 48755 | 2 | 1.030 | 47335.0 |
134 | 2020-03-28 16:38:48 | subfix | 1 | 48755 | 2 | 0.843 | 57835.1 |
133 | 2020-03-22 17:06:12 | subfix | 1 | 48755 | 2 | 0.890 | 54780.9 |
132 | 2020-03-18 09:41:38 | subfix | 1 | 48755 | 2 | 0.856 | 56956.8 |
131 | 2020-03-05 21:41:12 | subfix | 3 | 112716 | 124 | 9.736 | 11577.2 |
130 | 2020-03-05 20:19:09 | subfix | 1 | 48755 | 2 | 0.940 | 51867.0 |
129 | 2020-03-05 18:31:05 | subfix | 1 | 48755 | 2 | 0.953 | 51159.5 |
128 | 2020-03-05 07:01:08 | subfix | 3 | 112716 | 124 | 5.266 | 21404.5 |
127 | 2020-03-04 08:28:59 | subfix | 1 | 48755 | 2 | 1.766 | 27607.6 |
126 | 2020-02-25 17:24:34 | subfix | 1 | 48755 | 2 | 1.046 | 46610.9 |
125 | 2020-02-19 21:06:09 | subfix | 1 | 48755 | 2 | 0.970 | 50262.9 |
124 | 2020-02-19 02:58:01 | subfix | 1 | 48755 | 2 | 0.923 | 52822.3 |
123 | 2020-02-07 21:50:12 | subfix | 1 | 48755 | 2 | 1.766 | 27607.6 |
122 | 2020-01-30 11:00:45 | subfix | 1 | 48755 | 2 | 0.876 | 55656.4 |
121 | 2020-01-27 05:38:19 | subfix | 1 | 48755 | 2 | 0.860 | 56691.9 |
120 | 2020-01-24 08:54:36 | subfix | 1 | 48755 | 2 | 2.030 | 24017.2 |
119 | 2020-01-23 11:59:22 | subfix | 1 | 48755 | 2 | 2.156 | 22613.6 |
118 | 2020-01-17 23:44:45 | subfix | 3 | 112716 | 124 | 5.830 | 19333.8 |
117 | 2020-01-17 16:40:53 | subfix | 2 | 82551 | 7 | 3.923 | 21042.8 |
116 | 2020-01-17 16:40:42 | subfix | 3 | 112716 | 124 | 6.580 | 17130.1 |
115 | 2020-01-17 12:41:33 | subfix | 1 | 48755 | 2 | 2.046 | 23829.4 |
114 | 2020-01-17 11:20:34 | subfix | 1 | 48755 | 2 | 0.953 | 51159.5 |
113 | 2020-01-08 21:10:36 | subfix | 1 | 48755 | 2 | 0.906 | 53813.5 |
112 | 2020-01-08 01:40:33 | subfix | 1 | 48755 | 2 | 1.843 | 26454.2 |
111 | 2019-12-31 22:24:43 | subfix | 1 | 48755 | 2 | 0.923 | 52822.3 |
110 | 2019-12-30 15:37:18 | subfix | 1 | 48755 | 2 | 0.843 | 57835.1 |
109 | 2019-12-09 21:17:15 | subfix | 1 | 48755 | 2 | 0.843 | 57835.1 |
108 | 2019-09-08 00:00:56 | subfix | 1 | 48755 | 2 | 0.710 | 68669.0 |
107 | 2019-05-26 23:04:33 | subfix | 1 | 48755 | 2 | 0.780 | 62506.4 |
106 | 2019-05-23 20:29:09 | subfix | 1 | 48755 | 2 | 0.876 | 55656.4 |
105 | 2019-03-01 19:26:10 | subfix | 2 | 82551 | 7 | 2.600 | 31750.4 |
104 | 2019-02-26 15:01:21 | subfix | 1 | 48755 | 2 | 0.740 | 65885.1 |
103 | 2019-02-03 09:31:15 | subfix | 3 | 112716 | 124 | 4.760 | 23679.8 |
102 | 2019-01-26 18:26:45 | subfix | 1 | 48755 | 2 | 0.763 | 63899.1 |
101 | 2019-01-26 12:43:30 | subfix | 1 | 48755 | 2 | 0.730 | 66787.7 |
100 | 2019-01-23 07:54:30 | subfix | 1 | 48755 | 2 | 0.860 | 56691.9 |
99 | 2018-12-10 01:24:25 | subfix | 1 | 48755 | 2 | 0.813 | 59969.2 |
98 | 2018-11-19 04:54:30 | subfix | 1 | 48755 | 2 | 0.720 | 67715.3 |
97 | 2018-11-07 13:33:44 | subfix | 1 | 48755 | 2 | 0.726 | 67155.6 |
96 | 2018-10-23 03:44:30 | subfix | 1 | 48755 | 2 | 0.870 | 56040.2 |
95 | 2018-10-01 13:00:19 | subfix | 1 | 48755 | 2 | 0.846 | 57630.0 |
94 | 2018-10-01 12:58:29 | subfix | 1 | 48755 | 2 | 0.890 | 54780.9 |
93 | 2018-09-17 15:53:19 | subfix | 1 | 48755 | 2 | 0.760 | 64151.3 |
92 | 2018-08-23 00:55:41 | subfix | 1 | 48755 | 2 | 0.816 | 59748.8 |
91 | 2018-08-06 19:15:20 | subfix | 1 | 48755 | 2 | 0.893 | 54596.9 |
90 | 2018-08-06 19:15:12 | subfix | 1 | 48755 | 2 | 0.790 | 61715.2 |
89 | 2018-06-16 12:22:58 | subfix | 1 | 48755 | 2 | 0.890 | 54780.9 |
88 | 2018-05-18 02:06:11 | subfix | 2 | 82551 | 7 | 2.763 | 29877.3 |
87 | 2018-05-18 00:22:19 | subfix | 1 | 48755 | 2 | 0.816 | 59748.8 |
86 | 2018-05-15 14:23:51 | subfix | 1 | 48755 | 2 | 1.843 | 26454.2 |
85 | 2018-05-05 17:08:39 | subfix | 2 | 82551 | 7 | 2.236 | 36919.1 |
84 | 2018-05-01 20:33:47 | subfix | 2 | 82551 | 7 | 2.260 | 36527.0 |
83 | 2018-04-29 15:25:42 | subfix | 1 | 48755 | 2 | 0.860 | 56691.9 |
82 | 2018-04-22 23:57:08 | subfix | 1 | 48755 | 2 | 0.766 | 63648.8 |
81 | 2018-03-29 22:49:32 | subfix | 1 | 48755 | 2 | 1.426 | 34190.0 |