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

255 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
spine7653442(None) 
opine77422461opine
pine67755711_pine
seine55732871seine
shine85533091shine
sine46560621s_ine
spice95528811spice
spike114922841spike
spile75230081spile
spin66231301spin_
spined95423941spined
spinel85317331spinel
spines85132031spines
spinet85629751spinet
spins75327981spins
spiny104921301spiny
spire75828691spire
spite75430661spite
spline86020531spline
supine84216691supine
swine85625301swine
aline57243152aline
alpine84417372alpine
amine75835382amine
aping87327232aping
aspire8612122aspire
azine146721412azine
bine66650862_bine
brine75132272brine
chine105231722chine
cine66242942_cine
cline76428532cline
dine55555332_dine
dwine95616142dwine
exine125518492exine
fine75147952_fine
gwine95513662gwine
imine75821062imine
kine85643422_kine
koine9516482koine
line46965572_line
lupine84013532lupine
mine67256172_mine
nine45842172_nine
opined95113852opined
opines84820702opines
oping86322412oping
orpine83914482orpine
oscine8311562oscine
ovine86316642ovine
pane64950292_pane
pice84641092_pice
pie55457402_pi_e
pike106335212_pike
pile65649692_pile
pin57066722_pin_
pina65842632_pina
pined85935322_pined
pines76048862_pines
piney105727502_piney
ping75943592_ping
pink107039382_pink
pins65558452_pins
pint66963172_pint
piny911838352_piny
pipe86434432_pipe
pone65747532_pone
rapine85023082rapine
repine85627812repine
sabine84020392sabine
saice75424052saice
sain45551292sain_
sained75424242sained
sains55639972sains
saint55147072saint
saline65132702saline
sane45954342s_ane
savine94220282savine
scene77220572scene
scone74621832scone
seined74023062seined
seiner64622482seiner
seines65029902seines
seise54727852seise
seize143819502seize
sene46848052s_ene
serine65432672serine
shin75634312shin_
shined104620782shined
shiner93820872shiner
shines95028912shines
shins85131042shins
shiny115122142shiny
shire84727132shire
shive114423422shive
shone83725982shone
shrine94920052shrine
sice65545592s_ice
side55444482s_ide
sike87138782s_ike
sin36265892s_in_
since75024172s_ince
sines55954822s_ines
sinew84718922s_inew
sing57544172s_ing
singe65731132s_inge
sinh76238042s_inh
sink86640142s_ink
sins46755272s_ins
sipe67341042s_ipe
siping94220632siping
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skene96118122skene
skin85927532skin_
skink85916852skink
skins94723462skins
skint95629222skint
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slime74925752slime
sling66028802sling
slink95422912slink
slipe75626132slipe
smile74823922smile
smite75224872smite
snide64318722snide
snipe75320572snipe
soigne74310032soigne
sone46649982s_one
sopite84917712sopite
sozine15712352sozine
space95325672space
spade84423322spade
spae65034322sp_ae
spake114322742spake
spale74929212spale
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spare75135562spare
spate74731582spate
speise84614252speise
spence103813792spence
spend85619332spend
spense83912432spense
spent75532832spent
sphene113412402sphene
sphinx1866202sphinx
spic85227432spi_c
spica94717942spica
spicae104313702spicae
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicy125417712spicy
spider94516802spider
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spiff133616402spiff
spik105419712spi_k
spiked134915552spiked
spiker124315662spiker
spikes124520712spikes
spikey155411332spikey
spiks114117472spiks
spiky146014112spiky
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spinage10289652spinage
spinal84915312spinal
spinate93114812spinate
spindle103210092spindle
spinels94512442spinels
spinets94714812spinets
spinier93715162spinier
spinner93912262spinner
spinney12438922spinney
spinny114510182spinny
spinor839942spinor
spinose937942spinose
spinto8410662spinto
spinule9299992spinule
spirea84015632spirea
spired94921862spired
spirem104214162spirem
spires84628112spires
spirt75032952spirt
spiry105017352spiry
spit65545082spi_t
spited94820442spited
spites84127332spites
spits74429552spits
spitz166017972spitz
spiv95917792spi_v
spivs105114242spivs
splice104915102splice
splined105013112splined
splines94718892splines
splint85223282splint
spode84617702spode
spoke114818662spoke
sponge939662sponge
spore75428592spore
spree74830862spree
spring94526012spring
springe103913982springe
sprint84526792sprint
sprite84421772sprite
sprue74717632sprue
spue66025522sp_ue
spuing94313362spuing
spume95817312spume
spun66221462spun_
spunk114513402spunk
spying123913252spying
stane55933002stane
stile54931572stile
stime76521802stime
sting65330242sting
stink95122502stink
stint57037662stint
stipe76523372stipe
stone55431182stone
suing65026362suing
suint55638182suint
suite54829562suite
supines94216382supines
swing96124842swing
swinge105614382swinge
swink125116352swink
swipe105217082swipe
swive115316192swive
syne75725762s_yne
thine85026862thine
tine45855132_tine
trine54734602trine
twine85822362twine
urine55026592urine
vespine1237902vespine
vine75643682_vine
whine116022812whine
wine74953422_wine
zine137036152_zine

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 Filter178691538000.313570897.8
2DLD Change Limit538002551.65632487.9
3Display Results2552550.0634047.6
 (SQL Overall)1786912552.03287938.5
 
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.