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

236 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
spate7473158(None) 
pate65350461_pate
sate45556101s_ate
skate94721551skate
slate55438281slate
space95325671space
spade84423321spade
spae65034321spa_e
spake114322741spake
spale74929211spale
spare75135561spare
spat66548521spat_
spates85028171spates
spathe115115691spathe
spats75031381spats
spite75430661spite
state56237331state
abate76627842abate
agate66525152agate
alate55340322alate
apace94718382apace
ate37059242__ate
bate66552422_bate
blate75933782blate
cate66254602_cate
crate76537402crate
cuspate1138232cuspate
date56443322_date
elate55335882elate
enate54428152enate
estate64719762estate
fate75444282_fate
gate55746572_gate
grate64932882grate
hate78450172_hate
irate55627982irate
late47560482_late
mate65154222_mate
opiate8513462opiate
orate55133302orate
ovate84214392ovate
pace86345772_pace
page76036102_page
pale66055012_pale
pane64950292_pane
pare66760842_pare
pase65346862_pase
paste74932952_paste
pat58089462_pat_
pated85237842_pated
paten74827342_paten
pater74740722_pater
pates76047892_pates
path99134912_path
pats66460852_pats
paty95234562_paty
pave96133892_pave
plate74635112plate
prate75135982prate
pupate104213122pupate
quate144521412quate
rate45458762_rate
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sapote8314362sapote
sat36288482s_at_
sated66238532s_ated
satem76021462s_atem
sates54949322s_ates
sati45539332s_ati
saute55028082saute
savate9313782savate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
scat65848372scat_
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scute75520942scute
seat47575562seat_
seated75131062seated
seater64534162seater
seats54844342seats
sedate73019812sedate
senate63725172senate
sente56432882sente
septate9511872septate
setae56026222setae
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat_
shave114425892shave
shote85526102shote
shute84520352shute
site47052412s_ite
sixte126216582sixte
skat87037902skat_
skated114414882skated
skater105015492skater
skates104219402skates
skats94621542skats
skite95120052skite
slake93724052slake
slat46959022slat_
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slave84224032slave
smaze165012932smaze
smite75224872smite
smote75820282smote
snake94821112snake
snare54429982snare
snath86419802snath
snathe94415112snathe
soave84219052soave
solate64526072solate
sopite84917712sopite
spa55730812spa__
spaced114517252spaced
spacer104917792spacer
spaces104722632spaces
spacey136212532spacey
spacy125415622spacy
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spaed85522272spaed
spaes76029972spaes
spahee11313442spahee
spahi10311142spahi
spail74921552spail
spait75631602spait
spaits85017472spaits
spales84728102spales
spall74919302spall
spam85930042spa_m
spams94922192spams
span65234662spa_n
spang84919732spang
spank115919572spank
spans74528732spans
spar65433302spa_r
spared95427492spared
sparer84524962sparer
spares84834552spares
sparge94216052sparge
spark114920892spark
spars75431542spars
sparse84516342sparse
spas67036722spa_s
spasm94514172spasm
spathed134013182spathed
spathes125116532spathes
spatted104014142spatted
spatter94016522spatter
spatzle1834582spatzle
spavie113611382spavie
spawn107811712spawn
spay96631662spa_y
spayed124213612spayed
spays105520512spays
spaz155626162spa_z
spazz155811132spazz
spicate113214192spicate
spice95528812spice
spike114922842spike
spile75230082spile
spinate93114812spinate
spine76534422spine
spire75828692spire
spit65545082spit_
spited94820442spited
spites84127332spites
spits74429552spits
spitz166017972spitz
splake1259782splake
splat76129342splat_
splats84817302splats
spode84617702spode
spoke114818662spoke
spore75428592spore
spot65540692spot_
spots74424112spots
sprat76635972sprat_
sprats85819932sprats
spree74830862spree
sprite84421772sprite
sprue74717632sprue
spue66025522sp_ue
spume95817312spume
sputa74612962sputa
stacte82113912stacte
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
stat47352692stat_
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
stave85324992stave
suave83519872suave
suite54829562suite
swage94919562swage
swale85221592swale
sware85828212sware
swat77244442swat_
swath115920382swath
swathe125514112swathe
swats85726862swats
tate44748602_tate
update93810292update
uprate83916542uprate
urate55432162urate

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.296603685.8
2DLD Change Limit538002362.25023911.1
3Display Results2362360.0633746.0
 (SQL Overall)1786912362.60968490.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.