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

418 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
specie1041222(None) 
species11314131species
space95325672spac_e
spacier114011632spacier
spavie113611382spavie
spec85821972spec__
specced14266702specced
special11310302special
speciate12209582speciate
specify1764992specify
specimen1444422specimen
speck135115652spec_k
specked16329012specked
speckle15297552speckle
specks144312702specks
specs96916672spec_s
specter113111732specter
spectre11297772spectre
speil75618642spe_il
speir75315362spe_ir
speise84614252speise
spence103813792spence
spense83912432spense
spicae104313702spicae
spice95528812spic_e
spicier115112462spicier
splice104915102splice
aecia73819283_aecia
aerie54634603_aerie
apace94718383apac_e
apache134210773apache
apelike13310533apelike
aperies9423203aperies
apiece10510083apiec_e
aspect10612823aspec_t
aspects1146743aspects
asperse94210663asperse
belie75630383_belie
boccie123311453boccie
creche13310763creche
decide104116873_decide
decile94619213_decile
deice84320033_deice
dexie134716893_dexie
eche97520283__eche
eerie55228533_eerie
epee64628503epe__e
especial1246293especial
faerie93514683faerie
farcie114816473farcie
fleche14299303fleche
genie66124923_genie
grecize1935663grecize
ipecac1264623ipecac
newie81813483_newie
niece74814503niec_e
pace86345773_pac_e
pacier105018683_pacier
peace95026083_peace
peage84723563_peage
pease75231113_pease
pec76744413_pec__
pecan91919033_pecan
pech116125453_pec_h
peched144915343_peched
pechs125516203_pechs
peck125730683_pec_k
pecked155019103_pecked
pecker144615363_pecker
peckier153910523_peckier
pecks135724433_pecks
pecky165515093_pecky
pecs84634103_pec_s
pecten102711103_pecten
pectic122913873_pectic
pectin102615533_pectin
pectize20259913_pectize
pee56066513_pe__e
peerie83617893peerie
peeve104915253_peeve
pein65834943_pe_in
peise75825773_peise
peke105926203_pe_ke
pekin111514423_pekin
pekoe114612363_pekoe
pele65539553_pe_le
pelite84323003_pelite
pence94924453_pence
pencil103712973_pencil
penile82219603_penile
penis75129323_penis
penne75423853_penne
perdie94718513_perdie
pere66450263_pe_re
peri65636973_peri_
peril75425953_peril
peris75537073_peris
perse75429523_perse
petit74332653_petit
petite84320653_petite
pewee10319973_pewee
pewit104622793_pewit
pice84641093_pic_e
pie55457403_p__ie
piece96717993piec_e
pixie145415523_pixie
plie65127393_p_lie
precipe133012123precipe
precis103416703precis
precise113518173precise
premie103617993premie
price93725413_price
psocid1137253psocid
psyche1674293psyche
puce85127883_puc_e
pyxie17359363_pyxie
recce9514563_recce
recipe103414893_recipe
recit75235103_recit
recite83625113_recite
retie55735303_retie
saice75424053saic_e
saltie63422423saltie
sauce75121653sauc_e
saucier9810283saucier
scene77220573sce_ne
scenic10510513scenic
sec55945323s_ec__
secco9312423s_ecco
secede93311993s_ecede
secret8325063s_ecret
secs65033893s_ec_s
sect67443623s_ec_t
sectile9311973s_ectile
sects75622893s_ects
secure8513533s_ecure
sedge75019953s_edge
sedile73517233s_edile
see35772263s_e__e
seedier83513633seedier
seepier92912013seepier
seethe93712483seethe
segue6314413s_egue
sei36048933s_e_i_
seiche11811833seiche
seif75638733s_e_if
seine55732873s_eine
seis45542393s_e_is
seise54727853s_eise
seize143819503s_eize
selkie102811693selkie
selle54428313s_elle
seme65836653s_e_me
semi65127223s_emi_
semis74623533s_emis
sene46848053s_e_ne
senecio947203senecio
senile63420213s_enile
sense55526823s_ense
sente56432873s_ente
sepia75318673s_epia
sepic94617053s_epic
sepsis83011293sepsis
septic102713183septic
septime1138783septime
sere46153473s_e_re
serge64727463s_erge
series64540973s_eries
serif84132133s_erif
serin55434443s_erin
serine65432673s_erine
serve85425963s_erve
setae56026223s_etae
sexier13310683s_exier
shavie124312413shavie
sheave124514003sheave
sheenie10159483sheenie
sheeve123412843sheeve
sheik122514653she_ik
sheltie10109893sheltie
shelve124012763shelve
sherif122915233sherif
sice65545593s_ic_e
sickie123715743sickie
siege66718443sie_ge
sienite7312713sienite
sieve84918843sie_ve
silkie103313403silkie
since75024173sinc_e
skeane104611373skeane
skee85431473ske__e
skein94814403ske_in
skene96118123ske_ne
sleave94714153sleave
sleaze152611863sleaze
sledge85011283sledge
sleeve93411593sleeve
slice74925823slic_e
sluice849513sluice
smectic1336603smectic
smectite1245773smectite
sneck114713663snec_k
snecks124410033snecks
sneeze15318523sneeze
socle7419573s_ocle
softie93312473softie
solecise1089073solecise
solecize1998383solecize
sonsie6614853sonsie
sortie63621983sortie
spaced114517253spaced
spacer104917793spacer
spaces104722633spaces
spacey136212533spacey
spacial1138763spacial
spaciest122310893spaciest
spacing123614493spacing
spackle15369563spackle
spacy125415623spac_y
spade84423323sp_ade
spadix1636103spadix
spae65034323sp__ae
spahee11313443spahee
spahi10311143spahi_
spahis11310383spahis
spail74921553sp_ail
spait75631603sp_ait
spake114322743sp_ake
spale74929213sp_ale
spaniel948923spaniel
spare75135563sp_are
sparge94216043sparge
sparid94016933sparid
sparse84516343sparse
spate74731583sp_ate
spathe115115693spathe
spavies123012943spavies
spaviet123011923spaviet
spavin114210653spavin
speak114618673spe_ak
speaker133311213speaker
speaks125114583speaks
spean74620513spe_an
speaned103411523speaned
speans85417143speans
spear75821063spe_ar
speared104314423speared
spearer93913663spearer
spears84019473spears
speccing15306643speccing
specialer1344733specialer
specials1238033specials
speciated14207543speciated
speciates13229233speciates
specific1744703specific
specified1746243specified
specifier1645683specifier
specifies1647573specifies
specimens1543403specimens
specious1247483specious
specking17359733specking
speckled17255823speckled
speckles16268133speckles
spectate12248833spectate
specters122811063specters
spectra11275833spectra
spectres12268683spectres
specula11187413specula
sped76031493spe__d
speech1347563speech
speeches1537413speeches
speed85526623spe_ed
speeded113310423speeded
speeder103811073speeder
speedier1146623speedier
speedo94011993speedo
speeds94316053speeds
speedy1218410783speedy
speel74420763spe_el
speeled103712453speeled
speels85116393speels
speer74623903spe_er
speered103614813speered
speers85019953speers
speiled104412123speiled
speils84116223speils
speired103811103speired
speirs85013233speirs
speises93813933speises
speiss84311643speiss
spell75020303spe_ll
spelled103714733spelled
speller95415143speller
spells84617683spells
spelt75430193spe_lt
spelter94113703spelter
spelts84614643spelts
speltz174010113speltz
spencer113610973spencer
spences113413923spences
spend85619333spe_nd
spender103713693spender
spendier1147143spendier
spends94714473spends
spendy124911143spendy
spenses92913573spenses
spent75532833spe_nt
sperm93216013spe_rm
spermic1338523spermic
spermine12311433spermine
sperms102512603sperms
spew95421873spe__w
spewed125512333spewed
spewer115112143spewer
spewing133110453spewing
spews105015923spe_ws
sphene113412403sphene
sphenic1449093sphenic
sphere113313653sphere
spheric14510073spheric
spherier1337783spherier
spic85227433sp__ic
spica94717943spic_a
spicas104715823spicas
spicate113214193spicate
spiced115218313spiced
spicer104719313spicer
spices104326033spices
spicey134414233spicey
spiciest122711603spiciest
spicily1438653spicily
spicing123914533spicing
spick134519073spic_k
spicks144814993spicks
spics94123243spic_s
spicule11269933spicule
spicy125417713spic_y
spied85427713sp__ied
spiel74623913sp__iel
spier75728033sp__ier
spies76037623sp__ies
spik105419713sp__ik
spike114922843sp_ike
spikier13369983spikier
spile75230083sp_ile
spin66231303sp__in
spine76534423sp_ine
spinier93715163spinier
spire75828693sp_ire
spirier93214073spirier
spirit83519923spirit
spit65545083sp__it
spite75430663sp_ite
spiv95917793sp__iv
splake1259783splake
splenia948313splenia
splenic1148663splenic
splenii945543splenii
spliced124310593spliced
splicer114710523splicer
splices113914383splices
spline86020533spline
split75729013sp_lit
splore81611303splore
spode84617703sp_ode
spoil75818643sp_oil
spoke114818663sp_oke
sponge939663sponge
spore75428593sp_ore
spouse84112513spouse
sprain83614863sprain
spree74830863sp_ree
sprier84119063sp_rier
sprig85617743sp_rig
sprit76736403sp_rit
sprite84421773sprite
spruce103910873spruce
sprucier1254793sprucier
sprue74717633sp_rue
spue66025523sp__ue
spume95817313sp_ume
spumier1137903spumier
spunkie13215293spunkie
spurge93711323spurge
stacte82113913stacte
steelie7310213steelie
steeve93710903steeve
stein54620533ste_in
stelae63716483stelae
stele55026843ste_le
stelic8313083stelic
stencil946893stencil
steppe10319873steppe
stere55328543ste_re
steric8317063steric
sterile7316603sterile
stogie7311313stogie
stymie1137623stymie
sucre75019103s_ucre
suede64419753sue_de
suicide1038893suicide
sulci7615053sulci_
superlie10312123superlie
svelte9319753svelte
swede94413203swe_de
sweetie10157863sweetie
swerve1256293swerve
syce95820283s_yc_e
sycee105018623s_ycee
syenite1039773syenite
techie11511723_techie
thecae11299653thecae
vegie94614513_vegie
weenie92612023weenie
weepie11258793weepie
wienie9229973wienie
yperite1249893yperite
zoecia1735553zoecia

Search took 6 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.1401276364.3
2DLD Change Limit1127164184.73623799.8
3Display Results4184180.1233398.4
 (SQL Overall)1786914184.99935745.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.