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

157 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
phyllos153558(None) 
phyllo1435871phyllo_
aphyllous1783252aphyllous
ghylls1335142ghyll_s
hallos95425102_hallos
hellos95321682_hellos
hillos94618892_hillos
hollos95320632_hollos
hullos94916292_hullos
phallus1236062phallus
phyllode1743942phyllode
phyllodes1843822phyllodes
phylloid1746192phylloid
phylloids1844522phylloids
phyllome1854142phyllome
phyllomes1944122phyllomes
phylon14318032phy_lon
phytols15276552phytols
psyllas1244882psyllas
aphyllies1743823aphyllies
aphylly1843353aphyll_y
apollos946793apollos
brillos9369193brillos
cellos84517803_cellos
challas124414123challas
challis124613463challis
challot123613263challot
chillis124411603chillis
chills114717703chill_s
chollas123811353chollas
cholos114716853ch_olos
chyles144813283chy_les
chylous15107273chylous
cyclos1338073_cyclos
duellos845763duellos
fillos94415083_fillos
ghyll1246323ghyll__
hallo85127553_hallo_
halloa94918123_halloa
halloas104318463_halloas
halloes104021523_halloes
halloo95118973_halloo
halloos103716743_halloos
hallot95426783_hallot
hallow124818323_hallow
hallows134417393_hallows
halls85633783_hall_s
halos85230253_h_alos
helios94816633_helios
hello86522983_hello_
helloes103717473_helloes
hells85032043_hell_s
helos84928063_h_elos
hillo84721653_hillo_
hilloa94713033_hilloa
hilloas104413553_hilloas
hilloes103815963_hilloes
hills85431353_hill_s
hollas94616903_hollas
hollo84822163_hollo_
holloa94914823_holloa
holloas103814943_holloas
holloes103818193_holloes
holloo94415253_holloo
holloos104013583_holloos
hollow124212663_hollow
hollows134412333_hollows
hullo84417453_hullo_
hulloa95011183_hulloa
hulloas103911913_hulloas
hulloes104113923_hulloes
hulloo94511733_hulloo
hulloos104010073_hulloos
hulls84923563_hull_s
hydros13279363_hydros
hylas114815903_hy_las
hypos1312014743_hy_pos
idylls10425253idyll_s
jellos134714283_jellos
niellos736143niellos
paellas9411423paellas
pallor8313683p_allor
pallors9314373p_allors
palls74332563p_all_s
payolas12148973payolas
pedalos10329703pedalos
peplos101211543p_eplos
phalli1148263phall_i
phallic1447293phallic
phallism1545723phallism
phallist1338993phallist
pharos11312063ph_aros
phellem1435843phellem
phellems1544543phellems
phenols1238103phenols
phials1158873phial_s
phlox1737333ph__lox
phonos114114793ph_onos
photos113316643ph_otos
phyla13469183phy_l_a
phylae14458733phy_lae
phylar14437373phy_lar
phylaxis2344413phylaxis
phyle134111153phy_l_e
phyleses1645183phyleses
phylesis1645313phylesis
phylic16279553phy_lic
phyllary1943233phyllary
phyllite1645743phyllite
phyllites1745323phyllites
phyllodia1852763phyllodia
phyllomic2143383phyllomic
phyllopod2052433phyllopod
phyllopods2152293phyllopods
phylum1655153phy_lum
physeds16344033physeds
physes14399783phy_ses
physics17265963physics
physis14359663phy_sis
phytins15317893phytins
phytol14366563phy_tol
phyton143610253phy_ton
phytons15319063phytons
pillow113110573p_illow
pillows122610123p_illows
pills74130973p_ill_s
polios84019723p_olios
polls74627723p_oll_s
polos76129913p__olos
polyols1238493polyols
pomelos11218133pomelos
prills84015613prill_s
psychos1765263psychos
psylla1133953psyll_a
psyllid1344523psyllid
psyllids1443023psyllids
pueblos1134843pueblos
pulls74425053p_ull_s
pumelos11196093pumelos
pylon103614003p_y_lon
pylons113011243p_ylons
pyros105718293p_y_ros
shallop12348453shallop
shallops13288323shallops
shallot103614133shallot
shallots11319503shallots
shallow13388873shallow
shallows14388863shallows
shells94319523shell_s
shills94519613shill_s
thallous1136523thallous
thallus1035603thallus
thills95515383thill_s
tholos94213003th_olos
thymols1533843thymols
uphills1295233uphill_s
xylols1634173_xylols

Search took 7 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.420425454.8
2DLD Change Limit1340271576.45320769.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.93625762.8
 
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.