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

246 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
crap8573184(None) 
cap76758981c_ap
carp85139811carp
chap114928491chap
clap86429041clap
crab85727671crab
crag75625301crag
cram85635491cram
cramp115120691cramp
crape96128441crape
craps95328641craps
craw97725261craw
crop87628631crop
frap95925811frap
rap56261961_rap
scrap97120401scrap
trap67532801trap
wrap96821971wrap
arak86929572arak
atap66722452atap
bap76455842_bap
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
cab78355402c_ab
cad67456362c_ad
cam78058982c_am
camp106336452camp
can57760142c_an
cape87242782c_ape
caph116623292c_aph
capo85829212c_apo
caps87147892c_aps
car59165562c_ar
carat75048792carat
carb85143162carb
card710245872card
care66968372care
cark105539272cark
carl65144782carl
carn66245432carn
carpi94319392carpi
carps96932252carps
carr65434702carr
cars67364762cars
cart66570342cart
cat58282342c_at
caw86647932c_aw
cay87155982c_ay
cep75736332c_ep
chad105525502chad
chai95929902chai
cham115532312cham
champ145017962champ
chao95727312chao
chape125221142chape
chaps125326062chaps
chapt125827642chapt
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
cheap126915942cheap
chip116726422chip
chop116024922chop
ciao64924182ciao
clad76225822clad
clag75924572clag
clam86332292clam
clamp115517652clamp
clan65633922clan
claps95626182claps
clapt98027172clapt
clasp95517192clasp
claw95624342claw
clay95927412clay
clip86924002clip
clop86929892clop
coal66939252coal
coapt96131532coapt
coat67558352coat
coax136922982coax
comp106731252comp
coop87238652coop
cop711162372c_op
coral76033452coral
coup86729792coup
craal74117752craal
crabs95421392crabs
crack134120532crack
craft105327662craft
crags85622572crags
crake114823522crake
cramps125615562cramps
crampy154710992crampy
crams96229152crams
crane75331602crane
crank114819612crank
craped116120522craped
crapes104727692crapes
crappy15446802crappy
crash109120012crash
crass76328042crass
crate76537402crate
crave105626312crave
crawl104916712crawl
craws105723122craws
craze165221462craze
crazy195511222crazy
creak115418432creak
cream95721352cream
cred76530882cred
creep95218102creep
crepe95520722crepe
crept95125892crept
crepy124812702crepy
crew96122682crew
crib86323582crib
crimp115615802crimp
cripe95521142cripe
cris66233432cris
crisp95014622crisp
crit65743712crit
croak115216632croak
croc85723732croc
crops96125232crops
croup95616782croup
crow96428132crow
cru57129562cr_u
crud75219612crud
crump115616422crump
crus65828482crus
crux135415002crux
cry89726242cr_y
crypt123715232crypt
cup76738242c_up
cusp86021062cusp
cyan96419622cyan
czar156013132czar
dap66652452_dap
drab76226452drab
drag64825052drag
dram75832002dram
drape85319632drape
drat56247832drat
draw85623012draw
dray85428092dray
drip76223952drip
drop75324402drop
era35741502era_
eras45441502eras
flap96128702flap
frae75330472frae
frag85126272frag
fraps105620552fraps
frat75648542frat
fray105428902fray
gap67055612_gap
grab75427612grab
grad66829862grad
gram77034582gram
gramp106218322gramp
gran56335012gran
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grat55651282grat
gray85329892gray
grip76127022grip
hap87360052_hap
harp96134292harp
heap96432892heap
knap105815402knap
lap58565272_lap
leap66032682leap
map77255122_map
nap56753202_nap
neap66927012neap
ora37250832ora_
orad56031692orad
oral47638122oral
pap76758402_pap
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prep86427672prep
prop85932812prop
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
ram56867272_ram
ramp85934002_ramp
ran38266622_ran
rape65041632_rape
raps66247732_raps
rapt67245312_rapt
ras37575392_ras
rasp66029162_rasp
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
reap65934742reap
rep55847802_rep
rip56851302_rip
sap56463232_sap
scarp95724102scarp
scrag85916172scrag
scram910621622scram
scrape105917572scrape
scraps106017242scraps
scrip96619192scrip
slap66434042slap
snap65727032snap
soap65831132soap
strap77925262strap
swap95925432swap
tap57663872_tap
tarp66936412tarp
trad55630912trad
tram67034552tram
tramp96319772tramp
traps75727482traps
trapt76433392trapt
tray77632592tray
trip66830392trip
trop66833302trop
urp56426392ur_p
wap86553372_wap
warp95635002warp
whap125119642whap
wraps105617152wraps
wrapt105123182wrapt
yap85949822_yap
zap145840692_zap

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 Filter178691298720.280638182.1
2DLD Change Limit298722460.89033564.0
3Display Results2462460.0633904.8
 (SQL Overall)1786912461.233144923.8
 
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.