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

335 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
band7674090(None) 
and47244161_and
bad67763151ba_d
bald76432901bald
ban58366831ban_
banda85223101banda
bands85233421bands
bandy114824181bandy
bane65250421bane
baned85436351baned
bang74836991bang
bani65334951bani
bank105835741bank
bans66555131bans
bard75648861bard
baud74928421baud
bawd105520841bawd
bend76435261bend
bind76234501bind
bland85320451bland
bond75334361bond
brand85124491brand
bund75530661bund
hand86833701hand
land56337301land
rand55839561rand
sand55338461sand
wand85833871wand
abed79734132abed
ad311975032_a_d
add510132362_add
aid49269072_aid
aland65526412aland
an211879072_an_
ana39559822_ana
ands57833612_ands
ane37866942_ane
ani37751172_ani
ant37270782_ant
any68440482_any
ba49962342ba__
baa510650422ba_a
baaed85218162baaed
baal67033112baal
baas66844672baas
baba88828342baba
babe86835812babe
babu85829222babu
baby116723672baby
bach116131392bach
back125535762back
baddy125016022baddy
bade75140882bade
bads77048862bads
baff124632262baff
bag67059222ba_g
bags76645502bags
bah87755352ba_h
baht96740012baht
bail65042802bail
bait66556002bait
bake105637512bake
baked126130772baked
bal56662722ba_l
balds85524642balds
baldy115518932baldy
bale66353842bale
baled85436442baled
balk105132222balk
ball66043322ball
balm85534202balm
bals66354042bals
bam78560142ba_m
bams87044452bams
banal75925992banal
banco94019392banco
bandas95120542bandas
banded105223172banded
bander93928222bander
bandit93821132bandit
bandog1038722bandog
banes74945582banes
banged104923722banged
bangs85627772bangs
banjo143812442banjo
banked135021442banked
banks115527902banks
banned94721342banned
banns75321232banns
banty106624002banty
bap76455842ba_p
baps86040842baps
bar58070552ba_r
barb85240062barb
barde85330772barde
bards87139642bards
bare65460522bare
bared85144482bared
barf95844402barf
bark106242152bark
barm86739602barm
barn66444642barn
barned95623582barned
barns76335142barns
barny105821732barny
bars66564092bars
bas58681752ba_s
base64847022base
based85331582based
bash915240162bash
bask105131422bask
bass66146782bass
bast66362412bast
bat510988952ba_t
bate66552422bate
bated85935532bated
bath95940082bath
bats66962332bats
batt65053872batt
bauds85821042bauds
bawds116115492bawds
bawdy147513282bawdy
bawl95326062bawl
bay89661642ba_y
bayed115423022bayed
bays97143912bays
bead75937922bead
bean66443862bean_
beaned95621472beaned
beano75421552beano
beans75734692beans
beard86024962beard
bed67950622b_ed
ben56554922ben_
bends85628972bends
bendy115017252bendy
bene66439492bene
bens65945702bens
bent67759912bent
bhang115512922bhang
bid67751782b_id
bin56658632bin_
bindi85617012bindi
binds86627472binds
bine66650852bine
bins66548242bins
bint67355032bint
bird76128312bird
blank115418552blank
bled75729312bled
blend85317452blend
blind86319322blind
blond85618372blond
board85523002board
bod67055542b_od
bold75432812bold
bonds86126842bonds
bone65949322bone
boned85133242boned
bong75633412bong
bonk105531712bonk
bony96732082bony
bound84819582bound
brad75234342brad
braid85822262braid
bran65740382bran_
brands95118942brands
brandy124712062brandy
brank115222282brank
brans75437432brans
brant74742172brant
bred75130972bred
bud67041272b_ud
bun56348142bun_
buna64730722buna
bunds85523542bunds
bundt85824852bundt
bung75730632bung
bunk105731352bunk
bunn65023652bunn
buns66243722buns
bunt65850852bunt
burd75534262burd
bwana10310242bwana
cad67456362ca_d
caid77837532caid
can57760132can_
candy115119822candy
cane66653112cane
caned85838092caned
canid85526342canid
cans65050842cans
cant66362022cant
card710245872card
dad58456162da_d
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
eland65820392eland
end46834352_end
fad77452412fa_d
fan67158852fan_
fane75343562fane
fang85432542fang
fano75831682fano
fans76247362fans
fard85639062fard
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060122gan_
gane55145292gane
gang66031962gang
gaud67025432gaud
gland75217712gland
grand75122692grand
had77658762ha_d
haed86338582haed
hands95327382hands
handy125520872handy
hang85535542hang
hank115134132hank
hant75461582hant
hard85443502hard
hind85529752hind
jane115031472jane
kana85928522kana
kane85133962kane
kind96128552kind
lad48165702la_d
laid56439142laid
lands65426902lands
lane45153322lane
lang56637372lang
lank84734442lank
lard56742002lard
laud56527722laud
lend56233672lend
mad68958702ma_d
maid75537632maid
man57465852man_
mana65341942mana
mane65052012mane
maned86634092maned
mano66536792mano
mans66354532mans
many95731842many
maud75325392maud
maund85515442maund
mend75334022mend
mind75434362mind
nan37854872nan_
nana46632892nana
nans46139392nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466442pan_
panda85022612panda
pandy115021172pandy
pane64950282pane
paned85437182paned
pang75336282pang
pans65855722pans
pant66061252pant
pard76441322pard
pend75934532pend
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266612ran_
rands65930452rands
randy95022082randy
rang56939152rang
rani46640102rani
ranid66429332ranid
rank85135522rank
rant45864672rant
rend56136572rend
riband9239622riband
rind56535602rind
roband92310722roband
rynd86414102rynd
sad47459202sa_d
said55742112said
sands65228582sands
sandy94221132sandy
sane45954332sane
saned65636272saned
sang55441222sang
sank85236822sank
sans45153352sans
sard55344242sard
send55237292send
stand65923282stand
tad47959822ta_d
tan37167562tan_
tang56138662tang
tank85134012tank
tans46154812tans
tend56433772tend
van66246322van_
vanda94515922vanda
vane75534682vane
vaned94622422vaned
vang84926032vang
vans76236722vans
vend86626422vend
viand9511072viand
wad77053892wa_d
wan66761932wan_
wands96425482wands
wane76344712wane
waned95831782waned
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
ward86542252ward
wend85330452wend
wind85533852wind
wynd116114462wynd
yald86920602yald
yang85626062yang
yank115423662yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316982zany

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 Limit298723351.14326134.7
3Display Results3353350.0764407.9
 (SQL Overall)1786913351.295137985.3
 
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.