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

158 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
spark11492089(None) 
park105237491_park
sark84938971s_ark
shark126225021shark
snark95419941snark
spank115919571spank
spar65433301spar_
spare75135561spare
sparks124616361sparks
sparky154511521sparky
spars75431541spars
stark95425621stark
apart74330672apart
ark77044962__ark
bark106242152_bark
cark105539272_cark
chark144222712chark
dark95133212_dark
hark115237392_hark
impark14287072impark
lark85733862_lark
mark105138062_mark
nark85230062_nark
pack125535442_pack
paik105726802_paik
par57467022_par_
para65242172_para
pard76441322_pard
pare66760842_pare
parka115120882_parka
parks116134462_parks
parr65731152_parr
pars67560792_pars
part65967462_part
perk106232842_perk
pork106929682_pork
quark184614122quark
repark123511712repark
sack105337312s_ack
sank85236832s_ank
sard55344242s_ard
sari45444042s_ari
sarks96632462s_arks
sarky125521782s_arky
scar66434202scar_
scare75334462scare
scarf105427142scarf
scarp95724102scarp
scars75433532scars
scart76139772scart
scary105222592scary
sear47353842sear_
sears54744912sears
shack145321752shack
shank125422192shank
shard96125962shard
share86437082share
sharks135019722sharks
sharn84823702sharn
sharp104922532sharp
shirk124817842shirk
skank84415582skank
slack115021762slack
slank95822772slank
smack134615452smack
smarm95517602smarm
smart75834092smart
smerk115412722smerk
smirk116612752smirk
snack114718062snack
snare54429982snare
snarf86525422snarf
snarks104815732snarks
snarky134210842snarky
snarl54921082snarl
soak87227662soa_k
soar46838672soar_
soars54732512soars
spa55730812spa__
space95325672space
spacy125415622spacy
spade84423322spade
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spaes76029972spaes
spahi10311142spahi
spail74921552spail
spait75631602spait
spake114322742spake
spale74929212spale
spall74919302spall
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spanks124514122spanks
spans74528732spans
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
sparid94016932sparid
sparked143513142sparked
sparker133914362sparker
sparkle133710212sparkle
sparkly16348132sparkly
sparry115111302sparry
sparse84516342sparse
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spate74731582spate
spats75031382spats
spawn107811712spawn
spay96631662spa_y
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
speak114618672speak
spear75821062spear_
spears84019472spears
speck135115652speck
sperm93216012sperm
spick134519072spick
spik105419712sp_ik
spire75828692spire
spirt75032952spirt
spiry105017352spiry
spook115416042spook
spore75428592spore
sport75935982sport
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spry96819122sp_ry
spunk114513402spunk
spur65321192spur_
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
squark19438112squark
stack114421692stack
stalk94518002stalk
stank95823302stank
star48037762star_
stare54440262stare
stars55836572stars
start55642312start
stirk95717412stirk
stork96819692stork
swank125318232swank
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218832swarm
swart86234642swart
wark115737772_wark

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.296603685.8
2DLD Change Limit538001581.69031834.3
3Display Results1581580.0463434.8
 (SQL Overall)1786911582.03287938.5
 
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.