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 “trophiet” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
trophied1437651trophied
trophies13413681trophies
atrophied1546072atrophied
atrophies14410102atrophies
prophet14316032proph_et
trophic14311032trophi_c
atrophia1348113atrophi_a
atrophias1447933atrophias
atrophic1549373atrophi_c
crochet143616663croch_et
croppie13278803croppie_
croppies143111153croppies
droplet10312113drop_let
dropsied1234973dropsied
dropsies1138703dropsies
eutrophies1556533eutrophies
frothier1435953frothier
frothiest1537453frothiest
graphite1447153graphite
ophite11410563__ophite
prophets1539503proph_ets
propjet1839913prop_jet
propriety1645433propriety
rochet115423003_roch_et
ropier84118813_rop_ier
ropiest93317773_rop_iest
sophies12314623_sophies
sophist12311573_sophist
strophe1239143stroph_e_
strophes13310603stroph_es
strophic1569003strophi_c
stroppier1364463stroppier
stroppiest1444583stroppiest
toothier1136423toothier
toothiest1237523toothiest
tophe106718973t_oph_e_
tophes115218423t_oph_es
tophi105215303t_ophi__
torchier1337463torchier
torchiest1438033torchiest
trashier113210103trashier
trashiest123110643trashiest
trephine1338933trephine
trephined1544903trephined
trephines1448483trephines
trichite1349333trichite
triplet94319213trip_let
triplite1039103triplite
trippet113714113trip_pet
trippier1246623trippier
trippiest1336603trippiest
troche113112513troch_e_
trochee122613883troch_ee
trochees132510183trochees
troches123715343troch_es
trochil1258713trochi_l
trochili1376943trochili
trochils1388583trochils
trochlea1345193trochlea
troilite849543troilite
trollied935903trollied
trollies8310233trollies
trope75725803trop__e_
tropes84824353trop__es
trophy1438283troph__y
trophying1844713trophying
tropic103014193trop_i_c
tropics113610653trop_ics
tropin83316753trop_i_n
tropine93116653trop_ine
tropines102214923tropines
tropins93116313trop_ins
tropism1139293trop_ism
trothed114010973troth_ed
trothing122410843trothing
troutier8277153troutier
troutiest9127803troutiest
turophile1475883turophile
turophiles1565983turophiles

Search took 9 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.466383457.1
2DLD Change Limit146162797.81318707.5
3Display Results79790.0332393.9
 (SQL Overall)178691798.31221498.0
 
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.