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 “loftinesses” 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.

175 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
loftinesses143791(None) 
dottinesses1238122dottinesses
goutinesses1239952goutinesses
heftinesses1737132heftinesses
loaminesses1358442loaminesses
loathnesses1445852loathnesses
loftiness1236572loftine_s_s
loginesses11410312lo_ginesses
looninesses1197992looninesses
loopinesses13116732loopinesses
lostnesses1049292lost_nesses
lousinesses111210302lousinesses
lowlinesses1436682lowlinesses
lustinesses11910402lustinesses
niftinesses1437232niftinesses
pottinesses1339092pottinesses
rootinesses1139512rootinesses
softnesses1337602soft_nesses
sootinesses11410042sootinesses
artinesses10815193_artinesses
battinesses13169443battinesses
bittinesses13148253bittinesses
bloodinesses1544263bloodinesses
blowinesses1635973blo_winesses
bogginesses1555663bogginesses
boninesses121111443bo_ninesses
bonninesses1337343bonninesses
boozinesses22175793boozinesses
boskinesses17136803boskinesses
bossinesses12117343bossinesses
boxinesses19127893bo_xinesses
bustinesses131310073bustinesses
cattinesses13129703cattinesses
cloudinesses1545123cloudinesses
cockinesses1947553cockinesses
comfinesses1846903comfinesses
corkinesses1749203corkinesses
corninesses13410583corninesses
cosinesses121012813co_sinesses
costlinesses1446243costlinesses
cozinesses21179493co_zinesses
craftinesses1746373craftinesses
daffinesses1834843daffinesses
daftnesses1436383daft_nesses
deftnesses1436813deft_nesses
dirtinesses1239873dirtinesses
dodginesses1435433dodginesses
dopinesses13159713do_pinesses
dorkinesses1647653dorkinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168623do_zinesses
draftinesses1645743draftinesses
dustinesses121110333dustinesses
emptinesses1545983emptinesses
fattinesses14118973fattinesses
finesses111912333__f_inesses
fitnesses12219373__fitnesses
flintinesses1546323flintinesses
floppinesses1942953floppinesses
fluffinesses1742663fluffinesses
foaminesses1658063foaminesses
fogginesses1645493fogginesses
forkinesses1847993forkinesses
foxinesses20127723fo_xinesses
fozinesses22158183fo_zinesses
frostinesses1546523frostinesses
fustinesses14129763fustinesses
gloominesses1544123gloominesses
glossinesses1254493glossinesses
godlinesses1337123godlinesses
goofinesses1535963goofinesses
gorinesses11311533go_rinesses
gustinesses12139503gustinesses
hastinesses141210683hastinesses
hoarinesses14310213hoarinesses
hokinesses1758933ho_kinesses
holinesses13511483ho_linesses
hominesses15510843ho_minesses
horninesses1458993horninesses
horsinesses1439533horsinesses
hotnesses1238903ho_t_nesses
huffinesses2034113huffinesses
iffinesses1635573_iffinesses
jettinesses1836383jettinesses
jokinesses2147523jo_kinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
knottinesses1643903knottinesses
kookinesses1435373kookinesses
lacinesses12312103l_acinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
latenesses10413353l_atenesses
lazinesses19310143l_azinesses
leafinesses1437873leafinesses
leakinesses1538473leakinesses
leerinesses11119473leerinesses
legginesses1345293legginesses
licitnesses1346393licitnesses
liminesses121310843l_iminesses
lippinesses1535513lippinesses
litenesses10513003l_itenesses
localnesses1345843localnesses
lonelinesses12146343lonelinesses
lonenesses10311343lo_nenesses
longnesses1138503lo_ngnesses
loosenesses1147233loosenesses
lordlinesses1345153lordlinesses
lornnesses1037823lo_rnnesses
loudnesses1138433lo_udnesses
loutishnesses1644983loutishnesses
lovelinesses15125333lovelinesses
lownesses1236983lo__wnesses
luckinesses1746633luckinesses
lumpinesses15107103lumpinesses
maltinesses13310223maltinesses
matinesses12314523_matinesses
meatinesses13311973meatinesses
miffinesses1944363miffinesses
mistinesses131310603mistinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mootnesses1237153moot_nesses
mopinesses14139113mo_pinesses
mossinesses12117453mossinesses
mousinesses13129813mousinesses
mustinesses131010393mustinesses
nastinesses111110723nastinesses
nattinesses11119313nattinesses
noisinesses1139453noisinesses
nosinesses101411303no_sinesses
nuttinesses11117733nuttinesses
oilinesses101512433_oilinesses
oozinesses19178013_oozinesses
pastinesses13911703pastinesses
pettinesses1338623pettinesses
pokinesses1669603po_kinesses
porkinesses1748763porkinesses
portlinesses1446973portlinesses
puffinesses1934503puffinesses
rockinesses1737353rockinesses
roominesses1337423roominesses
ropinesses121311013ro_pinesses
rosinesses101213133ro_sinesses
rowdinesses1536963rowdinesses
runtinesses111210943runtinesses
rustinesses11911523rustinesses
ruttinesses11128973ruttinesses
saltinesses11311443saltinesses
shiftinesses18105243shiftinesses
slatinesses11311613slatinesses
sloppinesses1644053sloppinesses
snootinesses1265793snootinesses
snottinesses1255833snottinesses
soapinesses1339703soapinesses
sogginesses1346773sogginesses
soppinesses1566843soppinesses
sorrinesses11310083sorrinesses
sportinesses1447863sportinesses
spottinesses1445683spottinesses
tartinesses111011493tartinesses
tastinesses111110773tastinesses
tattinesses11128943tattinesses
testinesses111210313testinesses
toploftinesses1951273toploftinesses
unfitnesses1446123unfitnesses
wittinesses14127483wittinesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses
wordinesses15138873wordinesses
worminesses16127983worminesses
worthinesses1845753worthinesses

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.1401276364.3
2DLD Change Limit1216331755.89320640.3
3Display Results1751750.1101590.9
 (SQL Overall)1786911756.14329088.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.