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

215 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
silds6552053(None) 
gilds75417531gilds
milds86422061milds
sild55030591sild_
silks94620681silks
sills55135991sills
silos56029431silos
silts55330821silts
wilds94818211wilds
aids57846372ai_ds
ails45654722ail_s
balds85524642balds
bids75838462bi_ds
bields94110002bields
biles75542142biles
bilks115117892bilks
bills75632862bills
binds86627482binds
birds85421342birds
bolds85825282bolds
builds9378492builds
colds85726972colds
dildo71911782dildo
dildos8179302dildos
dills65530972dills
elds56324862_elds
fids87034752fi_ds
fields104211042fields
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838702fil_s
finds95424832finds
folds95221692folds
gelds75118342gelds
gids65933752gi_ds
gild65526522gild_
gills64728192gills
gilts64924262gilts
girds74817002girds
golds75421312golds
guilds8388352guilds
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hinds96721482hinds
holds94623242holds
ids47535482_i_ds
ilks87218572_ilks
ills47030422_ills
isles54220562isles
jills125122822jills
jilts124717412jilts
kids96029652ki_ds
kills94526182kills
kilns95112992kilns
kilos95021482kilos
kilts95122192kilts
kinds106221832kinds
lids56336472li_ds
lilos55821872lilos
lilts55822802lilts
melds84822382melds
mids76541802mi_ds
mild75330862mild_
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045342mil_s
milts75430712milts
minds85427132minds
molds85324832molds
nills54926672nills
nils46132462nil_s
oils46337982oil_s
olds55926582_olds
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
rids56539562ri_ds
riles55343642riles
rills55032712rills
rinds64826152rinds
saids65328862saids
sails55738102sail_s
salads75316962salads
sales56055592sales
salps74423242salps
sals46851672sal_s
salts55431882salts
sands65228582sands
sards64736182sards
scads85419962scads
scalds94813692scalds
scolds95011232scolds
scuds85116242scuds
seeds64330062seeds
selfs85220242selfs
sells55134432sells
sels46345982sel_s
sends65528242sends
shads95124482shads
sheds96122702sheds
shields11538042shields
shills94519612shills
sialids839722sialids
sials54227242sials
sibbs96211902sibbs
sibs65933552si_bs
sices75637272sices
sicks115127622sicks
sics65234102si_cs
side55444502si_de
sides65838372sides
sidh86223002si_dh
sidle65124042sidle
sidles74721152sidles
sifts84918922sifts
sighs95416742sighs
siglos7311472siglos
signs65516322signs
sikas94617022sikas
sikes96236082sikes
silex123417412silex
silk85529332sil_k
silky125315822silky
sill45545162sil_l
silly84527622silly
silo46037922sil_o
silt46558202sil_t
silty84721632silty
silva82714022silva
silvas92912182silvas
simas75727552simas
simps94719762simps
sims65737182si_ms
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755282si_ns
sinus55523852sinus
sipes76036952sipes
sips65740112si_ps
sires55945372sires
sirs44338342si_rs
sis37360552si__s
sises55233832sises
sites56045432sites
sits45050212si_ts
situs55019232situs
sixes124526362sixes
sizes146727762sizes
skalds11437832skalds
skids104615342skids
skills104313922skills
sleds64418852sleds
slid55828992slid_
slide64725422slide
slides73922182slides
slims75423652slims
slips76023722slips
slits56128852slits
smiles84522292smiles
sneds65715352sneds
sods54940222s_ods
soils55327982soil_s
sold54837412sold_
soldi65717202soldi
soldo67116562soldo
soles55547922soles
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
sords64527802sords
spiles84227912spiles
spills84717462spills
spuds85113672spuds
stiles64328772stiles
stills64118572stills
stilts67915312stilts
studs64415872studs
sudds75513592sudds
suds56135302s_uds
sulks94818462sulks
sulus54821882sulus
surds65624662surds
swills94213362swills
sylis84316022sylis
tilde65017352tilde
tildes74513962tildes
tiles55542102tiles
tills54631712tills
tils45739622til_s
tilts55325612tilts
velds95615582velds
vids85627552vi_ds
vills86429322vills
welds94719162welds
wields10469622wields
wild85126522wild_
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winds95425612winds
wolds95420182wolds
yids85224972yi_ds
yields10466842yields
yills83921552yills
yirds96612522yirds
zills144020782zills

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.330541487.9
2DLD Change Limit538002151.68631909.8
3Display Results2152150.0633412.7
 (SQL Overall)1786912152.07985950.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.