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

205 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
trophies1341367(None) 
atrophies14410091atrophies
trophied1437641trophied
atrophias1447932atrophias
atrophied1546062atrophied
croppies143111132croppies
dropsies1138692dropsies
eutrophies1556512eutrophies
sophies12314612_sophies
strophes13310602stroph_es
tophes115218422t_oph_es
trephines1448482trephines
trochees132510182trochees
troches123715342troch_es
trochils1388582trochils
trollies8310232trollies
tropes84824352trop__es
trophic14311032trophi_c
tropics113610652trop_ics
tropines102214922tropines
tropins93116312trop_ins
turophiles1565982turophiles
atopies92816433atop_ies
atrophia1348103atrophi_a
atrophic1549373atrophi_c
atropines1148883atropines
atropins10410493atrop_ins
biopsies1237383biopsies
bothies12414783_bothies
brollies1039533brollies
brookies1459143brookies
brownies13189613brownies
copies104130303_cop_ies
crappies142911153crappies
cronies9622503cro_nies
croppie13278793croppie_
crowdies1437553crowdies
dropsied1234963dropsied
droshkies1762563droshkies
droskies13186343droskies
dystrophies2053763dystrophies
enophiles1448433enophiles
entropies11411023entrop_ies
exstrophies2353713exstrophies
floppies1546813floppies
frothier1435953frothier
frothiest1537453frothiest
graphics1645653graphics
graphites1546823graphites
gropes95220403grop__es
groupies1137523groupies
grumphies1743653grumphies
hoochies1639603hoochies
ironies7517423iro_nies
koppies153210013_koppies
morphias1546843morphias
morphines1648233morphines
morphins1538653morphins
murphies1536453murphies
myopies14309723myop_ies
ophites12310103__ophites
poppies102816193_poppies
popsies112816463_popsies
preppies1149683preppies
propanes122415823propanes
propenes122816513propenes
prophages1749763prophages
prophase15410243prophase
prophases16411063prophases
prophecies1996503prophecies
prophesies17107893prophesies
prophesy1844453proph_esy
prophet14316033proph_et
prophets1539503prophets
propines122618933propines
propones122516963propones
proposes122515973proposes
prossies101515223prossies
prosties101421193prosties
proxies163014933pro_xies
raphes115117453_raph_es
raphias123511083_raphias
raphides14188393_raphides
raphis114014323_raphi_s
replies94521043_replies
roadies83317443_roadies
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
roperies10315763_roperies
ropes75940063_rop__es
ropier84118803_rop_ier
ropiest93317773_rop_iest
roshis9311793_roshi_s
roughies1298323_roughies
rowdies113112693_rowdies
strophe1239143stroph_e_
strophic1569003strophi_c
strophoids1655523strophoids
stroppier1364453stroppier
stroppiest1444563stroppiest
tawpies12309873tawp_ies
techies12513603t_echies
timothies1444713timothies
toadies82914863t_oadies
tobies84521023t_o_bies
toddies93011993t_oddies
todies74223553t_o_dies
toffies133210213t_offies
tommies113812983t_ommies
toonies73719883t_oonies
toothier1136423toothier
toothiest1237523toothiest
tootsies848613tootsies
topazes1857313t_opazes
topees85519703t_op_ees
topes76941763t_op__es
tophe106718973t_oph_e_
tophi105215303t_ophi__
tophs105220053t_oph__s
tophus115210363t_oph_us
topics104714583t_op_ics
topis76025833t_op_i_s
toplines102412563t_oplines
topples113111653t_opples
topsides1137203t_opsides
torches123715433torch_es
torchier1337463torchier
torchiers1445073torchiers
torchiest1438033torchiest
tories65435883t_o_ries
torpids1037373torp_ids
toshes94520103t_osh_es
toughies1278243toughies
towhees13277793t_owhees
towies93521193t_o_wies
townies103113623t_ownies
trachles13311753trachles
trannies8415013trannies
trapes85024463trap__es
trapeses1039153trapeses
trapezes1936543trapezes
traplines11310373traplines
trashes104119263trash_es
trashier113210103trashier
trashiest123110633trashiest
treaties8316983treaties
trendies9312213trendies
trephine1338933trephine
trephined1544903trephined
trichites1448883trichites
tries55742813tr___ies
trilbies1037693trilbies
tripes85324873trip__es
triphase1346193triphase
triples94616873trip_les
triplites1148283triplites
tripodies1246573tripodies
triposes1039973triposes
trippier1246623trippier
trippiest1336583trippiest
tripwires1443283tripwires
trochaics1645063trochaics
trochars1377853trochars
troche113112513troch_e_
trochee122613883troch_ee
trochil1258713trochi_l
trochili1376943trochili
trochilus1474713trochilus
trochlea1345193trochlea
trochleas1444713trochleas
trochoids1546603trochoids
troilites948433troilites
trois57226093tro__i_s
trokes104019263tro__kes
trollied935893trollied
trompes114111623tro_mpes
trones65629283tro__nes
troopships1753153troopships
trope75725803trop__e_
trophy1438283troph__y
trophying1844713trophying
tropic103014193trop_i_c
tropin83316753trop_i_n
tropine93116653trop_ine
tropism1139293trop_ism
tropisms1247723tropisms
troponins1147203troponins
trothed114010973troth_ed
trothing122410843trothing
troths95414153troth__s
trotlines939103trotlines
troubles1057203troubles
trounces1037063trounces
troupes94112853tro_upes
troutier8277153troutier
troutiest9127803troutiest
troves94719113tro__ves
trusties82712853trusties
trypsins1344903trypsins
turophile1475883turophile
tushies10312163t_ushies
twoonies1155693twoonies
worthies14310283worthies
zoophiles2356523zoophiles

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.440406115.9
2DLD Change Limit1461622056.65321969.3
3Display Results2052050.0802562.5
 (SQL Overall)1786912057.17324911.6
 
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.