History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"hoagies"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1199 | 2024-04-25 20:26:32 | hoagies | 3 | 134027 | 557 | 19.046 | 7037.0 |
1198 | 2024-04-24 16:58:32 | hoagies | 3 | 134027 | 557 | 10.360 | 12937.0 |
1197 | 2024-04-22 08:44:01 | hoagies | 3 | 134027 | 557 | 21.893 | 6121.9 |
1196 | 2024-04-04 04:11:01 | hoagies | 3 | 134027 | 557 | 9.436 | 14203.8 |
1195 | 2024-03-30 19:32:04 | hoagies | 3 | 134027 | 557 | 14.703 | 9115.6 |
1194 | 2024-03-30 13:10:04 | hoagies | 1 | 69583 | 3 | 1.513 | 45990.1 |
1193 | 2024-03-30 09:15:43 | hoagies | 3 | 134027 | 557 | 21.550 | 6219.4 |
1192 | 2024-03-30 08:58:24 | hoagies | 3 | 134027 | 557 | 13.813 | 9703.0 |
1191 | 2024-03-30 08:58:23 | hoagies | 2 | 107671 | 34 | 3.846 | 27995.6 |
1190 | 2024-03-30 06:53:16 | hoagies | 1 | 69583 | 3 | 1.343 | 51811.6 |
1189 | 2024-03-15 23:29:35 | hoagies | 1 | 69583 | 3 | 2.296 | 30306.2 |
1188 | 2024-03-15 20:14:20 | hoagies | 2 | 107671 | 34 | 2.783 | 38688.8 |
1187 | 2024-03-13 17:29:44 | hoagies | 1 | 69583 | 3 | 2.373 | 29322.8 |
1186 | 2024-03-01 17:00:26 | hoagies | 1 | 69583 | 3 | 1.373 | 50679.5 |
1185 | 2024-02-13 13:39:11 | hoagies | 3 | 134027 | 557 | 21.750 | 6162.2 |
1184 | 2024-02-12 16:52:52 | hoagies | 3 | 134027 | 557 | 21.330 | 6283.5 |
1183 | 2024-02-12 16:52:52 | hoagies | 2 | 107671 | 34 | 11.140 | 9665.3 |
1182 | 2024-02-12 11:26:20 | hoagies | 1 | 69583 | 3 | 1.250 | 55666.4 |
1181 | 2024-01-29 19:34:40 | hoagies | 1 | 69583 | 3 | 1.250 | 55666.4 |
1180 | 2024-01-19 04:32:44 | hoagies | 1 | 69583 | 3 | 1.063 | 65459.1 |
1179 | 2024-01-07 07:01:25 | hoagies | 1 | 69583 | 3 | 1.186 | 58670.3 |
1178 | 2023-12-25 17:36:22 | hoagies | 3 | 134027 | 557 | 6.860 | 19537.5 |
1177 | 2023-12-20 02:36:39 | hoagies | 3 | 134027 | 557 | 7.986 | 16782.7 |
1176 | 2023-11-28 07:31:30 | hoagies | 2 | 107671 | 34 | 2.843 | 37872.3 |
1175 | 2023-11-24 16:01:10 | hoagies | 1 | 69583 | 3 | 1.063 | 65459.1 |
1174 | 2023-11-21 06:05:16 | hoagies | 1 | 69583 | 3 | 1.216 | 57222.9 |
1173 | 2023-11-19 00:26:47 | hoagies | 3 | 134027 | 557 | 5.813 | 23056.4 |
1172 | 2023-11-15 01:27:59 | hoagies | 1 | 69583 | 3 | 1.093 | 63662.4 |
1171 | 2023-11-12 16:46:56 | hoagies | 3 | 134027 | 557 | 5.813 | 23056.4 |
1170 | 2023-11-11 11:03:43 | hoagies | 1 | 69583 | 3 | 1.266 | 54962.9 |
1169 | 2023-10-13 15:14:35 | hoagies | 1 | 69583 | 3 | 1.186 | 58670.3 |
1168 | 2023-09-29 15:32:54 | hoagies | 1 | 69583 | 3 | 1.063 | 65459.1 |
1167 | 2023-09-10 23:19:23 | hoagies | 3 | 134027 | 557 | 5.983 | 22401.3 |
1166 | 2023-09-10 01:42:15 | hoagies | 3 | 134027 | 557 | 5.876 | 22809.2 |
1165 | 2023-09-09 15:45:04 | hoagies | 3 | 134027 | 557 | 6.736 | 19897.1 |
1164 | 2023-09-08 06:25:48 | hoagies | 3 | 134027 | 557 | 5.780 | 23188.1 |
1163 | 2023-09-02 05:48:03 | hoagies | 3 | 134027 | 557 | 6.876 | 19492.0 |
1162 | 2023-09-01 19:05:12 | hoagies | 1 | 69583 | 3 | 1.050 | 66269.5 |
1161 | 2023-08-28 17:27:15 | hoagies | 2 | 107671 | 34 | 2.923 | 36835.8 |
1160 | 2023-08-20 16:49:48 | hoagies | 3 | 134027 | 557 | 6.296 | 21287.6 |
1159 | 2023-08-17 17:17:40 | hoagies | 3 | 134027 | 557 | 7.110 | 18850.5 |
1158 | 2023-08-08 14:23:34 | hoagies | 1 | 69583 | 3 | 1.060 | 65644.3 |
1157 | 2023-08-06 18:09:59 | hoagies | 3 | 134027 | 557 | 7.173 | 18684.9 |
1156 | 2023-08-04 19:49:18 | hoagies | 1 | 69583 | 3 | 1.126 | 61796.6 |
1155 | 2023-08-03 06:15:27 | hoagies | 3 | 134027 | 557 | 10.140 | 13217.7 |
1154 | 2023-08-02 20:37:13 | hoagies | 3 | 134027 | 557 | 6.013 | 22289.5 |
1153 | 2023-08-01 15:01:34 | hoagies | 3 | 134027 | 557 | 6.733 | 19906.0 |
1152 | 2023-07-30 19:07:24 | hoagies | 3 | 134027 | 557 | 7.156 | 18729.3 |
1151 | 2023-07-28 22:30:56 | hoagies | 3 | 134027 | 557 | 6.546 | 20474.6 |
1150 | 2023-07-27 09:52:09 | hoagies | 3 | 134027 | 557 | 5.970 | 22450.1 |
1149 | 2023-07-26 14:34:14 | hoagies | 3 | 134027 | 557 | 5.796 | 23124.1 |
1148 | 2023-07-25 02:22:27 | hoagies | 3 | 134027 | 557 | 5.703 | 23501.1 |
1147 | 2023-07-23 06:46:03 | hoagies | 3 | 134027 | 557 | 5.720 | 23431.3 |
1146 | 2023-07-21 04:08:00 | hoagies | 3 | 134027 | 557 | 6.673 | 20085.0 |
1145 | 2023-07-19 03:09:29 | hoagies | 3 | 134027 | 557 | 5.983 | 22401.3 |
1144 | 2023-07-17 19:42:02 | hoagies | 3 | 134027 | 557 | 6.063 | 22105.7 |
1143 | 2023-07-16 20:18:02 | hoagies | 3 | 134027 | 557 | 5.643 | 23751.0 |
1142 | 2023-07-15 13:24:05 | hoagies | 3 | 134027 | 557 | 6.390 | 20974.5 |
1141 | 2023-07-14 22:56:46 | hoagies | 3 | 134027 | 557 | 6.670 | 20094.0 |
1140 | 2023-07-13 22:20:02 | hoagies | 3 | 134027 | 557 | 6.763 | 19817.7 |
1139 | 2023-07-09 18:39:06 | hoagies | 3 | 134027 | 557 | 6.000 | 22337.8 |
1138 | 2023-07-08 04:31:33 | hoagies | 3 | 134027 | 557 | 5.843 | 22938.0 |
1137 | 2023-07-07 00:42:24 | hoagies | 3 | 134027 | 557 | 6.203 | 21606.8 |
1136 | 2023-07-06 08:21:43 | hoagies | 3 | 134027 | 557 | 5.860 | 22871.5 |
1135 | 2023-07-04 19:13:53 | hoagies | 3 | 134027 | 557 | 6.500 | 20619.5 |
1134 | 2023-07-03 22:44:14 | hoagies | 3 | 134027 | 557 | 5.860 | 22871.5 |
1133 | 2023-07-03 00:45:07 | hoagies | 3 | 134027 | 557 | 6.356 | 21086.7 |
1132 | 2023-07-02 05:23:42 | hoagies | 3 | 134027 | 557 | 7.000 | 19146.7 |
1131 | 2023-07-01 14:47:32 | hoagies | 3 | 134027 | 557 | 6.330 | 21173.3 |
1130 | 2023-06-30 21:18:44 | hoagies | 3 | 134027 | 557 | 6.843 | 19586.0 |
1129 | 2023-06-30 04:51:35 | hoagies | 3 | 134027 | 557 | 6.923 | 19359.7 |
1128 | 2023-06-29 05:21:23 | hoagies | 3 | 134027 | 557 | 5.843 | 22938.0 |
1127 | 2023-06-28 09:37:02 | hoagies | 3 | 134027 | 557 | 5.920 | 22639.7 |
1126 | 2023-06-27 13:51:24 | hoagies | 3 | 134027 | 557 | 6.233 | 21502.8 |
1125 | 2023-06-26 04:26:01 | hoagies | 3 | 134027 | 557 | 6.203 | 21606.8 |
1124 | 2023-06-25 08:08:12 | hoagies | 3 | 134027 | 557 | 6.160 | 21757.6 |
1123 | 2023-06-24 18:41:27 | hoagies | 3 | 134027 | 557 | 5.860 | 22871.5 |
1122 | 2023-06-23 23:27:19 | hoagies | 3 | 134027 | 557 | 6.420 | 20876.5 |
1121 | 2023-06-22 10:22:43 | hoagies | 3 | 134027 | 557 | 6.796 | 19721.5 |
1120 | 2023-06-21 18:26:23 | hoagies | 3 | 134027 | 557 | 5.810 | 23068.3 |
1119 | 2023-06-21 01:50:45 | hoagies | 3 | 134027 | 557 | 6.690 | 20033.9 |
1118 | 2023-06-20 07:43:33 | hoagies | 3 | 134027 | 557 | 5.936 | 22578.7 |
1117 | 2023-06-19 13:49:30 | hoagies | 3 | 134027 | 557 | 6.050 | 22153.2 |
1116 | 2023-06-18 01:58:08 | hoagies | 3 | 134027 | 557 | 6.610 | 20276.4 |
1115 | 2023-06-17 05:07:26 | hoagies | 3 | 134027 | 557 | 6.346 | 21119.9 |
1114 | 2023-06-16 11:03:13 | hoagies | 3 | 134027 | 557 | 5.703 | 23501.1 |
1113 | 2023-06-15 14:39:30 | hoagies | 3 | 134027 | 557 | 5.876 | 22809.2 |
1112 | 2023-06-14 14:39:24 | hoagies | 3 | 134027 | 557 | 6.576 | 20381.2 |
1111 | 2023-06-14 00:35:25 | hoagies | 3 | 134027 | 557 | 5.923 | 22628.2 |
1110 | 2023-06-13 03:56:07 | hoagies | 3 | 134027 | 557 | 6.656 | 20136.3 |
1109 | 2023-06-12 12:14:19 | hoagies | 3 | 134027 | 557 | 6.250 | 21444.3 |
1108 | 2023-06-11 12:25:04 | hoagies | 3 | 134027 | 557 | 6.216 | 21561.6 |
1107 | 2023-06-09 16:45:37 | hoagies | 3 | 134027 | 557 | 5.893 | 22743.4 |
1106 | 2023-06-08 16:31:37 | hoagies | 3 | 134027 | 557 | 11.406 | 11750.6 |
1105 | 2023-06-07 17:29:15 | hoagies | 3 | 134027 | 557 | 6.576 | 20381.2 |
1104 | 2023-06-06 05:30:39 | hoagies | 3 | 134027 | 557 | 6.673 | 20085.0 |
1103 | 2023-06-06 03:27:59 | hoagies | 1 | 69583 | 3 | 1.160 | 59985.3 |
1102 | 2023-06-05 11:54:32 | hoagies | 3 | 134027 | 557 | 5.733 | 23378.2 |
1101 | 2023-06-04 08:45:29 | hoagies | 3 | 134027 | 557 | 5.733 | 23378.2 |
1100 | 2023-06-03 01:48:39 | hoagies | 3 | 134027 | 557 | 5.656 | 23696.4 |