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

292 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
slate5543828(None) 
alate55340321alate
blate75933781blate
elate55335881elate
late47560481_late
plate74635111plate
sate45556101s_ate
skate94721551skate
slake93724051slake
slat46959021slat_
slated75028311slated
slater64429181slater
slates64934061slates
slatey95417061slatey
slats55436901slats
slaty86523151slaty
slave84224031slave
solate64526071solate
spate74731581spate
state56237331state
abate76627842abate
ablate82219212ablate
agate66525152agate
alae45643752ala_e
alane56135612alane
alated75625142alated
alates64833962alates
ate37059242__ate
bate66552422_bate
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blat66550952blat_
blats75132502blats
blaze165520832blaze
blite76225352blite
cate66254602_cate
clade85821012clade
clave105420152clave
crate76537402crate
date56443322_date
delate73827752delate
dilate73220692dilate
elated74725822elated
elater64724202elater
elates65032362elates
elite56230182elite
eluate62315432eluate
elute54822572elute
enate54428142enate
estate64719762estate
fate75444282_fate
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flite85424962flite
flute86823752flute
flyte115713942flyte
folate93320392folate
gate55746572_gate
gelate73421252gelate
glace87420152glace
glade75121962glade
glare65222952glare
glaze155418162glaze
glute66020902glute
grate64932882grate
hate78450172_hate
irate55627982irate
isolate7313922isolate
lace66848472_lace
lade56345982_lade
lake85741602_lake
lame66849292_lame
lane45153332_lane
lase46148512_lase
lat37593402_lat_
lated65240672_lated
laten54328342_laten
later54843922_later
latex124717112_latex
lath76640382_lath
lathe85626712_lathe
lati46438272_lati
latke94817092_latke
lats45962702_lats
latte55426302_latte
latu47934182_latu
lave75642142_lave
laze136235052_laze
lite47054542_lite
lute46341012_lute
malate84624552malate
mate65154222_mate
oblate82214742oblate
oleate6318882oleate
orate55133302orate
ovate84214392ovate
palate84226782palate
pate65350462_pate
place94824612place
plage84520402plage
plane74929142plane
plat66048872plat_
plated95225772plated
platen84518202platen
plater84427692plater
plates85432242plates
plats75531372plats
platy105021662platy
prate75135982prate
quate144521412quate
rate45458762_rate
relate64033632relate
reslate73520592reslate
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
salt45758522salt_
salted74121202salted
salter64325082salter
saltie63422432saltie
salts55431882salts
salty85524382salty
salute64418022salute
salve85022132salve
same65245642s_ame
sane45954342s_ane
sat36288482s_at_
sated66238532s_ated
satem76021462s_atem
sates54949322s_ates
sati45539332s_ati
saute55028082saute
savate9313782savate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
scat65848372scat_
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scute75520942scute
seat47575562seat_
seated75131052seated
seater64534152seater
seats54844342seats
sedate73019802sedate
senate63725142senate
sente56432872sente
setae56026222setae
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shat76456602shat_
shave114425892shave
shote85526102shote
shute84520352shute
silage72715302silage
silane62718052silane
site47052412s_ite
sixte126216582sixte
skat87037902skat_
skated114414882skated
skater105015492skater
skates104219402skates
skats94621542skats
skite95120052skite
slab67133762sla_b
slabs75322642slabs
slack115021762slack
slag55934352sla_g
slags66525902slags
slain54923572slain
slainte738542slainte
slaked114318272slaked
slaker104219272slaker
slakes104021882slakes
slam67737972sla_m
slams74927902slams
slang66324022slang
slank95822772slank
slant55238702slant
slanted83514742slanted
slants64819082slants
slanty95114842slanty
slap66434042sla_p
slaps76025712slaps
slash84719682slash
slatch114510532slatch
slaters73123732slaters
slather103816072slather
slatier74016812slatier
slatted84015182slatted
slaved104017042slaved
slaver94419612slaver
slaves95023022slaves
slavey124011802slavey
slaw77930712sla_w
slaws85222712slaws
slay76436382sla_y
slayed104716222slayed
slayer93916332slayer
slays85723682slays
sleave94714152sleave
sleaze152611862sleaze
sleet55639132sleet
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
sloe45534952sl_oe
slope75823562slope
slot46049832slot_
sloth85019452sloth
slots54830532slots
slue45332192sl_ue
slut45040592slut_
sluts54523982sluts
slype105112362slype
smaze165012932smaze
smite75224872smite
smote75820282smote
snake94821112snake
snare54429982snare
snath86419802snath
snathe94415112snathe
soave84219052soave
solace83415822solace
solated83618022solated
solates73523852solates
solute64016662solute
solvate102710212solvate
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
spat66548522spat_
spates85028172spates
spathe115115692spathe
spats75031382spats
spite75430662spite
splake1259782splake
splat76129342splat_
splats84817302splats
stacte82113912stacte
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
stat47352692stat_
stated75427832stated
stater64427562stater
states64337082states
stats55933362stats
statue66015322statue
stave85324992stave
stylate10179772stylate
suave83519872suave
sublate9315362sublate
suite54829562suite
sulcate9314422sulcate
sulfate10311652sulfate
swage94919562swage
swale85221592swale
sware85828212sware
swat77244442swat_
swath115920382swath
swathe125514112swathe
swats85726862swats
tate44748602_tate
urate55432162urate
velate93720142velate
zlote143912942zlote

Search took 2 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.0802233637.5
2DLD Change Limit538002921.70331591.3
3Display Results2922920.0763842.1
 (SQL Overall)1786912921.85996122.1
 
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.