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

159 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
spades9422258(None) 
sades65239891s_ades
shades105924531shades
spaces104722631spaces
spade84423321spade_
spaded103816751spaded
spader94317131spader
spaders104214471spaders
spaes76029971spa_es
spales84728101spales
spares84834551spares
spates85028171spates
spodes94817431spodes
stades74626241stades
blades95221252blades
cades85440732_cades
clades94920462clades
epodes94315562epodes
evades1039022evades
fades94932862_fades
glades84820342glades
grades84926312grades
hades96035112_hades
irades74517392irades
jades135222112_jades
lades65141272_lades
paces96741112_paces
padis86227142_padis
padles95221122_padles
padres95016982_padres
pads76742952_pad_s
pages85235072_pages
pales75753802_pales
panes76148692_panes
pares77164482_pares
pases75346502_pases
pates76047892_pates
paves104833922_paves
paxes144928422_paxes
pedes85327282_pedes
respades1139852respades
sabes76437462s_abes
sade55544472s_ade_
sadhes104715372s_adhes
sadis64930852s_adis
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sales56055592s_ales
sanes55649072s_anes
sates54949322s_ates
saves85838632s_aves
saxes125229342s_axes
scads85419962scad_s
scales84529312scales
scapes105122262scapes
scares85033002scares
shade95125582shade_
shaded114518872shaded
shader104218762shader
shaders115915552shaders
shads95124482shad_s
shakes135024592shakes
shales94731252shales
shames114726222shames
shapes115124942shapes
shares95236412shares
shaves125224932shaves
sides65838362s_ides
skates104219402skates
slakes104021882slakes
slates64934062slates
slaves95023022slaves
slides73922182slides
smazes174311662smazes
snakes103919602snakes
snares65329032snares
soaves94218672soaves
sondes74922872sondes
space95325672space_
spaced114517252spaced
spacer104917792spacer
spacers113813872spacers
spacey136212532spacey
spadices1336092spadices
spadix1636112spadix
spadixes1834112spadixes
spado83713702spad_o
spadones1137252spadones
spae65034322spa_e_
spaed85522272spa_ed
spahee11313442spahee
spahees1238262spahees
spahis11310382spahis
spails84817822spails
spaits85017472spaits
spake114322742spake_
spale74929212spale_
spalls84217342spalls
spams94922192spa_ms
spandex1735832spandex
spanks124514122spanks
spans74528732spa_ns
spare75135562spare_
spared95427492spared
sparer84524962sparer
sparers94519612sparers
sparest94616422sparest
sparges104016342sparges
sparks124616362sparks
spars75431542spa_rs
sparse84516342sparse
spas67036722spa__s
spasms10418972spasms
spate74731582spate_
spathes125116532spathes
spats75031382spa_ts
spavies123012942spavies
spawns11577922spawns
spayed124213612spayed
spays105520512spa_ys
spazzes1735262spazzes
speeds94316052speeds
spices104326032spices
spider94516802spider
spiders103914412spiders
spies76037622sp_ies
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
splakes1349672splakes
spode84617702spode_
spokes124417212spokes
spores84726612spores
sprees85620642sprees
sprues84515762sprues
spuds85113672spud_s
spues75025382sp_ues
spumes1021314882spumes
stade64825302stade_
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
stapes85028732stapes
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
suedes73918112suedes
swages104417072swages
swales93920762swales
swedes102711892swedes
trades75724502trades
tsades74310992tsades
upases84112902upases
wades95634142_wades

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 Filter178691825510.1101624463.6
2DLD Change Limit825511592.62331472.0
3Display Results1591590.0503180.0
 (SQL Overall)1786911592.78364208.0
 
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.