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

192 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
scape9692184(None) 
cape87242781_cape
escape103811661escape
scale74629141scale
scaped115519551scaped
scapes105122261scapes
scare75334461scare
scope94821481scope
scrape105917571scrape
shape105125111shape
agape85614842agape
ape57251182__ape
cade76443912_cade
cafe95230322_cafe
cage75339062_cage
cake105439962_cake
came87648752_came
cane66653122_cane
cap76758982_cap_
caped104931802_caped
caper94831622_caper
capes95441922_capes
caph116623292_caph
capo85829212_capo
caps87147892_caps
care66968372_care
case65848082_case
cate66254602_cate
cave95941262_cave
cepe84926652_cepe
chape125221142chape
cope86847382_cope
crape96128442crape
drape85319632drape
escaped12388852escaped
escapee113310462escapee
escaper11368842escaper
escapes113811672escapes
etape74413702etape
gape75134512_gape
grape84824662grape
inscape1138012inscape
jape134923422_jape
nape65230802_nape
rape65041632_rape
sabe66140572s_abe
sade55544472s_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
scab85926712sca_b
scabs94818642scabs
scad75725772sca_d
scads85419962scads
scag76626892sca_g
scags85520972scags
scald84818122scald
scaled94822442scaled
scaler84321602scaler
scales84529312scales
scall74420372scall
scalp95217982scalp
scalped124411992scalped
scalpel11377712scalpel
scalper113912922scalper
scalps104315232scalps
scaly104718722scaly
scam85932352sca_m
scamp115717312scamp
scamped144711962scamped
scamper134613162scamper
scampi12469102scampi
scamps125014172scamps
scams94423972scams
scan65530452sca_n
scans74625102scans
scant79735072scant
scapose1147752scapose
scar66434202sca_r
scarce104013632scarce
scared95227292scared
scarer84524612scarer
scares85033002scares
scarey115016982scarey
scarf105427142scarf
scarp95724102scarp
scarped124314402scarped
scarper114814822scarper
scarph13429602scarph
scarps104718602scarps
scars75433532scars
scart76139772scart
scary105222592scary
scat65848372sca_t
scathe114414992scathe
scats75930602scats
scatt76030092scatt
scaup95515992scaup
scauper11379452scauper
scaups105411932scaups
scaur75814902scaur
scene77220572scene
schappe1635262schappe
scone74621832scone
scop85925522scop_
scoped115116652scoped
scopes104719592scopes
scops95820192scops
score75526742score
scrap97120402scrap_
scraped124313132scraped
scraper114513422scraper
scrapes116217662scrapes
scrapie115010942scrapie
scraps106017242scraps
scree720031712scree
scup84822382scup_
scups95316652scups
scute75520942scute
serape84818412serape
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapes115124942shapes
share86437082share
shave114425892shave
sipe67341042s_ipe
skate94721552skate
slake93724052slake
slap66434042slap_
slaps76025712slaps
slate55438282slate
slave84224032slave
slipe75626132slipe
slope75823562slope
slype105112362slype
smaze165012932smaze
snake94821112snake
snap65727032snap_
snaps74719562snaps
snare54429982snare
snipe75320572snipe
soap65831132soap_
soaped95817972soaped
soaper84517872soaper
soaps75120712soaps
soapy106114782soapy
soave84219052soave
socage91012122socage
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
tape64538142_tape

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.296603685.8
2DLD Change Limit538001921.72031279.1
3Display Results1921920.1231561.0
 (SQL Overall)1786911922.13983539.5
 
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.