History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"trough"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1178 | 2024-05-06 18:50:00 | trough | 1 | 48755 | 6 | 0.890 | 54780.9 |
1177 | 2024-05-06 15:04:46 | trough | 2 | 82551 | 46 | 2.530 | 32628.9 |
1176 | 2024-05-06 10:06:51 | trough | 1 | 48755 | 6 | 0.953 | 51159.5 |
1175 | 2024-05-06 02:05:55 | trough | 2 | 82551 | 46 | 3.516 | 23478.7 |
1174 | 2024-05-05 21:56:40 | trough | 2 | 82551 | 46 | 2.580 | 31996.5 |
1173 | 2024-05-05 21:56:36 | trough | 1 | 48755 | 6 | 1.046 | 46610.9 |
1172 | 2024-05-05 21:56:20 | trough | 3 | 112716 | 322 | 7.326 | 15385.7 |
1171 | 2024-05-05 18:32:39 | trough | 3 | 112716 | 322 | 19.720 | 5715.8 |
1170 | 2024-05-05 09:46:09 | trough | 1 | 48755 | 6 | 1.920 | 25393.2 |
1169 | 2024-05-04 16:26:23 | trough | 3 | 112716 | 322 | 10.236 | 11011.7 |
1168 | 2024-04-29 20:04:36 | trough | 1 | 48755 | 6 | 0.860 | 56691.9 |
1167 | 2024-04-29 07:53:01 | trough | 2 | 82551 | 46 | 2.546 | 32423.8 |
1166 | 2024-04-26 03:20:12 | trough | 1 | 48755 | 6 | 0.890 | 54780.9 |
1165 | 2024-04-24 23:10:22 | trough | 3 | 112716 | 322 | 6.093 | 18499.3 |
1164 | 2024-04-23 07:18:50 | trough | 1 | 48755 | 6 | 1.110 | 43923.4 |
1163 | 2024-04-17 10:24:12 | trough | 1 | 48755 | 6 | 1.093 | 44606.6 |
1162 | 2024-04-16 11:26:42 | trough | 1 | 48755 | 6 | 2.000 | 24377.5 |
1161 | 2024-04-13 15:21:17 | trough | 1 | 48755 | 6 | 0.890 | 54780.9 |
1160 | 2024-04-08 06:24:20 | trough | 2 | 82551 | 46 | 5.470 | 15091.6 |
1159 | 2024-04-08 06:23:55 | trough | 3 | 112716 | 322 | 8.610 | 13091.3 |
1158 | 2024-04-04 19:45:50 | trough | 3 | 112716 | 322 | 12.376 | 9107.6 |
1157 | 2024-04-04 19:45:27 | trough | 2 | 82551 | 46 | 5.373 | 15364.0 |
1156 | 2024-04-04 07:14:53 | trough | 3 | 112716 | 322 | 18.233 | 6182.0 |
1155 | 2024-04-04 07:14:58 | trough | 2 | 82551 | 46 | 5.766 | 14316.9 |
1154 | 2024-04-03 09:33:23 | trough | 2 | 82551 | 46 | 4.466 | 18484.3 |
1153 | 2024-04-03 09:32:30 | trough | 3 | 112716 | 322 | 6.330 | 17806.6 |
1152 | 2024-03-28 19:26:48 | trough | 1 | 48755 | 6 | 0.890 | 54780.9 |
1151 | 2024-03-28 11:45:09 | trough | 1 | 48755 | 6 | 0.810 | 60191.4 |
1150 | 2024-03-28 11:45:02 | trough | 3 | 112716 | 322 | 5.343 | 21096.0 |
1149 | 2024-03-28 11:45:02 | trough | 2 | 82551 | 46 | 2.516 | 32810.4 |
1148 | 2024-03-28 11:45:01 | trough | 1 | 48755 | 6 | 0.843 | 57835.1 |
1147 | 2024-03-05 10:28:26 | trough | 1 | 48755 | 6 | 0.920 | 52994.6 |
1146 | 2024-02-29 23:56:02 | trough | 2 | 82551 | 46 | 2.593 | 31836.1 |
1145 | 2024-02-29 23:55:17 | trough | 3 | 112716 | 322 | 6.016 | 18736.0 |
1144 | 2024-02-27 08:27:01 | trough | 2 | 82551 | 46 | 6.890 | 11981.3 |
1143 | 2024-02-25 23:07:30 | trough | 3 | 112716 | 322 | 17.186 | 6558.6 |
1142 | 2024-02-25 16:23:52 | trough | 1 | 48755 | 6 | 0.766 | 63648.8 |
1141 | 2024-02-19 23:04:18 | trough | 3 | 112716 | 322 | 12.733 | 8852.3 |
1140 | 2024-02-12 03:49:04 | trough | 3 | 112716 | 322 | 8.330 | 13531.3 |
1139 | 2024-02-11 18:21:35 | trough | 3 | 112716 | 322 | 18.546 | 6077.6 |
1138 | 2024-02-11 14:13:24 | trough | 3 | 112716 | 322 | 4.610 | 24450.3 |
1137 | 2024-01-26 14:32:27 | trough | 1 | 48755 | 6 | 0.876 | 55656.4 |
1136 | 2024-01-07 07:23:06 | trough | 1 | 48755 | 6 | 0.733 | 66514.3 |
1135 | 2023-12-21 00:40:38 | trough | 2 | 82551 | 46 | 2.203 | 37472.1 |
1134 | 2023-12-15 11:07:39 | trough | 1 | 48755 | 6 | 0.813 | 59969.2 |
1133 | 2023-11-12 09:55:17 | trough | 3 | 112716 | 322 | 4.986 | 22606.5 |
1132 | 2023-11-11 04:36:21 | trough | 2 | 82551 | 46 | 2.203 | 37472.1 |
1131 | 2023-11-11 04:36:14 | trough | 3 | 112716 | 322 | 5.140 | 21929.2 |
1130 | 2023-11-10 15:23:59 | trough | 2 | 82551 | 46 | 5.923 | 13937.4 |
1129 | 2023-11-10 15:23:57 | trough | 3 | 112716 | 322 | 6.656 | 16934.5 |
1128 | 2023-11-08 11:33:56 | trough | 1 | 48755 | 6 | 0.876 | 55656.4 |
1127 | 2023-11-08 01:18:12 | trough | 1 | 48755 | 6 | 0.720 | 67715.3 |
1126 | 2023-11-07 10:28:27 | trough | 1 | 48755 | 6 | 1.720 | 28345.9 |
1125 | 2023-11-06 19:07:33 | trough | 1 | 48755 | 6 | 0.826 | 59025.4 |
1124 | 2023-11-05 19:05:15 | trough | 1 | 48755 | 6 | 1.623 | 30040.0 |
1123 | 2023-10-29 23:21:39 | trough | 1 | 48755 | 6 | 0.876 | 55656.4 |
1122 | 2023-10-27 01:52:48 | trough | 3 | 112716 | 322 | 4.750 | 23729.7 |
1121 | 2023-10-27 01:52:46 | trough | 2 | 82551 | 46 | 2.296 | 35954.3 |
1120 | 2023-10-25 20:01:11 | trough | 1 | 48755 | 6 | 0.843 | 57835.1 |
1119 | 2023-10-20 17:10:13 | trough | 3 | 112716 | 322 | 20.546 | 5486.0 |
1118 | 2023-10-20 17:09:47 | trough | 2 | 82551 | 46 | 2.983 | 27673.8 |
1117 | 2023-10-19 14:56:52 | trough | 1 | 48755 | 6 | 0.766 | 63648.8 |
1116 | 2023-10-18 04:09:56 | trough | 2 | 82551 | 46 | 2.343 | 35233.0 |
1115 | 2023-10-18 04:09:52 | trough | 3 | 112716 | 322 | 4.966 | 22697.5 |
1114 | 2023-10-16 19:10:09 | trough | 1 | 48755 | 6 | 0.843 | 57835.1 |
1113 | 2023-10-14 07:16:07 | trough | 3 | 112716 | 322 | 5.563 | 20261.7 |
1112 | 2023-10-12 07:30:27 | trough | 2 | 82551 | 46 | 2.623 | 31472.0 |
1111 | 2023-10-10 12:47:57 | trough | 1 | 48755 | 6 | 0.826 | 59025.4 |
1110 | 2023-10-05 19:58:32 | trough | 1 | 48755 | 6 | 0.846 | 57630.0 |
1109 | 2023-10-04 08:58:44 | trough | 3 | 112716 | 322 | 4.860 | 23192.6 |
1108 | 2023-10-04 08:58:43 | trough | 2 | 82551 | 46 | 2.266 | 36430.3 |
1107 | 2023-10-03 08:53:50 | trough | 1 | 48755 | 6 | 0.750 | 65006.7 |
1106 | 2023-09-25 13:29:47 | trough | 1 | 48755 | 6 | 0.750 | 65006.7 |
1105 | 2023-09-23 21:06:39 | trough | 3 | 112716 | 322 | 4.783 | 23566.0 |
1104 | 2023-09-23 21:06:33 | trough | 2 | 82551 | 46 | 2.343 | 35233.0 |
1103 | 2023-09-21 07:20:11 | trough | 2 | 82551 | 46 | 4.750 | 17379.2 |
1102 | 2023-09-18 23:47:50 | trough | 1 | 48755 | 6 | 0.763 | 63899.1 |
1101 | 2023-09-15 20:11:14 | trough | 1 | 48755 | 6 | 0.766 | 63648.8 |
1100 | 2023-09-10 13:59:43 | trough | 2 | 82551 | 46 | 2.360 | 34979.2 |
1099 | 2023-09-10 13:59:39 | trough | 3 | 112716 | 322 | 4.923 | 22895.8 |
1098 | 2023-09-10 11:10:03 | trough | 1 | 48755 | 6 | 0.733 | 66514.3 |
1097 | 2023-08-24 01:27:16 | trough | 1 | 48755 | 6 | 1.000 | 48755.0 |
1096 | 2023-08-15 10:42:04 | trough | 3 | 112716 | 322 | 11.283 | 9989.9 |
1095 | 2023-07-26 11:31:31 | trough | 1 | 48755 | 6 | 0.813 | 59969.2 |
1094 | 2023-07-23 16:44:19 | trough | 1 | 48755 | 6 | 0.843 | 57835.1 |
1093 | 2023-07-23 10:07:40 | trough | 1 | 48755 | 6 | 0.826 | 59025.4 |
1092 | 2023-07-16 19:45:00 | trough | 1 | 48755 | 6 | 0.876 | 55656.4 |
1091 | 2023-06-30 00:42:47 | trough | 2 | 82551 | 46 | 2.470 | 33421.5 |
1090 | 2023-06-10 12:59:59 | trough | 1 | 48755 | 6 | 0.736 | 66243.2 |
1089 | 2023-05-28 00:14:32 | trough | 1 | 48755 | 6 | 0.720 | 67715.3 |
1088 | 2023-05-26 23:57:51 | trough | 1 | 48755 | 6 | 0.750 | 65006.7 |
1087 | 2023-05-25 03:15:24 | trough | 1 | 48755 | 6 | 0.796 | 61250.0 |
1086 | 2023-04-27 22:34:14 | trough | 3 | 112716 | 322 | 4.670 | 24136.2 |
1085 | 2023-03-27 14:09:31 | trough | 1 | 48755 | 6 | 0.826 | 59025.4 |
1084 | 2023-03-23 09:47:32 | trough | 2 | 82551 | 46 | 2.110 | 39123.7 |
1083 | 2023-03-20 00:42:38 | trough | 1 | 48755 | 6 | 0.750 | 65006.7 |
1082 | 2023-03-14 17:07:09 | trough | 1 | 48755 | 6 | 0.813 | 59969.2 |
1081 | 2023-03-12 12:09:11 | trough | 1 | 48755 | 6 | 0.750 | 65006.7 |
1080 | 2023-03-10 07:51:01 | trough | 1 | 48755 | 6 | 0.736 | 66243.2 |
1079 | 2023-01-31 12:48:19 | trough | 3 | 112716 | 322 | 4.606 | 24471.6 |