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

521 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
spicae10431370(None) 
spica94717941spica_
spicas104715821spicas
spicate113214191spicate
spice95528811spic_e
apical10913902apical
epical10413392epical
pica85831492_pica_
pical95524372_pical
picas94626522_picas
pice84641092_pic_e
plicae10410952plicae
saice75424052saic_e
seiche11811832seiche
sice65545592s_ic_e
slice74925822slic_e
space95325672spac_e
spae65034322sp__ae
specie10412222specie
spic85227432spic__
spicated13309902spicated
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spicier115112462spicier
spick134519072spic_k
spicks144814992spicks
spics94123242spic_s
spiculae12218602spiculae
spicule11269932spicule
spicy125417712spic_y
spike114922842spi_ke
spile75230082spi_le
spinage10289652spinage
spinal84915312spinal
spinate93114812spinate
spine76534422spi_ne
spiraea9407982spiraea
spiral83715342spiral
spire75828692spi_re
spirea84015632spirea
spital83813872spital
spite75430662spi_te
splice104915102splic_e
amice96122873amic_e
apace94718383apac_e
apache134210773apache
apian75018333api_an
apicals1159923apicals
apices104916263apices
apiece10510083apiece
aspic95114733aspic__
aspics104211563aspic_s
aspirate1039943aspirate
aspire8612123aspi_re
auspicate1345743auspicate
auspice1136523auspic_e
baccae12119703baccae
bice86235563_bic_e
chica125818263chica_
chicane1489553chicane
chicas135916473chicas
chicle134312543chicle
cicale10314503_cicale
cliche133712453cliche
cnidae978143cnidae
deice84320033deic_e
dice75841893_dic_e
epic86921303epic__
epicarp1376073epicarp
epicene1148593epicene
epics95014283epic_s
epicure1136823epicure
epilate9314283epilate
erica7316543erica_
ericas8315463ericas
espial839543espi_al
faciae112913413faciae
fice95737113_fic_e
fiche134616743_fiche
hospice14117063hospic_e
ice56737243__ic_e
icicle1036583icicle
ipecac1264623ipecac
juice14311323juic_e
laical8312323laical
lice66045063_lic_e
loricae938253loricae
mica86428253_mica_
micas96823053_micas
mice87442233_mic_e
miche126219243_miche
minae75627723_minae
muscae10410673muscae
nicad8312613_nicad
nice65534713_nic_e
niche105016793_niche
ocicat101412813ocicat
opiate8513463opiate
opine77422463opi_ne
optical1149863optical
ossicle944483ossicle
paca85132243_paca_
pacas96029403_pacas
pace86345773_pac_e
parae76335703_parae
peace95026083_peace
pecan91919033_pecan
pia56848033_pi_a_
pial65636703_pi_al
pian66136093_pi_an
pias66542553_pi_as
pibal95217323_pibal
pic76046823_pic__
picante11310523_picante
picara10311903_picara
picaro10311323_picaro
pick125933813_pic_k
pickax2135913_pickax
pickaxe2244623_pickaxe
picked154421313_picked
picker144422173_picker
picket144924313_picket
pickle144215653_pickle
picks135226143_picks
picky165416943_picky
picot95031013_picot
picrate112014143_picrate
pics85633913_pic_s
picul95015363_picul
pie55457403_pi__e
piece96717993_piece
pika106322953_pika_
pikake11115803_pikake
pikas114218093_pikas
pike106335213_pi_ke
pilaf103923483_pilaf
pilar75221503_pilar
pilau73618523_pilau
pilaw103913743_pilaw
pile65649693_pi_le
pilea75123953_pilea
pima85428653_pima_
pimas94725103_pimas
pina65842633_pina_
pinas75434453_pinas
pine67755713_pi_ne
pinnae84414643_pinnae
pipage1199143_pipage
pipal95118353_pipal
pipe86434433_pi_pe
pique16410173_pique
pirate82322883_pirate
piste75824603_piste
pita65436433_pita_
pitas77427673_pitas
pixie145415523_pixie
place94824613_place
plica9613373plica_
plical10411683plical
plicate11314513plicate
price93725413pric_e
psoae74411623_psoae
psyche1674293psyche
puce85127883_puc_e
pupae96515643_pupae
quiche2057903quiche
rice64942913_ric_e
saccade12107033saccade
saccate111311763saccate
sae38365183s___ae
saices84221803saices
saiga64717933saiga_
saigas74114293saigas
saithe94713913saithe
salpae84614273salpae
sanicle91210263sanicle
sauce75121653sauc_e
scab85926713s__cab
scad75725773s__cad
scag76626893s__cag
scale74629143s__cale
scam85932353s__cam
scan65530453s__can
scape96921843s__cape
scar66434203s__car
scare75334463s__care
scat65848373s__cat
seiches12513813seiches
seine55732873sei_ne
seise54727853sei_se
seitan62613233seitan
seize143819503sei_ze
sepia75318673sepi_a_
sepias83616103sepi_as
sepic94617053sepic__
septical1259363septical
setae56026223s_etae
seviche1545113seviche
shibah14387473shibah
shicker163914823shicker
shikar1336803shikar
shikse1386073shikse
shine85533093shi_ne
shire84727133shi_re
shitake1455623shitake
shiva115915003shiva_
shivah15488543shivah
shivas124512413shivas
shive114423423shi_ve
sial45938833s_i_al
sic55847873s_ic__
siccan1037593siccan
sicced11489653s_icced
sices75637273s_ices
sick106435573s_ic_k
sicked134524403s_icked
sickee124622223s_ickee
sicken124615253s_icken
sicker124023903s_icker
sickie123715743s_ickie
sickle124418323s_ickle
sicko115315393s_icko
sicks115127623s_icks
sics65234093s_ic_s
side55444493s_i_de
sidhe95315103s_idhe
sidle65124033s_idle
siege66718443s_iege
sieve84918843s_ieve
sika86021323s_ika_
sikas94617023s_ikas
sike87138783s_i_ke
silage72715303s_ilage
silane62718053s_ilane
silica8311243silica_
silicas9310603silicas
silicate10312623silicate
silicle937753silicle
silvae92811093silvae
sima64730783s_ima_
simar74920813s_imar
simas75727553s_imas
since75024173s_ince
sine46560623s_i_ne
singe65731133s_inge
sipe67341043s_i_pe
sire46150413s_i_re
siree55238813s_iree
sisal54217733s_isal
sitar54820543s_itar
site47052413s_i_te
sixte126216583s_ixte
sizar145214993s_izar
size135630963s_i_ze
skite95120053ski_te
skive124614113ski_ve
skycap1742913skycap
sliced94416313sliced
slicer84117603slicer
slices84022853slices
slick115520523slic_k
slicked144413843slicked
slicken13309293slicken
slicker133314533slicker
slicks124816113slicks
slide64725413sli_de
slieve9359273slieve
slime74925753sli_me
slipcase1263923slipcase
slipe75626133sli_pe
sluice849513sluic_e
smidge10378483smidge
smilax1535393smilax
smile74823923smi_le
smite75224873smi_te
snick114416013snic_k
snicked143811633snicked
snicker133012673snicker
snicks124312473snicks
snide64318723sni_de
snipe75320573sni_pe
soca66330053s_oca_
socage91012123s_ocage
socas74026183s_ocas
soccage1236283soccage
social8813333social
socle7419573s_ocle
soigne74310033soigne
soilage8169353soilage
soiree62919483soiree
solace83415823solace
sonicate10310933sonicate
sopite84917713sopi_te
soucar839323soucar
sowcar1135863sowcar
spa55730813sp__a_
spaced114517253spaced
spacer104917793spacer
spaces104722633spaces
spacey136212533spacey
spacial1138763spacial
spacier114011633spacier
spackle15369573spackle
spacy125415623spac_y
spade84423323sp_ade
spaed85522273sp__aed
spaes76029973sp__aes
spahee11313443spahee
spake114322743sp_ake
spale74929213sp_ale
spam85930043sp__am
span65234663sp__an
spar65433303sp__ar
spare75135563sp_are
sparge94216053sparge
sparse84516343sparse
spas67036723sp__as
spat66548523sp__at
spate74731583sp_ate
spathe115115693spathe
spavie113611383spavie
spay96631663sp__ay
spaz155626163sp__az
speak114618673sp_eak
spean74620513sp_ean
spear75821063sp_ear
spec85821973spec__
specced14266703specced
special11310303special
speciate12209583speciate
species11314133species
speck135115653spec_k
specked16329013specked
speckle15297553speckle
specks144312703specks
specs96916673spec_s
spectate12248833spectate
specter113111733specter
spectre11297773spectre
speise84614253speise
spence103813793spence
spense83912433spense
sphene113412403sphene
sphere113313663sphere
spiccato1463183spiccato
spicers113815553spicers
spicery14499013spicery
spiciest122711603spiciest
spicily1438653spicily
spicing123914533spicing
spicula11259293spicula
spicular12238903spicular
spiculate132210163spiculate
spicules12219803spicules
spider94516803spider
spied85427713spi_ed
spiegel1034553spiegel
spiel74623913spi_el
spieled104811883spieled
spieler93111233spieler
spiels85317953spiels
spier75728033spi_er
spiered104412463spiered
spiers84421743spiers
spies76037623spi_es
spiff133616403spi_ff
spiffed16257103spiffed
spiffs14328473spiffs
spiffy17326223spiffy
spigot9312603spigot
spik105419713spi__k
spiked134915553spiked
spiker124315663spiker
spikes124520713spikes
spikey155411333spikey
spikier13369983spikier
spiks114117473spi_ks
spiky146014113spi_ky
spiled94621993spiled
spiles84227913spiles
spill74821163spi_ll
spillage1146263spillage
spilled103613623spilled
spiller92914333spiller
spills84717463spills
spilt75532223spi_lt
spilth11469733spilth
spin66231303spi__n
spinach1435403spinach
spinages11289293spinages
spinals93911863spinals
spindle103210093spindle
spined95423943spined
spinel85317333spinel
spines85132033spines
spinet85629753spinet
spinier93715163spinier
spinner93912263spinner
spinney12438923spinney
spinny114510183spinny
spinor839943spinor
spinose937943spinose
spins75327983spi_ns
spinto8410663spinto
spinulae10276963spinulae
spinule9299993spinule
spiny104921303spi_ny
spiracle1255803spiracle
spiraeas10286233spiraeas
spiraled1137733spiraled
spirals93212513spirals
spirant9814293spirant
spireas94412513spireas
spired94921863spired
spirem104214163spirem
spireme11478363spireme
spires84628113spires
spirier93214073spirier
spirit83519923spirit
spirt75032953spi_rt
spirted103913073spirted
spirts85317133spirts
spirulae10216573spirulae
spiry105017353spi_ry
spit65545083spi__t
spitals93011593spitals
spited94820443spited
spites84127333spites
spits74429553spi_ts
spitted103912703spitted
spitter94015183spitter
spittle937923spittle
spitz166017973spi_tz
spitzes1849183spitzes
spiv95917793spi__v
spivs105114243spi_vs
spivvy1733213spivvy
splake1259783splake
splat76129343sp_lat
splay105816043sp_lay
spliced124310593spliced
splicer114710523splicer
splices113914383splices
spline86020533spline
splore81611303splore
spode84617703sp_ode
spoilage11195373spoilage
spoke114818663sp_oke
sponge939663sponge
sporal82915453sporal
spore75428593sp_ore
spouse84112513spouse
sprag86418693sp_rag
sprat76635973sp_rat
spray106720063sp_ray
spread9312533spread
spree74830863sp_ree
springe103913983springe
sprite84421773sprite
spruce103910873spruce
sprue74717633sp_rue
spue66025523sp__ue
spume95817313sp_ume
spurge93711323spurge
sputa74612963sputa_
stacte82113913stacte
stelae63716483stelae
stich104117923stic_h
stichs114511653stichs
stick115121563stic_k
sticked144114633sticked
sticker133515883sticker
stickle132410973stickle
sticks125118613sticks
sticky154711343sticky
stifle93611903stifle
stile54931573sti_le
stime76521803sti_me
stipe76523373sti_pe
stoae55024263s_toae
stoical9310283stoical
striae65422273striae
succah1336643succah
sucre75019103s_ucre
suicide1038893suicide
suitcase1043893suitcase
suite54829563sui_te
sulcal8311273sulcal
sulcate9314423sulcate
summae103911013summae
sundae7312873sundae
supinate10310313supinate
supine84216693supi_ne
suricate10312613suricate
swine85625303swi_ne
swinge105614383swinge
swipe105217083swi_pe
swiple11379233swiple
swithe124010683swithe
swive115316193swi_ve
syce95820283s_yc_e
sycee105018623s_ycee
sylvae12236863sylvae
thecae11299653thecae
tical76021493_tical
tipcat10312653tipcat
topical1139953topical
trice75127493tric_e
tunicae9328143tunicae
twice104711123twic_e
typical1436343typical
unciae83215313unciae
upscale11136323upscale
vesicae12177703vesicae
vicar10513863_vicar
vice95732853_vic_e
vitae84217633_vitae
voice104915323voic_e
vomicae1445303vomicae

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127165215.70319764.3
3Display Results5215210.1563339.7
 (SQL Overall)1786915216.24928595.1
 
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.