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

182 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
scapes10512226(None) 
capes95441921_capes
escapes113811671escapes
scales84529311scales
scape96921841scape_
scaped115519551scaped
scares85033001scares
scopes104719591scopes
scrapes116217661scrapes
shapes115124941shapes
stapes85028731stapes
agapes95212412agapes
apes66047432__apes
cades85440732_cades
cafes106426922_cafes
cages85936012_cages
cakes116037672_cakes
cames97047312_cames
canes75350372_canes
cape87242782_cape_
caped104931802_caped
caper94831622_caper
capers105428142_capers
caphs124515372_caphs
capos94826072_capos
caps87147892_cap_s
cares77369182_cares
cases75048382_cases
cates75951892_cates
caves105639702_caves
cepes94424462_cepes
chapes135421872chapes
copes97747102_copes
crapes104727692crapes
drapes95419652drapes
escape103811662escape_
escaped12388852escaped
escapee113310462escapee
escapees12336332escapees
escaper11368842escaper
escapers12337412escapers
etapes85415292etapes
gapes86030822_gapes
grapes95123122grapes
inscapes1237812inscapes
japes146322822_japes
napes74828462_napes
rapes75740722_rapes
sabes76437462s_abes
sades65239892s_ades
safes85226722s_afes
sages65339062s_ages
sakes95540752s_akes
sales56055592s_ales
sanes55649072s_anes
saps65346372s_ap_s
sarapes94617742sarapes
sates54949322s_ates
saves85838632s_aves
saxes125229342s_axes
scabies11613332scabies
scabs94818642sca_bs
scads85419962sca_ds
scags85520972sca_gs
scalds94813692scalds
scale74629142scale_
scaled94822442scaled
scaler84321602scaler
scalers93817262scalers
scalls84218202scalls
scalped124411992scalped
scalpel11377712scalpel
scalpels12345882scalpels
scalper113912922scalper
scalpers123710862scalpers
scalps104315232scalps
scamped144711962scamped
scamper134613162scamper
scampers143611032scampers
scampies1439322scampies
scamps125014172scamps
scams94423972sca_ms
scans74625102sca_ns
scants85219722scants
scapose1147752scapose
scare75334462scare_
scared95227292scared
scarer84524602scarer
scarers94618502scarers
scarey115016982scarey
scarfs114714682scarfs
scarped124314402scarped
scarper114814822scarper
scarpers124712512scarpers
scarphs14437412scarphs
scarps104718602scarps
scars75433532sca_rs
scarts85321492scarts
scarves124511622scarves
scathes124515712scathes
scats75930602sca_ts
scatts85914662scatts
scauper11379452scauper
scaupers12378172scaupers
scaups105411932scaups
scaurs85512052scaurs
scenes84520352scenes
schappes1736032schappes
scones84521302scones
scope94821482scope_
scoped115116652scoped
scops95820192scop_s
scores84725922scores
scrape105917572scrape_
scraped124313132scraped
scraper114513412scraper
scrapers125510522scrapers
scrapies124612472scrapies
scraps106017242scrap_s
screes85023962screes
scries85226822scries
scups95316652scup_s
scutes85219192scutes
serapes95218102serapes
shades105924532shades
shakes135024592shakes
shales94731252shales
shames114726222shames
shape105125112shape_
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapers124016892shapers
shares95236412shares
shaves125224932shaves
sipes76036952s_ipes
skates104219402skates
slakes104021882slakes
slaps76025712slap_s
slates64934062slates
slaves95023022slaves
slipes84921412slipes
slopes84820452slopes
slypes114410482slypes
smazes174311662smazes
snakes103919602snakes
snaps74719562snap_s
snares65329032snares
snipes83917392snipes
soaped95817972soaped
soaper84517872soaper
soapers93715922soapers
soaps75120712soap_s
soaves94218672soaves
socages101012052socages
spaces104722632spaces
spades94222582spades
spaes76029972spa_es
spales84728102spales
spares84834552spares
spates85028172spates
stades74626242stades
stages75629492stages
stakes103927292stakes
stales65538292stales
stanes64933402stanes
staphs114411032staphs
staples93617212staples
stares66038752stares
stases64225562stases
states64337082states
staves94525192staves
stipes84524052stipes
stopes84525892stopes
stupes84116952stupes
supes75628302s_upes
swages104417072swages
swales93920762swales
swaps104819202swap_s
swipes114114332swipes
tapes75838602_tapes
trapes85024462trapes

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 Filter178691825510.1101624463.6
2DLD Change Limit825511822.59331836.1
3Display Results1821820.0632888.9
 (SQL Overall)1786911822.76664602.7
 
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.