History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"aspen"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1173 | 2025-04-17 03:27:23 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
1172 | 2025-04-11 06:22:57 | aspen | 1 | 28756 | 5 | 1.156 | 24875.4 |
1171 | 2025-04-09 05:27:31 | aspen | 2 | 53800 | 71 | 8.516 | 6317.5 |
1170 | 2025-04-08 16:18:52 | aspen | 1 | 28756 | 5 | 0.533 | 53951.2 |
1169 | 2025-04-08 04:43:44 | aspen | 3 | 83667 | 1197 | 4.296 | 19475.6 |
1168 | 2025-04-02 10:08:35 | aspen | 1 | 28756 | 5 | 2.423 | 11867.9 |
1167 | 2025-04-02 10:03:13 | aspen | 1 | 28756 | 5 | 2.470 | 11642.1 |
1166 | 2025-03-30 10:28:16 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
1165 | 2025-03-23 14:30:37 | aspen | 2 | 53800 | 71 | 8.110 | 6633.8 |
1164 | 2025-03-23 13:26:01 | aspen | 3 | 83667 | 1197 | 20.236 | 4134.6 |
1163 | 2025-03-22 06:33:32 | aspen | 2 | 53800 | 71 | 1.390 | 38705.0 |
1162 | 2025-03-21 17:24:38 | aspen | 3 | 83667 | 1197 | 27.190 | 3077.1 |
1161 | 2025-03-21 12:54:47 | aspen | 3 | 83667 | 1197 | 15.406 | 5430.8 |
1160 | 2025-03-21 12:37:10 | aspen | 3 | 83667 | 1197 | 17.346 | 4823.4 |
1159 | 2025-03-21 05:01:12 | aspen | 3 | 83667 | 1197 | 16.673 | 5018.1 |
1158 | 2025-03-20 21:32:52 | aspen | 3 | 83667 | 1197 | 4.300 | 19457.4 |
1157 | 2025-03-19 17:12:23 | aspen | 3 | 83667 | 1197 | 3.360 | 24900.9 |
1156 | 2025-03-17 15:19:40 | aspen | 1 | 28756 | 5 | 2.200 | 13070.9 |
1155 | 2025-03-09 07:56:21 | aspen | 1 | 28756 | 5 | 2.343 | 12273.2 |
1154 | 2025-03-08 01:06:28 | aspen | 1 | 28756 | 5 | 3.576 | 8041.4 |
1153 | 2025-03-02 03:10:20 | aspen | 1 | 28756 | 5 | 2.330 | 12341.6 |
1152 | 2025-02-28 00:03:59 | aspen | 1 | 28756 | 5 | 0.546 | 52666.7 |
1151 | 2025-02-26 08:31:03 | aspen | 1 | 28756 | 5 | 1.716 | 16757.6 |
1150 | 2025-02-25 01:46:17 | aspen | 2 | 53800 | 71 | 6.376 | 8437.9 |
1149 | 2025-02-25 00:07:21 | aspen | 2 | 53800 | 71 | 5.936 | 9063.3 |
1148 | 2025-02-24 20:33:10 | aspen | 2 | 53800 | 71 | 8.203 | 6558.6 |
1147 | 2025-02-13 02:11:55 | aspen | 1 | 28756 | 5 | 1.343 | 21411.8 |
1146 | 2025-02-07 02:20:02 | aspen | 2 | 53800 | 71 | 8.030 | 6699.9 |
1145 | 2025-02-07 02:11:50 | aspen | 1 | 28756 | 5 | 0.503 | 57169.0 |
1144 | 2025-02-01 10:02:34 | aspen | 3 | 83667 | 1197 | 4.186 | 19987.3 |
1143 | 2025-01-29 13:53:11 | aspen | 3 | 83667 | 1197 | 10.326 | 8102.6 |
1142 | 2025-01-29 09:12:51 | aspen | 3 | 83667 | 1197 | 19.483 | 4294.4 |
1141 | 2025-01-29 08:51:34 | aspen | 3 | 83667 | 1197 | 24.063 | 3477.0 |
1140 | 2025-01-29 08:04:41 | aspen | 3 | 83667 | 1197 | 21.873 | 3825.1 |
1139 | 2025-01-29 08:04:23 | aspen | 1 | 28756 | 5 | 2.593 | 11089.9 |
1138 | 2025-01-27 23:47:20 | aspen | 2 | 53800 | 71 | 6.516 | 8256.6 |
1137 | 2025-01-27 23:08:35 | aspen | 2 | 53800 | 71 | 7.236 | 7435.0 |
1136 | 2025-01-27 03:45:39 | aspen | 1 | 28756 | 5 | 2.360 | 12184.7 |
1135 | 2025-01-26 12:02:46 | aspen | 1 | 28756 | 5 | 2.936 | 9794.3 |
1134 | 2025-01-07 20:21:56 | aspen | 1 | 28756 | 5 | 2.420 | 11882.6 |
1133 | 2025-01-01 21:48:09 | aspen | 2 | 53800 | 71 | 11.703 | 4597.1 |
1132 | 2024-12-29 16:30:22 | aspen | 2 | 53800 | 71 | 5.296 | 10158.6 |
1131 | 2024-12-28 15:15:59 | aspen | 3 | 83667 | 1197 | 14.563 | 5745.2 |
1130 | 2024-12-28 10:45:03 | aspen | 3 | 83667 | 1197 | 15.266 | 5480.6 |
1129 | 2024-12-27 23:37:48 | aspen | 1 | 28756 | 5 | 1.173 | 24514.9 |
1128 | 2024-12-27 22:30:06 | aspen | 3 | 83667 | 1197 | 21.126 | 3960.4 |
1127 | 2024-12-27 17:01:43 | aspen | 3 | 83667 | 1197 | 18.063 | 4632.0 |
1126 | 2024-12-27 06:22:18 | aspen | 1 | 28756 | 5 | 0.453 | 63479.0 |
1125 | 2024-12-26 05:43:35 | aspen | 3 | 83667 | 1197 | 14.873 | 5625.4 |
1124 | 2024-12-25 14:50:43 | aspen | 3 | 83667 | 1197 | 22.626 | 3697.8 |
1123 | 2024-12-08 17:19:30 | aspen | 1 | 28756 | 5 | 2.156 | 13337.7 |
1122 | 2024-12-05 03:01:18 | aspen | 3 | 83667 | 1197 | 20.703 | 4041.3 |
1121 | 2024-12-03 05:13:14 | aspen | 1 | 28756 | 5 | 1.703 | 16885.5 |
1120 | 2024-11-28 03:36:43 | aspen | 2 | 53800 | 71 | 7.873 | 6833.5 |
1119 | 2024-11-28 02:26:02 | aspen | 3 | 83667 | 1197 | 9.266 | 9029.5 |
1118 | 2024-11-27 14:28:16 | aspen | 3 | 83667 | 1197 | 16.936 | 4940.2 |
1117 | 2024-11-27 14:28:15 | aspen | 2 | 53800 | 71 | 5.406 | 9951.9 |
1116 | 2024-11-27 14:15:39 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
1115 | 2024-11-27 03:35:26 | aspen | 1 | 28756 | 5 | 1.093 | 26309.2 |
1114 | 2024-11-26 01:09:02 | aspen | 3 | 83667 | 1197 | 19.140 | 4371.3 |
1113 | 2024-11-24 15:53:28 | aspen | 3 | 83667 | 1197 | 14.140 | 5917.0 |
1112 | 2024-11-08 14:06:47 | aspen | 1 | 28756 | 5 | 1.390 | 20687.8 |
1111 | 2024-10-29 19:16:53 | aspen | 2 | 53800 | 71 | 9.076 | 5927.7 |
1110 | 2024-10-29 02:33:58 | aspen | 3 | 83667 | 1197 | 10.936 | 7650.6 |
1109 | 2024-10-28 20:52:42 | aspen | 2 | 53800 | 71 | 7.516 | 7158.1 |
1108 | 2024-10-28 19:46:53 | aspen | 1 | 28756 | 5 | 1.766 | 16283.1 |
1107 | 2024-10-28 16:03:17 | aspen | 3 | 83667 | 1197 | 14.530 | 5758.2 |
1106 | 2024-10-28 12:22:57 | aspen | 3 | 83667 | 1197 | 17.673 | 4734.2 |
1105 | 2024-10-28 12:22:51 | aspen | 2 | 53800 | 71 | 10.203 | 5273.0 |
1104 | 2024-10-28 11:33:56 | aspen | 1 | 28756 | 5 | 0.500 | 57512.0 |
1103 | 2024-10-28 01:53:38 | aspen | 1 | 28756 | 5 | 0.486 | 59168.7 |
1102 | 2024-10-23 13:56:50 | aspen | 1 | 28756 | 5 | 1.420 | 20250.7 |
1101 | 2024-10-20 18:41:17 | aspen | 3 | 83667 | 1197 | 29.846 | 2803.3 |
1100 | 2024-10-19 18:28:19 | aspen | 3 | 83667 | 1197 | 20.596 | 4062.3 |
1099 | 2024-10-18 17:17:06 | aspen | 3 | 83667 | 1197 | 8.970 | 9327.4 |
1098 | 2024-10-17 16:56:26 | aspen | 1 | 28756 | 5 | 1.736 | 16564.5 |
1097 | 2024-10-17 01:25:07 | aspen | 1 | 28756 | 5 | 1.173 | 24514.9 |
1096 | 2024-10-14 19:18:47 | aspen | 3 | 83667 | 1197 | 10.156 | 8238.2 |
1095 | 2024-10-12 18:17:34 | aspen | 3 | 83667 | 1197 | 16.423 | 5094.5 |
1094 | 2024-10-11 23:18:21 | aspen | 3 | 83667 | 1197 | 16.223 | 5157.3 |
1093 | 2024-10-10 17:10:21 | aspen | 3 | 83667 | 1197 | 14.750 | 5672.3 |
1092 | 2024-10-09 22:09:04 | aspen | 3 | 83667 | 1197 | 10.860 | 7704.1 |
1091 | 2024-10-09 13:28:41 | aspen | 1 | 28756 | 5 | 1.546 | 18600.3 |
1090 | 2024-10-02 15:13:12 | aspen | 3 | 83667 | 1197 | 30.110 | 2778.7 |
1089 | 2024-09-29 04:16:46 | aspen | 2 | 53800 | 71 | 5.423 | 9920.7 |
1088 | 2024-09-29 00:37:38 | aspen | 1 | 28756 | 5 | 3.330 | 8635.4 |
1087 | 2024-09-28 20:22:21 | aspen | 2 | 53800 | 71 | 1.530 | 35163.4 |
1086 | 2024-09-28 15:12:08 | aspen | 3 | 83667 | 1197 | 27.596 | 3031.9 |
1085 | 2024-09-28 14:38:39 | aspen | 3 | 83667 | 1197 | 21.813 | 3835.6 |
1084 | 2024-09-28 07:09:04 | aspen | 3 | 83667 | 1197 | 17.513 | 4777.4 |
1083 | 2024-09-28 07:09:04 | aspen | 2 | 53800 | 71 | 17.766 | 3028.3 |
1082 | 2024-09-28 05:05:20 | aspen | 1 | 28756 | 5 | 0.516 | 55728.7 |
1081 | 2024-09-27 22:43:11 | aspen | 1 | 28756 | 5 | 1.686 | 17055.8 |
1080 | 2024-09-26 16:37:47 | aspen | 3 | 83667 | 1197 | 32.670 | 2561.0 |
1079 | 2024-09-21 05:57:55 | aspen | 1 | 28756 | 5 | 2.780 | 10343.9 |
1078 | 2024-09-14 13:36:54 | aspen | 1 | 28756 | 5 | 2.813 | 10222.5 |
1077 | 2024-09-08 16:46:38 | aspen | 1 | 28756 | 5 | 3.860 | 7449.7 |
1076 | 2024-08-30 15:25:49 | aspen | 1 | 28756 | 5 | 4.733 | 6075.6 |
1075 | 2024-08-29 20:12:57 | aspen | 3 | 83667 | 1197 | 14.440 | 5794.1 |
1074 | 2024-08-29 08:15:44 | aspen | 3 | 83667 | 1197 | 29.783 | 2809.2 |