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

148 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
phyllo143587(None) 
phyllos1535581phyllos
aphylly1843352aphylly
ghyll1246322ghyll_
ghylls1335142ghylls
hallo85127552_hallo
hello86522982_hello
hillo84721652_hillo
hollo84822162_hollo
hullo84417452_hullo
phalli1148262phalli
phyla13469182phy_la
phylae14458732phylae
phylar14437372phylar
phyle134111152phy_le
phylic16279552phylic
phyllode1743942phyllode
phylloid1746192phylloid
phyllome1854142phyllome
phylon14318032phylon
phylum1655152phylum
phytol14366562phytol
psylla1133952psylla
ahull84010313ahull_
aphyllous1783253aphyllous
apollo837183apollo
brillo84211003brillo
cello74919583_cello
challa114014193challa
challot123613263challot
chally144314293chally
chill105619873chill_
chilli114312773chilli
chills114717703chills
chilly144113223chilly
cholla113911023cholla
cholo105217973ch_olo
chyle134913483chy_le
chyles144813283chyles
cyclo1237703_cyclo
duello756783duello
fillo84319783_fillo
hall75741163_hall_
halloa94918123_halloa
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
hallow124818323_hallow
halls85633783_halls
halo76437323_h_alo
helio85321193_helio
hell75637893_hell_
hellos95321683_hellos
hells85032043_hells
helo75332853_h_elo
hill76439493_hill_
hilloa94713033_hilloa
hillos94618893_hillos
hills85431353_hills
hilly114422163_hilly
holla84918493_holla
holloa94914823_holloa
holloo94415253_holloo
hollos95320633_hollos
hollow124212663_hollow
holly114824433_holly
hull75428783_hull_
hulloa95011183_hulloa
hulloo94511733_hulloo
hullos94916293_hullos
hulls84923563_hulls
hydro12259423_hydro
hyla106716513_hy_la
hylas114815903_hylas
hypo127516353_hy_po
idyll9436713idyll_
idylls10425253idylls
jello126716273_jello
niello636603niello
paella8410913paella
pall65039343p_all_
pallor8313673p_allor
palls74332563p_alls
pally105727123p_ally
payola11208113payola
pedalo93811153pedalo
phallic1447293phallic
phallus1236063phallus
phellem1435833phellem
phenol1149253phenol
phial10313203phial_
phials1158873phials
phlox1737333ph_lox
phono104917023ph_ono
photo104417233ph_oto
phyllary1943233phyllary
phyllite1645743phyllite
phyllodes1843823phyllodes
phyllodia1852763phyllodia
phylloids1844523phylloids
phyllomes1944123phyllomes
phyllomic2143383phyllomic
phyllopod2052433phyllopod
physed15386793physed
physes14399783physes
physic16288473physic
physis14359663physis
phytin14459013phytin
phytols15276553phytols
phyton143610253phyton
pill65339463p_ill_
pillow113110573p_illow
pills74130973p_ills
polio75722553p_olio
poll66332133p_oll_
polls74627723p_olls
polo66236633p__olo
polyol1138713polyol
pomelo10238663pomelo
prill74117943prill_
prills84015613prills
psycho1674533psycho
psyllas1244883psyllas
psyllid1344523psyllid
pueblo1035553pueblo
pull64731663p_ull_
pulls74425053p_ulls
pumelo10257113pumelo
pylon103614003p_ylon
pyro96019393p_y_ro
shall85024053shall_
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
shell84424123shell_
shells94319523shells
shelly124414473shelly
shill85325333shill_
shills94519613shills
shyly144811573shy_ly
thalli958923thalli
thill85918733thill_
thills95515383thills
thymol1434463thymol
uphill11106173uphill_
uphills1295233uphills
wholly15366573wholly
xylol1546133_xylol

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.373479064.3
2DLD Change Limit1127161484.78323566.0
3Display Results1481480.0463217.4
 (SQL Overall)1786911485.20234350.4
 
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.