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 “spoilers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

401 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
spoilers1023863(None) 
spoiler93310681spoiler_
spoolers10349361spoolers
boilers93417062_boilers
broilers103210092broilers
coilers93619902_coilers
despoilers1343532despoilers
moilers93615202_moilers
oilers64721192__oilers
poisers94214432_poisers
polers84225642_po_lers
pollers93420022_pollers
poolers94217422_poolers
sailers73822322s_ailers
scowlers13257352scowlers
smilers94113852s_milers
spallers102910732spallers
spellers102812752spellers
spicers113815552sp_icers
spiders103914412sp_iders
spielers10319652spielers
spiers84421742sp_i_ers
spikers135311992sp_ikers
spiles84227912sp_ile_s
spillers103311702spillers
splicers12338112splicers
spoiled104811352spoile_d
spoils84614532spoil__s
spongers1137602spongers
spoofers13307322spoofers
spooler93711382spooler_
sporters103714062sporters
spotless1037042spotless
spotters104313382spotters
spouters104011162spouters
toilers74116262_toilers
appliers1235573appliers
aspirers1066493asp_irers
assailers943983assailers
avoiders1254793avoiders
bailers94221353_bailers
boiler84319273_boiler_
boodlers113710743boodlers
bowlers123715783_bowlers
broiders114211193broiders
broiler92911753broiler_
cavilers1348113cavilers
ceilers93912533_ceilers
cholers124215203cho_lers
coalers94419353_coalers
coiler84421593_coiler_
coiners93620753_coiners
coolers93522493_coolers
copiers114215963copi_ers
defilers12439473defilers
despoiler1243963despoiler_
doodlers10338843doodlers
eloiners8128153eloiners
epimers11109493ep_imers
espaliers1144123espaliers
espousers1143383espousers
etoiles7411293etoile_s
exilers14419733_exilers
filers94623723__filers
footlers113910793footlers
foozlers20346073foozlers
fowlers133411203_fowlers
gaolers83511563gao_lers
goiters84014443_goiters
growlers12327093growlers
hailers104017263_hailers
hollers103818233_hollers
howlers133312353_howlers
jailers144114043_jailers
joiners144211573_joiners
knollers12255133knollers
loiters74116613_loiters
lollers72713793_lollers
mailers94420333_mailers
milers84625163__milers
moiler84017263_moiler_
nailers73215893_nailers
oglers74313183__oglers
oiler54628283__oiler_
pedlers103013273_pedlers
peelers93615593_peelers
peoplers1237153peoplers
philters1398173_philters
piers75926333_p_i_ers
pikers124717393_p_ikers
piles74742613_p_ile_s
pileus84514943_p_ileus
pilfers1238963_p_ilfers
piolets93513193_piolets
pipers104318663_p_ipers
pliers84715153_pli_ers
poilus82210573_poil_us
pointers103013723_pointers
poiser84217243_poiser_
poises84226543_poise_s
pokers124617923_po_kers
polars84419353_po_lars
polders103617373_polders
poleis86018353_po_leis
poler74431793_po_ler_
poles75351003_po_le_s
policers12259993_policers
polies84034583_polie_s
pollees93215333_pollees
pollens93713303_pollens
poller83921853_poller_
ponders103618843_ponders
pooler83819843_pooler_
poplars113910333_poplars
poppers103414863_poppers
porkers134314933_porkers
porters93722703_porters
posers84223973_po_sers
posters93928013_posters
pothers123818623_pothers
potters94024343_potters
potzers184010543_potzers
poulters103911053_poulters
pourers93513673_pourers
pouters94221873_pouters
powders134111553_powders
powers113822323_po_wers
powters124015663_powters
pricers113915063_pricers
priers84521193_pri_ers
primers114215673_primers
prizers183911843_prizers
profilers14236293profilers
prowlers13328933prowlers
pulers83820283_p_ulers
pullers93618483_pullers
railers74420663_railers
recoilers11318153recoilers
revilers114011693revilers
rollers73117473_rollers
saddlers10289753saddlers
sailer63526103s_ailer_
sailors73213723s_ailors
salliers83613343salliers
samplers12299403samplers
scalers93817263s_calers
schillers14285663schillers
scoffers16286133scoffers
scolders11288993scolders
scoopers124210193scoopers
scooters103511033scooters
scorers94115313sco_rers
scorners10228493scorners
scoters93313813sco_ters
scourers10348533scourers
scouters103411323scouters
scowders14276223scowders
scowler12248173scowler_
scribers12307953scribers
scullers103510483scullers
sealers74323553s_ealers
seiners74219273s_einers
seisers73816393s_eisers
seizers164112503s_eizers
sellers73721313s_ellers
seniles72618023senile_s
settlers8289023settlers
shellers112812573shellers
shiers94921753s_hi_ers
shiners104015943s_hiners
shivers133714833s_hivers
shoaler102610083shoaler_
shockers17319463shockers
shoeless1137803shoeless
shoers94518333sho__ers
shooters112811583shooters
shoppers153010763shoppers
shoulders1334233shoulders
shouters113510623shouters
shovelers15174943shovelers
shovers134613003sho_vers
showers134612683sho_wers
shrivers14419103shrivers
sidlers83414233s_idlers
sillers73822103s_illers
silvers104714043s__ilvers
similes92915233simile_s
sivers95324153s__ivers
sizers155215813s__izers
sizzlers16274753sizzlers
skiers104713703s_ki_ers
skivers14409703s_kivers
slicers94114923s_licers
sliders83515223s_liders
slivers104115253s_livers
slobbers12398523slobbers
sloggers10418783sloggers
slopers94213093slo_pers
slotters84012403slotters
smellers10329763smellers
smiler83916683s_miler_
smiles84522293s_mile_s
smileys12336323s_mileys
smiters93414363s_miters
smogless1134053smogless
smokers13389323smo_kers
smolders11287193smolders
smothers13349933smothers
smoulders1243143smoulders
snarlers8298753snarlers
snipers93311773s_nipers
snookers12398653snookers
snoopers10319843snoopers
snoozers17296943snoozers
snorers74313803sno_rers
snorters83410583snorters
snowless1145623snowless
soakers114114953s_oakers
soapers93715923s_oapers
soarers74118093s_oarers
sobbers114114263s_obbers
sobers85218863s_o_bers
soccers1138393s_occers
socles8418453s_ocle_s
soiled73822473s_oile_d
soilless8279033s_oilless
soils55327983s_oil__s
soilure736233s_oilure
soilures836503s_oilures
soirees72411643s_oirees
solders83517773s_olders
soles55547923s_o_le_s
soleus64615613s_o_leus
solvers104414253s_olvers
sonders83820713s_onders
sonless72612613s_onless
sooners73916643s_ooners
soothers113913433soothers
sopites93817173sopite_s
sorners73416873s_orners
sorters74221133s_orters
souters74422603s_outers
sowers94923443s_o_wers
spacers113813873sp_acers
spaders104214473sp_aders
spails84817823spail__s
spales84728103sp_ale_s
spaller92713473spaller_
spammers14378693spammers
spankers14369863spankers
spanless10247363spanless
spanners103710773spanners
sparers94519613sp_arers
spargers11389733spargers
sparkers144111313sparkers
sparklers15315643sparklers
spatters103914703spatters
spawners13396493spawners
speakers14299453speakers
spearers103711143spearers
specters122811063specters
speeders11339313speeders
speers85019953sp__eers
speiled104412123speile_d
speils84116223speil__s
speirs85013233spei__rs
speises93813933speise_s
speller95415143speller_
spelters103912243spelters
spencers12269193spencers
spenders113211743spenders
spewers124210653sp_ewers
spicer104719313sp_icer_
spicery14499013sp_icery
spices104326033sp_ice_s
spider94516803sp_ider_
spidery13308203sp_idery
spieler93111233spieler_
spiels85317953sp_i_els
spier75728033sp_i_er_
spies76037623sp_i_e_s
spiker124315663sp_iker_
spikes124520713sp_ike_s
spile75230083sp_ile__
spiled94621993sp_ile_d
spiller92914333spiller_
spills84717463sp_il_ls
spilths12356023sp_ilths
spindlers12286453spindlers
spinels94512443sp_inels
spines85132033sp_ine_s
spinets94714813sp_inets
spinless10238703spinless
spinners103810863spinners
spinors939423sp_inors
spireas94412513sp_ireas
spirems11499563sp_irems
spires84628113sp_ire_s
spites84127333sp_ite_s
spitters104113383spitters
splicer114710523splicer_
splices113914383splice_s
splines94718893spline_s
splinters11277923splinters
splitters11307323splitters
spodes94817433spo_de_s
spoil75818653spoil___
spoilage11195373spoilage
spoilages12184713spoilages
spoiling112911553spoiling
spoilt85016593spoil__t
spokes124417213spo_ke_s
spondees1136483spondees
sponger1038523sponger_
sponges10311043sponge_s
sponsors1045753sponsors
spoofer12368723spoofer_
spoofery16354313spoofery
spookery17264143spookery
spooled104613523spoole_d
spools85115913spool__s
spooneys13314583spooneys
spoors84014033spo__ors
spores84726613spo_re_s
sporter93616553sporter_
sporules1037703sporule_s
spotter94514883spotter_
spouses92912813spouse_s
spouter94213223spouter_
spoutless1134243spoutless
sprawlers1433893sprawlers
sprayers13367053sprayers
sprier84119063spri_er_
spriggers13325493spriggers
springers12309983springers
sprinklers1642973sprinklers
sprinters11329363sprinters
sprites94220333sprite_s
spritzers2043903spritzers
spudders12255633spudders
spurners10288493spurners
spurrers10338463spurrers
spurters103311703spurters
sputters104012873sputters
stablers103611153stablers
stainers83212173stainers
staplers103111203staplers
stealers83412203stealers
stiflers11238833stiflers
stiles64328773s_tile_s
stivers103613543s_tivers
stockers143411073stockers
stokers114515183sto_kers
stoles63927673sto_le_s
stollens835293stollens
stompers123610043stompers
stoners74817953sto_ners
stookers12449793stookers
stoopers103711303stoopers
stopers94217373sto_pers
stoppers123910593stoppers
storers75018683sto_rers
stovers103713733sto_vers
striders94412123striders
strikers123611293strikers
stripers103911593stripers
strivers113911843strivers
strollers937543strollers
stuivers11406673stuivers
stylers10359353s_tylers
subsoilers1244063subsoilers
sucklers14379963sucklers
suiters73618883s_uiters
suppliers1354483suppliers
sutlers73116973s_utlers
swillers11299113swillers
swobbers15355593swobbers
swooners11336863swooners
swoopers13317523swoopers
swotters11448483swotters
tailers73720183_tailers
tilers63523503__tilers
toiler63918283_toiler_
toiles63923513_toile_s
toilets74112913_toilets
tollers73217463_tollers
toolers74416503_toolers
tootlers8289503tootlers
trailers82912923trailers
trollers83211213trollers
uppiles11208263uppile_s
uprisers10206773uprisers
uprivers13215563uprivers
veilers103911823_veilers
voicers12348993_voicers
voiders11279823_voiders
voiles94616443_voile_s
wailers103916803_wailers
woolers104214023_woolers
yodlers11298923_yodlers
yowlers13328923_yowlers

Search took 9 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461624017.73618893.7
3Display Results4014010.1562570.5
 (SQL Overall)1786914018.04522211.4
 
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.