Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “jettinesses” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
jettinesses183638(None) 
pettinesses1338631pettinesses
battinesses13169452battinesses
bittinesses13148262bittinesses
cattinesses13129702cattinesses
dottinesses1238132dottinesses
fattinesses14118972fattinesses
heftinesses1737132heftinesses
jerkinesses2246052jerkinesses
jettiness1675692jettine_s_s
meatinesses13311982meatinesses
nattinesses11119322nattinesses
nuttinesses11117752nuttinesses
pottinesses1339102pottinesses
prettinesses1447542prettinesses
ruttinesses11128992ruttinesses
tattinesses11128942tattinesses
testinesses111210322testinesses
wittinesses14127482wittinesses
antsinesses1148753antsinesses
artinesses10815213_artinesses
artsinesses1138713artsinesses
beadinesses1449563beadinesses
beefinesses1675953beefinesses
beerinesses1398923beerinesses
brattinesses1466263brattinesses
bustinesses131310093bustinesses
chattinesses1755153chattinesses
deftnesses1436813deft_nesses
dewinesses1438353de_winesses
dirtinesses1239883dirtinesses
ditsinesses12108763ditsinesses
ditzinesses21126213ditzinesses
dustinesses121110353dustinesses
easinesses10314443_easinesses
edginesses1236703_edginesses
eerinesses10612603_eerinesses
emptinesses1545993emptinesses
feistinesses1555893feistinesses
fetidnesses1546653fetidnesses
fustinesses14129783fustinesses
geekinesses1635813geekinesses
gemminesses1634983gemminesses
gentilesses1243493gentilesses
germinesses1437883germinesses
goutinesses1239973goutinesses
grittinesses1345843grittinesses
gustinesses12139523gustinesses
gutsinesses12128153gutsinesses
hastinesses141210693hastinesses
headinesses1539843headinesses
heartinesses1548003heartinesses
heavinesses1747453heavinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
jitterinesses2083313jitterinesses
jokinesses2147533j_okinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
juicinesses2035893juicinesses
jumpinesses22125343jumpinesses
justnesses1736493just_nesses
knottinesses1643913knottinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119483leerinesses
legginesses1345293legginesses
loftinesses1437923loftinesses
lustinesses11910423lustinesses
maltinesses13310233maltinesses
matinesses12314543_matinesses
mealinesses13310973mealinesses
meetnesses1237453meet_nesses
merrinesses1358263merrinesses
messinesses1297513messinesses
mistinesses131310623mistinesses
mustinesses131010413mustinesses
nastinesses111110743nastinesses
neatnesses10310013neat_nesses
needinesses1258103needinesses
nerdinesses1249053nerdinesses
nervinesses1437323nervinesses
newsinesses1436323newsinesses
niftinesses1437243niftinesses
pastinesses13911713pastinesses
peppinesses1435313peppinesses
perkinesses1748923perkinesses
pertnesses12310313pert_nesses
peskinesses1746573peskinesses
petitenesses14169363petitenesses
pettiness1178703pettine_s_s
pettishnesses1844383pettishnesses
pithinesses1637503pithinesses
readinesses12611273readinesses
reedinesses1259563reedinesses
ritzinesses2096743ritzinesses
rootinesses1139523rootinesses
runtinesses111210963runtinesses
rustinesses11911553rustinesses
saltinesses11311453saltinesses
seaminesses13310753seaminesses
seedinesses1259203seedinesses
sexinesses1739213se_xinesses
slatinesses11311633slatinesses
smuttinesses14135083smuttinesses
snottinesses1255843snottinesses
sootinesses11410053sootinesses
spottinesses1445683spottinesses
sweatinesses1546913sweatinesses
tartinesses111011503tartinesses
tastinesses111110783tastinesses
tearinesses11311693tearinesses
tetchinesses1753553tetchinesses
wearinesses14310213wearinesses
weedinesses1557073weedinesses
weepinesses1646133weepinesses
wetnesses12208213we_t_nesses
yeastinesses1545563yeastinesses

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911216330.406440125.6
2DLD Change Limit1216331185.61021681.5
3Display Results1181180.0631873.0
 (SQL Overall)1786911186.07929394.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.