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

123 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
abuts7541707(None) 
abets75621671abets
abut66834951abut_
buts67247691_buts
abas68642082ab_as
abate76627842abate
abates85825032abates
abatis84317932abatis
abbas95918642abbas
abbes96723522abbes
abbots1039282abbots
abducts1265312abducts
abet610547942abet_
ablauts936082ablauts
ables75935542ables
aborts84916182aborts
abos67734412ab_os
about75229082about_
abris75722602abris
abs59356072ab__s
abuse77119562abuse
abuses85119102abuses
abuzz15517212abuzz
abyes105518532abyes
abys97221882ab_ys
abyss10669462abyss
acts66929862a_cts
acute74720362acute
acutes83917722acutes
adits66523712adits
adults7299952adults
adust64117452adust
agues64919052agues
airts55626342airts
aits46355532a_its
albums10198272albums
alts46639902a_lts
alums75720602alums
ambits103713412ambits
amus65529612amu_s
ants47243472a_nts
anus47131112anu_s
aquas142412612aquas
arbute8311042arbute
arbutes939702arbutes
arbutus944842arbutus
arts49650262a_rts
arums75517832arums
auks85525262a_uks
aunts55227632aunts
auto47432082a_uto
autos56523322a_utos
babuls105413642babuls
babus95620332babu_s
bahts105617802bahts
baits76630582baits
barbuts11439842barbuts
basts75936932basts
bats66962332_bats
batts76727562batts
bauds85821042bauds
bets67051442_bets
bhuts105812952bhuts
bits66148162_bits
bots66453952_bots
bouts75131312bouts
bruts75922952bruts
bubs86235502_bubs
buds75235172_buds
bugs76035912_bugs
bums85934592_bums
buns66243722_buns
bunts75729802_bunts
burs65847422_burs
bus56950972_bu_s
buss65134912_buss
bust65947782_bust
busts75227692_busts
but55963022_but_
bute66739672_bute
butes714535872_butes
butt65143742_butt
butts75824252_butts
buys95726792_buys
cuts65841152_cuts
dauts67822242dauts
debuts93911752debuts
gamuts958782gamuts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
habits113014652habits
habus106317142habu_s
hagbuts1354932hagbuts
huts76737442_huts
jabots1538882jabots
juts115930162_juts
louts56330272louts
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
obits74617552obits
outs45746962_outs
phuts104613502phuts
pouts75530322pouts
puts65641752_puts
rabats83116222rabats
rebuts84015192rebuts
routs57133412routs
ruts44541492_ruts
sabots8314702sabots
sacbuts1166472sacbuts
sagbuts1065222sagbuts
scuts74522522scuts
shuts85622482shuts
sluts54523982sluts
smuts75415712smuts
tabuns8489222tabuns
tabus74820922tabu_s
tauts56125512tauts
touts54830392touts
tuts45838452_tuts
uts35534372__uts

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 Limit538001231.57634137.1
3Display Results1231230.0502460.0
 (SQL Overall)1786911231.92292971.4
 
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.