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

234 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
phonate1241181(None) 
phenate12412201phenate
phonated1447891phonated
phonates13410641phonates
phorate12413361phorate
pronate9418871pronate
apholate13410472apholate
cholate122114932cholate
donate73619502_donate
ephorate1359502ephorate
khanate1437072khanate
neonate7311332neonate
odonate848402odonate
ozonate1646862ozonate
pennate93314032pennate
peonage1048722peonage
phenates13611582phenates
phonal11310382phona_l
phone105621932phon__e
phoneme1446202phoneme
phorates13413042phorates
pinnate93613742pinnate
planate9314572planate
probate11414482probate
prolate9419792prolate
pronated11414052pronated
pronates10418372pronates
prorate9418732prorate
thionate11137502thionate
zonate154114922_zonate
aconite9315473aconite
adnate72913483_adnate
agnate73314883_agnate
aphanite1348773aphanite
apholates1449683apholates
binate8419773_binate
borate85026153_borate
bromate11313553bromate
chelate122914903chelate
chlorate133112693chlorate
choanae1236863choanae
cholates132414763cholates
chorale124313353chorale
chordate1448033chordate
chromate15312783chromate
cognate10312203cognate
cohobate1547013cohobate
comate104124843_comate
connate9315753connate
conte76633203_con_te
coronate103018213coronate
crenate93317113crenate
cyanate12259703cyanate
detonate9311193detonate
donated93513863_donated
donates83217223_donates
ebonite9310293ebonite
echinate1359403echinate
elongate945613elongate
emanate9312473emanate
enate54428153__enate
ephorates1459163ephorates
folate93320393_folate
globate1057823globate
hamate113319833_hamate
hate78450173_h__ate
homage121210603_homage
honan85319773_hona_n
honans94814503_honans
hondle103914523_hondle
hone77549323_hon__e
honkie133011673_honkie
horste94817413_horste
humate113214443_humate
hyphenate2044513hyphenate
innate63917313_innate
intonate8310923intonate
iodate7313503_iodate
isolate7313923isolate
khanates1535733khanates
lanate6421263_lanate
lobate82915243_lobate
locate83919843_locate
lunate6316043_lunate
magnate10512703magnate
monte75829773_mon_te
neonates8310063neonates
niobate937703niobate
nonage7313683_nonage
notate63217863_notate
obovate1235463obovate
odonates947743odonates
orate55133303__orate
ornate6315143_ornate
ovate84214393__ovate
ozonated1864593ozonated
ozonates1745963ozonates
paginate114012443paginate
palate84226793p_alate
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
pate65350463p___ate
patinate103016313patinate
pawnage1335873pawnage
pectate112214693pectate
pedate93117763p_edate
peltate92013773peltate
penates93321603p_enates
pennae84314033penna_e
penname11328553penname
pennated11299543pennated
peonages1138473peonages
perorate10417923perorate
personate112111423personate
phage115113673ph__age
phase104617213ph__ase
phat95837863ph__at_
phenacite1686103phenacite
phenakite1864233phenakite
phenolate1447493phenolate
phocine1438833phocine
phoebe1335003pho_ebe
phon95925383phon___
phonathon1743443phonathon
phonating1537813phonating
phonation1439393phonation
phoned124014553phon_ed
phonemes1546193phonemes
phones114121213phon_es
phonetic15310323phonetic
phoney143612983phon_ey
phoneyed1743843phoneyed
phoneys15437143phoneys
phonic133315213phon_ic
phonics143110723phonics
phonied133710563phonied
phonier122710633phonier
phonies123717513phonies
phonily1537103phonily
phoning13312053phoning
phono104917023phon__o
phonolite1448283phonolite
phonon114012033phon_on
phonons123310253phonons
phonos114114793phon_os
phonotype1944273phonotype
phons105221143phon__s
phony136715443phon__y
phosphate1977273phosphate
phot95534363pho__t_
photo104417233pho__to
phots105418503pho__ts
phrase11109903ph_rase
phylae14458733phyla_e
phytane1545443phytane
picante11310523picante
picrate112014143picrate
pileate93815923pileate
pinata83817223p_inata
pinite8321243p_inite
pinnace113510313pinnace
pinnae84414643pinna_e
pinnated11338553pinnated
pirate82322883p_irate
placate11312433placate
plate74635113p__late
plicate11314513plicate
plumate1149803plumate
podite93315353p_odite
pointe84619313p_ointe
polite83625073p_olite
pomace123111913p_omace
pomade113611333p_omade
ponce95222513p_on_ce
pone65747533p_on__e
pongee94920193p_ongee
pontes83627853p_on_tes
potage92715903p_otage
potato8513433p_otato
prate75135983p__rate
predate10616893predate
prelate9519693prelate
prename11412643prename
primate111516283primate
priorate10411733priorate
private121513263private
probated13410863probated
probates12414283probates
proette9312363proette
profane122111863profane
promote11313143promote
pronator10311783pronator
prone75332623pron__e
pronota939763pronota
pronto8313993pron_to
propane112716153propane
prorated11513713prorated
prorates10418073prorates
prostate10314533prostate
protonate11412573protonate
psoae74411623pso_a_e
pulmonate1344763pulmonate
pulsate9510233pulsate
pupate104213123p_upate
quinate16511573quinate
resonate8513513resonate
rotate63320343_rotate
ruinate7312833ruinate
senate63725173_senate
shoat85633953sho_at_
shoats94117083sho_ats
shogunate1342853shogunate
shone83725983shon__e
shote85526103sho__te
siphonage1542953siphonage
solate64526073_solate
sonata6313223_sonata
spinate93114813spinate
stomate9313123stomate
tannate71813523tannate
ternate7415483ternate
thanage11117943thanage
thecate123210023thecate
thenage11107843thenage
thionates12106663thionates
thorite10313443thorite
togate74515683_togate
umbonate1245293umbonate
unornate848013unornate
urinate7315363urinate
violate10311553violate
zonae145116443_zona_e
zonated173310533_zonated

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272346.58020368.8
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.09225196.1
 
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.