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

317 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
butes71453587(None) 
bates75846341bates
bites75641171bites
brutes86118681brutes
buses75936011buses
bute66739671bute_
buteo75419891buteo
buteos84913411buteos
butles84423911butles
buts67247691but_s
buttes84822561buttes
butts75824251butts
bytes105217491bytes
cutes79438311cutes
jutes125125131jutes
lutes55836661lutes
mutes75033781mutes
utes45930881_utes
abates85825032abates
abuses85119102abuses
abuts75417072abut_s
acutes83917722acutes
antes56334322antes
arbutes939702arbutes
ates45047922_ates
aures55137092aures
autos56523322autos
babes95834112babes
bakes117035372bakes
bales76250082bales
banes74945582banes
bares75457132bares
bases75644352bases
bastes85330382bastes
bate66552422bate_
bated85935532bated
bathes116524832bathes
baths105922922baths
bats66962332bat_s
batts76727562batts
bees65453382b_ees
beets76131442beets
benes75536232benes
bes56557432b__es
beses75830722beses
betas75528762betas
betel74419902betel
betels84515062betels
beths105519222beths
bets67051442bet_s
bhuts105812952bhut_s
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bite66546992bite_
biter75030032biter
biters83925232biters
bits66148152bit_s
bitts75022592bitts
bizes165923662bizes
blets75324942blets
blites84721212blites
blues75127042blues
bluets87215492bluets
blumes105917792blumes
bodes84935102bodes
boites84322702boites
boles75448602boles
bones76446532bones
bores76448252bores
botas75328782botas
botel75121862botel
botels84815802botels
bots66453952bot_s
botts75224862botts
boules84925972boules
bouses84931782bouses
bouts75131312bout_s
boxes145625072boxes
braes75735052braes
brees75632552brees
bries74942152bries
brumes106417072brumes
brute75321782brute_
bruted95113262bruted
bruts75922952brut_s
bruxes154811022bruxes
bubkes144612622bubkes
buboes104513992buboes
bubs86235492bu_bs
bubus95115452bubus
bucks134824292bucks
budges104820122budges
buds75235172bu_ds
buffs135519512buffs
bugles94822442bugles
bugs76035912bu_gs
buhls105111802buhls
buhrs104811242buhrs
bulbs96016932bulbs
bulges95919322bulges
bulks115920612bulks
bulls75629572bulls
bumfs125414052bumfs
bumps115921142bumps
bums85934592bu_ms
bunas75126572bunas
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bu_ns
bunted95219182bunted
bunter85020382bunter
bunters94717112bunters
bunts75729802bunts
buoys104810632buoys
bupkes144811482bupkes
buras74736292buras
burbs95423492burbs
burds84626062burds
buret77444012buret
burets84321262burets
burgs84924092burgs
buries84633272buries
burkes124421312burkes
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bu_rs
burse75527252burse
burses84425512burses
bus56950972bu__s
bused85624492bused
bushes115226112bushes
busies85525262busies
busks115521372busks
buss65134912bu_ss
busses85023382busses
busted95123152busted
buster84726492buster
busters94724122busters
bustles93816322bustles
busts75227692busts
but55963022but__
butanes9312742butanes
butch125416542butch
butches144315362butches
butene8312622butene
butenes9313032butenes
butle75023102butle
butled94818602butled
butler84220032butler
butlers94518052butlers
butt65143742but_t
butte74924292butte
butted94722062butted
butter84724232butter
butters94521712butters
butties93217952butties
butty104020112butty
butut75522912butut
bututs8409422bututs
butyl1089102butyl
butyls1176752butyls
buyer105013092buyer
buyers114511002buyers
buys95726792bu_ys
buzzes165011172buzzes
byes95230532b_yes
byres104421382byres
byte96521812byte_
cates75951872cates
cetes75731102cetes
chutes114615762chutes
cites74435582cites
cotes76347842cotes
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cures75645432cures
cute66440452cute_
cuter74728222cuter
cutest85820142cutest
cutesy114810732cutesy
cutey105819792cutey
cuteys11569972cuteys
cuties84927362cuties
cutis77723752cutis
cuts65841152cut_s
dates65639152dates
dites66339152dites
dotes65836692dotes
duces86327472duces
dudes75424372dudes
dues56045502du_es
duets65323882duets
dukes105023472dukes
dunes65332172dunes
dupes86425932dupes
dures65635922dures
duties74921902duties
elutes64020312elutes
fates85139232fates
fetes85630142fetes
flutes95421782flutes
fumes105224702fumes
fuses85628422fuses
futzes184313112futzes
fuzes175120222fuzes
gates65939502gates
gites65630182gites
glutes74517672glutes
gudes74520812gudes
gules64831042gules
guts56637252gut_s
hates86742572hates
hues75235232hu_es
huts76737442hut_s
jetes124922842jetes
jubes145420742jubes
jukes165319102jukes
jupes145218552jupes
jute115327892jute_
juts115930162jut_s
kites95432542kites
kues86426772ku_es
kytes125012912kytes
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunes55337772lunes
lures56138532lures
lute46341012lute_
lutea54819072lutea
luted64826142luted
lutzes153711922lutzes
luxes124921502luxes
mates75251362mates
metes74736212metes
mites75141802mites
motes75944002motes
mules75034292mules
mures75937212mures
muses75134302muses
mute65136872mute_
muted85023382muted
muter74525542muter
mutest84218052mutest
muts64839982mut_s
mutts75120252mutts
nates55238332nates
nites55736342nites
notes55034582notes
nudes64723292nudes
nukes95418122nukes
nuts45032672nut_s
outed65429062outed
outer55633302outer
outers64230162outers
outs45746962out_s
pates76047892pates
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
puses75532202puses
puts65641752put_s
putts75719272putts
putzes174212522putzes
quotes153312462quotes
rates55352012rates
rites54442552rites
rotes56143902rotes
routes66129312routes
rubes74928412rubes
rues46044482ru_es
rules55234252rules
runes55530222runes
ruses56136582ruses
ruths85714642ruths
ruts44541492rut_s
sates54949322sates
sautes63924912sautes
scutes85219192scutes
shutes93518212shutes
sites56045432sites
sues46247652su_es
suets55126102suets
suites63727402suites
supes75628302supes
tates55444982tates
totes55139682totes
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tutee5423522tutee
tutees6514552tutees
tuts45838452tut_s
tutus55214812tutus
tuxes124316042tuxes
ukes86122812_ukes
uses44931112_uses
utas45924952_utas
ute35335882_ute_
uts35534372_ut_s
votes84627082votes
wites85536962wites
wytes114113432wytes
yules84521582yules
yutzes18408412yutzes

Search took 4 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.1731032896.0
2DLD Change Limit538003172.82619037.5
3Display Results3173170.1562032.1
 (SQL Overall)1786913173.15556637.4
 
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.