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

328 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
bute6673967(None) 
bate66552421bate
bite66547001bite
brute75321781brute
but55963021but_
buteo75419891buteo
butes714535871butes
butle75023101butle
buts67247691buts
butt65143741butt
butte74924291butte
byte96521811byte
cute66440451cute
jute115327891jute
lute46341011lute
mute65136871mute
ute35335881_ute
abate76627842abate
abuse77119562abuse
abut66834952abut_
abuts75417072abuts
acute74720362acute
ante46538902ante
arbute8311042arbute
ate37059242_ate
auto47432082auto
babe86835822babe
bade75140882bade
bake105637512bake
bale66353842bale
bane65250432bane
bare65460522bare
base64847022base
baste74829982baste
bat510988952bat_
bated85935532bated
bates75846342bates
bath95940082bath
bathe105822882bathe
bats66962332bats
batt65053872batt
be47948942b__e
bee56262402b_ee
beet66457542beet
bene66439492bene
bet58376672bet_
beta66234132beta
betel74419902betel
beth96629232beth
bets67051442bets
bhut95425712bhut_
bhuts105812952bhuts
bice86235562bice
bide76041482bide
bike106532602bike
bile66147182bile
bine66650862bine
bise66437102bise
bit57070902bit_
biter75030032biter
bites75641172bites
bits66148162bits
bitt65545812bitt
bize155926292bize
blae66134642blae
blate75933782blate
blet66247672blet
blite76225352blite
blue65328462blue
bluet75631192bluet
blume95619892blume
bode75838752bode
boite74426322boite
bole66448692bole
bone65949322bone
bore66051332bore
bot59680402bot_
bota66236502bota
botel75121862botel
both96533432both
bots66453952bots
bott66548572bott
boule74828042boule
bouse75931852bouse
bout66353292bout_
bouts75131312bouts
brae65639112brae
bree67241262bree
brie65837902brie
brume95817982brume
brut66537962brut_
bruted95113262bruted
brutes86118682brutes
bruts75922952bruts
bub76343982bu_b
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
buck125129902buck
bud67041272bu_d
budge94619872budge
buds75235172buds
buff125229862buff
bug65340742bu_g
bugle84721942bugle
bugs76035912bugs
buhl95518222buhl
buhr95315382buhr
bulb85626692bulb
bulge86419872bulge
bulk105426152bulk
bull65634872bull
bum75342692bu_m
bumf116126512bumf
bump106228242bump
bums85934592bums
bun56348142bu_n
buna64730722buna
bund75530662bund
bung75730632bung
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunt65850852bunt
bunted95219182bunted
bunter85020382bunter
bunts75729802bunts
buoy95921782buoy
bur55744692bu_r
bura66139532bura
burb85334672burb
burd75534262burd
buret77444012buret
burg74930362burg
burke115122762burke
burl64937182burl
burn65636422burn
burp85028882burp
burr65631232burr
burs65847422burs
burse75527252burse
bury95633592bury
bus56950972bu_s
bused85624492bused
buses75936012buses
bush96630712bush
busk105429222busk
buss65134912buss
bust65947782bust
busted95123152busted
buster84726492buster
bustle84015482bustle
busts75227692busts
busty105621012busty
busy94727172busy
butane8313652butane
butch125416542butch
butene8312622butene
buteos84913412buteos
butled94818602butled
butler84220032butler
butles84423912butles
butted94722062butted
butter84724232butter
buttes84822562buttes
butts75824252butts
butty104020112butty
butut75522912butut
butyl1089102butyl
buy86436542bu_y
buyer105013092buyer
buys95726792buys
buzz146617802buzz
bye86134592b_ye
byre95023852byre
bytes105217492bytes
cate66254602cate
cete64934782cete
chute104316462chute
cite65640342cite
cote66648732cote
cube85830212cube
cue57544182cu_e
cuke105824982cuke
cure66149122cure
cut57957662cut_
cuter74728232cuter
cutes79438322cutes
cutey105819792cutey
cutie76925932cutie
cuts65841152cuts
date56443322date
dite55547552dite
dote55442882dote
duce76933502duce
dude65629662dude
due45249862du_e
duet56446262duet
duke95628102duke
dune56137582dune
dupe76630602dupe
dure56341812dure
duty85321452duty
elute54822572elute
fate75444282fate
fete75734922fete
flute86823752flute
fume96727632fume
fuse76429992fuse
futz167823802futz
fuze166422372fuze
gate55746572gate
gite55438612gite
glute66020902glute
gude65423332gude
gut46753852gut_
guts56637252guts
hate78450172hate
haute89521612haute
hue66642302hu_e
huge86321652huge
hut66457292hut_
huts76737442huts
hyte109018942hyte
jete115927252jete
jube136322782jube
juke154721662juke
jupe134921002jupe
jut105944012jut_
jutes125125132jutes
juts115930162juts
kite85338232kite
kue76631862ku_e
kune85424572kune
kyte117017762kyte
late47560482late
lite47054542lite
lube64731562lube
luce65132572luce
lude55331642lude
luge55531642luge
lune47140492lune
lure45142462lure
lutea54819072lutea
luted64826142luted
lutes55836662lutes
lutz136826322lutz
luxe115222692luxe
mate65154222mate
mete64438132mete
mite66249412mite
mote67048082mote
mule65236972mule
mure65941332mure
muse67136032muse
mut58357182mut_
muted85023382muted
muter74525542muter
mutes75033782mutes
muts64839982muts
mutt65739402mutt
nite45943582nite
note46239962note
nude56626272nude
nuke85920752nuke
nut36651962nut_
nuts45032672nuts
out38072152out_
outed65429062outed
outer55633302outer
outre53922202outre
outs45746962outs
pate65350462pate
puce85127882puce
puke105025462puke
pule65040952pule
pure65543332pure
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
quate144521412quate
quite144621462quite
quote143714772quote
rate45458762rate
rete44944132rete
rite45849452rite
rote46249022rote
route55132072route
rube65532012rube
rude55632782rude
rue35549262ru_e
rule49938422rule
rune45236292rune
ruse45938932ruse
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
sate45556102sate
saute55028082saute
scute75520942scute
shute84520352shute
site47052412site
sue35651462su_e
suet46754822suet
suite54829562suite
supe65932762supe
sure45447412sure
tate44748602tate
tote46643672tote
tube65828662tube
tule45735872tule
tune45635862tune
tut36758092tut_
tutee5423522tutee
tuts45838452tuts
tutu48423172tutu
uke75727292_uke
use36835162_use
ut28647032_ut_
uta37425582_uta
utes45930882_utes
uts35534372_uts
vote74728622vote
wite75443272wite
wyte106018642wyte
yule75725142yule
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.0762351197.4
2DLD Change Limit298723281.76616915.1
3Display Results3283280.0764315.8
 (SQL Overall)1786913281.91893165.3
 
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.