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

149 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
spiny10492130(None) 
piny911838351_piny
shiny115122141shiny
spicy125417711spicy
spiky146014111spiky
spin66231301spin_
spine76534421spine
spinny114510181spinny
spins75327981spins
spiry105017351spiry
aping87327232aping
briny104719662briny
liny78141322_liny
meiny104015402meiny
opine77422462opine
oping86322412oping
pily96132732_pily
pin57066722_pin_
pina65842632_pina
pine67755712_pine
piney105727502_piney
ping75943592_ping
pink107039382_pink
pinky145823402_pinky
pinny105222062_pinny
pins65558452_pins
pint66963172_pint
pipy115421512_pipy
pity96031932_pity
pixy166117762_pixy
pony96434052_pony
puny95526992_puny
rainy85921082rainy
sain45551292sain_
sains55639972sains
saint55147072saint
satiny93817982satiny
seine55732872seine
shily115222012shily
shin75634302shin_
shindy13449322shindy
shine85533092shine
shinny124810782shinny
shins85131042shins
sin36265892s_in_
sine46560622s_ine
sing57544172s_ing
sinh76238042s_inh
sink86640142s_ink
sins46755272s_ins
siping94220632siping
sizy164816392s_izy
skiey125012892skiey
skin85927522skin_
skink85916852skink
skinny13456612skinny
skins94723462skins
skint95629222skint
slily85820032slily
slimy105417422slimy
sling66028802sling
slink95422912slink
slinky13399102slinky
sonny85016102sonny
spacy125415622spacy
span65234662span_
spang84919732spang
spank115919572spank
spans74528732spans
spay96631662sp_ay
spend85619332spend
spendy124911142spendy
spent75532832spent
sphinx1866202sphinx
spic85227432spi_c
spica94717942spica
spice95528812spice
spicey134414232spicey
spick134519072spick
spics94123242spics
spied85427712spied
spiel74623912spiel
spier75728032spier
spies76037622spies
spiff133616392spiff
spiffy17326222spiffy
spik105419712spi_k
spike114922842spike
spikey155411332spikey
spiks114117472spiks
spile75230082spile
spill74821162spill
spilt75532222spilt
spinal84915312spinal
spindly13257382spindly
spined95423942spined
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spinney12438922spinney
spinor839942spinor
spinto8410662spinto
spire75828692spire
spirt75032952spirt
spit65545082spi_t
spite75430662spite
spits74429552spits
spitz166017962spitz
spiv95917792spi_v
spivs105114242spivs
spivvy1733212spivvy
splay105816042splay
spline86020532spline
splint85223282splint
spongy1236742spongy
spoony114111792spoony
spray106720062spray
spring94526012spring
springy13359662springy
sprint84526792sprint
spry96819122sp_ry
spuing94313362spuing
spumy124610362spumy
spun66221462spun_
spunk114513402spunk
spunky15427162spunky
spy86023742sp__y
spying123913252spying
stimy105114732stimy
sting65330242sting
stingy105213202stingy
stink95122502stink
stinky134611072stinky
stint57037662stint
stony85818642stony
suing65026362suing
suint55638182suint
sunny84917742sunny
supine84216692supine
swine85625302swine
swing96124842swing
swingy13489872swingy
swink125116352swink
tiny76134632_tiny
twiny116012812twiny
veiny115414362veiny
viny106025952_viny
whiny144915572whiny
winy107034322_winy

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.0762351197.4
2DLD Change Limit538001492.01626686.5
3Display Results1491490.0463239.1
 (SQL Overall)1786911492.13883578.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.