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

514 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
species1131413(None) 
specie10412221specie_
aperies9423202aperies
series64540972s_eries
spaces104722632spac_es
spacier114011632spacier
spaciest122310902spaciest
spavies123012952spavies
specced14266702specced
special11310302special
specials1238032specials
speciates13229232speciates
specifies1647572specifies
specify1764992specify
specimen1444422specimen
specimens1543402specimens
specious1247482specious
specked16329012specked
speckles16268132speckles
specks144312702spec_ks
specs96916672spec__s
specter113111732specter
specters122811062specters
spectres12268682spectres
speeches1537412speeches
speils84116222spe_ils
speirs85013232spe_irs
speise84614252spe_ise
speises93813932speises
speiss84311642spe_iss
spences113413922spences
spenses92913572spenses
spices104326032spic_es
spicier115112462spicier
spiciest122711612spiciest
spies76037622sp__ies
splices113914382splices
aeries64737783_aeries
agencies1138743agencies
apaches143411843apaches
apexes1539133ape_xes
apices104916263apic_es
applies11311223applies
aspects1146743aspec_ts
asperges11318093asperges
asperses104111673asperses
beeches143413883beeches
beedies10314203beedies
belies84631053_belies
bevies114017303_bevies
boccies133311513boccies
chevies153511443chevies
creches14313093creches
decides114217653_decides
deciles104417723_deciles
decries103319813_decries
defies104624053_defies
deices94119373_deices
demies94825803_demies
denies74729643_denies
dexies145018343_dexies
dioecies1138933dioecies
duperies11312813duperies
eches106322163__eches
ecospecies1652823ecospecies
elegies81312903elegies
emeries91620023emeries
emperies12314563emperies
enemies9313693enemies
epees75219833epe__es
epoxies1637753epoxies
especial1246293especial
espies83716803esp__ies
facies113921593_facies
faeces114713123faec_es
faeries104118993faeries
fancies124018783fancies
farcies125317883farcies
feces105625363_fec_es
fleches153411443fleches
genies75324943_genies
grecizes2035683grecizes
ipecacs1354503ipecacs
japeries17311463japeries
leches115421313_leches
leeches123911933leeches
levies93919863_levies
mercies113817563mercies
moperies12313873moperies
nancies93516843nancies
naperies10313903naperies
newies91014073_newies
nieces84112713niec_es
paces96741113_pac_es
pacier105018683_pacier
paciest112917813_paciest
papacies1439483papacies
paries84742513_paries
peaces106324083_peaces
peaches144120053_peaches
peages94321853_peages
peases85229473_peases
peavies122213403_peavies
pecans101515833_pecans
peched144915343_peched
pechs125516203_pec_hs
pecked155019103_pecked
pecker144615363_pecker
peckers153312673_peckers
peckier153910523_peckier
peckiest162711393_peckiest
pecks135724433_pec_ks
pecs84634103_pec__s
pecten102711103_pecten
pectens11189203_pectens
pectines121914683_pectines
pectins112315233_pectins
pectizes21229793_pectizes
pedes85327293_pe_des
peeries93623023peeries
pees65257373_pe__es
peeves113814873_peeves
peins76128063_pe_ins
peise75825773_pe_ise
peises84125043_peises
pekes114623563_pe_kes
pekins121812233_pekins
pekoes124410423_pekoes
peles75738083_pe_les
pelites93821993_pelites
pelves114514663_pelves
pencils113011773_pencils
penes75839223_pe_nes
penis75129323_peni_s
penises9318193_penises
pennies94218813_pennies
peones83821043_peones
peonies93620153_peonies
perches143717953_perches
peres76246643_pe_res
perils84121853_perils
peris75537073_peri_s
perries93226603_perries
perses85428063_perses
petites93820203_petites
pewees11311393_pewees
pewits112810683_pewits
pieces104217273piec_es
pies66949603_p__ies
pieties9419223pieties
pities83828083_pities
pixies154915513_pixies
plies74526513_p_lies
poesies93217403poesies
pogies94123543_pogies
pokies125921333_pokies
polies84034583_polies
ponies84833463_ponies
poperies12316793poperies
posies84431433_posies
precipes143212213precipes
precis103416703preci_s
precise113518173precise
precises123218333precises
premies113823063premies
prexies163415003prexies
prices104524543_prices
pries74339533_p_ries
psocids1234863psocids
psyches1755803psyches
puces94924633_puc_es
pyxies18338293_pyxies
queries16315873queries
recces10614913_recces
recipes113314463_recipes
recites93524583_recites
recits83621353_recits
relies65036423_relies
replies94521043replies
reties65436193_reties
roperies10315773roperies
safeties1139163safeties
saices84221803saic_es
sallies73227813sallies
salties73725773salties
sanies63031953s_anies
sapiencies1445123sapiencies
sassies74719263sassies
sauces84919503sauc_es
saucier9810283saucier
sauciers1076733sauciers
sauciest10310983sauciest
sauries72821623sauries
savvies1337603savvies
scabies11613333scabies
scenes84520353sce_nes
scenics1137773scenics
scries85226823s_cries
seccos1039923s_eccos
secedes103711983s_ecedes
secrecies1346923secrecies
secret8325063s_ecret
secrets9311773s_ecrets
secs65033893s_ec__s
sects75622893s_ec_ts
secures9613163s_ecures
sedges83817813s_edges
seedier83513633seedier
seediest92714053seediest
seepier92912013seepier
seepiest102412633seepiest
sees45361053s_e__es
seethes103613743seethes
segues7412073s_egues
seiches12513813seiches
seifs85019333s_e_ifs
seines65029903s_eines
seis45542393s_e_i_s
seise54727853s_e_ise
seises64026713s_eises
seizes154317533s_eizes
selkies113513353selkies
selles64426983s_elles
selves94119613s_elves
semes75731583s_e_mes
semis74623533s_emi_s
semises93916553s_emises
senecios1046303senecios
seniles72618023s_eniles
senses63923943s_enses
sepias83616103s_epias
sepses84515883s_epses
sepsis83011293sepsi_s
septics112810433septics
septimes1238303septimes
seres55448893s_e_res
serges74225973s_erges
serifs94017053s_erifs
serines74229543s_erines
serins64029673s_erins
serries73925353serries
serves94423653s_erves
sexes126126223s_e_xes
sexier13310683s_exier
sexiest142112223s_exiest
sferics1236133sferics
shavies134213213shavies
sheaves134412973sheaves
sheenies111411543sheenies
sheeves133911953sheeves
sheiks132510013she_iks
shelties111111383shelties
shelves134112093shelves
sherifs13299683sherifs
sherries111812903sherries
shies86136553s__hies
sices75637273s_ic_es
sickies133717503sickies
sieges73816833sie_ges
sienites8311913sienites
sieves93216003sie_ves
silkies113715693silkies
sillies73425083sillies
sissies73716603sissies
sixties14310973sixties
skeanes113610713skeanes
skees95023123ske__es
skeins103911903ske_ins
skenes104616633ske_nes
skerries12168673skerries
sketches1746823sketches
skies95026833s__kies
sleaves103813203sleaves
sleazes162810333sleazes
sledges94511573sledges
sleeves103311343sleeves
slices84022853slic_es
sluices959073sluices
smectites1344623smectites
snecks124410033snec_ks
sneezes16278503sneezes
socles8418453s_ocles
soddies92312853soddies
softies103414613softies
solecise1089073solecise
solecises1189103solecises
solecizes2087863solecizes
sonnies7315223sonnies
sophies12314623sophies
sorties74126403sorties
space95325673spac_e_
spaced114517253spac_ed
spacer104917793spac_er
spacers113813873spacers
spacey136212533spac_ey
spacial1138763spacial
spaciness1337083spaciness
spacing123614493spacing
spacings13287043spacings
spacious1237813spacious
spackles16319953spackles
spades94222583sp_ades
spadices1336093spadices
spadixes1834113spadixes
spaes76029973sp__aes
spahees1238263spahees
spahis11310383spahi_s
spails84817823sp_ails
spaits85017473sp_aits
spales84728103sp_ales
spaniel948923spaniel
spaniels1045963spaniels
spares84834553sp_ares
sparges104016343sparges
sparids103512123sparids
spates85028173sp_ates
spathes125116533spathes
spavie113611383spavie_
spaviet123011933spaviet
spavins12419323spavins
spazzes1735263spazzes
speaker133311213speaker
speakers14299453speakers
speaks125114583spe_aks
speaned103411523speaned
speans85417143spe_ans
speared104314423speared
spearer93913663spearer
spearers103711143spearers
spears84019473spe_ars
spec85821973spec___
speccing15306643speccing
specialer1344733specialer
specialest1445573specialest
speciate12209583speciate
speciated14207543speciated
speciesism1652353speciesism
specific1744703specific
specifics1843933specifics
specified1746253specified
specifier1645683specifier
specifiers1743803specifiers
speck135115653spec__k
specking17359733specking
speckle15297553speckle
speckled17255833speckled
spectates13228813spectates
spectra11275833spectra
spectre11297773spectre
specula11187413specula
speed85526623spe__ed
speeded113310423speeded
speeder103811073speeder
speeders11339313speeders
speedier1146623speedier
speediest1257473speediest
speedos10298263speedos
speeds94316053spe_eds
speel74420763spe__el
speeled103712453speeled
speels85116393spe_els
speer74623903spe__er
speered103614813speered
speers85019953spe_ers
speil75618643spe_i_l
speiled104412123speiled
speir75315363spe_i_r
speired103811103speired
speisses10245693speisses
spelled103714743spelled
speller95415153speller
spellers102812763spellers
spells84617683spe_lls
spelter94113703spelter
spelters103912243spelters
spelts84614643spe_lts
speltzes1944003speltzes
spence103813793spence_
spencer113610973spencer
spencers12269193spencers
spender103713693spender
spenders113211743spenders
spendier1147143spendier
spendiest1237533spendiest
spends94714473spe_nds
spense83912433spense_
spermines13310543spermines
sperms102512603spe_rms
spewed125512333spe_wed
spewer115112153spe_wer
spewers124210663spewers
spewing133110453spewing
spews105015923spe__ws
sphenes123013163sphenes
spheres123114353spheres
spherics1537073spherics
spherier1337783spherier
spheriest1438383spheriest
spicae104313703spicae_
spicas104715823spic_as
spice95528813spic_e_
spiced115218313spic_ed
spicer104719313spic_er
spiceries1349313spiceries
spicers113815553spicers
spicey134414233spic_ey
spicily1438653spicily
spiciness1347053spiciness
spicing123914533spicing
spicks144814993spic_ks
spics94123243sp__ics
spicules12219803spicules
spied85427713sp__ied
spiel74623913sp__iel
spiels85317953sp__iels
spier75728033sp__ier
spiers84421743sp__iers
spiffies16277993spiffies
spikes124520713sp_ikes
spikier13369983spikier
spikiest14259543spikiest
spiks114117473sp__iks
spiles84227913sp_iles
spines85132033sp_ines
spinier93715163spinier
spiniest102813233spiniest
spinnies103210543spinnies
spins75327983sp__ins
spires84628113sp_ires
spirier93214073spirier
spiriest102513463spiriest
spirits94112623spirits
spites84127333sp_ites
spits74429553sp__its
spitzes1849183spitzes
spivs105114243sp__ivs
splakes1349673splakes
splenius1046033splenius
splice104915103splice_
spliced124310593spliced
splicer114710523splicer
splicers12338113splicers
splines94718893splines
splits85416413sp_lits
splores91910953splores
spodes94817433sp_odes
spoils84614533sp_oils
spokes124417213sp_okes
sponges10311043sponges
spoonies101911753spoonies
spores84726613sp_ores
spouses92912813spouses
sprains93013593sprains
sprees85620643sp_rees
sprier84119063sp_rier
spriest92718653sp_riest
sprigs94814773sp_rigs
sprites94220333sprites
sprits85122533sp_rits
spruces113810503spruces
sprucier1254793sprucier
spruciest1345153spruciest
sprues84515763sp_rues
spues75025383sp__ues
spumes1021314883sp_umes
spumier1137903spumier
spumiest1238213spumiest
spunkies14227593spunkies
spurges104111653spurges
spurries102311323spurries
stactes91914633stactes
steadies9311123steadies
steelies8312553steelies
steeves103410903steeves
steins64818343ste_ins
steles63725663ste_les
stenches132110293stenches
stencils1046403stencils
steppes113110693steppes
steres63929533ste_res
stickies142211973stickies
sties55132983s__ties
stimies9316563stimies
stogies8413693stogies
stories7324273stories
studies82413863studies
stupefies1443833stupefies
stymies1239213stymies
subspecies1644743subspecies
sucres84218893s_ucres
suedes73918113sue_des
suicides1139083suicides
sulkies114315763sulkies
sullies74122233sullies
superlies11314553superlies
supplies1268843supplies
sureties8316583sureties
swamies123712063swamies
swedes102711893swe_des
sweenies11148763sweenies
sweeties11159723sweeties
swerves1377533swerves
sycees11409653s_ycees
syces106416463s_yc_es
syenites1138943syenites
techies12513603_techies
tepefies1346893tepefies
updries10209083updries
veeries102916893veeries
vegies104314273_vegies
weenies102915093weenies
weepies122811743weepies
wienies102213683wienies
yperites13310153yperites

Search took 8 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.393454684.5
2DLD Change Limit1340275146.71619956.4
3Display Results5145140.1862763.4
 (SQL Overall)1786915147.29524495.0
 
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.