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

195 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
spinneys1333555(None) 
shinneys14275091shinneys
spinners103810861spinners
spinney12438921spinney_
swinneys14264201swinneys
pinkeys16378212_pinkeys
pinners93518602_pinners
shinney13368292shinney_
sinners74019022s_inners
skinners12347292skinners
spanners103710772spanners
spinels94512442spi_nels
spines85132032spi_ne_s
spinets94714812spi_nets
spininess1137962spininess
spinless10238702spinless
spinner93912262spinne_r
spinnery13416592spinnery
spinnies103210542spinnies
spinny114510182spinn_y_
spooneys13314582spooneys
swinney13365972swinney_
aginners954623aginners
chimneys1883643chimneys
dingeys12458403_dingeys
dinkeys15507263_dinkeys
dinners83915443_dinners
ginners84314223_ginners
grinners9288043grinners
inners63919353__inners
jitneys17313173_jitneys
kidneys1533423_kidneys
linnets739833_linnets
linseys1035083_linseys
openness1035473openness
opines84820703opi_ne_s
panners93621273_panners
pannes85522853_panne_s
penners93414183_penners
phoneys15437143_phoneys
pigsneys1442003_pigsneys
pincers113916503_pincers
pinders103720473_pinders
pinenes93416673_pinenes
pines76048863_pi_ne_s
piney105727503_pi_ney_
pingers104020743_pingers
pinkens13419643_pinkens
pinkers134118603_pinkers
pinkey154314673_pinkey_
pinkeye16326493_pinkeye
pinkeyes17335973_pinkeyes
pinkness1436513_pinkness
pinnas85315513_pinn_as
pinned94818383_pinne_d
pinner84521503_pinne_r
pinnies93318443_pinnies
pinny105222063_pinn_y_
pinones94717073_pinone_s
punkeys16366493_punkeys
punners94114233_punners
punnets9409263_punnets
sawneys13274643s_awneys
scanners10379703scanners
scunners10357303scunners
seiners74219273sei_ners
seines65029903sei_ne_s
sennets73712583s_ennets
shanteys14395513shanteys
sheeneys14294903sheeneys
shindys14314133shi_ndys
shiners104015943shi_ners
shines95028913shi_ne_s
shininess1237333shininess
shinned114310913shinne_d
shinnery14305673shinnery
shinneyed1642083shinneyed
shinnies113010913shinnies
shinny124810783shinn_y_
shunners11317743shunners
signees83510803s_ignees
signers84714443s_igners
signets83311503s_ignets
simnels976103s_imnels
sines55954823s_i_ne_s
sinews94210623s_i_news
singers83824703s_ingers
singes74326853s_inge_s
sinkers113618543s_inkers
sinless73014213s_inless
sinned73818413s_inne_d
sinner64320603s_inne_r
sinters74024083s_inters
skinkers11298183skinkers
skinless12216973skinless
skinned12387293skinne_d
skinner11348093skinne_r
skinny13456613skinn_y_
slimness1036523slimness
slingers93712683slingers
smileys12336323smi_leys
sonnets74211993s_onnets
spancels1245273spancels
spaniels1045963spaniels
spankers14369863spankers
spanless10247363spanless
spanned104111223spanne_d
spanner94312563spanne_r
spawners13396493spawners
spencers12269193spencers
spences113413923spence_s
spenders113211743spenders
spenses92913573spense_s
sphenes123013163sphene_s
sphinges14267483sphinge_s
sphinxes20334403sphinxe_s
spicers113815553spi_cers
spices104326033spi_ce_s
spicey134414233spi_cey_
spiciness1347053spiciness
spiders103914413spi_ders
spiegels1133873spiegels
spielers10319653spielers
spiels85317953spi__els
spiers84421743spi__ers
spies76037623spi__e_s
spikers135311993spi_kers
spikes124520713spi_ke_s
spikey155411333spi_key_
spikiness1536313spikiness
spiles84227913spi_le_s
spillers103311703spillers
spinages11289293spinages
spinals93911863spi_nals
spindlers12286453spindlers
spindles112710353spindles
spindly13257383spindly_
spine76534423spi_ne__
spined95423943spi_ne_d
spinel85317333spi_ne_l
spineless1136133spineless
spinet85629753spi_ne_t
spinier93715163spinie_r
spiniest102813223spiniest
spinnakers1641913spinnakers
spinneret1146193spinneret
spinnerets1242543spinnerets
spinneries1245733spinneries
spinning113310813spinning
spinnings12294853spinnings
spinoffs1642773spinoffs
spinors939423spi_nors
spinous9310443spi_nous
spinouts1036023spinouts
spins75327983spi_n__s
spinsters1136613spinsters
spintos939133spi_ntos
spinules10249333spinules
spiny104921303spi_n_y_
spiraeas10286233spiraeas
spireas94412513spi_reas
spirems11499563spi_rems
spires84628113spi_re_s
spites84127333spi_te_s
spitters104113383spitters
spitzes1849183spitze_s
splines94718893spline_s
splinters11277923splinters
spondees1136483spondees
spongers1137603spongers
sponges10311043sponge_s
spooney12418243spooney_
springers12309983springers
springes114014033springe_s
sprinters11329363sprinters
spryness1334003spryness
spurners10288493spurners
spurreys13364603spurreys
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stunners8277923stunners
supineness1245873supineness
supines94216383supi_ne_s
sweeneys14294023sweeneys
swingbys17282123swingbys
swingers123710423swingers
swinges113413423swinge_s
thinners11327753thinners
thinness11277163thinness
tinners73717313_tinners
vainness1136063vainness
winceys15395523_winceys
winners104316913_winners
witneys13274723_witneys

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621958.19017846.4
3Display Results1951950.0762565.8
 (SQL Overall)1786911958.42221217.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.