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

145 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
snake9482111(None) 
sake85244961s_ake
shake124726401shake
slake93724051slake
snaked115017591snaked
snakes103919601snakes
snakey135011271snakey
snaky125113911snaky
snare54429981snare
spake114322741spake
stake95927531stake
ananke1038282ananke
awake125014782awake
bake105637512_bake
brake116025342brake
cake105439962_cake
crake114823522crake
drake104918302drake
enate54428152enate
fake115534942_fake
flake125119972flake
hake115637842_hake
inane52820342inane
intake10510862intake
jake155925772_jake
knave12389462knave
knawe12397882knawe
lake85741602_lake
make105537892_make
nabe66029492_nabe
nae35952742_na_e
naked105320852_naked
name65637412_name
nape65230802_nape
nave75732312_nave
nuke85920752_nuke
quake184114642quake
rake84841572_rake
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
saker95132022s_aker
sakes95540752s_akes
saki85628482s_aki
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sank85236832sank_
sate45556102s_ate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
senate63725172senate
shade95125582shade
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516092shako
shaky154616842shaky
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
sike87138782s_ike
skate94721552skate
slaked114318272slaked
slaker104219272slaker
slakes104021882slakes
slate55438282slate
slave84224032slave
smaze165012932smaze
smoke115015822smoke
snack114718062snack
snacked144013112snacked
snacker133112602snacker
snacks124514552snacks
snafu8412142snafu
snag55827872sna_g
snags64421312snags
snail57020202snail
snakier112810002snakier
snap65727032sna_p
snaps74719562snaps
snared74824552snared
snarer64620842snarer
snares65329032snares
snarf86525422snarf
snark95419942snark
snarks104815732snarks
snarky134210842snarky
snarl54921082snarl
snash84815672snash
snath86419802snath
snathe94415112snathe
snaw78923072sna_w
snawed104813732snawed
snaws86116362snaws
sneak96016172sneak_
sneaked12329692sneaked
sneaker112910452sneaker
sneaks104312492sneaks
sneaky13427842sneaky
snide64318722snide
snipe75320572snipe
snore55424952snore
snye77115492sn_ye
soak87227662soak_
soaked114717592soaked
soaker105717532soaker
soaks95220292soaks
soave84219052soave
soke85436262s_oke
space95325672space
spade84423322spade
spae65034322spa_e
spale74929212spale
spare75135562spare
spate74731582spate
spike114922842spike
splake1259782splake
spoke114818662spoke
stade64825302stade
stage65330192stage
staked114621942staked
stakes103927292stakes
stale55637102stale
stane55933002stane
stare54440262stare
state56237332state
stave85324992stave
stoke94922512stoke
strake104017392strake
suave83519872suave
swage94919562swage
swale85221592swale
sware85828212sware
syke115420562s_yke
take84739262_take
uncake122813522uncake
unmake122811212unmake
wake114935702_wake

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.360496363.9
2DLD Change Limit538001451.48336277.8
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.88994595.6
 
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.