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

122 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
trophic1431103(None) 
atrophic1549371atrophic
strophic1569001strophic
tropic103014191trop_ic
atrophia1348102atrophia
eutrophic1646402eutrophic
graphic1537352graphic
morphic1648692morphic
orphic1368322or_phic
tophi105215302t_ophi_
topic95721502t_op_ic
trochaic1546942trochaic
trochil1258712trochil
trophied1437642trophied
trophies13413672trophies
trophy1438282troph_y
tropics113610652trop_ics
tropin83316752trop_in
tryptic1446002tryptic
agraphic1646183agraphic
atopic103514143atop_ic
atrophias1447933atrophias
atrophied1546063atrophied
atrophies14410093atrophies
atrophy1546183atroph_y
atropin9311583atrop_in
biopic123710673biop_ic
biopsic1345523biopsic
bioptic1337563bioptic
bromic122412693bro_mic
croppie13278793croppie
cryptic1646153cryptic
delphic1545103delphic
dropkick1641953dropkick
dystrophic2154203dystrophic
edaphic1544243edaphic
entropic1249683entrop_ic
erethic1257723erethic
erotic82620273ero_tic
frolic1149203fro_lic
glyphic1844063glyphic
gothic1237793_gothic
graphics1645653graphics
ironic8313773iro_nic
meropic13310263merop_ic
morphia1447483morphia
morphin1439003morphin
myopic15308463myop_ic
optic93715183__optic
prophasic1848473prophasic
prophecy2043913prophecy
prophet14316033prophet
prophetic18710583prophetic
propria1149933propria
propylic1747183propylic
prosaic11311163prosaic
raphia113511263_raphia
raphis114014323_raphis
roshi8310753_roshi_
roshis9311793_roshis
sapphic1644553sapphic
seraphic1546633seraphic
strobic1138253stro_bic
strontic1048103strontic
strophe1239143stroph_e
strophes13310603strophes
strophoid1567203strophoid
sylphic1745883sylphic
teraphim1545003teraphim
thoric114314043tho_ric
toluic837693t_oluic
tonic74727653t_o_nic
toph96326873t_oph__
tophe106718973t_oph_e
tophes115218423t_ophes
tophs105220053t_oph_s
tophus115210363t_ophus
topi67830393t_op_i_
topics104714583t_op_ics
topis76025833t_op_is
topkick1443143t_opkick
topoi76018353t_opoi_
toric76529313t_o_ric
torpid9310913torp_id
toxic145315623t_o_xic
traffic1544733traffic
tragic93811543tr_agic
trephine1338933trephine
trepid9310083trep_id
triadic1037833triadic
trimorphic1954073trimorphic
tripodic1345333tripodic
trismic1137483trismic
trochaics1645063trochaics
trochal1288243trochal
trochar1257073trochar
troche113112513troch_e
trochee122613883trochee
troches123715343troches
trochili1376943trochili
trochils1388583trochils
trochoid1468443trochoid
trois57226093tro__is
troopship1653233troopship
trop66833303trop___
trope75725803trop__e
tropes84824353trop_es
trophying1844713trophying
tropical1248733trop_ical
tropine93116653tropine
tropins93116313tropins
tropism1139293tropism
tropistic1347223tropistic
troponin1047943troponin
troth85622203troth__
trothed114010973trothed
trothing122410843trothing
troths95414153troth_s
trypsin1245113trypsin
turophile1475883turophile
typic124511963t_yp_ic
tyronic1239313tyro_nic

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.406440125.6
2DLD Change Limit1340271225.97022450.1
3Display Results1221220.0304066.7
 (SQL Overall)1786911226.40627894.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.