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 “phylae” 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
phylae1445873(None) 
phyla13469181phyla_
phylar14437371phylar
phyle134111151phyl_e
chelae113614602chelae
chyle134913482chyl_e
hyla106716512_hyla_
hylas114815902_hylas
phylic16279552phylic
phyllo1435872phyllo
phylon14318032phylon
phylum1655152phylum
phytane1545442phytane
acylate12310533acylate
alae45643753__alae
alulae6312743alulae
amylase1237023amylase
apholate13410473apholate
aphthae1544703aphthae
aphylly1843353aphylly
asyla839333asyla_
blae66134643__blae
boyla102912363boyla_
boylas113011723boylas
bullae83416163bullae
bylaw13408603_bylaw
cellae84915933cellae
chalah143511663chalah
chela103916803chela_
chelas113817203chelas
chelate122914893chelate
childe124711213childe
chile105626893chil_e
chola104718033chola_
cholas114818003cholas
cholate122114933cholate
chyles144813283chyles
chyme156512503chy_me
cymae126713013_cymae
dhole95215363dhol_e
ethylate1446223ethylate
ghyll1246323ghyl_l
ghylls1335143ghylls
hae67364003_h__ae
halal85623593_halal
hale76052833_hal_e
halve114818923_halve
haylage1436443haylage
helve115018093_helve
hila76228353_hila_
hilar85418143_hilar
hole77553393_hol_e
hoyle11314413hoyl_e
hula74923753_hula_
hulas84920883_hulas
hydrae13258573_hydrae
hype125519813_hy_pe
hyphae1746433_hyphae
hyrax1838033_hyrax
hyte109018943_hy_te
mylar105311533_mylar
odyle9349593odyl_e
padle84522343padl_e
palace104516923p_alace
palate84226793p_alate
pale66055013p_al_e
palea75028663p_alea
paleae84820293paleae
papulae11249353papulae
parae76335703p_arae
parlay113713993parlay
parle75836163parl_e
payday1536613payday
payee105524723pay_ee
payload1336403payload
payola11208113payola_
payolas12148973payolas
pedlar93311273pedlar
pelage9515363p_elage
pele65539553p_el_e
pennae84314033pennae
pepla9312863pepla_
peyote1139853peyote
phage115113673ph_age
phalange1465193phalange
phalanx1945203phalanx
phalli1148263phalli
phase104617213ph_ase
phat95837863ph__at
phellem1435833phellem
phenate12412203phenate
phial10313203ph_ial
phials1158873phials
philabeg1642313philabeg
philter12108213philter
philtre12105213philtre
phloem1335713ph_loem
phlox1737333ph_lox
phoebe1335003phoebe
phonal11310383phonal
phonate12411813phonate
phone105621933ph_one
phorate12413363phorate
phrase11109903phrase
phreak1536153phreak
phylaxis2344413phylaxis
phyleses1645183phyleses
phyllary1943233phyllary
phyllite1645743phyllite
phyllode1743943phyllode
phyllome1854143phyllome
phyllos1535583phyllos
physed15386793physed
physes14399783physes
physic16288473physic
physis14359663physis
phytanes1645763phytanes
phytin14459013phytin
phytol14366563phytol
phyton143610253phyton
pilaf103923483p_ilaf
pilar75221503p_ilar
pilau73618523p_ilau
pilaw103913743p_ilaw
pile65649693p_il_e
pilea75123953p_ilea
pillage103412603pillage
pillar8314023pillar
pinnae84414643pinnae
place94824613p__lace
plage84520403p__lage
plan65833943p__lan
plane74929143p__lane
plat66048873p__lat
plate74635113p__late
play95928983p__lay
plea66830603p__lea
plicae10410953plicae
plie65127393p__lie
polar75623453p_olar
pole65951303p_ol_e
pollee83623273pollee
poplar103611113poplar
prelate9519693prelate
prelaw1139103prelaw
prolan8414693prolan
prolate9419793prolate
prole74527793prol_e
psoae74411623p_soae
psyche1674293psyche
psylla1133953psylla
psyllas1244883psyllas
psywar1443323psywar
pterylae1343013pterylae
pula65129373p_ula_
pule65040953p_ul_e
pulse74219973p_ulse
pupae96515643p_upae
pya87023753p_y_a_
pyas96225703p_y_as
pye86432503p_y__e
pylon103614003p_ylon
pyran10514473p_yran
pyre94925553p_y_re
pyxie17359363p_yxie
rhyme13479553rhy_me
rhyta1135083rhyta_
shale85332833shal_e
shelve124012763shelve
shyly144811573shyl_y
stelae63716483stelae
stylar9358113stylar
stylate10179773stylate
style85519363styl_e
sylvae12236863_sylvae
telae54323293_telae
thae76825563th__ae
thecae11299653thecae
thole85620843thol_e
thyme134612473thy_me
thyrse1235133thyrse
uhlan849113uh_lan
uvulae945323uvulae
villae95615383villae
waylay1535453waylay
whale115517433whal_e
while115418693whil_e
whole114418093whol_e
whydah1942953whydah
wyle105519383_wyl_e
xylan1537463_xylan

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161915.18621734.7
3Display Results1911910.0633031.7
 (SQL Overall)1786911915.62531767.3
 
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.