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

195 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
slake9372405(None) 
flake125119971flake
lake85741601_lake
sake85244961s_ake
shake124726401shake
slaked114318271slaked
slaker104219271slaker
slakes104021881slakes
slate55438281slate
slave84224031slave
snake94821111snake
spake114322741spake
splake1259781splake
stake95927531stake
alae45643752ala_e
alane56135612alane
alate55340332alate
alike95523962alike
awake125014782awake
bake105637512_bake
blade85923332blade
blae66134642bla_e
blame95625492blame
blare75826232blare
blase75524232blase
blate75933782blate
blaze165520832blaze
bloke114316632bloke
brake116025342brake
cake105439962_cake
clade85821012clade
clave105420152clave
crake114823522crake
drake104918302drake
elate55335882elate
fake115534942_fake
flak116026172flak_
flaked144715652flaked
flaker134916172flaker
flakes134118872flakes
flakey164410512flakey
flaky155715582flaky
flame105124442flame
flare84823632flare
fluke125016892fluke
glace87420162glace
glade75121962glade
glare65222962glare
glaze155418162glaze
hake115637842_hake
jake155925772_jake
lace66848472_lace
lade56345982_lade
laked105731122_laked
laker95432872_laker
lakes95737652_lakes
lakh114919952_lakh
laky116725822_laky
lame66849292_lame
lane45153332_lane
lase46148512_lase
late47560482_late
latke94817092_latke
lave75642142_lave
laze136235052_laze
leke85527402_leke
like86040842_like
make105537892_make
place94824612place
plage84520402plage
plane74929142plane
plate74635112plate
quake184114642quake
rake84841572_rake
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
saker95132022s_aker
sakes95540752s_akes
saki85628482s_aki
sale44959702s_ale
salve85022132salve
same65245642s_ame
sane45954342s_ane
sate45556102s_ate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
shade95125582shade
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516092shako
shaky154616842shaky
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
sike87138782s_ike
silage72715302silage
silane62718052silane
skate94721552skate
slab67133762sla_b
slabs75322642slabs
slack115021762slack
slacked143815452slacked
slacken13399932slacken
slacker133915292slacker
slacks124416532slacks
slag55934352sla_g
slags66525902slags
slain54923572slain
slakers114115752slakers
slam67737972sla_m
slams74927902slams
slang66324022slang
slank95822772slank
slant55238702slant
slap66434042sla_p
slaps76025712slaps
slash84719682slash
slat46959022sla_t
slated75028312slated
slater64429182slater
slates64934062slates
slatey95417062slatey
slats55436902slats
slaty86523152slaty
slaved104017042slaved
slaver94419612slaver
slaves95023022slaves
slavey124011802slavey
slaw77930712sla_w
slaws85222712slaws
slay76436382sla_y
slayed104716222slayed
slayer93916332slayer
slays85723682slays
sleave94714152sleave
sleaze152611862sleaze
sleek94619042sleek
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
sloe45534952sl_oe
slope75823562slope
slue45332192sl_ue
slype105112362slype
smaze165012932smaze
smoke115015822smoke
snaked115017592snaked
snakes103919602snakes
snakey135011272snakey
snaky125113912snaky
snare54429982snare
soak87227662soak_
soaked114717592soaked
soaker105717532soaker
soaks95220292soaks
soave84219052soave
soke85436262s_oke
solace83415822solace
solate64526072solate
space95325672space
spade84423322spade
spae65034322spa_e
spale74929212spale
spare75135562spare
spate74731582spate
spike114922842spike
splakes1349672splakes
spoke114818662spoke
stade64825302stade
stage65330192stage
staked114621942staked
stakes103927292stakes
stale55637102stale
stane55933002stane
stare54440262stare
state56237332state
stave85324992stave
stoke94922512stoke
strake104017392strake
suave83519872suave
swage94919562swage
swale85221592swale
sware85828212sware
syke115420562s_yke
take84739262_take
wake114935702_wake

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.343520965.0
2DLD Change Limit538001951.78030224.7
3Display Results1951950.0464239.1
 (SQL Overall)1786911952.16982384.0
 
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.