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

209 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
shape10512511(None) 
chape125221141chape
scape96921841scape
shade95125581shade
shake124726401shake
shale85332831shale
shame105726701shame
shaped125020101shaped
shapen114414651shapen
shaper114119931shaper
shapes115124951shapes
share86437081share
shave114425891shave
agape85614842agape
ape57251182__ape
cape87242782_cape
chafe135117352chafe
chap114928492chap_
chapel134911372chapel
chapes135421872chapes
chaps125326062chaps
chapt125827642chapt
chare105231982chare
chase105127122chase
crape96128442crape
drape85319632drape
escape103811662escape
etape74413702etape
gape75134512_gape
grape84824662grape
hade85440202_hade
hae67364002_ha_e
hake115637842_hake
hale76052832_hale
hame97043132_hame
hap87360052_hap_
haps96443462_haps
hare76255732_hare
hate78450172_hate
have106137072_have
haze164833392_haze
hope96639672_hope
hype125519812_hype
jape134923422_jape
khaph17395962khaph
nape65230802_nape
phage115113672phage
phase104617212phase
rape65041632_rape
reshape1249042reshape
rhaphe1433422rhaphe
sabe66140572s_abe
sade55544482s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
same65245642s_ame
sane45954342s_ane
sap56463232s_ap_
saps65346372s_aps
sarape84817572sarape
sate45556102s_ate
save75741362s_ave
scale74629142scale
scaped115519552scaped
scapes105122262scapes
scare75334462scare
schappe1635272schappe
scope94821482scope
scrape105917572scrape
serape84818412serape
sha69837782sha__
shack145321752shack
shad86230912sha_d
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shaft115725272shaft
shag86430562sha_g
shags95123862shags
shah105627782sha_h
shahs115919512shahs
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516092shako
shaky154616842shaky
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534492shalt
shaly114322862shaly
sham96436362sha_m
shamed125120212shamed
shames114726222shames
shams105829412shams
shank125422192shank
shapely1536892shapely
shapers124016892shapers
shapeup1443292shapeup
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
sharped134112052sharped
sharpen12389722sharpen
sharper124312702sharper
sharpie1238402sharpie
sharps115516082sharps
sharpy145211032sharpy
shat76456602sha_t
shaul85418102shaul
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shaves125224932shaves
shavie124312422shavie
shaw108132552sha_w
shawed134817232shawed
shawl116217572shawl
shawm135316152shawm
shawn116417612shawn
shaws116226262shaws
shay107133342sha_y
shays116021432shays
she66837692sh__e
sheave124514002sheave
sheep105321522sheep
shine85533092shine
ship95228242ship_
ships105123772ships
shire84727132shire
shive114423422shive
shlep104914832shlep
shnaps1148082shnaps
shoe75933442sh_oe
shone83725982shone
shop95629842shop_
shoppe133110322shoppe
shops104222902shops
shore85432652shore
shote85526102shote
shove114421042shove
shute84520352shute
sipe67341052s_ipe
skate94721552skate
slake93724052slake
slap66434042slap_
slaps76025712slaps
slate55438282slate
slave84224032slave
slipe75626132slipe
slope75823562slope
slype105112362slype
smaze165012932smaze
snake94821112snake
snap65727032snap_
snaps74719562snaps
snare54429982snare
snipe75320572snipe
soap65831132soap_
soaped95817972soaped
soaper84517872soaper
soaps75120712soaps
soapy106114782soapy
soave84219052soave
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
spate74731582spate
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stapes85028732stapes
staph104314652staph
staple84415822staple
stare54440262stare
state56237332state
stave85324992stave
stipe76523372stipe
stope74727242stope
stupe75217752stupe
suave83519872suave
supe65932762s_upe
swage94919562swage
swale85221592swale
swap95925432swap_
swaps104819202swaps
sware85828212sware
swipe105217082swipe
tape64538152_tape
thae76825562tha_e
thane86122532thane
whale115517432whale
whap125119642whap_
whaps135115162whaps

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.406440125.6
2DLD Change Limit538002091.64032804.9
3Display Results2092090.0633317.5
 (SQL Overall)1786912092.10984727.8
 
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.