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

218 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
butt6514374(None) 
batt65053871batt
bitt65545821bitt
bott66548571bott
bunt65850851bunt
bust65947781bust
but55963021bu_t
bute66739671bute
buts67247691buts
butte74924291butte
butts75824251butts
butty104020111butty
butut75522911butut
mutt65739401mutt
putt66937841putt
abut66834952abu_t
abuts75417072abuts
att35454652_att
aunt46553652aunt
auto47432082auto
baht96740012baht
bait66556002bait
bast66362412bast
bat510988952b_at
bate66552422bate
bath95940082bath
bats66962332bats
batts76727562batts
battu75216612battu
batty105422242batty
beat66168302beat
beet66457542beet
belt65754032belt
bent67759912bent
best66355322best
bet58376672b_et
beta66234132beta
beth96629232beth
bets67051442bets
betta74916842betta
bhut95425712bhut
bhuts105812952bhuts
bint67355052bint
bit57070912b_it
bite66547012bite
bits66148172bits
bitts75022592bitts
bitty106119172bitty
blat66550952blat
blet66247672blet
blot65842322blot
bluet75631192bluet
blunt75525022blunt
blurt77625622blurt
boat66360312boat
bolt66254172bolt
boot67759372boot
bort65960962bort
bot59680402b_ot
bota66236502bota
both96533432both
bots66453952bots
botts75224862botts
bout66353292bout
bouts75131312bouts
brat66055542brat
brit66350152brit
britt75732232britt
bruit76126722bruit
brunt75728752brunt
brut66537962brut
brute75321782brute
bruts75922952bruts
bub76343982bu_b
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
buck125129902buck
bud67041282bu_d
buds75235182buds
buff125229862buff
bug65340742bu_g
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
built74325922built
bulb85626692bulb
bulk105426152bulk
bull65634872bull
bum75342692bu_m
bumf116126512bumf
bump106228242bump
bums85934592bums
bun56348142bu_n
buna64730722buna
bund75530662bund
bundt85824852bundt
bung75730632bung
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunts75729802bunts
buoy95921782buoy
bur55744692bu_r
bura66139532bura
burb85334672burb
burd75534262burd
buret77444012buret
burg74930362burg
burl64937182burl
burn65636432burn
burnt75230332burnt
burp85028882burp
burr65631232burr
burs65847422burs
burst75332242burst
bury95633592bury
bus56950972bu_s
bush96630712bush
busk105429222busk
buss65134912buss
busts75227692busts
busty105621012busty
busy94727172busy
butch125416542butch
buteo75419892buteo
butes714535872butes
butle75023102butle
butted94722062butted
butter84724232butter
buttes84822562buttes
button8310272button
bututs8409422bututs
butyl1089102butyl
buy86436542bu_y
buys95726792buys
buzz146617802buzz
byte96521812byte
cult66541152cult
cunt66243672cunt
curt67051712curt
cut57957662cu_t
cute66440452cute
cuts65841152cuts
cutty105417222cutty
duct75735462duct
duet56446262duet
duit56241582duit
dunt55746872dunt
dust57142532dust
duty85321452duty
futz167823802futz
gust55240702gust
gut46753852gu_t
guts56637252guts
gutta64613382gutta
gutty94516992gutty
hunt76445492hunt
hurt77142572hurt
hut66457292hu_t
huts76737442huts
just115433342just
jut105944012ju_t
jute115327892jute
juts115930162juts
jutty154914642jutty
lunt46148842lunt
lust47442602lust
lute46341012lute
lutz136826322lutz
matt65752662matt
mitt66145502mitt
mott66648442mott
must65145442must
mut58357182mu_t
mute65136872mute
muts64839982muts
mutts75120252mutts
nett46643232nett
nut36651962nu_t
nuts45032672nuts
nutty84816872nutty
oust46747442oust
out38072152ou_t
outs45746962outs
punt65747202punt
put55759072pu_t
puts65641752puts
putti76018742putti
putto75617662putto
putts75719272putts
putty104721402putty
putz158326322putz
quit136136512quit
runt46647992runt
rust45544912rust
rut35560522ru_t
ruth76825992ruth
ruts44541492ruts
rutty85617802rutty
sett45949052sett
suet46754822suet
suit45649872suit
sutta54015332sutta
tuft76929512tuft
tut36758092tu_t
tuts45838452tuts
tutti54614672tutti
tutty85217022tutty
tutu48423172tutu
ut28647032_u_t
uta37425582_uta
ute35335882_ute
uts35534372_uts
watt75545412watt
yett76434492yett
yurt76435042yurt
yutz167519882yutz

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 Filter178691298720.263679433.5
2DLD Change Limit298722180.78338150.7
3Display Results2182180.0464739.1
 (SQL Overall)1786912181.092163636.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.