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

201 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
stade6482530(None) 
sade55544481s_ade
shade95125581shade
spade84423321spade
stades74626241stades
stage65330191stage
stake95927531stake
stale55637101stale
stane55933001stane
stare54440261stare
state56237331state
stave85324991stave
tsade64311121tsade
bade75140892_bade
blade85923332blade
cade76443922_cade
clade85821012clade
estate64719762estate
etape74413702etape
etude63612302etude
evade938182evade
fade85736352_fade
glade75121962glade
grade75126092grade
hade85440202_hade
irade65618152irade
jade125325452_jade
lade56345992_lade
made75440252_made
sabe66140572s_abe
sad47459212s_ad_
sades65239892s_ades
sadhe94815132s_adhe
sadi55834652s_adi
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
sated66238532sated
save75741362s_ave
scad75725772scad_
scads85419962scads
scale74629142scale
scape96921842scape
scare75334462scare
setae56026222seta_e
shad86230912shad_
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
side55444502s_ide
skate94721552skate
slake93724052slake
slate55438282slate
slave84224032slave
slide64725422slide
smaze165012932smaze
snake94821112snake
snare54429982snare
snide64318732snide
soave84219052soave
sonde64622832sonde
space95325672space
spaded103816752spaded
spader94317132spader
spades94222582spades
spado83713702spado
spae65034322spa_e
spaed85522272spaed
spake114322742spake
spale74929212spale
spare75135562spare
spate74731582spate
spode84617702spode
stab67329932sta_b
stable83921642stable
stabs76221382stabs
stack114421692stack
stacte82113912stacte
staddle9288092staddle
stadia7312142stadia
staff113817712staff
stag57332002sta_g
staged84521562staged
stager74821342stager
stages75629492stages
stagey105915582stagey
stags66226742stags
stagy96618892stagy
staid66722082staid
staider83912612staider
staig65519642staig
stain55727942stain
stair54719942stair
staked114621942staked
stakes103927292stakes
staled74728102staled
staler64025822staler
stales65538292stales
stalk94518002stalk
stall54722352stall
stamen84115942stamen
stamp95217362stamp
stance84316912stance
stand65923282stand
standee83514512standee
stander84316162stander
stands75118052stands
staned74824642staned
stanes64933402stanes
stang66424692stang
stank95823302stank
stapes85028732stapes
staph104314652staph
staple84415822staple
star48037762sta_r
stared75429872stared
starer64027362starer
stares66038752stares
stark95425622stark
stars55836572stars
start55642312start
starve94613742starve
stases64225562stases
stash84916972stash
stat47352692sta_t
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
staved103918052staved
staves94525192staves
staw78627692sta_w
stay78333722sta_y
stayed104817272stayed
stayer94516482stayer
stays86022022stays
stead65520272stead_
steaded92811672steaded
steads74116222steads
steady103510202steady
steed66024942steed
stele55026842stele
stere55328542stere
stied65723032stied
stile54931572stile
stime76521802stime
stipe76523372stipe
stoae55024262stoae
stodge8369042stodge
stoke94922512stoke
stole54928812stole
stone55431182stone
stope74727242stope
store56333812store
stove85220252stove
strafe95215982strafe
strake104017392strake
stride75420962stride
strode75215972strode
stud56220092stud_
studs64415872studs
study94411792study
stupe75217752stupe
stye76218972st_ye
styed95815482styed
style85519362style
suave83519872suave
suede64419752suede
swage94919562swage
swale85221592swale
sware85828212sware
swede94413202swede
tace65342512_tace
tad47959832_tad_
tads57143952_tads
tae38267052_ta_e
take84739262_take
tale46154162_tale
tame66343662_tame
tape64538152_tape
tare45957622_tare
tate44748602_tate
tide55237392_tide
trade65026042trade
tsades74310992tsades
tsadi6379912tsadi
wade85237072_wade

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.310576422.6
2DLD Change Limit538002011.72031279.1
3Display Results2012010.0633190.5
 (SQL Overall)1786912012.09385375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.