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

209 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
silos5602943(None) 
filos86125381filos
kilos95021471kilos
lilos55821871lilos
milos75428011milos
siglos7311471siglos
silds65520521silds
silks94620681silks
sills55135991sills
silo46037911silo_
silts55330821silts
solos54830791solos
ails45654712ail_s
bigos85020012bigos
bilbos105011202bilbos
biles75542142biles
bilks115117892bilks
bills75632862bills
bios66335322bi_os
biros75325132biros
bolos75531372bolos
calos74431902calos
didos76820812didos
dildos8179302dildos
dills65530972dills
dinos65428062dinos
diols65521012diols
eidos65817752eidos
fidos95819052fidos
files85441272files
fillos94415082fillos
fills84632372fills
films105617962films
filo76034282filo_
filose96112502filose
fils75838692fil_s
finos86226952finos
gilds75417522gilds
gills64728192gills
gilts64924262gilts
giros65722652giros
halos85230252halos
helos84928062helos
hillos94618892hillos
hills85431352hills
hilts86924412hilts
hilus84817642hilus
ilks87218572_ilks
ills47030422_ills
isles54220562isles
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilo86028672kilo_
kilts95122182kilts
kinos96626142kinos
kolos94921212kolos
lidos65219882lidos
lilo46731562lilo_
lilts55822802lilts
limos75320812limos
linos55631502linos
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milo65536102milo_
mils66045332mil_s
milts75430712milts
misos76523292misos
nills54926672nills
nils46132452nil_s
nolos54423352nolos
oils46337972oil_s
olios54520852olios
piles74742612piles
pilis75825202pilis
pills74130972pills
pilose84514242pilose
pilot77435062pilot
pilots84018872pilots
pilous84717752pilous
pilus75921062pilus
pisos76021062pisos
polos76129912polos
riles55343642riles
rills55032712rills
sagos66123872sagos
sailor63113752sailor
sailors73213722sailors
sails55738102sail_s
sales56055592sales
salol55222142salol
salols64017872salols
salon55228552salon
salons63823692salons
salps74423242salps
sals46851672sal_s
salts55431882salts
salvos94613382salvos
saros55238062saros
segos64919482segos
selfs85220242selfs
sells55134432sells
sels46345982sel_s
shills94519612shills
shoos84226362shoos
sials54227242sials
sibbs96211902sibbs
sibs65933542si_bs
sices75637272sices
sickos125112032sickos
sicks115127622sicks
sics65234092si_cs
sides65838362sides
sidles74721152sidles
sifts84918922sifts
sighs95416742sighs
sigloi737742sigloi
signs65516322signs
sikas94617022sikas
sikes96236082sikes
sild55030582sil_d
silex123417412silex
silk85529322sil_k
silky125315822silky
sill45545152sil_l
silly84527622silly
siloed74615302siloed
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
sixmos1534812sixmos
sizes146727762sizes
skills104313922skills
skimos12548802skimos
slims75423652slims
slips76023722slips
slits56128852slits
slob66029422s_lob
slobs74419872s_lobs
sloe45534952s_loe
sloes54728872s_loes
slog56728272s_log
slogs64521842s_logs
slop66533872s_lop
slops75026012s_lops
slosh84514482s_losh
slot46049832s_lot
slots54830532s_lots
slow77729492s_low
slows85323462s_lows
smiles84522292smiles
soils55327982soil_s
soles55547922soles
solo45538942solo_
solon55026132solon
solons65120022solons
sols45448162sol_s
solus54726982solus
sos37761602s__os
spiles84227912spiles
spills84717462spills
splosh1186542splosh
stiles64328772stiles
stills64118572stills
stilts67915312stilts
sulks94818462sulks
sulus54821882sulus
sumos75720092sumos
swills94213362swills
sylis84316022sylis
telos55424522telos
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
tiros54524892tiros
vills86429322vills
vinos84723072vinos
viols86118102viols
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winos84625042winos
yills83921552yills
zills144020782zills

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 Filter178691538000.296603685.8
2DLD Change Limit538002091.48636204.6
3Display Results2092090.0464543.5
 (SQL Overall)1786912091.82897752.2
 
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.