History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"gates"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1216 | 2025-05-09 00:45:12 | gates | 1 | 28756 | 28 | 0.533 | 53951.2 |
1215 | 2025-05-08 14:36:48 | gates | 1 | 28756 | 28 | 0.970 | 29645.4 |
1214 | 2025-05-04 13:57:09 | gates | 1 | 28756 | 28 | 2.423 | 11867.9 |
1213 | 2025-05-03 20:06:57 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1212 | 2025-05-03 01:39:18 | gates | 1 | 28756 | 28 | 2.563 | 11219.7 |
1211 | 2025-04-30 12:34:16 | gates | 1 | 28756 | 28 | 3.470 | 8287.0 |
1210 | 2025-04-29 22:49:00 | gates | 1 | 28756 | 28 | 3.766 | 7635.7 |
1209 | 2025-04-27 22:57:31 | gates | 1 | 28756 | 28 | 2.153 | 13356.2 |
1208 | 2025-04-25 09:37:12 | gates | 2 | 53800 | 455 | 1.670 | 32215.6 |
1207 | 2025-04-24 23:15:34 | gates | 1 | 28756 | 28 | 2.330 | 12341.6 |
1206 | 2025-04-23 21:02:16 | gates | 2 | 53800 | 455 | 8.610 | 6248.5 |
1205 | 2025-04-16 06:47:59 | gates | 1 | 28756 | 28 | 2.346 | 12257.5 |
1204 | 2025-04-15 02:12:10 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1203 | 2025-04-12 05:00:11 | gates | 2 | 53800 | 455 | 8.110 | 6633.8 |
1202 | 2025-04-08 13:46:13 | gates | 1 | 28756 | 28 | 1.656 | 17364.7 |
1201 | 2025-04-03 02:14:53 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1200 | 2025-04-02 01:13:11 | gates | 1 | 28756 | 28 | 2.343 | 12273.2 |
1199 | 2025-03-29 14:28:01 | gates | 1 | 28756 | 28 | 2.626 | 10950.5 |
1198 | 2025-03-25 00:28:48 | gates | 1 | 28756 | 28 | 0.983 | 29253.3 |
1197 | 2025-03-16 06:10:23 | gates | 2 | 53800 | 455 | 5.953 | 9037.5 |
1196 | 2025-03-15 09:30:23 | gates | 2 | 53800 | 455 | 5.970 | 9011.7 |
1195 | 2025-03-15 08:14:48 | gates | 1 | 28756 | 28 | 0.923 | 31154.9 |
1194 | 2025-03-13 14:54:05 | gates | 1 | 28756 | 28 | 1.266 | 22714.1 |
1193 | 2025-03-12 07:35:52 | gates | 1 | 28756 | 28 | 1.046 | 27491.4 |
1192 | 2025-03-07 02:50:11 | gates | 1 | 28756 | 28 | 1.343 | 21411.8 |
1191 | 2025-03-02 05:06:57 | gates | 1 | 28756 | 28 | 0.966 | 29768.1 |
1190 | 2025-02-26 06:22:10 | gates | 2 | 53800 | 455 | 8.500 | 6329.4 |
1189 | 2025-02-25 18:35:25 | gates | 2 | 53800 | 455 | 4.026 | 13363.1 |
1188 | 2025-02-25 12:37:45 | gates | 2 | 53800 | 455 | 7.470 | 7202.1 |
1187 | 2025-02-25 11:34:13 | gates | 1 | 28756 | 28 | 0.530 | 54256.6 |
1186 | 2025-02-25 06:48:26 | gates | 1 | 28756 | 28 | 1.546 | 18600.3 |
1185 | 2025-02-25 00:24:18 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1184 | 2025-02-22 19:19:44 | gates | 1 | 28756 | 28 | 0.983 | 29253.3 |
1183 | 2025-02-14 00:00:14 | gates | 1 | 28756 | 28 | 2.406 | 11951.8 |
1182 | 2025-02-04 17:06:08 | gates | 1 | 28756 | 28 | 1.716 | 16757.6 |
1181 | 2025-01-29 13:56:51 | gates | 1 | 28756 | 28 | 0.453 | 63479.0 |
1180 | 2025-01-26 09:23:19 | gates | 1 | 28756 | 28 | 0.563 | 51076.4 |
1179 | 2025-01-26 05:55:52 | gates | 1 | 28756 | 28 | 3.030 | 9490.4 |
1178 | 2025-01-23 18:39:34 | gates | 1 | 28756 | 28 | 2.640 | 10892.4 |
1177 | 2025-01-17 22:07:34 | gates | 1 | 28756 | 28 | 1.673 | 17188.3 |
1176 | 2025-01-14 04:39:40 | gates | 1 | 28756 | 28 | 0.533 | 53951.2 |
1175 | 2025-01-05 16:07:33 | gates | 1 | 28756 | 28 | 2.470 | 11642.1 |
1174 | 2024-12-29 17:23:47 | gates | 1 | 28756 | 28 | 0.436 | 65954.1 |
1173 | 2024-12-27 12:06:37 | gates | 2 | 53800 | 455 | 5.420 | 9926.2 |
1172 | 2024-12-27 09:16:24 | gates | 2 | 53800 | 455 | 2.546 | 21131.2 |
1171 | 2024-12-27 05:35:04 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1170 | 2024-12-27 04:18:26 | gates | 2 | 53800 | 455 | 9.253 | 5814.3 |
1169 | 2024-12-27 02:53:59 | gates | 2 | 53800 | 455 | 3.690 | 14579.9 |
1168 | 2024-12-27 02:50:48 | gates | 1 | 28756 | 28 | 0.950 | 30269.5 |
1167 | 2024-12-24 17:22:47 | gates | 1 | 28756 | 28 | 1.013 | 28387.0 |
1166 | 2024-12-06 13:23:37 | gates | 1 | 28756 | 28 | 0.950 | 30269.5 |
1165 | 2024-11-27 03:04:43 | gates | 1 | 28756 | 28 | 1.203 | 23903.6 |
1164 | 2024-11-27 02:06:41 | gates | 1 | 28756 | 28 | 2.253 | 12763.4 |
1163 | 2024-11-24 15:43:51 | gates | 1 | 28756 | 28 | 2.156 | 13337.7 |
1162 | 2024-11-06 08:25:11 | gates | 1 | 28756 | 28 | 3.186 | 9025.7 |
1161 | 2024-10-28 01:57:16 | gates | 1 | 28756 | 28 | 1.076 | 26724.9 |
1160 | 2024-10-28 00:45:25 | gates | 1 | 28756 | 28 | 2.080 | 13825.0 |
1159 | 2024-10-26 19:44:31 | gates | 2 | 53800 | 455 | 8.500 | 6329.4 |
1158 | 2024-10-25 15:36:18 | gates | 2 | 53800 | 455 | 7.283 | 7387.1 |
1157 | 2024-10-25 13:13:49 | gates | 2 | 53800 | 455 | 2.020 | 26633.7 |
1156 | 2024-10-25 13:13:45 | gates | 1 | 28756 | 28 | 0.516 | 55728.7 |
1155 | 2024-10-19 21:27:34 | gates | 1 | 28756 | 28 | 1.500 | 19170.7 |
1154 | 2024-10-07 09:48:08 | gates | 1 | 28756 | 28 | 5.580 | 5153.4 |
1153 | 2024-09-30 16:25:35 | gates | 1 | 28756 | 28 | 4.890 | 5880.6 |
1152 | 2024-09-28 00:13:25 | gates | 1 | 28756 | 28 | 0.466 | 61708.2 |
1151 | 2024-09-27 23:17:40 | gates | 1 | 28756 | 28 | 3.343 | 8601.9 |
1150 | 2024-09-25 12:05:37 | gates | 1 | 28756 | 28 | 5.296 | 5429.8 |
1149 | 2024-09-07 08:30:45 | gates | 1 | 28756 | 28 | 2.093 | 13739.1 |
1148 | 2024-09-03 03:31:53 | gates | 1 | 28756 | 28 | 4.486 | 6410.2 |
1147 | 2024-08-29 16:38:18 | gates | 1 | 28756 | 28 | 2.876 | 9998.6 |
1146 | 2024-08-28 20:33:15 | gates | 1 | 28756 | 28 | 6.596 | 4359.6 |
1145 | 2024-08-28 18:12:40 | gates | 1 | 28756 | 28 | 6.596 | 4359.6 |
1144 | 2024-08-26 19:16:40 | gates | 1 | 28756 | 28 | 2.766 | 10396.2 |
1143 | 2024-08-18 12:27:39 | gates | 1 | 28756 | 28 | 3.280 | 8767.1 |
1142 | 2024-08-12 12:11:57 | gates | 1 | 28756 | 28 | 2.190 | 13130.6 |
1141 | 2024-08-09 16:51:34 | gates | 1 | 28756 | 28 | 1.750 | 16432.0 |
1140 | 2024-08-02 09:44:33 | gates | 1 | 28756 | 28 | 0.763 | 37688.1 |
1139 | 2024-07-29 16:39:50 | gates | 1 | 28756 | 28 | 1.953 | 14724.0 |
1138 | 2024-07-29 15:59:21 | gates | 1 | 28756 | 28 | 2.860 | 10054.5 |
1137 | 2024-07-26 20:50:52 | gates | 1 | 28756 | 28 | 2.403 | 11966.7 |
1136 | 2024-07-26 06:07:29 | gates | 1 | 28756 | 28 | 1.780 | 16155.1 |
1135 | 2024-07-13 20:31:12 | gates | 2 | 53800 | 455 | 3.170 | 16971.6 |
1134 | 2024-07-13 20:22:25 | gates | 2 | 53800 | 455 | 6.766 | 7951.5 |
1133 | 2024-07-11 18:54:14 | gates | 1 | 28756 | 28 | 2.860 | 10054.5 |
1132 | 2024-07-08 04:52:09 | gates | 1 | 28756 | 28 | 2.813 | 10222.5 |
1131 | 2024-07-08 04:23:26 | gates | 1 | 28756 | 28 | 2.703 | 10638.5 |
1130 | 2024-07-05 05:02:45 | gates | 1 | 28756 | 28 | 1.903 | 15110.9 |
1129 | 2024-07-05 05:00:02 | gates | 1 | 28756 | 28 | 1.966 | 14626.7 |
1128 | 2024-07-03 06:29:55 | gates | 1 | 28756 | 28 | 2.610 | 11017.6 |
1127 | 2024-06-29 17:36:44 | gates | 2 | 53800 | 455 | 3.610 | 14903.0 |
1126 | 2024-06-29 15:29:57 | gates | 2 | 53800 | 455 | 7.360 | 7309.8 |
1125 | 2024-06-29 15:07:45 | gates | 1 | 28756 | 28 | 0.500 | 57512.0 |
1124 | 2024-06-29 13:49:09 | gates | 1 | 28756 | 28 | 1.550 | 18552.3 |
1123 | 2024-06-26 14:29:48 | gates | 1 | 28756 | 28 | 2.563 | 11219.7 |
1122 | 2024-06-21 09:46:12 | gates | 1 | 28756 | 28 | 1.046 | 27491.4 |
1121 | 2024-06-13 15:56:19 | gates | 1 | 28756 | 28 | 2.670 | 10770.0 |
1120 | 2024-06-12 09:04:49 | gates | 1 | 28756 | 28 | 0.876 | 32826.5 |
1119 | 2024-06-11 03:12:59 | gates | 1 | 28756 | 28 | 1.390 | 20687.8 |
1118 | 2024-06-10 02:48:21 | gates | 1 | 28756 | 28 | 1.000 | 28756.0 |
1117 | 2024-05-31 04:19:23 | gates | 1 | 28756 | 28 | 0.530 | 54256.6 |