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

251 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
phenates1361158(None) 
penates93321601p_enates
phenate12412201phenate_
phonates13410641phonates
chelates132713842chelates
enates64026432__enates
hyphenates2144472hyphenates
khanates1535732khanates
phenacites1765402phenacites
phenakites1963862phenakites
phenixes2035642phenixes
phenolates1547022phenolates
phonate12411812phonate_
phonated1447892phonated
phorates13413042phorates
predates11615812predates
prelates10418572prelates
prenames12311642prenames
pronates10418372pronates
senates73322612_senates
thenages12107482thenages
acetates102013063acetates
aerates74627493_aerates
agemates111110023agemates
agnates82813193_agnates
alienates9310683alienates
annates72415423_annates
aphanites1448273aphanites
apholates1449683apholates
arenites8917103arenites
arsenates979373arsenates
benames112814603_benames
berates94126873_berates
catenates11311813catenates
cenotes92814543_cenotes
cerates95428253_cerates
cheated134416343che_ated
cheater124816963che_ater
cheaters133613513che_aters
cheats114519543che_at_s
chedites1438263chedites
chelate122914893chelate_
chelated142610483chelated
cholates132414763cholates
cognates11311583cognates
creates95225203cre_ates
cremates124216003cremates
crenate93317113crenate_
crenated113013913crenated
cyanates13238433cyanates
debates103718533_debates
delates83526283_delates
denotes83817003_denotes
derates84028893_derates
donates83217223_donates
edentates1046953edentates
elates65032363__elates
elevates111110423elevates
emanates10311333emanates
emendates1246083emendates
enate54428153__enate_
ephorates1459163ephorates
gelates83219593_gelates
gentes75324163_gen_tes
gheraoes1244813gheraoes
grenades1038433grenades
hamates122917683_hamates
hates86742573_h__ates
heated104525593_he_ated
heater94828303_he_ater
heaters104225223_he_aters
heaths126316383_he_aths
heats85838403_he_at_s
heaves124120303_he_aves
henbanes1336573_henbanes
henges104516463_hen_ges
henries102718283_henries
hented104218753_hen_ted
hents87330743_hen_t_s
herniates1247333_herniates
hexades18378703_hexades
hexanes17319463_hexanes
humates122813193_humates
hyphenate2044513hyphenate_
hyphenated2253373hyphenated
ideates8313733ide_ates
iterates81317823iterates
kentes105118653_ken_tes
khanate1437073khanate_
legates82917683_legates
lenites7818443_lenites
maenades1137473maenades
magnates11511613magnates
menaces112715523_menaces
menages103615393_menages
metates92720013_metates
nates55238333___nates
negates83215843_negates
neonates8310063neonates
odonates947743odonates
oleates7417833ole_ates
operates10515413operates
ozonates1745963ozonates
paginates123111363paginates
palates93624943p_alates
palpates122613063palpates
pates76047893p___ates
patinates113814693patinates
pawnages1435313pawnages
peaces106324083p_e_aces
peages94321853p_e_ages
peases85229473p_e_ases
peats76140193p_e_at_s
pectates122213953pectates
pedate93117763p_edate_
peerages1189893peerages
pelages10714613p_elages
pelites93821993p_elites
penalties11139513p_enalties
penances12312443p_enances
penangs10268373p_enangs
penes75839223p_en__es
penises9318193p_enises
penlites10312273p_enlites
pennames12287793pennames
pennate93314033pennate_
pennated11299543pennated
pennies94218813p_ennies
pensees9311203p_ensees
penster92811953p_enster
pensters103012123p_ensters
pentads1039523p_entads
pentanes10316083p_entanes
peonages1138473peonages
perennates1256763perennates
pesades10310903p_esades
petites93820203p_etites
peyotes1238483p_eyotes
phages125213513ph__ages
phases114618403ph__ases
phenacite1686103phenacite_
phenakite1864233phenakite_
phenazin2245603phenazin
phenazines2445133phenazines
phenazins2345303phenazins
phenetic1549203phenetic
phenetics1646483phenetics
phenetol1344063phenetol
phenetoles1544153phenetoles
phenetols1443713phenetols
phenolate1447493phenolate_
phenolated1645253phenolated
phenols1238103phen_ols
phenoms1437813phen_oms
phenotypes2044633phenotypes
phenyls1534333phen_yls
phereses1348093phereses
phoenixes2143393phoenixes
phonemes1546193phonemes
phones114121213phon__es
phonies123717513phon_ies
phorate12413363phorate_
phrases12711463ph_rases
phrenitis1445623phrenitis
phrensies1445743phrensies
phytanes1645763phytanes
picrates122013213picrates
pinatas93711503p_inatas
pinites9319533p_inites
pinnaces12268863pinnaces
pinnate93613743pinnate_
pinnated11338553pinnated
pirates93020333p_irates
placates12311753placates
planate9314573planate_
plates85432243p__lates
pleases94515483ple_ases
pleated103816633ple_ated
pleater93916333ple_ater
pleaters103613793ple_aters
pleats85218593ple_at_s
pleiades1145753pleiades
plenaries11410383plenaries
plenches153110623plenches
plenties10314693plenties
pointes93216753poin_tes
pollenates1246743pollenates
pontes83627853p_on_tes
potentates12106333potentates
prates84633163p__rates
prebakes1639013prebakes
predate10616893predate_
predated12513273predated
prefaces15311063prefaces
prefades1439533prefades
pregames1339003pregames
prelate9519693prelate_
prename11412643prename_
prenatal1048373prenatal
prepares122014163prepares
prepastes13128823prepastes
prepaves15189193prepaves
presages11312203presages
presales10315263presales
pretapes122811533pretapes
pretastes11119423pretastes
preunites1138933preunites
primates121515933primates
privates131812373privates
probates12414283probates
pronate9418873pronate_
pronated11414053pronated
prorates10418073prorates
pulsates1048813pulsates
pupates113311433p_upates
rebates95123183_rebates
redates83423873_redates
relates73731433_relates
remates93827113_remates
renames92418053_renames
rentes65431193_ren_tes
ruinates8311883ruinates
sedates83418043_sedates
selenates91611363selenates
senate63725173_senate_
sensates8511143_sensates
sheathes14610193she_athes
sheaths1358753she_aths
sheaves134412973she_aves
sienites8311913sienites
sphenes123013163sphen__es
syenites1138943syenites
tannates81911953tannates
tenaces92814513_tenaces
thanages12107623thanages
thanatos1165123thanatos
theater104014253the_ater
theaters114211903the_aters
theatres11298633the_atres
thecate123210023thecate_
thenage11107843thenage_
thenars10248523thena_rs
thionates12106663thionates
upheaves1643913uphe_aves
urinates8314133urinates
venenates1247583venenates
wheaten1336403whe_aten
wheatens1454663whe_atens
wheats125013223whe_at_s
whenas124610463whena__s
yentes95517603_yen_tes

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.406440125.6
2DLD Change Limit1461622517.11020557.2
3Display Results2512510.0932698.9
 (SQL Overall)1786912517.60923484.2
 
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.