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

243 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
trets5592802(None) 
frets85523401frets
rets45352561_rets
tets45847461t_ets
treats64821691treats
trees55835761trees
treks96016851treks
tres46542901tre_s
tress55423161tress
tret46653531tret_
trews86118891trews
treys85018211treys
trots56629941trots
abets75621672abets
areas55935772areas
ares45871022are_s
arete56031352arete
aretes64425352aretes
armets84918352armets
arts49650262ar_ts
beets76131442beets
berets85822522berets
bets67051442_bets
blets75324942blets
brats75336012brats
brees75632552brees
brens75823362brens
brents84717272brents
brews105617072brews
brits76433082brits
bruts75922952bruts
burets84321262burets
carets85330772carets
creds85418772creds
cress75022832cress
crest74632692crest
crests85218702crests
crews105917492crews
crits75527572crits
cruets85314952cruets
curets84922342curets
deets65330242deets
diets66026642diets
drats66628372drats
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
drest65530342drest
duets65323882duets
egrets72712242egrets
erects84116182erects
fets75345942_fets
frats86829672frats
frees86131392frees
fret75845042fret_
frits86129102frits
gets55442482_gets
greats76318392greats
grees65132472grees
greets75117422greets
greys96614852greys
grits65529582grits
grots65025852grots
haets86525122haets
hets75547202_hets
ires45639282ire_s
jets115834102_jets
keets95123482keets
khets124913432khets
leets54927122leets
lets47147942_lets
meets74224612meets
nerts55924982nerts
nets45941532_nets
ores46056682ore_s
orts46538332or_ts
pets66248332_pets
poets76024442poets
prats76333392prats
prees75937172prees
preps96220692preps
press75425952press
prest75736352prest
prests84021262prests
preys105717782preys
rats46260372_rats
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
rents55935182_rents
reps65937952_reps
res35565042_re_s
rest46459842_rest
rests54935872_rests
ret35982832_ret_
rete44944132_rete
revs75027052_revs
rots46454092_rots
ruts44541492_ruts
sets45549502_sets
starets73515922starets
stets55423912stets
streets73312612streets
streps86218062streps
stress66616672stress
strews96817092strews
struts65616802struts
suets55126102suets
tacts76524122tacts
taels56822072taels
tares57456562tare_s
targets84314222targets
tarots66422992tarots
tarts57242022tarts
tates55444982tates
tats46858132t_ats
tauts56125512tauts
teas45851492t_eas
teats55636812teats
teds54932572t_eds
teels55726372teels
teems76019782teems
teens56227482teens
tees45353582t_ees
teeth87315852teeth
tegs56031492t_egs
tels46841692t_els
tenets65518952tenets
tens45647412t_ens
tents56434212tents
tercets93512442tercets
terete6319332terete
terms75523472terms
terns55226872terns
terrets72913582terrets
test48651622t_est
tests56530192tests
tet39274992t_et_
teth76327892t_eth
teths85418512t_eths
tews76431642t_ews
texts125515042texts
thefts12387922thefts
thens85921832thens
theta83414572theta
thetas93011572thetas
thews117416192thews
threats104311672threats
threes97117322threes
tiers55526522tiers
ties45248312tie_s
tilts55325612tilts
tints56030922tints
tires55437492tire_s
tits46145042t_its
toeas55726422toeas
toes46956442toe_s
tofts84919242tofts
toits55327472toits
toots55331872toots
tores55352672tore_s
tortes64826052tortes
torts56138122torts
totes55139682totes
tots46654122t_ots
touts54830392touts
tracts85019072tracts
traits65121982traits
trams75327672trams
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
tread64821702tread
treads74817922treads
treat56240352treat
treaty94414352treaty
tree47745812tre_e
treed65626732treed
treen55622752treen
treens65317872treens
tref77030992tre_f
trek86222312tre_k
trend64817452trend
trends75513542trends
tressy9448552tressy
trevets10499972trevets
trey77228792tre_y
triens65417542triens
triers64321522triers
tries55742812tries
trigs65423062trigs
trijets14308262trijets
trims75021472trims
trios55528092trios
trips74923362trips
trite54730032trite
trivets103911582trivets
trogs67022602trogs
trois57226092trois
trot46351312trot_
troth85622202troth
troths95414152troths
trouts66116632trouts
trows88826182trows
troys86418612troys
trues54925322trues
truest64816192truest
trugs65516802trugs
truss54916922truss
trust55426852trust
trusts64714432trusts
truth85214152truth
truths9449502truths
tryst84716222tryst
trysts9448792trysts
tsetse664692tsetse
tufts85713272tufts
turrets73010672turrets
tuts45838452t_uts
twats86616602twats
tweets94210102tweets
twits86015792twits
tyees86019452tyees
tyers86220052tyers
tyes76433372tye_s
tyres84725232tyre_s
ureas55826012ureas
verts85724732verts
vets76835092_vets
weets85427722weets
wets75940292_wets
whets115019612whets
wrens85016242wrens
wrest84925432wrest
wrests95313082wrests
writs86624382writs

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.0931921408.6
2DLD Change Limit538002431.40638264.6
3Display Results2432430.0633857.1
 (SQL Overall)1786912431.562114398.8
 
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.