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

335 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
spaniel94892(None) 
spancel1147361spancel
spaniels1045961spaniels
panel76023622_pan_el
panier84425502_panier
samiel8313332s_amiel
sanies63031952s_anies
spacial1138762spacial
spacier114011632spacier
spail74921552spa_i_l
spancels1245272spancels
spandex1735832spandex
spandrel1144062spandrel
spangle1038402spangle
spanked143111732spanked
spanker133612352spanker
spanned104111222spanned
spanner94312562spanner
spatial9310322spatial
spavie113611382spavie_
spavies123012952spavies
spaviet123011932spaviet
spiel74623912sp__iel
spinel85317332spin_el
spinier93715162spinier
angel65019573__angel
anil46437433__ani_l
anile54634463__anile
ariel55228973__ariel
beanie83618593beanie_
beanies93821093beanies
cancel105316683_cancel
cannel84216403_cannel
chancel144011783chancel
channel123910493channel
cranial92114683cranial
empanel1145963empan_el
espalier1036363espalier
espanol943783espan_ol
evangel1134303evangel
flannel1035423flannel
hansel95214373_hansel
impanel1137093impan_el
mangel94017543_mangel
mantel84317973_mantel
meanie83718393meanie_
meanies93620743meanies
pacier105018683_pacier
pail66141833_pa_i_l
pained95622853_pained
palier85023573_palier
pander93725533_pander
pandied113913443_pandied
pandies104224503_pandies
pane64950293_pan_e_
paned85437183_pan_ed
panels84716523_pan_els
panes76148693_pan_es
panful1179743_panful
panged104722343_panged
pangen94115923_pangen
panic93923903_pani_c
panicle11129983_panicle
panics103815363_panics
paniers94717333_paniers
panini8314273_panini
panino8315683_panino
panne76623653_panne_
panned94123433_panned
panner84224763_panner
pannes85522853_pannes
pannier93613353_pannier
pansies94521983_pansies
panted95024823_panted
pantie84326473_pantie_
panties94230933_panties
pantile93918483_pantile
panzer174213233_panzer
parcel103915473_parcel
paries84742523_paries
parrel84515983_parrel
passel85117003_passel
pastel85918713_pastel
pencel103812923_pencel
penial84120893_penial
penile82219603_penile
pinier84024693_pinier
ponied94920703_ponied
ponies84833463_ponies
punier84519233_punier
repanel939963repan_el
sagier73717163s_agier
sail45447163s_a_i_l
sained75424243s_ained
samiels939763s_amiels
sandal73317283s_andal
sanded84920613s_anded
sander74828533s_ander
sandier84017843s_andier
sane45954343s_an_e_
saned65636273s_an_ed
sanely93114613s_an_ely
saner54334323s_an_er
sanes55649073s_an_es
sanger74524573s_anger
sanicle91210263s_anicle
saning75127643s_aning
sanity9316203s_anity
sansei63411903s_ansei
santol64515243s_antol
sappier113613123sappier
saurel6511993s_aurel
scabies11613333scabies
scalier94316913scalier
scalpel11377713scalpel
scandal1038673scandal
scanned104110893scanned
scanner94411813scanner
scanted104114393scanted
scanter94215183scanter
scantier10309983scantier
scanties103215423scanties
scarier94017873scarier
scrannel1044033scrannel
seamier93114633seamier
seance83716693seance_
seances93015343seances
senile63420213s_enile
shadier113111153shadier
shakier143411153shakier
shalier103116423shalier
shandies122714113shandies
shanked153212123shanked
shannies113411263shannies
shantey134210043shantey
shanties113116593shanties
shavie124312423shavie_
shavies134213213shavies
shiel811023773s__hiel
shinier104113143shinier
simnel857023simn_el
skanked11338103skanked
skanker10268483skanker
skankier11184883skankier
slander84015453slander
slanged94112853slanged
slangier9117933slangier
slanted83514743slanted
slatier74016813slatier
snail57020203sna_i_l
snakier112810003snakier
snivel9368853s__nivel
soapier93411713soapier
sonnies7315223sonnies
space95325673spa_ce_
spaced114517253spa_ced
spacer104917793spa_cer
spaces104722633spa_ces
spacey136212533spa_cey
spaciest122310903spaciest
spacing123614493spacing
spackle15369573spackle
spade84423323spa_de_
spaded103816753spa_ded
spader94317133spa_der
spades94222583spa_des
spadices1336093spadices
spadille1145193spadille
spading113114383spading
spadix1636113spadi_x
spadixes1834113spadixes
spae65034323spa__e_
spaed85522273spa__ed
spaeing103413543spaeing
spaes76029973spa__es
spahee11313443spa_hee
spahees1238263spahees
spahi10311143spahi__
spahis11310383spahi_s
spails84817823spa_ils
spait75631603spa_i_t
spaits85017473spa_its
spake114322743spa_ke_
spale74929213spa_le_
spales84728103spa_les
spall74919303spa__ll
spalled103113133spalled
spaller92713473spaller
spammed14348523spammed
spammer133410433spammer
span65234663span___
spanceled1443693spanceled
spandrels1243253spandrels
spandril1144093spandril
spang84919733span__g
spangled1236153spangled
spangles1138893spangles
spanglier1244193spanglier
spangly1336473spangly
spank115919573span__k
spankers14369863spankers
spanking153911973spanking
spanks124514123span_ks
spanless10247363spanless
spanners103710773spanners
spanning113311083spanning
spans74528733span__s
spansule1043633spansule
spare75135563spa_re_
spared95427493spa_red
sparely123410673spa_rely
sparer84524963spa_rer
spares84834553spa_res
sparge94216053sparge_
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparid94016933spari_d
sparids103512123sparids
sparing104823873sparing
sparked143513143sparked
sparker133914363sparker
sparkier14298033sparkier
sparkle133710213sparkle
sparred104512863sparred
sparrier10329143sparrier
sparse84516343sparse_
sparsely1335123sparsely
sparser94311483sparser
spasmed12296993spasmed
spate74731583spa_te_
spates85028173spa_tes
spathal1236263spathal
spathe115115693spathe_
spathed134013183spathed
spathes125116533spathes
spatted104014143spatted
spatter94016523spatter
spatzle1834583spatzle
spavin114210653spavi_n
spavined1434333spavined
spavins12419323spavins
spawned13316803spawned
spawner12347363spawner
spawning14296913spawning
spayed124213613spa_yed
spaying133014623spaying
spazzes1735263spazzes
speaned103411523spean_ed
speaning113512243speaning
special11310303special
specie10412223specie_
species11314133species
speel74420763sp__eel
speil75618643sp_ei_l
spence103813793spence_
spencer113610973spencer
spences113413923spences
spender103713693spender
spendier1147143spendier
spense83912433spense_
spenses92913573spenses
spicier115112463spicier
spied85427713sp__ied
spiegel1034553spiegel
spiels85317953sp__iels
spier75728033sp__ier
spies76037623sp__ies
spikier13369983spikier
spile75230083sp__ile
spill74821163sp__ill
spinal84915313spin_al
spindle103210093spindle
spine76534423spin_e_
spined95423943spin_ed
spinels94512443spin_els
spines85132033spin_es
spinet85629753spin_et
spiniest102813233spiniest
spinifex2042053spinifex
spinner93912263spinner
spinney12438923spinney
spinnies103210543spinnies
spinule9299993spinule
spirier93214073spirier
splenial1047183splenial
spline86020533spline_
splined105013113splined
splines94718893splines
spoil75818653sp_oi_l
spondee10310593spondee
sponge939663sponge_
sponged1137953sponged
sponger1038523sponger
sponges10311043sponges
spongier1135743spongier
sponsal946343sponsal
spoonier10167653spoonier
spoonies101911753spoonies
sprained1138433sprained
sprier84119063sp_rier
spumier1137903spumier
spunked14307783spunked
spunkie13215303spunkie_
spunkier14235823spunkier
spunkies14227593spunkies
stabile9312063stabile
stagier83513443stagier
stained84215343stained
stainer73614923stainer
stammel11607533stammel
stance84316913stance_
stances93715963stances
standee83514513standee
stander84316163stander
stane55933003stan_e_
staned74824643stan_ed
stanes64933403stan_es
stanged94113853stanged
stanine73417073stanine
stanines85115673stanines
staning83922243staning
stanol6310723stan_ol
stonier72013793stonier
subpanel1246083subpan_el
sunnier73412153sunnier
swail86217163swa_i_l
swamies123712063swamies
swanked15359543swanked
swanker14369483swanker
swankier15225503swankier
swanned11358173swanned
wanier93920683_wanier
zanier154314713_zanier
zanies153219673_zanies

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273357.70317399.3
3Display Results3353350.1103045.5
 (SQL Overall)1786913358.21921741.2
 
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.