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

184 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
space9532567(None) 
apace94718381apace
pace86345771_pace
spaced114517251spaced
spacer104917791spacer
spaces104722631spaces
spacey136212531spacey
spacy125415621spacy
spade84423321spade
spae65034321spa_e
spake114322741spake
spale74929211spale
spare75135561spare
spate74731581spate
spice95528811spice
ace59656832__ace
apache134210772apache
brace95629272brace
dace76934922_dace
epact94921532epact
face96140122_face
glace87420152glace
grace85124542grace
lace66848472_lace
mace87345792_mace
pac79054082_pac_
paca85132242_paca
paced106931682_paced
pacer96131612_pacer
paces96741112_paces
pacey126720282_pacey
pack125535442_pack
pacs85842182_pacs
pact86648722_pact
pacy115328682_pacy
page76036102_page
pale66055012_pale
pane64950292_pane
pare66760842_pare
pase65346862_pase
pate65350462_pate
pave96133892_pave
peace95026082peace
pice84641092_pice
place94824612place
puce85127882_puce
race66746262_race
respace11310912respace
sabe66140572s_abe
sac57452862s_ac_
sack105337312s_ack
sacs65739072s_acs
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
saice75424052saice
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
sauce75121652sauce
save75741362s_ave
scale74629142scale
scape96921842scape
scarce104013632scarce
scare75334462scare
seance83716682seance
shack145321752shack
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
sice65545592s_ice
since75024172since
skate94721552skate
slack115021762slack
slake93724052slake
slate55438282slate
slave84224032slave
slice74925822slice
smack134615452smack
smaze165012932smaze
snack114718062snack
snake94821112snake
snare54429982snare
soave84219052soave
solace83415822solace
spa55730812spa__
spacers113813872spacers
spacier114011632spacier
spackle15369572spackle
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spaed85522272spaed
spaes76029972spaes
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spait75631602spait
spales84728102spales
spall74919302spall
spam85930042spa_m
spams94922192spams
span65234662spa_n
spancel1147362spancel
spang84919732spang
spank115919572spank
spans74528732spans
spar65433302spa_r
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
spark114920892spark
spars75431542spars
sparse84516342sparse
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spates85028172spates
spathe115115692spathe
spats75031382spats
spavie113611382spavie
spawn107811712spawn
spay96631662spa_y
spayed124213612spayed
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
spec85821972spec_
specie10412222specie
speck135115652speck
specs96916672specs
spence103813792spence
spic85227432spic_
spica94717942spica
spicae104313702spicae
spiced115218312spiced
spicer104719312spicer
spices104326032spices
spicey134414232spicey
spick134519072spick
spics94123242spics
spicy125417712spicy
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
splake1259782splake
splice104915102splice
spode84617702spode
spoke114818662spoke
spore75428592spore
spree74830862spree
spruce103910872spruce
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
stack114421692stack
stacte82113912stacte
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stance84316912stance
stane55933002stane
stare54440262stare
state56237332state
stave85324992stave
suave83519872suave
swage94919562swage
swale85221592swale
sware85828212sware
syce95820282s_yce
tace65342512_tace
trace75829612trace

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.313570897.8
2DLD Change Limit538001841.64032804.9
3Display Results1841840.0464000.0
 (SQL Overall)1786911841.99989390.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.