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

169 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
spade8442332(None) 
sade55544471s_ade
shade95125581shade
space95325671space
spaded103816751spaded
spader94317131spader
spades94222581spades
spado83713701spado
spae65034321spa_e
spaed85522271spaed
spake114322741spake
spale74929211spale
spare75135561spare
spate74731581spate
spode84617701spode
stade64825301stade
apace94718382apace
bade75140882_bade
blade85923332blade
cade76443912_cade
clade85821012clade
epode85114092epode
evade938182evade
fade85736342_fade
glade75121962glade
grade75126092grade
hade85440192_hade
irade65618152irade
jade125325442_jade
lade56345982_lade
made75440242_made
pace86345772_pace
pad68057322_pad_
padi76331782_padi
padle84522342_padle
padre86018162_padre
pads76742952_pads
page76036102_page
pale66055012_pale
pane64950292_pane
pare66760842_pare
pase65346862_pase
pate65350462_pate
pave96133892_pave
respade1039572respade
sabe66140572s_abe
sad47459202s_ad_
sades65239892s_ades
sadhe94815132s_adhe
sadi55834642s_adi
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
save75741362s_ave
scad75725772scad_
scads85419962scads
scale74629142scale
scape96921842scape
scare75334462scare
shad86230912shad_
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
side55444482s_ide
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
slide64725412slide
smaze165012932smaze
snake94821112snake
snare54429982snare
snide64318722snide
soave84219052soave
sonde64622832sonde
spa55730812spa__
spaced114517252spaced
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spacy125415622spacy
spaders104214472spaders
spadix1636112spadix
spaes76029972spaes
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spait75631602spait
spales84728102spales
spall74919302spall
spam85930042spa_m
spams94922192spams
span65234662spa_n
spandex1735832spandex
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
sped76031492sped_
speed85526622speed
spice95528812spice
spider94516802spider
spied85427712spied
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
splake1259782splake
spodes94817432spodes
spoke114818662spoke
spore75428592spore
spree74830862spree
sprue74717632sprue
spud75818492spud_
spuds85113672spuds
spue66025522sp_ue
spued84918472spued
spume95817312spume
stades74626242stades
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
state56237332state
stave85324992stave
suave83519872suave
suede64419752suede
swage94919562swage
swale85221592swale
sware85828212sware
swede94413202swede
trade65026042trade
tsade64311122tsade
wade85237062_wade

Search took 2 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.0931921408.6
2DLD Change Limit538001691.61033416.1
3Display Results1691690.0463673.9
 (SQL Overall)1786911691.749102167.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.