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 “spandex” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

264 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
spandex173583(None) 
pander93725522_pander
sanded84920612s_anded
sander74828532s_ander
slander84015442slander
spade84423322spa_de_
spaded103816752spa_ded
spader94317132spa_der
spades94222582spa_des
spadix1636112spa_dix
spancel1147362spancel
spandexes1943452spandexes
spandrel1144062spandrel
spaniel948922spaniel
spanked143111732spanked
spanker133612352spanker
spanned104111222spanned
spanner94312562spanner
spender103713692spender
spondee10310592spondee
standee83514512standee
stander84316162stander
annex12310883__annex
banded105223173_banded
bander93928223_bander
blander103715163blander
branded114414103branded
brander103915823brander
caudex1636403_caudex
coannex1635513coannex
dander811222993_dander
expanded19145163expanded
expander18145803expander
gander84322763_gander
glandes95413833glandes
grandee93115513grandee
grander93315873grander
handax1749583_handax
handed114919983_handed
hander104526433_hander
index13310983__index
islanded1035513islanded
islander946103islander
landed84619243_landed
lander74028483_lander
meander1049973meander
padded114113503_padded
padder103415493_padder
panda85022613_pand_a
pandas95521963_pandas
pandect12310953_pandect
panders103423733_panders
pandied113913443_pandied
pandies104224503_pandies
pandit93820753_pandit
pandy115021173_pand_y
pane64950293_pan_e_
paned85437183_pan_ed
panel76023623_pan_el
panes76148693_pan_es
panged104722333_panged
pangen94115913_pangen
panier84425503_panier
panne76623653_panne_
panned94123433_panned
panner84224763_panner
pannes85522853_pannes
panted95024823_panted
panzer174213233_panzer
pardee93922023_pardee
pended103819013_pended
pinder94523453_pinder
ponded105218773_ponded
ponder94521693_ponder
reannex1434733reannex
reindex1536093reindex
sadden83212403s_adden
sadder82916973s_adder
sade55544473s_a_de_
sades65239893s_a_des
sand55338473s_and__
sandal73317283s_andal
sandbox1744803s_andbox
sanders84025943s_anders
sandhi1038193s_andhi
sandier84017843s_andier
sandmen1039413s_andmen
sands65228583s_and_s
sandy94221133s_and_y
sane45954343s_an_e_
saned65636273s_an_ed
saner54334323s_an_er
sanes55649073s_an_es
sanger74524563s_anger
sanies63031953s_anies
sansei63411903s_ansei
scalded11409763scalded
scandal1038673scandal
scandent1148493scandent
scandia1038063scandia
scandic1237003scandic
scanned104110893scanned
scanner94411813scanner
scanted104114393scanted
scanter94215183scanter
scended11329873scended
seance83716683seance_
seances93015343seances
sended85121233s_ended
sender73824413s_ender
shade95125583sha_de_
shaded114518873sha_ded
shader104218763sha_der
shades105924533sha_des
shandies122714103shandies
shandy134710033shand_y
shanked153212123shanked
shantey134210043shantey
skanked11338103skanked
skanker10268483skanker
slanders94014013slanders
slanged94112853slanged
slanted83514743slanted
slender83413593slender
solander948123solander
sonde64622833s_onde_
sonder73623523s_onder
sondes74922873s_ondes
sounded93214463sounded
sounder83315383sounder
space95325673spa_ce_
spaced114517253spa_ced
spacer104917793spa_cer
spaces104722633spa_ces
spacey136212533spa_cey
spacier114011633spacier
spaders104214473spa_ders
spado83713703spa_d_o
spae65034323spa__e_
spaed85522273spa__ed
spaes76029973spa__es
spahee11313443spa_hee
spahees1238263spahees
spake114322743spa_ke_
spaldeen1142773spaldeen
spale74929213spa_le_
spales84728103spa_les
spalled103113133spalled
spaller92713473spaller
spammed14348523spammed
spammer133410433spammer
span65234663span___
spancels1245273spancels
spandrels1243253spandrels
spandril1144093spandril
spang84919733span__g
spangle1038403spangle
spangled1236153spangled
spangles1138893spangles
spangly1336473spangly
spaniels1045963spaniels
spank115919573span__k
spankers14369863spankers
spanks124514123span_ks
spanless10247363spanless
spanners103710773spanners
spans74528733span__s
spare75135563spa_re_
spared95427493spa_red
sparer84524963spa_rer
spares84834553spa_res
sparge94216053sparge_
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparked143513143sparked
sparker133914363sparker
sparred104512863sparred
sparse84516343sparse_
sparser94311483sparser
spasmed12296993spasmed
spate74731583spa_te_
spates85028173spa_tes
spathe115115693spathe_
spathed134013183spathed
spathes125116533spathes
spatted104014143spatted
spatter94016523spatter
spavie113611383spavie_
spavies123012943spavies
spaviet123011923spaviet
spawned13316803spawned
spawner12347363spawner
spayed124213613spa_yed
spazzes1735263spazzes
speaned103411523spean_ed
speeded113310423speeded
speeder103811073speeder
spence103813793spence_
spencer113610973spencer
spences113413923spences
spend85619333spend__
spenders113211743spenders
spendier1147143spendier
spends94714473spend_s
spendy124911143spend_y
spense83912433spense_
spenses92913573spenses
spider94516803sp_ider
spindle103210093spindle
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindly13257383spindly
spine76534423spin_e_
spined95423943spin_ed
spinel85317333spin_el
spines85132033spin_es
spinet85629753spin_et
spinier93715163spinier
spinifex2042053spinifex
spinner93912263spinner
spinney12438923spinney
spode84617703sp_ode_
spodes94817433sp_odes
spondees1136483spondees
sponge939663sponge_
sponged1137953sponged
sponger1038523sponger
sponges10311043sponges
spudded12235903spudded
spudder11256553spudder
spunked14307783spunked
squander1835533squander
stade64825303sta_de_
stades74626243sta_des
staider83912613staider
stance84316913stance_
stances93715963stances
stand65923283stand__
standby1334423standby
standees93310143standees
standers93514303standers
stands75118053stand_s
standup1034353standup
stane55933003stan_e_
staned74824643stan_ed
stanes64933403stan_es
stanged94113843stanged
stranded102710813stranded
strander97112063strander
subindex1843453subindex
sunder74019823s_under
sundew10369693s_undew
swanked15359543swanked
swanker14369483swanker
swanned11358173swanned
swarded1238153swarded
syndet10311963s_yndet
tandem9311403_tandem
upended11267323upended
uplander1145533uplander
wander104423713_wander
zander163417113_zander

Search took 7 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272646.73319906.0
3Display Results2642640.0932838.7
 (SQL Overall)1786912646.96925640.8
 
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.