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

342 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
sand5533846(None) 
and47244161_and
band76740901band
hand86833701hand
land56337301land
rand55839561rand
sad47459201sa_d
said55742111said
sands65228581sands
sandy94221131sandy
sane45954331sane
saned65636271saned
sang55441221sang
sank85236821sank
sans45153351sans
sard55344241sard
send55237291send
stand65923281stand
wand85833871wand
ad311975032_a_d
add510132362_add
aid49269072_aid
aland65526412aland
an211879072_an_
ana39559822_ana
ands57833612_ands
ane37866942_ane
ani37751172_ani
ant37270782_ant
any68440482_any
asana5315482asana
bad67763152ba_d
bald76432902bald
ban58366832ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250422bane
baned85436352baned
bang74836992bang
bani65334952bani
bank105835742bank
bans66555132bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bind76234502bind
bland85320452bland
bond75334362bond
brand85124492brand
bund75530662bund
cad67456362ca_d
caid77837532caid
can57760132can_
candy115119822candy
cane66653112cane
caned85838092caned
canid85526342canid
cans65050842cans
cant66362022cant
card710245872card
dad58456162da_d
dan46859662dan_
dandy104416702dandy
dang65131532dang
dank95828232dank
dans56748142dans
desand84812632desand
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
island738532island
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
rind56535602rind
rynd86414102rynd
sab56563202sa_b
sabe66140572sabe
sabed86526812sabed
sabs66643742sabs
sac57452862sa_c
sack105337312sack
sacs65739072sacs
sade55544472sade
sadi55834642sadi
sae38365182sa_e
safe75930952safe
sag46163402sa_g
saga55331172saga
sage55044592sage
sago56332672sago
sags55948402sags
sagy85327082sagy
saids65328852saids
sail45447162sail
sain45551292sain
sained75424242sained
sains55639972sains
saint55147072saint
sake85244962sake
saki85628472saki
sal36462882sa_l
salad65321832salad
sale44959702sale
sall44544682sall
salp64534092salp
sals46851672sals
salt45758522salt
same65245642same
samp85733592samp
sandal73317282sandal
sanded84920612sanded
sander74828532sander
sandhi1038192sandhi
saner54334322saner
sanes55649072sanes
sanga66023792sanga
sangh95517452sangh
santo56227282santo
sap56463232sa_p
sapid84720932sapid
saps65346372saps
sards64736182sards
sari45444042sari
sark84938972sark
sarod65325872sarod
sash77235302sash
sass45035622sass
sat36288482sa_t
sate45556102sate
sated66238532sated
sati45539322sati
sau36356572sa_u
saul45836522saul
sauna54117552sauna
save75741362save
saved95127112saved
saw68255352sa_w
sawed95628402sawed
sawn75428162sawn
saws75839482saws
sax107447642sa_x
say67264762sa_y
sayed96127142sayed
sayid95516722sayid
says75942102says
scad75725762scad
scald84818122scald
scan65530452scan_
scans74625102scans
scant79735072scant
scend85516292scend
scud76221282scud
seed55549482seed
sen36058522sen_
sends65528242sends
sene46848052sene
sent46963012sent
shad86230912shad
shandy134710032shandy
shank125422192shank
shard96125962shard
shed86536152shed
shend94719972shend
shod86225052shod
sild55030582sild
sin36265892sin_
sine46560622sine
sing57544172sing
sinh76238042sinh
sink86640142sink
sins46755272sins
skald104210172skald
skank84415582skank
skid95720912skid
slang66324022slang
slank95822772slank
slant55238702slant
sled55334372sled
slid55828982slid
snag55827872snag
snap65727032snap
snaw78923072snaw
sned56026052sned
sod46053702s_od
soland75115042soland
sold54837412sold
son37761952son_
sonde64622832sonde
sone46649982sone
song55133672song
sons46049552sons
sord56237202sord
sound64420022sound
spaed85522272spaed
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
sped76031492sped
spend85619332spend
spud75818492spud
staid66722072staid
stands75118052stands
stane55933002stane
staned74824642staned
stang66424682stang
stank95823302stank
strand74514822strand
stud56220092stud
sudd64719772sudd
sued56537932sued
sun37149032sun_
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
surd56433812surd
swan76631312swan_
swang95519722swang
swank125318232swank
swans84625012swans
sward94221462sward
syn67024122syn_
sync95415102sync
syne75725762syne
synod9610282synod
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.0632836365.1
2DLD Change Limit298723421.00029872.0
3Display Results3423420.0764500.0
 (SQL Overall)1786913421.139156884.1
 
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.