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
sand5533847(None) 
and47244171_and
band76740911band
hand86833711hand
land56337311land
rand55839571rand
sad47459201sa_d
said55742111said
sands65228581sands
sandy94221131sandy
sane45954341sane
saned65636271saned
sang55441231sang
sank85236831sank
sans45153361sans
sard55344241sard
send55237291send
stand65923281stand
wand85833881wand
ad311975032_a_d
add510132362_add
aid49269072_aid
aland65526412aland
an211879082_an_
ana39559832_ana
ands57833612_ands
ane37866952_ane
ani37751182_ani
ant37270792_ant
any68440492_any
asana5315482asana
bad67763152ba_d
bald76432902bald
ban58366842ban_
banda85223102banda
bands85233422bands
bandy114824182bandy
bane65250432bane
baned85436352baned
bang74837002bang
bani65334962bani
bank105835752bank
bans66555142bans
bard75648862bard
baud74928422baud
bawd105520842bawd
bend76435262bend
bind76234512bind
bland85320452bland
bond75334362bond
brand85124492brand
bund75530662bund
cad67456362ca_d
caid77837532caid
can57760142can_
candy115119822candy
cane66653122cane
caned85838092caned
canid85526342canid
cans65050852cans
cant66362032cant
card710245872card
dad58456162da_d
dan46859672dan_
dandy104416702dandy
dang65131542dang
dank95828242dank
dans56748152dans
desand84812632desand
eland65820392eland
end46834352_end
fad77452412fa_d
fan67158862fan_
fane75343572fane
fang85432552fang
fano75831692fano
fans76247372fans
fard85639062fard
fend84832972fend
find87532602find
fond86330952fond
fund85624982fund
gad57556652ga_d
gaed66031512gaed
gan48060132gan_
gane55145302gane
gang66031972gang
gaud67025432gaud
gland75217712gland
grand75122692grand
had77658762ha_d
haed86338582haed
hands95327382hands
handy125520872handy
hang85535552hang
hank115134142hank
hant75461592hant
hard85443502hard
hind85529752hind
island738532island
jane115031482jane
kana85928532kana
kane85133972kane
kind96128552kind
lad48165702la_d
laid56439142laid
lands65426902lands
lane45153332lane
lang56637382lang
lank84734452lank
lard56742002lard
laud56527722laud
lend56233672lend
mad68958712ma_d
maid75537662maid
man57465872man_
mana65341962mana
mane65052032mane
maned86634102maned
mano66536812mano
mans66354552mans
many95731862many
maud75325402maud
maund85515452maund
mend75334032mend
mind75434382mind
nan37854882nan_
nana46632902nana
nans46139402nans
nard56634452nard
pad68057322pa_d
paid75737482paid
pan58466452pan_
panda85022612panda
pandy115021172pandy
pane64950292pane
paned85437182paned
pang75336292pang
pans65855732pans
pant66061262pant
pard76441322pard
pend75934532pend
pond75530492pond
qaid146023842qaid
rad47662002ra_d
raid55243072raid
ran38266622ran_
rands65930452rands
randy95022082randy
rang56939162rang
rani46640112rani
ranid66429332ranid
rank85135532rank
rant45864682rant
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
saki85628482saki
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
sati45539332sati
sau36356572sa_u
saul45836522saul
sauna54117552sauna
save75741362save
saved95127112saved
saw68255352sa_w
sawed95628402sawed
sawn75428162sawn
saws75839482saws
sax107447642sa_x
say67264762sa_y
sayed96127142sayed
sayid95516722sayid
says75942102says
scad75725772scad
scald84818122scald
scan65530452scan_
scans74625102scans
scant79735072scant
scend85516292scend
scud76221282scud
seed55549482seed
sen36058522sen_
sends65528242sends
sene46848052sene
sent46963012sent
shad86230912shad
shandy134710032shandy
shank125422192shank
shard96125962shard
shed86536152shed
shend94719972shend
shod86225062shod
sild55030582sild
sin36265892sin_
sine46560622sine
sing57544172sing
sinh76238042sinh
sink86640142sink
sins46755272sins
skald104210172skald
skank84415582skank
skid95720922skid
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
staid66722082staid
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
tan37167572tan_
tang56138672tang
tank85134022tank
tans46154822tans
tend56433772tend
van66246332van_
vanda94515922vanda
vane75534692vane
vaned94622422vaned
vang84926042vang
vans76236732vans
vend86626422vend
viand9511072viand
wad77053892wa_d
wan66761942wan_
wands96425482wands
wane76344722wane
waned95831782waned
wank115632512wank
wans76452272wans
want76156172want
wany106432362wany
ward86542252ward
wend85330452wend
wind85533852wind
wynd116114462wynd
yald86920612yald
yang85626072yang
yank115423672yank
yard85633252yard
yaud87020082yaud
yond86122312yond
zany167316992zany

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.266671770.7
2DLD Change Limit298723420.79637527.6
3Display Results3423420.0764500.0
 (SQL Overall)1786913421.138157022.0
 
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.