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

180 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
phonated144789(None) 
phonate12411811phonate_
phonates13410641phonates
pronated11414051pronated
donated93513862_donated
ozonated1864592ozonated
pennated11299542pennated
phenate12412202phenate_
phenates13611582phenates
phoned124014552phon__ed
phoneyed1743842phoneyed
phonied133710562phon_ied
phorate12413362phorate_
phorates13413042phorates
pinnated11338552pinnated
probated13410862probated
pronate9418872pronate_
pronates10418372pronates
prorated11513712prorated
zonated173310532_zonated
apholate13410473apholate_
apholates1449683apholates
bloated104513433blo_ated
boated94221973_bo_ated
borated104116363_borated
bromated1339173bromated
chanted134015953chan_ted
cheated134416343ch_eated
chelated142610493chelated
cholate122114933cholate_
cholates132414763cholates
coated94927043_co_ated
cohobated1744883cohobated
coronated123313323coronated
crenated113013913crenated
detonated1138213detonated
doated84118183_do_ated
donate73619503_donate_
donates83217223_donates
echinated1546483echinated
elongated1144283elongated
emanated1139163emanated
ephorate1359503ephorate_
ephorates1459163ephorates
floated113312703flo_ated
fronted114011273fron_ted
ghosted1236273gho_sted
gloated93511533glo_ated
globated1265753globated
hanted104124313_han_ted
hated95734023_h__ated
heated104525593_h_eated
hented104218753_hen_ted
hinted104318323_hin_ted
hoaxed17378873_ho_axed
hoisted113411293_hoisted
homaged1497413_homaged
hondled123510653_hondled
honed95332263_hon__ed
honeyed1437773_honeyed
hongied12308163_hongied
honied104818393_hon_ied
honked144517913_hon_ked
honored11310123_honored
hooted104422663_ho_oted
hosted105020343_ho_sted
hotted104319943_ho_tted
hunted104417013_hun_ted
hyphenated2253373hyphenated
intonated1048303intonated
iodated9310023_iodated
isolated9410523isolated
khanate1437073khanate_
khanates1535733khanates
lanated8313203_lanated
lobated102610943_lobated
located103114183_located
lunated8310823_lunated
moated94819003_mo_ated
neonate7311333neonate_
neonates8310063neonates
nonrated9310843_nonrated
notated82713663_notated
odonate848403odonate_
odonates947743odonates
orated74221503__orated
ozonate1646863ozonate_
ozonates1745963ozonates
paginated13309463paginated
painted104214633pain_ted
palmated132511003palmated
palpated13249763palpated
panted95024823p_an_ted
pated85237843p___ated
patinated123911413patinated
penates93321603p_enates
pennate93314033pennate_
peonage1048723peonage_
peonages1138473peonages
perorated12412473perorated
personated13258293personated
phased124011973ph__ased
phenolated1645253phenolated
phonal11310383phona__l
phonathon1743443phonathon
phonating1537813phonating
phonation1439393phonation
phone105621933phon__e_
phoneme1446203phoneme_
phonemes1546193phonemes
phones114121213phon__es
phonetic15310323phonetic
phoney143612983phon__ey
phonier122710633phon_ier
phonies123717513phon_ies
photoed1338913pho_toed
phrased1387383ph_rased
phreaked1834493phreaked
picrated132110113picrated
pileated112711133pileated
pinnate93613743pinnate_
pirated102515613p_irated
placated1338453placated
planate9314573planate_
planted103516123plan_ted
plated95225773p__lated
pleated103816633p_leated
plicated13310643plicated
plonked14348103plon_ked
plotted104612373plo_tted
pointed103813983p_ointed
pomaded13377863p_omaded
ponced114314813p_on_ced
ponded105218773p_on_ded
ponged105619353p_on_ged
ponied94920703p_on_ied
pontes83627853p_on_tes
ported94223243p_o_rted
posited10511493p_osited
posted93722493p_o_sted
potted94624013p_o_tted
pouted94021393p_o_uted
prated94924923p__rated
predated12513273predated
printed104016373prin_ted
probate11414483probate_
probates12414283probates
profaned14207973profaned
profited14279973profited
prolate9419793prolate_
promoted13310543promoted
prompted1536903prompted
pronator10311783pronator
pronged113912393pron_ged
prorate9418733prorate_
prorates10418073prorates
protonated1348593protonated
pulsated1136853pulsated
punted94618713p_un_ted
pupated12319353p_upated
resonated10510613resonated
rotated82715293_rotated
ruinated939523ruinated
saponated1245733saponated
shoaled113810973sho_aled
shorted113614403sho_rted
shotted113912403sho_tted
shouted113911553sho_uted
shunted11339783shun_ted
solated83618023_solated
thionate11137503thionate_
thionates12106663thionates
thonged12376843thon_ged
threated1259203threated
throated1247923throated
togated94410663_togated
urinated9311613urinated
violated1237883violated
wonted103213283_won_ted
zonate154114923_zonate_

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621806.62622058.9
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.