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

224 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
spale7492921(None) 
pale66055011_pale
sale44959701s_ale
scale74629141scale
shale85332831shale
space95325671space
spade84423321spade
spae65034321spa_e
spake114322741spake
spales84728101spales
spall74919301spall
spare75135561spare
spate74731581spate
spile75230081spile
stale55637101stale
swale85221591swale
ale36572342__ale
apace94718382apace
apple94517672apple
bale66353842_bale
dale55643982_dale
empale102611262empale
gale56347322_gale
hale76052832_hale
impale102811662impale
kale86533752_kale
male66052302_male
maple95521142maple
opal66923522opal_
opals75718352opals
pace86345772_pace
padle84522342_padle
page76036102_page
pal56761672_pal_
palea75028662_palea
paled85538722_paled
paler75436932_paler
pales75753802_pales
palet74650802_palet
pall65039342_pall
palm85331362_palm
palp85828572_palp
pals66951352_pals
paly95835532_paly
pane64950292_pane
pare66760842_pare
parle75836162_parle
pase65346862_pase
pate65350462_pate
pave96133892_pave
pele65539552_pele
pile65649692_pile
pole65951302_pole
psalm949272psalm
pule65040952_pule
quale143617852quale
rale45050562_rale
sabe66140572s_abe
sable74732162sable
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sal36462882s_al_
salep77022952s_alep
sales56055592s_ales
sall44544682s_all
salp64534092s_alp
sals46851672s_als
salt45758522s_alt
salve85022132s_alve
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
save75741362s_ave
scald84818122scald
scaled94822442scaled
scaler84321602scaler
scales84529312scales
scall74420372scall
scalp95217982scalp
scaly104718722scaly
scape96921842scape
scare75334462scare
seal45654372seal_
sealed74328362sealed
sealer63928962sealer
seals54839702seals
selle54428312selle
sepal77723002sepal_
sepaled10510592sepaled
sepals85217382sepals
shade95125582shade
shake124726402shake
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534492shalt
shaly114322862shaly
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
sial45938832sial_
sials54227242sials
sidle65124032sidle
skald104210172skald
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
small74016262small
smalt74729332smalt
smaze165012932smaze
smile74823922smile
snake94821112snake
snare54429982snare
soave84219052soave
socle7419572socle
sole46053672s_ole
spa55730812spa__
spaced114517252spaced
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spackle15369572spackle
spacy125415622spacy
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spaed85522272spaed
spaes76029972spaes
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spails84817822spails
spait75631602spait
spalled103113132spalled
spaller92713472spaller
spalls84217342spalls
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spangle1038402spangle
spank115919572spank
spans74528732spans
spar65433302spa_r
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
spark114920892spark
sparkle133710212sparkle
spars75431542spars
sparse84516342sparse
spas67036722spa_s
spasm94514172spasm
spat66548522spa_t
spates85028172spates
spathe115115692spathe
spats75031382spats
spatzle1834582spatzle
spavie113611382spavie
spawn107811712spawn
spay96631662spa_y
spayed124213612spayed
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
speel74420762speel
spell75020302spell
spelt75430192spelt
spice95528812spice
spiel74623912spiel
spike114922842spike
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spine76534422spine
spire75828692spire
spite75430662spite
splake1259782splake
splat76129342splat
splay105816042splay
spode84617702spode
spoke114818662spoke
spore75428592spore
spree74830862spree
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
stable83921642stable
stade64825302stade
stage65330192stage
stake95927532stake
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stane55933002stane
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
stele55026842stele
stile54931572stile
stole54928812stole
style85519362style
suable83920552suable
suave83519872suave
supple10410202supple
swage94919562swage
swales93920762swales
sware85828212sware
tale46154162_tale
vale74937342_vale
wale74546432_wale
whale115517432whale

Search took 10 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 Filter178691538001.423125573.4
2DLD Change Limit538002247.7506941.9
3Display Results2242240.1261777.8
 (SQL Overall)1786912249.29919216.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.