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

211 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
bruts7592295(None) 
bhuts105812951bhuts
bouts75131311bouts
brats75336011brats
brits76433081brits
bruits85714451bruits
brunts85215451brunts
brut66537961brut_
brute75321781brute
brutes86118681brutes
buts67247691b_uts
ruts44541491_ruts
abuts75417072abuts
arts49650262ar_ts
arums75517832arums
bahts105617802bahts
baits76630582baits
barbuts11439842barbuts
basts75936932basts
bats66962332b_ats
batts76727562batts
bauds85821042bauds
beats76042242beats
beauts86015282beauts
beets76131442beets
belts75931162belts
bents76033692bents
berets85822522berets
bests75932612bests
bets67051442b_ets
bhut95425712bhut_
bints76130182bints
bits66148152b_its
bitts75022592bitts
blats75132502blats
blets75324942blets
blots75626172blots
blubs95818152blubs
blues75127042blues
bluets87215492bluets
blunts84512892blunts
blurs74619082blurs
blurts84412642blurts
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952b_ots
botts75224862botts
bout66353292bout_
bracts105617772bracts
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
brants85723052brants
bras65746452br_as
brass75428022brass
brat66055542brat_
braws106425192braws
brays106723112brays
brees75632552brees
brens75823362brens
brents84717272brents
brews105617072brews
bries74942152bries
brigs85823222brigs
brims94721622brims
brins75533972brins
brios74725722brios
bris65539612br_is
briss75824272briss
brit66350152brit_
brith104924372brith
briths115113862briths
britt75732232britt
britts84813442britts
broos75126412broos
bros65635662br_os
broth106521092broth
broths115013922broths
brows105425982brows
brugh115414292brugh
brughs12509062brughs
bruin75818332bruin
bruins86014952bruins
bruise83412872bruise
bruit76126722bruit
brulots946222brulots
brume95817982brume
brumes106417072brumes
brunets9419552brunets
brung84613912brung
brunt75728752brunt
brush105917472brush
brusk114912432brusk
brutal859382brutal
bruted95113262bruted
brutish1237702brutish
brutism1146772brutism
brux136315272bru_x
bruxes154811022bruxes
bubs86235492b_ubs
buds75235172b_uds
bugs76035912b_ugs
bums85934592b_ums
buns66243722b_uns
bunts75729802bunts
buras74736292buras
burbs95423492burbs
burds84626062burds
burets84321262burets
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422b_urs
burst75332242burst
bursts85116242bursts
bus56950972b_u_s
buss65134912b_uss
bust65947782b_ust
busts75227692busts
but55963022b_ut_
bute66739672b_ute
butes714535872b_utes
butt65143742b_utt
butts75824252butts
bututs8409422bututs
buys95726792b_uys
crits75527572crits
cruds85815852cruds
cruets85314952cruets
crus65828482cru_s
crust75827662crust
crusts84916542crusts
cuts65841152_cuts
dauts67822242dauts
drats66628372drats
drubs85913832drubs
drugs75214652drugs
drums85415872drums
eructs83610792eructs
erupts8348902erupts
frats86829672frats
frets85523402frets
frits86129102frits
frugs96114282frugs
fruits94512492fruits
gluts66120132gluts
gouts64826172gouts
grits65529582grits
grots65025852grots
grouts75015612grouts
grubs86312602grubs
grues65721962grues
grunts75511852grunts
guts56637252_guts
hurts86922822hurts
huts76737442_huts
juts115930162_juts
krauts10418512krauts
louts56330272louts
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
orts46538332or_ts
outs45746962_outs
phuts104613502phuts
pouts75530322pouts
prats76333392prats
pruta7314242pruta
puts65641752_puts
rats46260372_rats
rets45352562_rets
rots46454092_rots
routs57133412routs
rubs66133492_rubs
rues46044482_rues
rugs56033682_rugs
rums64833472_rums
runs46438072_runs
runts55927632_runts
rust45544912_rust
rusts55026992_rusts
rut35560522_rut_
ruth76825992_ruth
ruths85714642_ruths
scuts74522522scuts
shuts85622472shuts
sluts54523982sluts
smuts75415712smuts
struts65616802struts
tauts56125512tauts
touts54830392touts
trets55928022trets
trots56629942trots
trouts66116622trouts
trues54925322trues
trugs65516802trugs
truss54916922truss
trust55426852trust
trusts64714432trusts
truth85214152truth
truths9449502truths
tuts45838452_tuts
urus46426132uru_s
uts35534372__uts
writs86624382writs
yurts87216532yurts

Search took 6 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.186960704.3
2DLD Change Limit538002114.98610790.2
3Display Results2112110.1401507.1
 (SQL Overall)1786912115.31233639.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.