History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"pike"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1160 | 2024-04-20 18:58:14 | pike | 2 | 29872 | 325 | 1.046 | 28558.3 |
1159 | 2024-04-15 07:14:08 | pike | 2 | 29872 | 325 | 1.453 | 20558.8 |
1158 | 2024-04-14 23:37:43 | pike | 2 | 29872 | 325 | 1.266 | 23595.6 |
1157 | 2024-04-14 23:31:49 | pike | 1 | 13983 | 23 | 1.126 | 12418.3 |
1156 | 2024-04-13 04:51:18 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1155 | 2024-04-13 04:51:02 | pike | 2 | 29872 | 325 | 2.030 | 14715.3 |
1154 | 2024-04-09 19:13:29 | pike | 1 | 13983 | 23 | 0.750 | 18644.0 |
1153 | 2024-04-04 22:36:44 | pike | 1 | 13983 | 23 | 0.266 | 52567.7 |
1152 | 2024-04-02 23:54:25 | pike | 2 | 29872 | 325 | 1.250 | 23897.6 |
1151 | 2024-04-02 23:42:25 | pike | 1 | 13983 | 23 | 0.546 | 25609.9 |
1150 | 2024-03-28 02:09:44 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1149 | 2024-03-20 19:08:17 | pike | 2 | 29872 | 325 | 2.060 | 14501.0 |
1148 | 2024-03-13 04:32:29 | pike | 1 | 13983 | 23 | 0.546 | 25609.9 |
1147 | 2024-03-13 04:31:49 | pike | 2 | 29872 | 325 | 0.983 | 30388.6 |
1146 | 2024-03-10 17:57:24 | pike | 1 | 13983 | 23 | 0.513 | 27257.3 |
1145 | 2024-03-05 19:35:30 | pike | 1 | 13983 | 23 | 0.483 | 28950.3 |
1144 | 2024-03-05 12:15:04 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1143 | 2024-03-03 18:49:18 | pike | 1 | 13983 | 23 | 0.563 | 24836.6 |
1142 | 2024-02-25 16:35:08 | pike | 1 | 13983 | 23 | 0.563 | 24836.6 |
1141 | 2024-02-12 16:33:21 | pike | 2 | 29872 | 325 | 1.046 | 28558.3 |
1140 | 2024-02-11 23:51:50 | pike | 2 | 29872 | 325 | 0.970 | 30795.9 |
1139 | 2024-02-08 14:21:34 | pike | 1 | 13983 | 23 | 0.546 | 25609.9 |
1138 | 2024-02-06 21:59:14 | pike | 1 | 13983 | 23 | 0.280 | 49939.3 |
1137 | 2024-02-03 02:43:29 | pike | 1 | 13983 | 23 | 0.470 | 29751.1 |
1136 | 2024-02-02 17:34:03 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1135 | 2024-01-30 12:06:25 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1134 | 2024-01-20 08:58:29 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1133 | 2024-01-05 22:38:19 | pike | 2 | 29872 | 325 | 0.936 | 31914.5 |
1132 | 2024-01-05 13:26:08 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1131 | 2023-12-20 03:48:18 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1130 | 2023-12-17 06:18:07 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1129 | 2023-11-19 06:57:43 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1128 | 2023-11-15 12:02:53 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1127 | 2023-11-14 06:41:45 | pike | 2 | 29872 | 325 | 0.750 | 39829.3 |
1126 | 2023-11-11 19:43:01 | pike | 2 | 29872 | 325 | 0.860 | 34734.9 |
1125 | 2023-11-08 03:47:53 | pike | 1 | 13983 | 23 | 0.206 | 67878.6 |
1124 | 2023-11-07 22:10:20 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1123 | 2023-11-02 06:19:58 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1122 | 2023-10-29 05:30:16 | pike | 2 | 29872 | 325 | 0.906 | 32971.3 |
1121 | 2023-10-25 21:57:19 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1120 | 2023-10-22 04:08:45 | pike | 2 | 29872 | 325 | 0.750 | 39829.3 |
1119 | 2023-10-19 16:08:08 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1118 | 2023-10-18 06:40:49 | pike | 2 | 29872 | 325 | 0.750 | 39829.3 |
1117 | 2023-10-16 19:15:59 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1116 | 2023-10-12 10:32:05 | pike | 2 | 29872 | 325 | 0.750 | 39829.3 |
1115 | 2023-10-11 03:35:25 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1114 | 2023-10-08 06:39:48 | pike | 1 | 13983 | 23 | 0.236 | 59250.0 |
1113 | 2023-10-03 20:11:47 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1112 | 2023-09-23 15:20:12 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1111 | 2023-09-22 06:10:30 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1110 | 2023-09-02 05:59:31 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1109 | 2023-07-23 10:13:29 | pike | 2 | 29872 | 325 | 0.750 | 39829.3 |
1108 | 2023-06-18 00:42:23 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1107 | 2023-06-14 19:07:04 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1106 | 2023-06-06 03:52:42 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1105 | 2023-04-04 17:58:37 | pike | 2 | 29872 | 325 | 0.780 | 38297.4 |
1104 | 2023-03-28 03:58:43 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1103 | 2023-03-09 02:13:31 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1102 | 2023-01-26 15:55:28 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1101 | 2023-01-24 00:47:32 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1100 | 2023-01-21 11:45:17 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1099 | 2023-01-19 09:36:02 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1098 | 2023-01-15 02:24:37 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1097 | 2023-01-12 02:42:39 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1096 | 2023-01-11 11:50:05 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1095 | 2023-01-10 01:03:59 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1094 | 2023-01-07 12:09:01 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1093 | 2023-01-04 23:31:25 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1092 | 2023-01-02 22:08:10 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1091 | 2022-12-31 15:37:31 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1090 | 2022-12-31 09:15:27 | pike | 2 | 29872 | 325 | 0.923 | 32364.0 |
1089 | 2022-11-20 20:16:32 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1088 | 2022-10-27 11:55:21 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1087 | 2022-10-20 08:16:49 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1086 | 2022-09-04 10:23:54 | pike | 2 | 29872 | 325 | 0.736 | 40587.0 |
1085 | 2022-09-02 07:14:11 | pike | 2 | 29872 | 325 | 0.733 | 40753.1 |
1084 | 2022-07-31 11:13:58 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1083 | 2022-06-16 15:32:28 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1082 | 2022-06-14 09:05:20 | pike | 1 | 13983 | 23 | 0.200 | 69915.0 |
1081 | 2022-05-18 10:27:29 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1080 | 2022-04-02 11:46:12 | pike | 1 | 13983 | 23 | 0.203 | 68881.8 |
1079 | 2022-03-27 19:52:49 | pike | 2 | 29872 | 325 | 0.906 | 32971.3 |
1078 | 2022-03-21 22:59:41 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1077 | 2022-03-19 23:15:36 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1076 | 2022-02-21 22:51:17 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1075 | 2022-02-21 08:40:56 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1074 | 2022-02-11 04:30:51 | pike | 1 | 13983 | 23 | 0.266 | 52567.7 |
1073 | 2022-02-10 11:37:59 | pike | 1 | 13983 | 23 | 0.220 | 63559.1 |
1072 | 2022-02-09 23:42:34 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1071 | 2022-02-09 15:17:39 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1070 | 2022-02-08 13:55:43 | pike | 1 | 13983 | 23 | 0.236 | 59250.0 |
1069 | 2022-02-07 19:37:20 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1068 | 2022-01-23 15:17:54 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |
1067 | 2022-01-22 19:35:37 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1066 | 2021-12-22 00:59:12 | pike | 1 | 13983 | 23 | 0.233 | 60012.9 |
1065 | 2021-12-18 19:29:37 | pike | 1 | 13983 | 23 | 0.500 | 27966.0 |
1064 | 2021-12-17 01:32:18 | pike | 1 | 13983 | 23 | 0.236 | 59250.0 |
1063 | 2021-12-16 11:58:20 | pike | 1 | 13983 | 23 | 0.500 | 27966.0 |
1062 | 2021-12-15 23:15:17 | pike | 1 | 13983 | 23 | 0.250 | 55932.0 |
1061 | 2021-12-15 05:56:25 | pike | 1 | 13983 | 23 | 0.216 | 64736.1 |