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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

184 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
trope7572580(None) 
grope84821611grope
rope65542911_rope
tope65946381t_ope
tripe75425381tripe
trode65322851trode
troke94821051troke
trompe105611261trompe
trone55131861trone
trop66833301trop_
tropes84824351tropes
troupe84812431troupe
trove85221921trove
arose55832082arose
broke116019782broke
brome94421972brome
brose75227032brose
cope86847382_cope
crape96128442crape
crepe95520722crepe
cripe95521142cripe
crone75231332crone
crop87628632crop_
crops96125232crops
crore74922872crore
croupe105114432croupe
croze164719452croze
dope76038892_dope
drape85319632drape
drone65324982drone
drop75324402drop_
drops85719502drops
dropt86924432dropt
drove95518062drove
drupe85012992drupe
elope75219342elope
erode64520992erode
erose55727272erose
froe75329992fro_e
frore86218802frore
froze174515652froze
grape84824662grape
gripe84622962gripe
groped107515052groped
groper94517252groper
gropes95220402gropes
grove95219332grove
hope96639672_hope
irone55126362irone
krone94018732krone
lope65941922_lope
mope86838042_mope
myope124010972myope
nope65934192_nope
ope56845242__ope
pope85535612_pope
probe94320812probe
prole74527792prole
prone75332622prone
prop85932812prop_
propel103714062propel
proper104319952proper
props95726882props
prose75835122prose
prove104823192prove
pyrope132810532pyrope
rape65041632_rape
ripe66038922_ripe
robe65335642_robe
rode55844302_rode
roe36861082_ro_e
role45851822_role
roped84630802_roped
roper75431912_roper
ropes75940062_ropes
ropey106021872_ropey
ropy96323412_ropy
rose46148902_rose
rote46249022_rote
roue45941742_roue
rove75136982_rove
scope94821482scope
slope75823562slope
stope74727242stope
stripe85822442stripe
strobe84513812strobe
strode75215972strode
stroke105116172stroke
strop77422242strop_
strophe1239142strophe
strops86220382strops
strove95014792strove
tape64538142t_ape
taupe7314162taupe
thole85620842thole
thorpe113610092thorpe
those85218142those
throe89321422thro_e
throne98517602throne
throve128012392throve
toe310166852t_o_e
toke86738492t_oke
tole46052902t_ole
tome67543192t_ome
tone46953742t_one
top510560682t_op_
toped85631312t_oped
topee76029952t_opee
toper75231022t_oper
topes76941762t_opes
toph96326872t_oph
tophe106718972t_ophe
topi67830392t_opi
topo66932402t_opo
tops66248122t_ops
tore47359322t_ore
torose64317692torose
torse55833332torse
torte55431702torte
tote46643672t_ote
towrope1245582towrope
trace75829612trace
trade65026042trade
trap67532802trap_
trapes85024462trapes
traps75727482traps
trapt76433392trapt
trave85223032trave
tree47745812tr_ee
tribe74420272tribe
trice75127492trice
trike95320162trike
trine54734602trine
triode75311892triode
triose64715382triose
trip66830392trip_
tripes85324872tripes
triple84215922triple
trips74923362trips
trite54730032trite
troak95213572troak
troche113112512troche
trock114817602trock
trod57627952tro_d
trog57628212tro_g
trogs67022602trogs
trois57226092trois
troked114114582troked
trokes104019262trokes
troll54416532troll
tromp95815802tromp
tromped124210292tromped
trompes114111622trompes
tromps104911702tromps
trona54118952trona
trones65629282trones
troop76417532troop
trooped104010722trooped
trooper94210362trooper
troops85712782troops
trooz145016152trooz
trophy1438282trophy
tropic103014192tropic
tropin83316752tropin
tropine93116652tropine
trot46351312tro_t
troth85622202troth
trots56629942trots
trouped103910982trouped
trouper93811432trouper
troupes94112852troupes
trout57332572trout
trover95014662trover
troves94719112troves
trow78031422tro_w
trowed104714652trowed
trowel94211462trowel
trows88826182trows
troy77429682tro_y
troys86418612troys
truce75118692truce
true46725852tr_ue
type96223742t_ype
wrote84717482wrote

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001841.40638264.6
3Display Results1841840.0464000.0
 (SQL Overall)1786911841.748102226.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.