History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"wares"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1172 | 2024-05-04 01:53:48 | wares | 1 | 28756 | 32 | 1.123 | 25606.4 |
1171 | 2024-05-03 23:36:10 | wares | 1 | 28756 | 32 | 0.533 | 53951.2 |
1170 | 2024-04-28 10:30:28 | wares | 2 | 53800 | 557 | 1.813 | 29674.6 |
1169 | 2024-04-24 20:52:48 | wares | 2 | 53800 | 557 | 2.483 | 21667.3 |
1168 | 2024-04-24 20:52:23 | wares | 1 | 28756 | 32 | 0.563 | 51076.4 |
1167 | 2024-04-17 09:52:28 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1166 | 2024-04-17 08:38:54 | wares | 1 | 28756 | 32 | 0.450 | 63902.2 |
1165 | 2024-04-17 08:35:57 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1164 | 2024-04-17 08:35:37 | wares | 1 | 28756 | 32 | 0.516 | 55728.7 |
1163 | 2024-04-13 16:53:25 | wares | 1 | 28756 | 32 | 0.516 | 55728.7 |
1162 | 2024-04-13 01:51:42 | wares | 2 | 53800 | 557 | 1.720 | 31279.1 |
1161 | 2024-04-02 21:56:58 | wares | 1 | 28756 | 32 | 1.076 | 26724.9 |
1160 | 2024-03-27 00:34:31 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1159 | 2024-03-25 19:42:46 | wares | 2 | 53800 | 557 | 3.656 | 14715.5 |
1158 | 2024-03-25 19:42:41 | wares | 1 | 28756 | 32 | 1.093 | 26309.2 |
1157 | 2024-03-25 19:41:53 | wares | 2 | 53800 | 557 | 1.626 | 33087.3 |
1156 | 2024-03-25 18:49:53 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1155 | 2024-03-03 23:10:16 | wares | 2 | 53800 | 557 | 6.050 | 8892.6 |
1154 | 2024-03-03 22:29:16 | wares | 1 | 28756 | 32 | 0.626 | 45936.1 |
1153 | 2024-02-26 18:10:57 | wares | 1 | 28756 | 32 | 0.610 | 47141.0 |
1152 | 2024-02-25 18:14:36 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1151 | 2024-02-25 16:32:54 | wares | 1 | 28756 | 32 | 0.466 | 61708.2 |
1150 | 2024-01-26 13:18:40 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1149 | 2024-01-24 06:54:49 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1148 | 2024-01-22 20:01:11 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1147 | 2024-01-22 10:51:18 | wares | 1 | 28756 | 32 | 0.530 | 54256.6 |
1146 | 2023-12-30 21:46:29 | wares | 1 | 28756 | 32 | 0.516 | 55728.7 |
1145 | 2023-12-29 21:18:18 | wares | 2 | 53800 | 557 | 1.703 | 31591.3 |
1144 | 2023-12-11 19:15:30 | wares | 2 | 53800 | 557 | 1.656 | 32487.9 |
1143 | 2023-12-03 06:45:20 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1142 | 2023-12-03 06:45:19 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1141 | 2023-11-21 06:46:18 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1140 | 2023-11-19 20:32:41 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1139 | 2023-11-14 21:47:20 | wares | 1 | 28756 | 32 | 0.516 | 55728.7 |
1138 | 2023-11-13 10:34:00 | wares | 2 | 53800 | 557 | 1.390 | 38705.0 |
1137 | 2023-11-08 11:15:21 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1136 | 2023-11-08 08:49:34 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1135 | 2023-11-07 10:52:42 | wares | 1 | 28756 | 32 | 1.123 | 25606.4 |
1134 | 2023-11-06 15:48:38 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1133 | 2023-10-27 10:07:04 | wares | 2 | 53800 | 557 | 1.703 | 31591.3 |
1132 | 2023-10-25 20:15:36 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1131 | 2023-10-20 21:16:10 | wares | 2 | 53800 | 557 | 1.423 | 37807.4 |
1130 | 2023-10-19 15:06:04 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1129 | 2023-10-17 21:41:37 | wares | 2 | 53800 | 557 | 1.513 | 35558.5 |
1128 | 2023-10-16 18:56:30 | wares | 1 | 28756 | 32 | 0.440 | 65354.5 |
1127 | 2023-10-11 01:40:07 | wares | 2 | 53800 | 557 | 1.876 | 28678.0 |
1126 | 2023-10-10 09:48:58 | wares | 1 | 28756 | 32 | 0.440 | 65354.5 |
1125 | 2023-10-04 10:39:43 | wares | 2 | 53800 | 557 | 1.563 | 34421.0 |
1124 | 2023-10-03 08:57:23 | wares | 1 | 28756 | 32 | 0.456 | 63061.4 |
1123 | 2023-09-25 14:39:28 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1122 | 2023-09-22 13:19:30 | wares | 2 | 53800 | 557 | 1.390 | 38705.0 |
1121 | 2023-09-22 00:52:13 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1120 | 2023-09-18 21:20:34 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1119 | 2023-09-18 19:14:55 | wares | 1 | 28756 | 32 | 0.486 | 59168.7 |
1118 | 2023-09-11 05:58:32 | wares | 2 | 53800 | 557 | 1.610 | 33416.1 |
1117 | 2023-09-10 12:56:54 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1116 | 2023-09-08 18:51:54 | wares | 2 | 53800 | 557 | 1.453 | 37026.8 |
1115 | 2023-09-08 14:35:53 | wares | 1 | 28756 | 32 | 0.486 | 59168.7 |
1114 | 2023-07-23 10:13:55 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1113 | 2023-07-16 19:49:17 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1112 | 2023-06-14 13:39:47 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1111 | 2023-05-29 09:32:07 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1110 | 2023-05-24 11:31:59 | wares | 2 | 53800 | 557 | 1.373 | 39184.3 |
1109 | 2023-03-31 17:28:36 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1108 | 2023-03-12 12:16:05 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1107 | 2023-03-03 19:39:24 | wares | 2 | 53800 | 557 | 1.373 | 39184.3 |
1106 | 2023-02-09 19:22:39 | wares | 1 | 28756 | 32 | 0.423 | 67981.1 |
1105 | 2023-01-17 08:37:03 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1104 | 2023-01-13 21:09:45 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1103 | 2022-12-11 03:03:13 | wares | 2 | 53800 | 557 | 1.546 | 34799.5 |
1102 | 2022-11-24 20:10:27 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1101 | 2022-11-14 13:01:00 | wares | 1 | 28756 | 32 | 0.576 | 49923.6 |
1100 | 2022-11-13 14:14:31 | wares | 1 | 28756 | 32 | 0.516 | 55728.7 |
1099 | 2022-11-02 12:21:08 | wares | 1 | 28756 | 32 | 0.903 | 31845.0 |
1098 | 2022-10-23 06:25:56 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1097 | 2022-10-13 19:58:21 | wares | 2 | 53800 | 557 | 1.436 | 37465.2 |
1096 | 2022-09-04 09:41:45 | wares | 2 | 53800 | 557 | 1.623 | 33148.5 |
1095 | 2022-09-02 02:43:13 | wares | 1 | 28756 | 32 | 0.456 | 63061.4 |
1094 | 2022-08-31 18:37:58 | wares | 1 | 28756 | 32 | 0.440 | 65354.5 |
1093 | 2022-07-27 16:27:53 | wares | 2 | 53800 | 557 | 1.423 | 37807.4 |
1092 | 2022-06-30 22:08:18 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1091 | 2022-06-29 13:55:03 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1090 | 2022-06-25 17:09:47 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1089 | 2022-06-22 13:24:04 | wares | 1 | 28756 | 32 | 0.453 | 63479.0 |
1088 | 2022-05-24 04:17:56 | wares | 1 | 28756 | 32 | 0.513 | 56054.6 |
1087 | 2022-05-18 10:47:47 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1086 | 2022-05-01 23:10:43 | wares | 1 | 28756 | 32 | 0.440 | 65354.5 |
1085 | 2022-05-01 09:02:42 | wares | 1 | 28756 | 32 | 0.576 | 49923.6 |
1084 | 2022-04-30 18:21:48 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |
1083 | 2022-04-30 09:38:38 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1082 | 2022-04-29 12:11:55 | wares | 1 | 28756 | 32 | 0.546 | 52666.7 |
1081 | 2022-04-29 00:29:39 | wares | 1 | 28756 | 32 | 0.513 | 56054.6 |
1080 | 2022-04-28 14:27:39 | wares | 1 | 28756 | 32 | 0.686 | 41918.4 |
1079 | 2022-04-28 03:07:36 | wares | 1 | 28756 | 32 | 0.483 | 59536.2 |
1078 | 2022-04-27 11:22:15 | wares | 1 | 28756 | 32 | 1.393 | 20643.2 |
1077 | 2022-04-26 14:26:46 | wares | 1 | 28756 | 32 | 0.560 | 51350.0 |
1076 | 2022-04-26 02:33:00 | wares | 1 | 28756 | 32 | 0.686 | 41918.4 |
1075 | 2022-04-25 12:22:22 | wares | 1 | 28756 | 32 | 0.690 | 41675.4 |
1074 | 2022-04-24 20:15:45 | wares | 1 | 28756 | 32 | 0.436 | 65954.1 |
1073 | 2022-04-24 01:44:10 | wares | 1 | 28756 | 32 | 0.500 | 57512.0 |