History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"house"
Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
1146 | 2024-04-18 17:39:36 | house | 1 | 28756 | 17 | 0.546 | 52666.7 |
1145 | 2024-04-17 22:01:29 | house | 1 | 28756 | 17 | 2.563 | 11219.7 |
1144 | 2024-04-17 22:00:53 | house | 2 | 53800 | 183 | 3.686 | 14595.8 |
1143 | 2024-04-03 04:34:35 | house | 1 | 28756 | 17 | 0.876 | 32826.5 |
1142 | 2024-04-01 17:02:37 | house | 1 | 28756 | 17 | 1.173 | 24514.9 |
1141 | 2024-03-19 05:57:27 | house | 1 | 28756 | 17 | 1.143 | 25158.4 |
1140 | 2024-03-17 19:58:18 | house | 2 | 53800 | 183 | 2.283 | 23565.5 |
1139 | 2024-03-05 10:31:17 | house | 1 | 28756 | 17 | 0.530 | 54256.6 |
1138 | 2024-03-03 21:54:12 | house | 1 | 28756 | 17 | 0.530 | 54256.6 |
1137 | 2024-03-02 14:36:48 | house | 1 | 28756 | 17 | 0.810 | 35501.2 |
1136 | 2024-02-25 17:58:30 | house | 1 | 28756 | 17 | 0.923 | 31154.9 |
1135 | 2024-02-25 16:25:11 | house | 1 | 28756 | 17 | 1.046 | 27491.4 |
1134 | 2024-02-17 19:00:14 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1133 | 2024-02-14 16:43:44 | house | 2 | 53800 | 183 | 1.750 | 30742.9 |
1132 | 2024-01-25 21:47:33 | house | 1 | 28756 | 17 | 0.596 | 48248.3 |
1131 | 2024-01-17 18:46:54 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1130 | 2024-01-17 15:45:37 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1129 | 2024-01-16 14:26:47 | house | 1 | 28756 | 17 | 0.486 | 59168.7 |
1128 | 2024-01-15 10:07:22 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1127 | 2024-01-12 07:35:49 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1126 | 2023-12-26 03:27:28 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1125 | 2023-12-13 19:11:14 | house | 1 | 28756 | 17 | 0.486 | 59168.7 |
1124 | 2023-12-08 12:28:29 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1123 | 2023-12-08 12:28:28 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1122 | 2023-12-07 08:42:24 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1121 | 2023-12-03 06:38:34 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1120 | 2023-12-03 06:38:33 | house | 1 | 28756 | 17 | 0.486 | 59168.7 |
1119 | 2023-11-24 03:55:34 | house | 1 | 28756 | 17 | 0.533 | 53951.2 |
1118 | 2023-11-21 14:20:12 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1117 | 2023-11-09 10:19:56 | house | 2 | 53800 | 183 | 1.356 | 39675.5 |
1116 | 2023-11-08 11:41:13 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1115 | 2023-11-08 04:20:38 | house | 2 | 53800 | 183 | 1.530 | 35163.4 |
1114 | 2023-11-07 23:25:05 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1113 | 2023-11-07 07:41:51 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1112 | 2023-11-06 15:31:12 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1111 | 2023-11-06 05:46:56 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1110 | 2023-11-05 16:14:45 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1109 | 2023-11-02 07:27:29 | house | 2 | 53800 | 183 | 1.703 | 31591.3 |
1108 | 2023-11-02 06:19:30 | house | 1 | 28756 | 17 | 0.530 | 54256.6 |
1107 | 2023-10-27 06:08:06 | house | 2 | 53800 | 183 | 1.576 | 34137.1 |
1106 | 2023-10-25 20:09:30 | house | 1 | 28756 | 17 | 0.530 | 54256.6 |
1105 | 2023-10-22 22:14:27 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1104 | 2023-10-19 17:04:09 | house | 2 | 53800 | 183 | 1.483 | 36277.8 |
1103 | 2023-10-19 14:13:17 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1102 | 2023-10-16 20:42:52 | house | 2 | 53800 | 183 | 1.750 | 30742.9 |
1101 | 2023-10-16 18:12:42 | house | 1 | 28756 | 17 | 0.440 | 65354.5 |
1100 | 2023-10-11 05:27:26 | house | 2 | 53800 | 183 | 3.030 | 17755.8 |
1099 | 2023-10-10 10:03:20 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1098 | 2023-10-04 06:06:38 | house | 2 | 53800 | 183 | 3.080 | 17467.5 |
1097 | 2023-10-03 08:47:16 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1096 | 2023-09-25 13:47:30 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1095 | 2023-09-24 15:20:06 | house | 1 | 28756 | 17 | 0.530 | 54256.6 |
1094 | 2023-09-23 14:32:30 | house | 2 | 53800 | 183 | 1.423 | 37807.4 |
1093 | 2023-09-18 23:03:01 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1092 | 2023-08-26 22:24:18 | house | 1 | 28756 | 17 | 0.486 | 59168.7 |
1091 | 2023-08-14 21:38:43 | house | 1 | 28756 | 17 | 0.546 | 52666.7 |
1090 | 2023-08-13 08:11:03 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1089 | 2023-07-23 10:11:32 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1088 | 2023-07-16 19:47:55 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1087 | 2023-05-26 09:34:00 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1086 | 2023-05-07 19:46:02 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1085 | 2023-03-23 04:34:34 | house | 1 | 28756 | 17 | 0.440 | 65354.5 |
1084 | 2023-03-12 12:08:01 | house | 1 | 28756 | 17 | 0.440 | 65354.5 |
1083 | 2023-01-25 11:10:19 | house | 1 | 28756 | 17 | 0.423 | 67981.1 |
1082 | 2023-01-21 18:51:05 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1081 | 2023-01-17 08:35:44 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1080 | 2023-01-09 07:09:38 | house | 1 | 28756 | 17 | 0.423 | 67981.1 |
1079 | 2023-01-07 04:07:40 | house | 2 | 53800 | 183 | 1.346 | 39970.3 |
1078 | 2022-11-26 04:52:26 | house | 2 | 53800 | 183 | 1.376 | 39098.8 |
1077 | 2022-11-24 19:10:36 | house | 1 | 28756 | 17 | 0.513 | 56054.6 |
1076 | 2022-10-29 09:49:15 | house | 2 | 53800 | 183 | 1.593 | 33772.8 |
1075 | 2022-10-11 03:45:20 | house | 1 | 28756 | 17 | 0.450 | 63902.2 |
1074 | 2022-10-04 01:54:58 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1073 | 2022-10-02 02:03:07 | house | 2 | 53800 | 183 | 1.393 | 38621.7 |
1072 | 2022-10-01 22:09:05 | house | 1 | 28756 | 17 | 0.470 | 61183.0 |
1071 | 2022-09-19 20:42:38 | house | 1 | 28756 | 17 | 0.580 | 49579.3 |
1070 | 2022-09-18 15:22:06 | house | 1 | 28756 | 17 | 0.440 | 65354.5 |
1069 | 2022-09-18 10:03:37 | house | 2 | 53800 | 183 | 1.360 | 39558.8 |
1068 | 2022-09-12 03:01:14 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1067 | 2022-09-02 09:33:15 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1066 | 2022-09-01 21:57:46 | house | 1 | 28756 | 17 | 0.953 | 30174.2 |
1065 | 2022-08-31 12:09:25 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1064 | 2022-08-23 12:36:48 | house | 2 | 53800 | 183 | 1.343 | 40059.6 |
1063 | 2022-08-06 20:53:35 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1062 | 2022-08-06 06:04:52 | house | 1 | 28756 | 17 | 0.450 | 63902.2 |
1061 | 2022-07-03 08:05:12 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1060 | 2022-06-25 19:42:15 | house | 2 | 53800 | 183 | 1.470 | 36598.6 |
1059 | 2022-06-20 18:39:00 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1058 | 2022-06-16 08:04:56 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1057 | 2022-06-15 16:34:10 | house | 1 | 28756 | 17 | 0.436 | 65954.1 |
1056 | 2022-05-21 14:47:37 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1055 | 2022-05-18 15:22:29 | house | 1 | 28756 | 17 | 0.453 | 63479.0 |
1054 | 2022-05-18 10:46:18 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1053 | 2022-05-11 05:05:50 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1052 | 2022-03-05 01:17:31 | house | 1 | 28756 | 17 | 0.516 | 55728.7 |
1051 | 2022-02-24 11:36:39 | house | 1 | 28756 | 17 | 0.623 | 46157.3 |
1050 | 2022-02-23 22:08:52 | house | 1 | 28756 | 17 | 0.610 | 47141.0 |
1049 | 2022-02-23 09:20:47 | house | 1 | 28756 | 17 | 0.483 | 59536.2 |
1048 | 2022-02-22 22:08:55 | house | 1 | 28756 | 17 | 0.500 | 57512.0 |
1047 | 2022-02-21 13:16:57 | house | 1 | 28756 | 17 | 0.720 | 39938.9 |