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

190 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
butts7582425(None) 
batts76727561batts
bitts75022591bitts
botts75224861botts
bunts75729801bunts
busts75227691busts
butes714535871butes
buts67247691bu_ts
butt65143741butt_
butte74924291butte
buttes84822561buttes
butty104020111butty
bututs8409421bututs
mutts75120251mutts
putts75719271putts
abuts75417072abu_ts
aunts55227632aunts
autos56523322autos
bahts105617802bahts
baits76630582baits
basts75936932basts
bates75846342bates
baths105922922baths
bats66962332b_ats
batt65053872batt_
battu75216612battu
batty105422242batty
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
betas75528762betas
beths105519222beths
bets67051442b_ets
betta74916842betta
bettas84913922bettas
bhuts105812952bhuts
bints76130182bints
bites75641172bites
bits66148162b_its
bitt65545812bitt_
bitty106119172bitty
blats75132502blats
blets75324942blets
blots75626172blots
bluets87215492bluets
blunts84512892blunts
blurts84412642blurts
boats75635152boats
bolts76232112bolts
boots75837972boots
borts76735452borts
botas75328782botas
bots66453952b_ots
bott66548572bott_
bouts75131312bouts
brats75336012brats
brits76433082brits
britts84813442britts
bruits85714452bruits
brunts85215452brunts
brutes86118682brutes
bruts75922952bruts
bubs86235502bu_bs
bubus95115452bubus
bucks134824292bucks
buds75235172bu_ds
buffs135519512buffs
bugs76035912bu_gs
buhls105111802buhls
buhrs104811242buhrs
bulbs96016932bulbs
bulks115920612bulks
bulls75629572bulls
bumfs125414052bumfs
bumps115921142bumps
bums85934592bu_ms
bunas75126572bunas
bunds85523542bunds
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bu_ns
bunt65850852bunt_
buoys104810632buoys
buras74736302buras
burbs95423492burbs
burds84626062burds
burets84321262burets
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bu_rs
burst75332242burst
bursts85116242bursts
bus56950972bu__s
buses75936012buses
busks115521372busks
buss65134912bu_ss
bust65947782bust_
busty105621012busty
but55963022bu_t_
butch125416542butch
bute66739672bu_te
buteo75419892buteo
buteos84913412buteos
butle75023102butle
butles84423912butles
buttals938502buttals
butted94722062butted
butter84724232butter
butters94521722butters
butties93217952butties
button8310272button
buttons9310332buttons
butut75522912butut
butyl1089102butyl
butyls1176752butyls
buys95726792bu_ys
bytes105217492bytes
cults75022552cults
cunts76125122cunts
cutes79438322cutes
cutis77723762cutis
cuts65841152cu_ts
cutty105417222cutty
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
gusts65722792gusts
guts56637252gu_ts
gutta64613382gutta
gutty94516992gutty
hunts86826172hunts
hurts86922822hurts
huts76737442hu_ts
justs124918262justs
jutes125125132jutes
juts115930162ju_ts
jutty154914642jutty
lunts55826902lunts
lusts55022802lusts
lutes55836662lutes
matts76829182matts
mitts75523752mitts
motts76527002motts
musts75527442musts
mutes75033782mutes
muts64839982mu_ts
mutt65739402mutt_
netts55320722netts
nuts45032672nu_ts
nutty84816872nutty
ousts55225702ousts
outs45746962ou_ts
punts75828002punts
puts65641752pu_ts
putt66937842putt_
putti76018742putti
putto75617662putto
putty104721402putty
quits144122352quits
runts55927632runts
rusts55026992rusts
ruths85714642ruths
ruts44541492ru_ts
rutty85617802rutty
setts55124322setts
suets55126102suets
suits55028052suits
sutta54015332sutta
suttas63813792suttas
tufts85713272tufts
tuts45838452tu_ts
tutti54614672tutti
tuttis63611372tuttis
tutty85217022tutty
tutus55214812tutus
utas45924952_utas
utes45930882_utes
uts35534372_u_ts
watts86923092watts
yetts86715132yetts
yurts87216532yurts

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 Limit538001901.37639098.8
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.718104011.1
 
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.