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

199 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
shake12472640(None) 
hake115637841_hake
sake85244961s_ake
shade95125581shade
shaken134113611shaken
shaker134319461shaker
shakes135024591shakes
shako125516081shako
shaky154616841shaky
shale85332831shale
shame105726701shame
shape105125111shape
share86437081share
shave114425891shave
slake93724051slake
snake94821111snake
spake114322741spake
stake95927531stake
ashcake1663372ashcake
awake125014782awake
bake105637512_bake
brake116025342brake
cake105439962_cake
chafe135117352chafe
chape125221142chape
chare105231982chare
chase105127122chase
choke145118022choke
crake114823522crake
dhak125512032dhak_
dhaks13479702dhaks
drake104918302drake
fake115534942_fake
flake125119972flake
hade85440192_hade
hae67364002_ha_e
hakes126034302_hakes
haku116923892_haku
hale76052832_hale
hame97043132_hame
hare76255732_hare
hate78450172_hate
have106137072_have
haze164833392_haze
hike116830392_hike
hoke115935932_hoke
jake155925772_jake
khaki1157642khaki
lake85741602_lake
make105537882_make
phage115113672phage
phase104617212phase
quake184114642quake
rake84841572_rake
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
saker95132022s_aker
sakes95540752s_akes
saki85628472s_aki
sale44959702s_ale
same65245642s_ame
sane45954332s_ane
sate45556102s_ate
save75741362s_ave
scale74629142scale
scape96921842scape
scare75334462scare
sha69837782sha__
shack145321752shack
shacked174015392shacked
shackle16409542shackle
shacko153810112shacko
shacks154817562shacks
shad86230912sha_d
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shaft115725252shaft
shag86430562sha_g
shags95123862shags
shah105627782sha_h
shahs115919512shahs
shakers144015562shakers
shakeup1632762shakeup
shakier143411152shakier
shakoes144510012shakoes
shakos134912182shakos
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534482shalt
shaly114322862shaly
sham96436352sha_m
shamed125120212shamed
shames114726222shames
shams105829412shams
shank125422192shank
shanked153212122shanked
shanks135315582shanks
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapes115124942shapes
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharked153613902sharked
sharker144313812sharker
sharks135019722sharks
sharn84823702sharn
sharp104922532sharp
shat76456592sha_t
shaul85418102shaul
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shaves125224932shaves
shavie124312412shavie
shaw108132552sha_w
shawed134817232shawed
shawl116217572shawl
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shay107133342sha_y
shays116021432shays
she66837692sh__e
sheave124514002sheave
shekel1338382shekel
shikse1386072shikse
shine85533092shine
shire84727132shire
shitake1455612shitake
shive114423422shive
shoe75933432sh_oe
shone83725972shone
shore85432642shore
shote85526082shote
shove114421032shove
shrike134513242shrike
shute84520342shute
sike87138782s_ike
skate94721542skate
slaked114318272slaked
slaker104219272slaker
slakes104021882slakes
slate55438282slate
slave84224032slave
smaze165012932smaze
smoke115015822smoke
snaked115017592snaked
snakes103919602snakes
snakey135011272snakey
snaky125113912snaky
snare54429982snare
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
thae76825562tha_e
thane86122532thane
wake114935702_wake
whale115517432whale

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.0931921408.6
2DLD Change Limit538001991.67332157.8
3Display Results1991990.0464326.1
 (SQL Overall)1786911991.81298615.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.