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

141 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
sparks12461636(None) 
parks116134461_parks
sarks96632461s_arks
sharks135019721sharks
snarks104815731snarks
spanks124514121spanks
spares84834551spares
spark114920891spark_
sparky154511521sparky
spars75431541spar_s
arks85936872__arks
barks115735812_barks
carks115534212_carks
charks155219702charks
darks106727872_darks
harks126333432_harks
imparks15276662imparks
larks95227812_larks
marks115933482_marks
narks96026032_narks
packs135528932_packs
paiks114719852_paiks
paras76143042_paras
pards85634332_pards
pares77164482_pares
paris75145942_paris
park105237492_park_
parka115120882_parka
parkas125018022_parkas
parrs75928672_parrs
pars67560792_par_s
parts77743372_parts
perks115325802_perks
porks115124142_porks
quarks193810912quarks
reparks13249512reparks
sacks114228872s_acks
sards64736182s_ards
saris54544952s_aris
sark84938972s_ark_
sarky125521782s_arky
saros55238062s_aros
scares85033002scares
scarfs114714682scarfs
scarps104718602scarps
scars75433532scar_s
scarts85321492scarts
sears54744912sear_s
shacks154817562shacks
shanks135315582shanks
shards104319172shards
shares95236412shares
shark126225022shark_
sharns95516982sharns
sharps115516082sharps
shirks134814122shirks
skanks94710832skanks
slacks124416532slacks
smacks144112322smacks
smarms105712532smarms
smarts86218002smarts
smerks12449712smerks
smirks124910122smirks
snacks124514552snacks
snares65329032snares
snarfs95113422snarfs
snark95419942snark_
snarky134210842snarky
snarls64016872snarls
soaks95220292soa_ks
soars54732512soar_s
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spahis11310382spahis
spails84817822spails
spaits85017472spaits
spake114322742spa_ke
spales84728102spales
spalls84217342spalls
spams94922192spa_ms
spank115919572spank_
spans74528732spa_ns
spar65433302spar__
spare75135562spar_e
spared95427482spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparge94216042sparge
sparges104016332sparges
sparid94016932sparid
sparids103512122sparids
sparked143513132sparked
sparker133914352sparker
sparkers144111312sparkers
sparkish17276972sparkish
sparkle133710202sparkle
sparkles143210482sparkles
sparkly16348122sparkly
sparry115111302sparry
sparse84516342sparse
spas67036722spa__s
spasms10418972spasms
spates85028172spates
spats75031382spa_ts
spawns11577922spawns
spays105520512spa_ys
speaks125114582speaks
spears84019472spear_s
specks144312702specks
sperms102512602sperms
spicks144814992spicks
spiks114117472sp_iks
spires84628112spires
spirts85317132spirts
spooks124312932spooks
spores84726612spores
sports84619182sports
sprags95715822sprags
sprats85819932sprats
sprays115913642sprays
spunks12349332spunks
spurns84811382spurns
spurs74621522spur_s
spurts84814972spurts
squarks20417182squarks
stacks124317262stacks
stalks104614552stalks
stanks104917702stanks
stares66038752stares
stark95425622stark_
stars55836572star_s
starts65423122starts
stirks104914232stirks
storks106115932storks
swanks134811562swanks
swards105415132swards
swarfs125612062swarfs
swarms116112162swarms
warks127932402_warks

Search took 4 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 Filter178691825510.220812231.8
2DLD Change Limit825511413.09326689.6
3Display Results1411410.0463065.2
 (SQL Overall)1786911413.35953197.7
 
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.