History of Dictionary Searches using Damerau-Levenshtein distance in T-SQL
Fuzzy-string Searches
(up to 100 most recent)
for
"nannies"
| Num | Started At (CA time) | Searched Word | Change Limit | Words Checked | Words Matched | Seconds | Words Per Sec |
| 1096 | 2024-04-28 06:34:50 | nannies | 3 | 134027 | 604 | 12.716 | 10540.0 |
| 1095 | 2024-04-28 04:12:29 | nannies | 2 | 107671 | 52 | 3.420 | 31482.7 |
| 1094 | 2024-04-28 04:11:51 | nannies | 3 | 134027 | 604 | 6.063 | 22105.7 |
| 1093 | 2024-04-27 17:33:43 | nannies | 3 | 134027 | 604 | 8.453 | 15855.6 |
| 1092 | 2024-04-17 10:48:12 | nannies | 1 | 69583 | 5 | 1.186 | 58670.3 |
| 1091 | 2024-04-17 10:20:11 | nannies | 3 | 134027 | 604 | 15.220 | 8806.0 |
| 1090 | 2024-04-16 04:38:59 | nannies | 3 | 134027 | 604 | 5.826 | 23005.0 |
| 1089 | 2024-03-27 10:59:58 | nannies | 2 | 107671 | 52 | 3.780 | 28484.4 |
| 1088 | 2024-03-27 10:59:29 | nannies | 3 | 134027 | 604 | 7.220 | 18563.3 |
| 1087 | 2024-03-27 01:46:40 | nannies | 2 | 107671 | 52 | 6.173 | 17442.2 |
| 1086 | 2024-03-27 01:45:52 | nannies | 3 | 134027 | 604 | 7.983 | 16789.1 |
| 1085 | 2024-03-26 04:47:01 | nannies | 1 | 69583 | 5 | 4.283 | 16246.3 |
| 1084 | 2024-03-26 02:23:29 | nannies | 2 | 107671 | 52 | 3.046 | 35348.3 |
| 1083 | 2024-03-26 02:20:41 | nannies | 3 | 134027 | 604 | 7.733 | 17331.8 |
| 1082 | 2024-03-23 08:38:41 | nannies | 3 | 134027 | 604 | 13.440 | 9972.2 |
| 1081 | 2024-03-23 06:14:48 | nannies | 3 | 134027 | 604 | 7.076 | 18941.1 |
| 1080 | 2024-02-27 04:43:14 | nannies | 1 | 69583 | 5 | 2.640 | 26357.2 |
| 1079 | 2024-01-13 12:36:11 | nannies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1078 | 2024-01-09 21:48:19 | nannies | 2 | 107671 | 52 | 3.283 | 32796.5 |
| 1077 | 2024-01-06 18:06:42 | nannies | 3 | 134027 | 604 | 7.466 | 17951.6 |
| 1076 | 2024-01-06 18:06:43 | nannies | 2 | 107671 | 52 | 3.626 | 29694.2 |
| 1075 | 2023-12-29 15:46:56 | nannies | 1 | 69583 | 5 | 1.063 | 65459.1 |
| 1074 | 2023-12-18 19:20:26 | nannies | 3 | 134027 | 604 | 6.563 | 20421.6 |
| 1073 | 2023-12-12 16:21:37 | nannies | 3 | 134027 | 604 | 5.860 | 22871.5 |
| 1072 | 2023-12-07 05:28:59 | nannies | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 1071 | 2023-12-02 12:01:32 | nannies | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 1070 | 2023-11-11 03:36:59 | nannies | 1 | 69583 | 5 | 1.110 | 62687.4 |
| 1069 | 2023-11-10 02:25:02 | nannies | 1 | 69583 | 5 | 1.263 | 55093.4 |
| 1068 | 2023-10-31 14:32:28 | nannies | 1 | 69583 | 5 | 1.233 | 56433.9 |
| 1067 | 2023-10-19 10:28:56 | nannies | 2 | 107671 | 52 | 3.530 | 30501.7 |
| 1066 | 2023-10-17 18:20:55 | nannies | 1 | 69583 | 5 | 1.096 | 63488.1 |
| 1065 | 2023-10-17 14:35:43 | nannies | 3 | 134027 | 604 | 7.970 | 16816.4 |
| 1064 | 2023-10-08 23:47:30 | nannies | 3 | 134027 | 604 | 6.733 | 19906.0 |
| 1063 | 2023-10-01 03:51:25 | nannies | 3 | 134027 | 604 | 9.046 | 14816.2 |
| 1062 | 2023-10-01 03:05:52 | nannies | 1 | 69583 | 5 | 1.093 | 63662.4 |
| 1061 | 2023-09-27 08:02:11 | nannies | 3 | 134027 | 604 | 6.923 | 19359.7 |
| 1060 | 2023-09-23 16:17:19 | nannies | 1 | 69583 | 5 | 2.673 | 26031.8 |
| 1059 | 2023-09-12 04:56:12 | nannies | 3 | 134027 | 604 | 7.376 | 18170.7 |
| 1058 | 2023-08-12 03:05:05 | nannies | 1 | 69583 | 5 | 1.250 | 55666.4 |
| 1057 | 2023-07-30 20:46:29 | nannies | 2 | 107671 | 52 | 3.406 | 31612.2 |
| 1056 | 2023-07-29 09:30:01 | nannies | 2 | 107671 | 52 | 2.936 | 36672.7 |
| 1055 | 2023-06-09 20:47:36 | nannies | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 1054 | 2023-06-06 20:45:05 | nannies | 3 | 134027 | 604 | 5.703 | 23501.1 |
| 1053 | 2023-05-12 03:29:43 | nannies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1052 | 2023-04-07 10:41:39 | nannies | 2 | 107671 | 52 | 2.780 | 38730.6 |
| 1051 | 2023-03-18 22:48:39 | nannies | 3 | 134027 | 604 | 6.766 | 19808.9 |
| 1050 | 2023-03-12 10:49:08 | nannies | 3 | 134027 | 604 | 6.500 | 20619.5 |
| 1049 | 2023-03-06 12:40:18 | nannies | 1 | 69583 | 5 | 1.046 | 66522.9 |
| 1048 | 2023-02-21 19:58:36 | nannies | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 1047 | 2023-01-13 21:25:23 | nannies | 2 | 107671 | 52 | 3.030 | 35535.0 |
| 1046 | 2022-12-30 07:14:59 | nannies | 1 | 69583 | 5 | 1.203 | 57841.2 |
| 1045 | 2022-12-18 02:45:22 | nannies | 3 | 134027 | 604 | 6.983 | 19193.3 |
| 1044 | 2022-11-01 07:08:22 | nannies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1043 | 2022-10-18 03:51:59 | nannies | 2 | 107671 | 52 | 2.830 | 38046.3 |
| 1042 | 2022-09-19 05:05:47 | nannies | 1 | 69583 | 5 | 1.080 | 64428.7 |
| 1041 | 2022-08-13 04:33:17 | nannies | 3 | 134027 | 604 | 5.890 | 22755.0 |
| 1040 | 2022-08-10 18:52:26 | nannies | 3 | 134027 | 604 | 5.986 | 22390.1 |
| 1039 | 2022-07-18 21:48:03 | nannies | 1 | 69583 | 5 | 1.173 | 59320.5 |
| 1038 | 2022-06-25 18:08:32 | nannies | 3 | 134027 | 604 | 6.156 | 21771.8 |
| 1037 | 2022-05-18 04:54:54 | nannies | 2 | 107671 | 52 | 2.920 | 36873.6 |
| 1036 | 2022-04-29 22:34:50 | nannies | 1 | 69583 | 5 | 1.060 | 65644.3 |
| 1035 | 2022-04-28 23:25:50 | nannies | 2 | 107671 | 52 | 3.736 | 28819.9 |
| 1034 | 2022-03-28 07:14:32 | nannies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1033 | 2022-03-11 16:45:24 | nannies | 3 | 134027 | 604 | 6.313 | 21230.3 |
| 1032 | 2022-03-01 06:10:50 | nannies | 2 | 107671 | 52 | 2.873 | 37476.9 |
| 1031 | 2022-02-28 13:13:04 | nannies | 2 | 107671 | 52 | 4.173 | 25801.8 |
| 1030 | 2022-02-27 19:16:40 | nannies | 2 | 107671 | 52 | 2.860 | 37647.2 |
| 1029 | 2022-02-27 06:55:10 | nannies | 2 | 107671 | 52 | 2.920 | 36873.6 |
| 1028 | 2022-02-26 12:39:56 | nannies | 2 | 107671 | 52 | 5.800 | 18564.0 |
| 1027 | 2022-02-25 22:12:43 | nannies | 2 | 107671 | 52 | 2.940 | 36622.8 |
| 1026 | 2022-02-25 07:06:52 | nannies | 2 | 107671 | 52 | 2.970 | 36252.9 |
| 1025 | 2022-02-25 04:48:04 | nannies | 2 | 107671 | 52 | 7.266 | 14818.5 |
| 1024 | 2022-02-24 11:11:02 | nannies | 2 | 107671 | 52 | 3.360 | 32044.9 |
| 1023 | 2022-02-23 20:04:16 | nannies | 2 | 107671 | 52 | 2.890 | 37256.4 |
| 1022 | 2022-02-23 00:50:38 | nannies | 2 | 107671 | 52 | 2.876 | 37437.8 |
| 1021 | 2022-02-22 05:37:59 | nannies | 2 | 107671 | 52 | 2.903 | 37089.6 |
| 1020 | 2022-02-21 09:18:04 | nannies | 2 | 107671 | 52 | 3.483 | 30913.3 |
| 1019 | 2022-02-20 20:44:01 | nannies | 2 | 107671 | 52 | 2.936 | 36672.7 |
| 1018 | 2022-02-20 09:37:32 | nannies | 2 | 107671 | 52 | 2.936 | 36672.7 |
| 1017 | 2022-02-19 19:14:08 | nannies | 2 | 107671 | 52 | 3.216 | 33479.8 |
| 1016 | 2022-02-19 06:36:44 | nannies | 2 | 107671 | 52 | 2.860 | 37647.2 |
| 1015 | 2022-02-18 20:24:33 | nannies | 2 | 107671 | 52 | 3.326 | 32372.5 |
| 1014 | 2022-02-18 10:50:18 | nannies | 2 | 107671 | 52 | 2.796 | 38508.9 |
| 1013 | 2022-02-17 18:43:37 | nannies | 2 | 107671 | 52 | 2.920 | 36873.6 |
| 1012 | 2022-02-17 00:55:20 | nannies | 2 | 107671 | 52 | 3.203 | 33615.7 |
| 1011 | 2022-02-16 08:56:19 | nannies | 2 | 107671 | 52 | 2.893 | 37217.8 |
| 1010 | 2022-02-15 15:10:56 | nannies | 2 | 107671 | 52 | 3.406 | 31612.2 |
| 1009 | 2022-02-14 18:33:00 | nannies | 2 | 107671 | 52 | 3.393 | 31733.3 |
| 1008 | 2022-02-13 23:45:49 | nannies | 2 | 107671 | 52 | 2.936 | 36672.7 |
| 1007 | 2022-02-12 18:23:59 | nannies | 2 | 107671 | 52 | 2.923 | 36835.8 |
| 1006 | 2022-02-12 10:04:36 | nannies | 2 | 107671 | 52 | 2.826 | 38100.1 |
| 1005 | 2022-02-11 18:38:43 | nannies | 2 | 107671 | 52 | 3.313 | 32499.5 |
| 1004 | 2022-01-21 17:51:26 | nannies | 2 | 107671 | 52 | 3.046 | 35348.3 |
| 1003 | 2022-01-21 09:06:55 | nannies | 2 | 107671 | 52 | 5.123 | 21017.2 |
| 1002 | 2022-01-21 02:58:47 | nannies | 1 | 69583 | 5 | 1.076 | 64668.2 |
| 1001 | 2022-01-20 17:05:58 | nannies | 2 | 107671 | 52 | 3.470 | 31029.1 |
| 1000 | 2022-01-20 05:30:10 | nannies | 2 | 107671 | 52 | 3.280 | 32826.5 |
| 999 | 2022-01-19 19:05:18 | nannies | 2 | 107671 | 52 | 5.296 | 20330.6 |
| 998 | 2022-01-19 09:33:38 | nannies | 2 | 107671 | 52 | 2.890 | 37256.4 |
| 997 | 2022-01-18 16:48:05 | nannies | 2 | 107671 | 52 | 2.923 | 36835.8 |