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

260 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
spinose93794(None) 
acinose938582acinose
pilose84514242_pilose
pinole83218782_pinole
spense83912432spen_se
spinage10289652spinage
spinate93114812spinate
spindle103210092spindle
spine76534422spin__e
spines85132032spines_
spinoff1544932spinoff
spinor839942spino_r
spinors939422spinors
spinosely1442532spinosely
spinous9310442spinous
spinout9311582spinout
spins75327982spin_s_
spintos939132spintos_
spinule9299992spinule
spinulose1142912spinulose
urinose738482urinose
adipose1036653adipose
anginose945903anginose
appose10411993ap_pose
arenose7311373arenose
ariose64818723ari_ose
cespitose1342063cespitose
chinone12510153chinone
chinos115018693chinos_
dinos65428063_dinos_
epidote1037393epidote
epigone1057843epigone
epinaos936283epinaos_
episode1056303episode
episome1157813episome
epitome1157743epitome
epitope1147053epitope
farinose1136463farinose
filose96112503_filose
finos86226953_finos_
hognose11117243hognose
kinase104210653_kinase
kinos96626143_kinos_
laminose1036913laminose
lanose6313593_lanose
linos55631503_linos_
mannose939243mannose
nose46739363___nose
operose939433operose
opine77422463opin__e
opines84820703opines_
oppose1039193op_pose
otiose639403oti_ose
pentose9311593_pentose
pepinos1137693pepinos_
pianos84315933_pianos_
pinas75434453_pinas_
pinbone1138183_pinbone
pine67755713_pin__e
pinene82915643_pinene
pines76048863_pines_
pingoes105116523_pingoes
pingos95317673_pingos_
pings85830883_pings_
pinhole122010433_pinhole
pinite8321243_pinite
pinkie124414273_pinkie
pinkoes135512313_pinkoes
pinkos125313873_pinkos_
pinks115729383_pinks_
pinnae84414643_pinnae
pinocle1138143_pinocle
pinoles93418703_pinoles
pinon76024533_pino_n
pinones94717073_pinones
pinons86019943_pinons
pinot78737293_pino_t
pinots85920273_pinots
pins65558453_pin_s_
pintle83818263_pintle
pintoes95117713_pintoes
pintos86021293_pintos_
pints75936223_pints_
pions75826393_pions_
pisos76021063_pisos_
porose84818743_porose
pose66441733_p__ose
prose75835123_p_rose
pruinose1044853pruinose
psiloses1036443psiloses
quinone16217463quinone
rhinos94411123rhinos_
ribose839893_ribose
rimose8310593_rimose
rinse54820973_rin_se
sains55639973sain_s_
saints65122423saints_
scapose1147753scapose
scions82612243scions_
segnos73610443segnos_
seine55732873sein__e
seines65029903seines_
seise54727853sei__se
sense55526823s_en_se
setose65114773s_etose
shikse1386073shi_kse
shinbone1354473shinbone
shine85533093shin__e
shines95028913shines_
shingle117711283shingle
shins85131043shin_s_
signore8329093signore
silos56029433s_ilos_
since75024173s_in_ce
sine46560623s_in__e
sines55954823s_ines_
singe65731133s_in_ge
singes74326853s_inges
single74520603s_ingle
sings65532703s_ings_
sinhs86719603s_inhs_
sinks95529183s_inks_
sinopie948783s_inopie
sins46755273s_in_s_
sinus55523853s_inus_
sinuses73011593s_inuses
skimos12548803skimos_
skinks94511653skinks_
skins94723463skin_s_
slings74618013slings_
slinks104315153slinks_
snore55424953s__nore
sorbose938983sorbose
spangle1038403spangle
spanks124514123spanks_
spans74528733span_s_
sparse84516343sp_arse
spathose1345633spathose
speise84614253sp_eise
spence103813793spen_ce
spences113413923spences
spends94714473spends_
spenses92913573spen_ses
sphinges14267483sphinges
sphinxes20334403sphinxes
spicae104313703spi_cae
spicas104715823spicas_
spicate113214193spicate
spice95528813spi__ce
spices104326033spices_
spicks144814993spicks_
spics94123243spi_cs_
spicule11269933spicule
spiels85317953spiels_
spiers84421743spiers_
spies76037623spi_es_
spiffs14328473spiffs_
spigot9312603spigo_t
spigots1037793spigots
spike114922843spi__ke
spikes124520713spikes_
spiks114117473spi_ks_
spile75230083spi__le
spiles84227913spiles_
spills84717463spills_
spin66231303spin___
spinach1435403spinach
spinages11289293spinages
spinal84915313spin_al
spinals93911863spinals
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindly13257383spindly
spined95423943spin_ed
spinel85317333spin_el
spinelle1046223spinelle
spinels94512443spinels
spinet85629753spin_et
spinets94714813spinets
spinier93715163spinier
spiniest102813233spiniest
spinifex2042053spinifex
spinless10238703spinless
spinner93912263spinner
spinney12438923spinney
spinnies103210543spinnies
spinny114510183spin_ny
spinoffs1642773spinoffs
spinosity1444243spinosity
spinouts1036023spinouts
spinster1036683spinster
spinto8410663spin_to
spinula9257903spinula
spinulae10276963spinulae
spinules10249333spinules
spiny104921303spin__y
spire75828693spi__re
spireme11478363spireme
spires84628113spires_
spiroid10219823spiroid
spirts85317133spirts_
spite75430663spi__te
spites84127333spites_
spits74429553spi_ts_
spittle937923spittle
spitzes1849183spitzes
spivs105114243spi_vs_
spline86020533splin__e
splines94718893splines_
splints94511743splints_
splore81611303sp_lore
splosh1186543sp_losh
spode84617703sp__ode
spoke114818663sp__oke
spondee10310593spondee
sponge939663spon_ge
sponges10311043sponges
sponson935383sponson
sponsor934973sponsor
spoons84116023spoons_
spore75428593sp__ore
spouse84112513sp_ouse
springe103913983sprin_ge
springes114014033springes
springs104415923springs_
sprinkle1434893sprinkle
sprints94113773sprints_
spumone1154383spumone
spunkie13215303spunkie
spunks12349333spunks_
starnose8136693starnose
stenos63915773stenos_
stenosed946343stenosed
stenoses8310443stenoses
stingos8459453stingos_
stings76220183stings_
stinks105616833stinks_
stints65119763stints_
strigose945583strigose
sucrose939303sucrose
suints64617783suints_
supinate10310313supinate
supine84216693supin__e
supines94216383supines_
suppose1137973suppose
swindle11389183swindle
swine85625303swin__e
swinge105614383swin_ge
swinges113413423swinges
swingle113510563swingle
swings104714453swings_
swinish1347203swinish
swinks134610653swinks_
triose64715383tri_ose
uprose82311483up_rose
venose9310843_venose
vinos84723073_vinos_
winoes94317013_winoes
winos84625043_winos_

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.406440125.6
2DLD Change Limit1340272606.90619407.3
3Display Results2602600.0763421.1
 (SQL Overall)1786912607.38824186.7
 
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.