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
silds6552052(None) 
gilds75417521gilds
milds86422051milds
sild55030581sild_
silks94620681silks
sills55135991sills
silos56029431silos
silts55330821silts
wilds94818201wilds
aids57846362ai_ds
ails45654712ail_s
balds85524642balds
bids75838452bi_ds
bields94110002bields
biles75542142biles
bilks115117892bilks
bills75632862bills
binds86627472binds
birds85421332birds
bolds85825282bolds
builds9378492builds
colds85726972colds
dildo71911772dildo
dildos8179302dildos
dills65530972dills
elds56324852_elds
fids87034742fi_ds
fields104211042fields
files85441272files
fills84632372fills
films105617962films
filos86125382filos
fils75838692fil_s
finds95424822finds
folds95221692folds
gelds75118342gelds
gids65933742gi_ds
gild65526512gild_
gills64728192gills
gilts64924262gilts
girds74816992girds
golds75421312golds
guilds8388352guilds
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hinds96721472hinds
holds94623242holds
ids47535472_i_ds
ilks87218572_ilks
ills47030422_ills
isles54220562isles
jills125122822jills
jilts124717412jilts
kids96029642ki_ds
kills94526172kills
kilns95112982kilns
kilos95021472kilos
kilts95122182kilts
kinds106221822kinds
lids56336462li_ds
lilos55821872lilos
lilts55822802lilts
melds84822382melds
mids76541792mi_ds
mild75330852mild_
miles74645072miles
milks115020582milks
mills75435052mills
milos75428012milos
mils66045332mil_s
milts75430712milts
minds85427122minds
molds85324832molds
nills54926672nills
nils46132452nil_s
oils46337972oil_s
olds55926572_olds
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
rids56539552ri_ds
riles55343642riles
rills55032712rills
rinds64826142rinds
saids65328852saids
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
sibs65933542si_bs
sices75637272sices
sicks115127622sicks
sics65234092si_cs
side55444492si_de
sides65838362sides
sidh86222992si_dh
sidle65124032sidle
sidles74721152sidles
sifts84918922sifts
sighs95416742sighs
siglos7311472siglos
signs65516322signs
sikas94617022sikas
sikes96236082sikes
silex123417412silex
silk85529322sil_k
silky125315822silky
sill45545152sil_l
silly84527622silly
silo46037912sil_o
silt46558192sil_t
silty84721632silty
silva82714022silva
silvas92912182silvas
simas75727552simas
simps94719762simps
sims65737172si_ms
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272si_ns
sinus55523852sinus
sipes76036952sipes
sips65740102si_ps
sires55945372sires
sirs44338332si_rs
sis37360542si__s
sises55233832sises
sites56045432sites
sits45050202si_ts
situs55019232situs
sixes124526362sixes
sizes146727762sizes
skalds11437832skalds
skids104615332skids
skills104313922skills
sleds64418852sleds
slid55828982slid_
slide64725412slide
slides73922182slides
slims75423652slims
slips76023722slips
slits56128852slits
smiles84522292smiles
sneds65715352sneds
sods54940212s_ods
soils55327982soil_s
sold54837412sold_
soldi65717202soldi
soldo67116562soldo
soles55547922soles
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
sords64527802sords
spiles84227912spiles
spills84717462spills
spuds85113672spuds
stiles64328772stiles
stills64118572stills
stilts67915312stilts
studs64415872studs
sudds75513592sudds
suds56135292s_uds
sulks94818462sulks
sulus54821882sulus
surds65624662surds
swills94213362swills
sylis84316022sylis
tilde65017342tilde
tildes74513962tildes
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
velds95615582velds
vids85627542vi_ds
vills86429322vills
welds94719162welds
wields10469622wields
wild85126512wild_
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winds95425602winds
wolds95420182wolds
yids85224962yi_ds
yields10466842yields
yills83921552yills
yirds96612512yirds
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.326548131.9
2DLD Change Limit538002151.65632487.9
3Display Results2152150.0633412.7
 (SQL Overall)1786912152.04587379.5
 
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.