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

179 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
phylar1443737(None) 
phyla13469181phyla_
phylae14458731phylae
hilar85418142_hilar
hyla106716512_hyla_
hylas114815902_hylas
mylar105311532_mylar
pedlar93311272pedlar
phyle134111152phyl_e
phylic16279552phylic
phyllary1943232phyllary
phyllo1435872phyllo
phylon14318032phylon
phylum1655152phylum
pilar75221502p_ilar
pillar8314022pillar
polar75623452p_olar
poplar103611112poplar
psywar1443322psywar
stylar9358112stylar
alar46340073__alar
alular6311353alular
aphylly1843353aphylly
ashlar9338193ashlar
astylar10265063astylar
asyla839333asyla_
bolar75123473_bolar
boyar106013763boy_ar
boyla102912363boyla_
boylas113011723boylas
bylaw13408603_bylaw
cellar84514983cellar
chadar1239353chadar
chalah143511663chalah
char95132153ch__ar
chela103916803chela_
chelae113614603chelae
chelas113817203chelas
chimar133911473chimar
chola104718033chola_
cholas114818003cholas
choler113717153choler
chukar1534633chukar
chyle134913483chyl_e
chyles144813283chyles
collar83816173collar
cymar125711263_cymar
dollar74110983dollar
filar84819293_filar
gaydar1135503gaydar
ghyll1246323ghyl_l
ghylls1335143ghylls
gular6314833_gular
haar77323493_h_aar
halal85623593_halal
haler85033523_haler
hear76143883_h_ear
hila76228353_hila_
hoar76729163_h_oar
holard10410573_holard
hula74923753_hula_
hulas84920883_hulas
hydra12249223_hydra
hyper135213903_hyper
hyrax1838033_hyrax
kyar116916843_ky_ar
lar37967533___lar
malar76424443_malar
medlar93010463medlar
molar75223093_molar
mylars114310443_mylars
ocular8610133ocular
ovular946833ovular
pabular11259473pabular
paler75436933p_aler
pallor8313673pallor
palmar104113463palmar
papular11299763papular
par57467023p___ar
parlay113713993parlay
parlor8312673parlor
payday1536613payday
payer105125723pay_er
payload1336403payload
payola11208113payola_
payolas12148973payolas
payor105413843pay_or
pear69745233p__ear
pedlars103210213pedlars
pedlary13277543pedlary
pedler93614613pedler
peeler83517383peeler
pepla9312863pepla_
phalanx1945203phalanx
phalli1148263phalli
phat95837863ph__at
phial10313203ph_ial
phials1158873phials
philter12108213philter
philtra12103683philtra
philtre12105213philtre
phlox1737333ph_lox
phonal11310383phonal
phreak1536153phreak
phylaxis2344413phylaxis
phyllos1535583phyllos
physed15386793physed
physes14399783physes
physic16288473physic
physis14359663physis
phytane1545443phytane
phytin14459013phytin
phytol14366563phytol
phyton143610253phyton
pilaf103923483p_ilaf
pilau73618523p_ilau
pilaw103913743p_ilaw
pillars9313493pillars
pilular938203pilular
plan65833943p__lan
planar84212713planar
plat66048873p__lat
play95928983p__lay
plyer106214333ply_er
polars84419353p_olars
poler74431793p_oler
pollard103511143pollard
poller83921853poller
pooler83819843pooler
poplars113910333poplars
popular11319563popular
poulard10299733poulard
prelaw1139103prelaw
prewar114712573prewar
prolan8414693prolan
prowar114110943prowar
pryer104415313pry_er
psylla1133953psylla
psyllas1244883psyllas
psywars1533673psywars
pula65129373p_ula_
puler74826623p_uler
puller83820813puller
pulsar8329363pulsar
pupilar11125313pupilar
pya87023753p_y_a_
pyas96225703p_y_as
pylon103614003p_ylon
pylori1147163p_ylori
pyran10514473p_yran
rhymer14387083rhymer
rhyta1135083rhyta_
scalar83612433scalar
scholar1236953scholar
shear85424833sh_ear
shikar1336803shikar
shmear1176933shmear
shofar1236313shofar
shyer114714783shy_er
shyly144811573shyl_y
skylark1343273skylark
solar55927343_solar
stelar64013863stelar
styler94013303styler
subphylar1951483subphylar
talar56225383_talar
thaler94613103thaler
thenar92610003thenar
tolar55524113_tolar
uhlan849113uh_lan
uvular955563uvular
velar85817633_velar
volar86917413_volar
waylay1535453waylay
whaler124611973whaler
whydah1942953whydah
xylan1537463_xylan
yar67253833__y_ar
year76534253__year

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.1401276364.3
2DLD Change Limit1127161795.01622471.3
3Display Results1791790.0434162.8
 (SQL Overall)1786911795.19934370.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.