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

279 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
sands6522858(None) 
ands57833611_ands
bands85233421bands
hands95327381hands
lands65426901lands
rands65930451rands
saids65328851saids
sand55338461sand_
sandy94221131sandy
sanes55649071sanes
sans45153351san_s
sards64736181sards
sends65528241sends
stands75118051stands
wands96425481wands
adds67622452_adds
ads49755732_a_ds
aids57846352_aids
alands75418372alands
anas46649862_anas
and47244162_and_
anes45255932_anes
anis45746462_anis
ants47243472_ants
anus47131112_anus
asanas6514112asanas
bads77048862ba_ds
balds85524642balds
band76740902band_
banda85223102banda
bandas95120542bandas
bandy114824182bandy
banes74945582banes
bangs85627772bangs
banks115527902banks
banns75321232banns
bans66555132ban_s
bards87139642bards
bauds85821042bauds
bawds116115492bawds
bends85628972bends
binds86627472binds
bonds86126842bonds
brands95118942brands
bunds85523542bunds
cads76144522ca_ds
caids85226422caids
candy115119822candy
canes75350372canes
canids95118132canids
cans65050842can_s
cants77036942cants
cards85137932cards
dads67442772da_ds
dandy104416702dandy
dangs75623202dangs
dans56748142dan_s
desands94810162desands
elands74914772elands
ends56528522_ends
fads86939872fa_ds
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247362fan_s
fards96629842fards
fends96324972fends
finds95424822finds
fonds95824822fonds
funds94119252funds
gads67843382ga_ds
gangs76222572gangs
gauds75717722gauds
glands85314402glands
grands84218242grands
hand86833702hand_
handy125520872handy
hangs95726722hangs
hanks126226862hanks
hants86335402hants
hards96435652hards
hinds96721472hinds
islands837322islands
janes124928122janes
kanas95326912kanas
kanes95529372kanes
kinds106221812kinds
lads56549132la_ds
land56337302land_
lanes54946792lanes
lards65331862lards
lauds65618482lauds
lends65326252lends
mads76845362ma_ds
maids86327132maids
manas76240422manas
manes76648952manes
manos74933612manos
mans66354532man_s
manus75924922manus
mauds85519272mauds
maunds9519652maunds
mends84927692mends
minds85427122minds
nanas55928632nanas
nans46139392nan_s
nards65928462nards
pads76742952pa_ds
panda85022612panda
pandas95521962pandas
pandy115021172pandy
panes76148692panes
pangs84628662pangs
pans65855722pan_s
pants76536922pants
pards85634332pards
pends85527192pends
ponds85323402ponds
qaids156116312qaids
rads56046602ra_ds
raids65827512raids
rand55839562rand_
randy95022082randy
ranids75118702ranids
ranis55235832ranis
ranks95225732ranks
rants55935342rants
rends65129952rends
rinds64826142rinds
rynds9569972rynds
sabes76437462sabes
sabs66643742sa_bs
sacks114228872sacks
sacs65739072sa_cs
sad47459202sa_d_
sade55544472sa_de
sades65239892sades
sadi55834642sa_di
sadis64930852sadis
safes85226722safes
sagas66025882sagas
sages65339062sages
sagos66123872sagos
sags55948402sa_gs
said55742112said_
sails55738102sails
sains55639972sains
saints65122422saints
sakes95540752sakes
sakis95323662sakis
salads75316962salads
sales56055592sales
salps74423242salps
sals46851672sa_ls
salts55431882salts
samps96124672samps
sandal73317282sandal
sandals82715202sandals
sanded84920612sanded
sander74828532sander
sanders84025942sanders
sandhi1038192sandhi
sandhis1139992sandhis
sane45954332san_e
saned65636272saned
saner54334322saner
sanest64426692sanest
sang55441222san_g
sanga66023792sanga
sangas75222652sangas
sangh95517452sangh
sanghs105312062sanghs
sanies63031952sanies
sank85236822san_k
santo56227282santo
santos64421832santos
saps65346372sa_ps
sard55344242sard_
saris54544952saris
sarks96632462sarks
sarods74918572sarods
saros55238062saros
sass45035622sa_ss
sates54949322sates
satis55633672satis
sauls55128122sauls
saunas63915432saunas
saves85838632saves
saws75839482sa_ws
saxes125229342saxes
sayeds10469252sayeds
sayids104310972sayids
says75942102sa_ys
scads85419952scads
scalds94813692scalds
scans74625102scan_s
scants85219722scants
scends95213002scends
scuds85116242scuds
seeds64330062seeds
send55237292send_
shads95124482shads
shandy134710032shandy
shanks135315582shanks
shards104319172shards
sheds96122702sheds
shends105313772shends
silds65520522silds
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272sin_s
sinus55523852sinus
skalds11437832skalds
skanks94710832skanks
skids104615322skids
slangs75615342slangs
slants64819082slants
sleds64418852sleds
snags64421312snags
snaps74719562snaps
snaws86116362snaws
sneds65715352sneds
sods54940212s_ods
solands84412342solands
sonde64622832sonde
sondes74922872sondes
sones55444142sones
songs67725552songs
sons46049552son_s
sords64527802sords
sounds74616182sounds
spanks124514122spanks
spans74528732span_s
spends94714472spends
spuds85113672spuds
stand65923282stand_
stanes64933402stanes
stangs75018162stangs
stanks104917702stanks
strands83711952strands
studs64415872studs
sudds75513592sudds
suds56135292s_uds
sunns55017352sunns
suns45841902sun_s
surds65624662surds
swanks134811562swanks
swans84625012swan_s
swards105415132swards
syncs104610172syncs
synods1077952synods
tads57143942ta_ds
tangs65028342tangs
tanks94624732tanks
tans46154812tan_s
tends65425582tends
vanda94515922vanda
vandas103915992vandas
vanes85130972vanes
vangs96319582vangs
vans76236722van_s
vends95520892vends
viands1047812viands
wads87343142wa_ds
wand85833872wand_
wanes85040882wanes
wanks126124482wanks
wans76452262wan_s
wants87932212wants
wards97734402wards
wends95822812wends
winds95425602winds
wynds126310372wynds
yangs95618692yangs
yanks125316572yanks
yards95324612yards
yauds95013222yauds

Search took 3 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.0931921408.6
2DLD Change Limit538002792.04626295.2
3Display Results2792790.0763671.1
 (SQL Overall)1786912792.21580673.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.