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

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

250 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
spines8513203(None) 
opines84820701opines
pines76048861_pines
seines65029901seines
shines95028911shines
sines55954821s_ines
spices104326031spices
spies76037621spi_es
spikes124520711spikes
spiles84227911spiles
spine76534421spine_
spined95423941spined
spinel85317331spinel
spinels94512441spinels
spinet85629751spinet
spinets94714811spinets
spins75327981spin_s
spires84628111spires
spites84127331spites
splines94718891splines
supines94216381supines
alines65735222alines
alpines94016192alpines
amines84727982amines
apices104916262apices
aspires9612042aspires
aspises9611642aspises
azines155517072azines
bines76946792_bines
brines85028852brines
chines115029172chines
cines75239682_cines
clines84926042clines
dines66449152_dines
dwines105013102dwines
espies83716802espi_es
exines135715802exines
fines86644262_fines
imines84918352imines
kines95039132_kines
koines10415732koines
lines57054572_lines
lupines93912502lupines
mines75651952_mines
nines55937342_nines
opine77422462opine_
opined95113852opined
orpines94414792orpines
oscines9310362oscines
ovines94614342ovines
panes76148692_panes
penes75839222_penes
pies66949602_pi_es
pikes115031032_pikes
piles74742612_piles
pinas75434452_pinas
pine67755712_pine_
pined85935322_pined
piney105727502_piney
pings85830882_pings
pinks115729382_pinks
pins65558452_pin_s
pints75936222_pints
pipes96030142_pipes
pixes144323172_pixes
pones74547042_pones
rapines95120862rapines
repines94927382repines
sabines94318482sabines
saices84221802saices
sained75424242sained
sains55639972sain_s
saints65122422saints
salines74029412salines
sanes55649072s_anes
sanies63031952sanies
sapiens9310172sapiens
savines104417632savines
scenes84520352scenes
scones84521302scones
seine55732872seine_
seined74023062seined
seiner64622482seiner
seiners74219272seiners
seises64026712seises
seizes154317532seizes
serines74229542serines
shies86136552shi_es
shine85533092shine_
shined104620782shined
shiner93820872shiner
shiners104015942shiners
shins85131042shin_s
shires95225572shires
shives124921412shives
shrines104618692shrines
sices75637272s_ices
sides65838362s_ides
sikes96236082s_ikes
sine46560622s_ine_
sinew84718922s_inew
sinews94210622s_inews
singes74326852s_inges
sings65532702s_ings
sinhs86719602s_inhs
sinks95529182s_inks
sins46755272s_in_s
sinus55523852s_inus
sipes76036952s_ipes
sires55945372s_ires
sises55233832s_ises
sites56045432s_ites
sixes124526362s_ixes
sizes146727762s_izes
skenes104616632skenes
skies95026832ski_es
skinks94511652skinks
skins94723462skin_s
skites104418042skites
skives134113942skives
slices84022852slices
slides73922182slides
slimes84722042slimes
slings74618012slings
slinks104315152slinks
slipes84921412slipes
smiles84522292smiles
smites83921922smites
snipes83917392snipes
sones55444142s_ones
sopites93817172sopites
sozines16611262sozines
spaces104722632spaces
spades94222582spades
spaes76029972sp_aes
spales84728102spales
spanks124514122spanks
spans74528732span_s
spares84834552spares
spates85028172spates
speises93813932speises
spences113413922spences
spends94714472spends
spense83912432spense
spenses92913572spenses
sphenes123013162sphenes
sphinges14267482sphinges
sphinxes20334402sphinxes
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spi_cs
spider94516802spider
spiders103914412spiders
spied85427712spi_ed
spiel74623912spi_el
spiels85317952spiels
spier75728032spi_er
spiers84421742spiers
spiffs14328472spiffs
spike114922842spike_
spiked134915552spiked
spiker124315662spiker
spikers135311992spikers
spikey155411332spikey
spiks114117472spi_ks
spile75230082spile_
spiled94621992spiled
spills84717462spills
spin66231302spin__
spinages11289292spinages
spinal84915312spinal
spinals93911862spinals
spindles112710352spindles
spinier93715162spinier
spiniest102813232spiniest
spinless10238702spinless
spinner93912262spinner
spinners103810862spinners
spinney12438922spinney
spinneys13335552spinneys
spinnies103210542spinnies
spinny114510182spinny
spinor839942spinor
spinors939422spinors
spinose937942spinose
spinous9310442spinous
spinto8410662spinto
spintos939132spintos
spinules10249332spinules
spiny104921302spin_y
spire75828692spire_
spirea84015632spirea
spireas94412512spireas
spired94921862spired
spirem104214162spirem
spirems11499562spirems
spirts85317132spirts
spite75430662spite_
spited94820442spited
spits74429552spi_ts
spitzes1849182spitzes
spivs105114242spi_vs
splices113914382splices
spline86020532spline_
splined105013112splined
splints94511742splints
spodes94817432spodes
spokes124417212spokes
sponges10311042sponges
spores84726612spores
sprees85620642sprees
springes114014032springes
springs104415922springs
sprints94113772sprints
sprites94220332sprites
sprues84515762sprues
spues75025382sp_ues
spumes1021314882spumes
spunks12349332spunks
stanes64933402stanes
sties55132982sti_es
stiles64328772stiles
stimes85920572stimes
stings76220182stings
stinks105616832stinks
stints65119762stints
stipes84524052stipes
stones65130032stones
suints64617782suints
suites63727402suites
supine84216692supine_
swine85625302swine_
swinges113413422swinges
swings104714452swings
swinks134610652swinks
swipes114114332swipes
swives123915182swives
tines54848422_tines
trines64132562trines
twines94717272twines
urines64724122urines
vines85137642_vines
whines125120102whines
wines85546862_wines
zines145232652_zines

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825512502.43633887.9
3Display Results2502500.0803125.0
 (SQL Overall)1786912502.85962501.2
 
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.