History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"vigil"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1162 | 2024-04-30 23:55:07 | vigil | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1161 | 2024-04-30 03:20:37 | vigil | 3 | 83667 | 563 | 11.936 | 7009.6 |
| 1160 | 2024-04-30 03:20:29 | vigil | 2 | 53800 | 42 | 5.266 | 10216.5 |
| 1159 | 2024-04-30 02:04:25 | vigil | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1158 | 2024-04-16 17:43:23 | vigil | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1157 | 2024-04-06 05:54:46 | vigil | 1 | 28756 | 4 | 0.623 | 46157.3 |
| 1156 | 2024-03-31 15:51:32 | vigil | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1155 | 2024-03-29 09:03:54 | vigil | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1154 | 2024-03-11 21:17:42 | vigil | 3 | 83667 | 563 | 3.250 | 25743.7 |
| 1153 | 2024-03-08 18:55:07 | vigil | 3 | 83667 | 563 | 9.313 | 8983.9 |
| 1152 | 2024-03-08 12:38:34 | vigil | 3 | 83667 | 563 | 13.486 | 6204.0 |
| 1151 | 2024-03-07 04:57:01 | vigil | 3 | 83667 | 563 | 4.546 | 18404.5 |
| 1150 | 2024-03-07 04:57:03 | vigil | 2 | 53800 | 42 | 1.813 | 29674.6 |
| 1149 | 2024-03-07 04:31:07 | vigil | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 1148 | 2024-03-01 13:01:49 | vigil | 1 | 28756 | 4 | 0.546 | 52666.7 |
| 1147 | 2024-02-28 02:15:56 | vigil | 1 | 28756 | 4 | 0.796 | 36125.6 |
| 1146 | 2024-02-04 00:34:19 | vigil | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1145 | 2024-01-29 06:33:35 | vigil | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 1144 | 2024-01-28 23:16:41 | vigil | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1143 | 2024-01-20 07:22:05 | vigil | 2 | 53800 | 42 | 1.500 | 35866.7 |
| 1142 | 2024-01-15 00:41:13 | vigil | 3 | 83667 | 563 | 3.720 | 22491.1 |
| 1141 | 2024-01-01 20:32:34 | vigil | 1 | 28756 | 4 | 0.486 | 59168.7 |
| 1140 | 2023-12-17 09:12:57 | vigil | 3 | 83667 | 563 | 3.500 | 23904.9 |
| 1139 | 2023-12-13 11:32:43 | vigil | 2 | 53800 | 42 | 1.313 | 40974.9 |
| 1138 | 2023-12-12 13:45:48 | vigil | 3 | 83667 | 563 | 4.123 | 20292.7 |
| 1137 | 2023-12-03 18:09:00 | vigil | 3 | 83667 | 563 | 3.623 | 23093.3 |
| 1136 | 2023-11-30 14:36:15 | vigil | 3 | 83667 | 563 | 3.376 | 24782.9 |
| 1135 | 2023-11-19 06:34:51 | vigil | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1134 | 2023-11-18 20:08:47 | vigil | 1 | 28756 | 4 | 0.530 | 54256.6 |
| 1133 | 2023-11-04 07:55:38 | vigil | 1 | 28756 | 4 | 0.466 | 61708.2 |
| 1132 | 2023-11-03 20:19:09 | vigil | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1131 | 2023-10-28 11:57:56 | vigil | 3 | 83667 | 563 | 4.093 | 20441.5 |
| 1130 | 2023-10-28 07:07:06 | vigil | 2 | 53800 | 42 | 1.406 | 38264.6 |
| 1129 | 2023-10-23 17:58:35 | vigil | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1128 | 2023-10-22 08:50:45 | vigil | 3 | 83667 | 563 | 4.000 | 20916.8 |
| 1127 | 2023-10-22 08:50:44 | vigil | 2 | 53800 | 42 | 1.560 | 34487.2 |
| 1126 | 2023-10-18 04:36:29 | vigil | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1125 | 2023-10-17 00:35:37 | vigil | 1 | 28756 | 4 | 0.470 | 61183.0 |
| 1124 | 2023-10-13 14:56:36 | vigil | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1123 | 2023-10-05 05:23:41 | vigil | 1 | 28756 | 4 | 0.483 | 59536.2 |
| 1122 | 2023-09-23 03:40:29 | vigil | 1 | 28756 | 4 | 0.500 | 57512.0 |
| 1121 | 2023-09-03 18:29:22 | vigil | 3 | 83667 | 563 | 3.420 | 24464.0 |
| 1120 | 2023-09-02 07:39:51 | vigil | 3 | 83667 | 563 | 3.186 | 26260.8 |
| 1119 | 2023-09-01 01:05:26 | vigil | 3 | 83667 | 563 | 3.296 | 25384.4 |
| 1118 | 2023-08-29 15:33:44 | vigil | 3 | 83667 | 563 | 3.360 | 24900.9 |
| 1117 | 2023-08-19 13:15:53 | vigil | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1116 | 2023-08-09 09:56:53 | vigil | 3 | 83667 | 563 | 3.283 | 25484.9 |
| 1115 | 2023-08-07 18:29:32 | vigil | 2 | 53800 | 42 | 1.310 | 41068.7 |
| 1114 | 2023-06-23 09:53:38 | vigil | 3 | 83667 | 563 | 3.813 | 21942.6 |
| 1113 | 2023-06-04 07:57:36 | vigil | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1112 | 2023-05-21 12:53:21 | vigil | 1 | 28756 | 4 | 0.453 | 63479.0 |
| 1111 | 2023-05-15 14:21:41 | vigil | 3 | 83667 | 563 | 3.173 | 26368.4 |
| 1110 | 2023-04-25 13:04:07 | vigil | 3 | 83667 | 563 | 3.156 | 26510.5 |
| 1109 | 2023-04-11 10:48:48 | vigil | 2 | 53800 | 42 | 1.280 | 42031.3 |
| 1108 | 2023-04-04 14:31:18 | vigil | 3 | 83667 | 563 | 4.093 | 20441.5 |
| 1107 | 2023-04-01 20:49:59 | vigil | 3 | 83667 | 563 | 3.236 | 25855.1 |
| 1106 | 2023-03-29 20:48:40 | vigil | 3 | 83667 | 563 | 3.626 | 23074.2 |
| 1105 | 2023-03-16 16:23:10 | vigil | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1104 | 2023-02-25 14:20:04 | vigil | 3 | 83667 | 563 | 3.330 | 25125.2 |
| 1103 | 2023-02-04 19:41:54 | vigil | 3 | 83667 | 563 | 3.156 | 26510.5 |
| 1102 | 2023-01-29 12:26:51 | vigil | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1101 | 2023-01-18 05:11:21 | vigil | 2 | 53800 | 42 | 1.546 | 34799.5 |
| 1100 | 2023-01-07 01:28:58 | vigil | 3 | 83667 | 563 | 3.593 | 23286.1 |
| 1099 | 2023-01-04 15:05:52 | vigil | 1 | 28756 | 4 | 0.420 | 68466.7 |
| 1098 | 2022-12-19 15:48:22 | vigil | 3 | 83667 | 563 | 3.220 | 25983.5 |
| 1097 | 2022-12-05 08:00:19 | vigil | 3 | 83667 | 563 | 3.110 | 26902.6 |
| 1096 | 2022-11-14 22:58:56 | vigil | 3 | 83667 | 563 | 3.670 | 22797.5 |
| 1095 | 2022-11-07 16:55:10 | vigil | 3 | 83667 | 563 | 3.500 | 23904.9 |
| 1094 | 2022-11-07 16:55:06 | vigil | 3 | 83667 | 563 | 3.686 | 22698.6 |
| 1093 | 2022-11-04 11:05:14 | vigil | 3 | 83667 | 563 | 3.173 | 26368.4 |
| 1092 | 2022-11-02 09:06:07 | vigil | 3 | 83667 | 563 | 3.250 | 25743.7 |
| 1091 | 2022-11-01 05:56:17 | vigil | 3 | 83667 | 563 | 3.093 | 27050.4 |
| 1090 | 2022-10-29 08:32:08 | vigil | 3 | 83667 | 563 | 3.830 | 21845.2 |
| 1089 | 2022-10-28 12:38:12 | vigil | 2 | 53800 | 42 | 1.486 | 36204.6 |
| 1088 | 2022-09-30 00:27:52 | vigil | 3 | 83667 | 563 | 3.153 | 26535.7 |
| 1087 | 2022-09-26 21:29:09 | vigil | 1 | 28756 | 4 | 0.423 | 67981.1 |
| 1086 | 2022-09-20 02:07:02 | vigil | 1 | 28756 | 4 | 0.440 | 65354.5 |
| 1085 | 2022-09-16 08:38:21 | vigil | 1 | 28756 | 4 | 0.436 | 65954.1 |
| 1084 | 2022-09-16 03:04:19 | vigil | 3 | 83667 | 563 | 3.640 | 22985.4 |
| 1083 | 2022-09-15 06:40:38 | vigil | 3 | 83667 | 563 | 3.733 | 22412.8 |
| 1082 | 2022-09-14 05:15:03 | vigil | 3 | 83667 | 563 | 3.923 | 21327.3 |
| 1081 | 2022-09-13 16:53:53 | vigil | 3 | 83667 | 563 | 3.626 | 23074.2 |
| 1080 | 2022-09-12 02:46:25 | vigil | 3 | 83667 | 563 | 3.733 | 22412.8 |
| 1079 | 2022-09-11 03:04:33 | vigil | 3 | 83667 | 563 | 3.923 | 21327.3 |
| 1078 | 2022-09-10 09:45:55 | vigil | 3 | 83667 | 563 | 3.656 | 22884.8 |
| 1077 | 2022-09-09 02:45:44 | vigil | 3 | 83667 | 563 | 3.750 | 22311.2 |
| 1076 | 2022-09-08 13:34:06 | vigil | 3 | 83667 | 563 | 3.610 | 23176.5 |
| 1075 | 2022-09-07 02:38:57 | vigil | 3 | 83667 | 563 | 3.576 | 23396.8 |
| 1074 | 2022-09-06 04:44:05 | vigil | 3 | 83667 | 563 | 3.780 | 22134.1 |
| 1073 | 2022-09-05 06:00:42 | vigil | 3 | 83667 | 563 | 3.453 | 24230.2 |
| 1072 | 2022-09-05 03:03:22 | vigil | 3 | 83667 | 563 | 3.903 | 21436.6 |
| 1071 | 2022-09-04 04:49:43 | vigil | 3 | 83667 | 563 | 3.826 | 21868.0 |
| 1070 | 2022-09-03 02:44:24 | vigil | 3 | 83667 | 563 | 4.063 | 20592.4 |
| 1069 | 2022-09-02 06:11:44 | vigil | 3 | 83667 | 563 | 3.846 | 21754.3 |
| 1068 | 2022-09-01 02:27:56 | vigil | 3 | 83667 | 563 | 3.860 | 21675.4 |
| 1067 | 2022-08-31 14:00:57 | vigil | 3 | 83667 | 563 | 3.576 | 23396.8 |
| 1066 | 2022-08-30 12:00:59 | vigil | 3 | 83667 | 563 | 3.670 | 22797.5 |
| 1065 | 2022-08-29 05:14:35 | vigil | 3 | 83667 | 563 | 3.516 | 23796.1 |
| 1064 | 2022-08-28 16:01:19 | vigil | 3 | 83667 | 563 | 3.720 | 22491.1 |
| 1063 | 2022-08-16 02:21:45 | vigil | 1 | 28756 | 4 | 0.486 | 59168.7 |