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

202 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
spivvy173321(None) 
skivvy1932781skivvy
chivvy20374432chivvy
civvy16435462_civvy
divvy15356482_divvy
savvy14497502s_avvy
spicey134414232spicey
spicy125417712spi_cy
spiffy17326222spiffy
spikey155411332spikey
spiky146014112spi_ky
spinny114510182spinny
spiny104921302spi_ny
spiry105017352spi_ry
spiv95917792spi_v_
spivs105114242spi_vs
apiary113910383apiary
chivy164810363chi_vy
ivy96317443__i_vy
jivey185111873_jivey
jivy176213113_ji_vy
navvy14696683_navvy
peavy135014843_peavy
picky165416943_picky
piety105817303_piety
piggy124011433_piggy
pigmy13299433_pigmy
pily96132733_pi_ly
piney105727503_piney
pinky145823403_pinky
pinny105222063_pinny
piny911838353_pi_ny
pipy115421513_pi_py
pithy135614463_pithy
pity96031933_pi_ty
pivot106523873_pivot
pixy166117763_pi_xy
privy13439833_privy
savoy114713883s_avoy
scurvy14386103scurvy
shelvy15377863shelvy
shifty15409263shifty
shily115222013shi_ly
shimmy16306413shimmy
shindy13449323shindy
shinny124810783shinny
shiny115122143shi_ny
shirty124312563shirty
shitty124110063shitty
shiv105721173shi_v_
shiva115915003shi_va
shivah15488543shivah
shivas124512413shivas
shive114423423shi_ve
shiver124517373shiver
shivery16317023shivery
shives124921413shives
shivs115018803shi_vs
sieve84918843s_ieve
silky125315823s_ilky
silly84527623s_illy
silty84721633s_ilty
silva82714023s_ilva
sissy85812073s_issy
siver85728613s_iver
sixty154912733s_ixty
sizy164816393s_i_zy
skiddy1533633skiddy
skiey125012893ski_ey
skimpy17475723skimpy
skinny13456613skinny
skive124614113ski_ve
skived14429893skived
skiver134612103skiver
skives134113943skives
slavey124011803slavey
slieve9359273slieve
slily85820033sli_ly
slimly11408903slimly
slimsy11407723slimsy
slimy105417423sli_my
slinky13399103slinky
slippy1375843slippy
slitty9329163slitty
sliver94116593sliver
smiley114012303smiley
smirky15406943smirky
smithy14508273smithy
sniffy15337193sniffy
snippy1374843snippy
snivel9368853snivel
spacey136212533spacey
spacy125415623sp_acy
sparky154511523sparky
sparry115111303sparry
spavie113611383spavie
spavin114210653spavin
spay96631663sp__ay
speedy1218410793speedy
spendy124911143spendy
sphery14318883sphery
spic85227433spi__c
spica94717943spi_ca
spicae104313703spicae
spicas104715823spicas
spice95528813spi_ce
spiced115218313spiced
spicer104719313spicer
spicery14499013spicery
spices104326033spices
spicily1438653spicily
spick134519073spi_ck
spicks144814993spicks
spics94123243spi_cs
spider94516803spider
spidery13308203spidery
spied85427713spi_ed
spiel74623913spi_el
spiels85317953spiels
spier75728033spi_er
spiers84421743spiers
spies76037623spi_es
spiff133616403spi_ff
spiffs14328473spiffs
spigot9312603spigot
spik105419713spi__k
spike114922843spi_ke
spiked134915553spiked
spiker124315663spiker
spikes124520713spikes
spikily1635873spikily
spiks114117473spi_ks
spile75230083spi_le
spiled94621993spiled
spiles84227913spiles
spill74821163spi_ll
spills84717463spills
spilt75532223spi_lt
spilth11469733spilth
spin66231303spi__n
spinal84915313spinal
spindly13257383spindly
spine76534423spi_ne
spined95423943spined
spinel85317333spinel
spines85132033spines
spinet85629753spinet
spinney12438923spinney
spinor839943spinor
spins75327983spi_ns
spinto8410663spinto
spiral83715343spiral
spire75828693spi_re
spirea84015633spirea
spired94921863spired
spirem104214163spirem
spires84628113spires
spirit83519923spirit
spirt75032953spi_rt
spirts85317133spirts
spit65545083spi__t
spital83813873spital
spite75430663spi_te
spited94820443spited
spites84127333spites
spits74429553spi_ts
spitz166017973spi_tz
splay105816043sp_lay
spongy1236743spongy
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
sporty115112493sporty
spotty11448583spotty
spray106720063sp_ray
spriggy14374213spriggy
springy13359663springy
sprucy13356323sprucy
spry96819123sp__ry
spryly1435513spryly
spumy124610363sp_umy
spunky15427163spunky
spurry11429123spurry
spy86023743sp___y
sticky154711343sticky
stilly93714093stilly
stimy105114743sti_my
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stiver93915733stiver
survey124111673survey
swimmy16234353swimmy
swingy13489873swingy
swirly12439253swirly
swishy15365843swishy
swive115316193swi_ve
swived133610633swived
swivel12369323swivel
swives123915183swives
swivet123615473swivet
tivy1014516863_ti_vy

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162025.31321215.1
3Display Results2022020.0633206.3
 (SQL Overall)1786912025.74931082.1
 
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.