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

191 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
fattinesses1411897(None) 
battinesses13169441battinesses
cattinesses13129701cattinesses
nattinesses11119311nattinesses
tattinesses11128941tattinesses
artinesses10815192_artinesses
bittinesses13148252bittinesses
brattinesses1466252brattinesses
chattinesses1755152chattinesses
dottinesses1238122dottinesses
fancinesses1638142fancinesses
fastnesses1389072fast_nesses
fatalnesses1456262fatalnesses
fatnesses121710462fa_t_nesses
fattiness12239372fattine_s_s
faultinesses1545182faultinesses
fustinesses14129762fustinesses
hastinesses141210682hastinesses
jettinesses1836382jettinesses
maltinesses13310222maltinesses
matinesses12314522ma_tinesses
nastinesses111110722nastinesses
nuttinesses11117732nuttinesses
pastinesses13911702pastinesses
pettinesses1338622pettinesses
pottinesses1339092pottinesses
ruttinesses11128972ruttinesses
saltinesses11311442saltinesses
tartinesses111011492tartinesses
tastinesses111110772tastinesses
wittinesses14127482wittinesses
achinesses1539293_achinesses
airinesses102613603_airinesses
antsinesses1148743antsinesses
aptnesses11168993_apt_nesses
artsinesses1138703artsinesses
ashinesses1339153_ashinesses
bagginesses1545943bagginesses
balkinesses1767493balkinesses
balminesses1537243balminesses
bandinesses14109723bandinesses
battiness11239843battine_s_s
bawdinesses17126313bawdinesses
bustinesses131310073bustinesses
caginesses13310933ca_ginesses
cakinesses16310603ca_kinesses
campinesses1737113campinesses
canninesses1368853canninesses
cattiness112310633cattine_s_s
craftinesses1746373craftinesses
daffinesses1834843daffinesses
daftnesses1436383daft_nesses
dailinesses1249493dailinesses
daintinesses1346243daintinesses
datednesses1357893datednesses
dirtinesses1239873dirtinesses
ditsinesses12108753ditsinesses
ditzinesses21126213ditzinesses
draftinesses1645743draftinesses
dustinesses121110333dustinesses
earlinesses11311033earlinesses
earthinesses1545813earthinesses
easinesses10314413ea_sinesses
emptinesses1545983emptinesses
fadednesses16126563fadednesses
faintnesses1447143faintnesses
fairnesses1357383fa_irnesses
falsenesses1446743falsenesses
farnesses122310813fa__rnesses
feistinesses1555883feistinesses
fetidnesses1546643fetidnesses
fierinesses1439223fierinesses
filminesses1636233filminesses
filthinesses1844463filthinesses
finesses111912333f___inesses
fishinesses17107233fishinesses
fitnesses12219373f_it_nesses
fittingnesses1773403fittingnesses
flabbinesses1943073flabbinesses
flakinesses1837073flakinesses
flashinesses18124863flashinesses
flatnesses1337763flat_nesses
flintinesses1546323flintinesses
flukinesses1836083flukinesses
foaminesses1658063foaminesses
fogginesses1645493fogginesses
forkinesses1847993forkinesses
foxinesses20127723f_oxinesses
fozinesses22158183f_ozinesses
franticnesses1843653franticnesses
frostinesses1546523frostinesses
frothinesses1845593frothinesses
fruitinesses1546403fruitinesses
funkinesses18136993funkinesses
funninesses14106863funninesses
furrinesses1437173furrinesses
fussinesses13126923fussinesses
fuzzinesses2243713fuzzinesses
gabbinesses1634903gabbinesses
gaminesses13410453ga_minesses
gassinesses1197963gassinesses
gastnesses11129133gast_nesses
gaudinesses1337843gaudinesses
gauzinesses2136033gauzinesses
gawkinesses1935633gawkinesses
goutinesses1239953goutinesses
grittinesses1345833grittinesses
gustinesses12139503gustinesses
gutsinesses12128133gutsinesses
hairinesses14198943hairinesses
hamminesses1835773hamminesses
handinesses151410273handinesses
happinesses1876163happinesses
hardinesses151110213hardinesses
hazinesses2239213ha_zinesses
heartinesses1547993heartinesses
heftinesses1737133heftinesses
jauntinesses1944683jauntinesses
jazzinesses2633373jazzinesses
knottinesses1643903knottinesses
lacinesses12312103la_cinesses
lankinesses1539013lankinesses
larkinesses1538993larkinesses
latenesses10413353la_tenesses
lazinesses19310143la_zinesses
loftinesses1437913loftinesses
lustinesses11910403lustinesses
manginesses1499593manginesses
manlinesses13910193manlinesses
massinesses12128683massinesses
mateynesses1645163mateynesses
mattresses1245433matt_resses
mazinesses2139903ma_zinesses
meatinesses13311973meatinesses
mistinesses131310603mistinesses
mustinesses131010393mustinesses
nappinesses1555923nappinesses
nattiness9239333nattine_s_s
niftinesses1437233niftinesses
paltrinesses1445513paltrinesses
pastnesses12910503past_nesses
patchinesses1944363patchinesses
patnesses111611793pa_t_nesses
patronesses1346473patronesses
pawkinesses2036153pawkinesses
pithinesses1637503pithinesses
prettinesses1447513prettinesses
racinesses12313493ra_cinesses
raininesses11310473raininesses
randinesses121311203randinesses
ranginesses121210113ranginesses
raptnesses1248523rapt_nesses
raspinesses1338003raspinesses
ritzinesses2096743ritzinesses
rootinesses1139513rootinesses
runtinesses111210943runtinesses
rustinesses11911523rustinesses
saltnesses10310163salt_nesses
sandinesses12911393sandinesses
sappinesses1567563sappinesses
sassinesses999313sassinesses
saucinesses1338953saucinesses
savvinesses1735663savvinesses
scantinesses1437313scantinesses
slatinesses11311613slatinesses
smuttinesses14135083smuttinesses
snottinesses1255833snottinesses
sootinesses11410043sootinesses
spottinesses1445683spottinesses
staginesses1238463staginesses
tacitnesses1336323tacitnesses
tackinesses1737253tackinesses
talkinesses1537353talkinesses
tanginesses1278883tanginesses
tardinesses121110243tardinesses
tarrinesses11129083tarrinesses
tartnesses101110713tart_nesses
tattiness9239413tattine_s_s
tautnesses10118283taut_nesses
tawninesses1436153tawninesses
testinesses111210313testinesses
vastnesses13128193vast_nesses
wackinesses2036653wackinesses
warinesses131514513wa_rinesses
washinesses1737253washinesses
waspinesses1636693waspinesses
waterinesses1567193waterinesses
wavinesses16199273wa_vinesses
waxinesses20138753wa_xinesses
yeastinesses1545563yeastinesses
zaninesses19310373za_ninesses

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.1561145455.1
2DLD Change Limit1216331915.81320924.3
3Display Results1911910.1101736.4
 (SQL Overall)1786911916.07929394.8
 
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.