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 “escarp” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

261 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
escarp1044900(None) 
escar74011991escar_
escarps11397371escarps
escars83913131escars
scarp95724101_scarp
carp85139812__carp
encamp1235942encamp
epicarp1376072epicarp
escalop1144782escalop
escape103811662escape
escarped1355162escarped
eschar1136522eschar_
eschars1237172eschars
escort84616482escort
eskar9457452eskar_
eskars10357592eskars
exocarp1843852exocarp
mesocarp1443982mesocarp
scalp95217982_scalp
scamp115717312_scamp
scar66434202_scar_
scare75334462_scare
scarf105427142_scarf
scarph13429602_scarph
scarps104718602_scarps
scars75433532_scars
scart76139772_scart
scary105222592_scary
scaup95515992_scaup
scrap97120402_scrap
sharp104922532_sharp
acari75020283_acari
apocarp1355133apocarp
ascared10399523ascared
ascarid103910713ascarid
ascaris93613323ascaris
ascocarp1442693ascocarp
aswarm11107913aswarm
becap114315053beca_p
beswarm1445773beswarm
bicarb1238543bicarb
camp106336453__camp
cap76758983__ca_p
car59165563__car_
carb85143163__carb
card710245873__card
care66968373__care
cark105539273__cark
carl65144783__carl
carn66245433__carn
carpi94319393__carpi
carps96932253__carps
carr65434703__carr
cars67364763__cars
cart66570343__cart
cascara1138313cascara
crap85731843__crap
decamp1338453decamp
decare93919153decare
descant104315583descant
descry1256183desc_ry
discard11310213discard
ear36867883e__ar_
earl45838143e__arl
earn46737553e__arn
ears46356593e__ars
ecarte84313503e_carte
echard1249223echard
ecru65819533e_c_ru
eggar7458883eggar_
eggars8398973eggars
embar94011603embar_
embark14458523embark
embars103812883embars
encage93713503encage
encamps1335423encamps
encase83714363encase
encash11276943encash
enclasp1145843enclasp
encore8314773encore
endocarp1343733endocarp
ensnare767123ensnare
ensnarl784913ensnarl
entrap8710563entrap
enwrap1185213enwrap
epicarps1444783epicarps
escallop1243183escallop
escalope1244523escalope
escalops1244663escalops
escaped12388853escaped
escapee113310463escapee
escaper11368843escaper
escapers12337413escapers
escapes113811673escapes
escargot1183863escargot
escarole1045743escarole
escarping1435203escarping
eschew1436333eschew
escolar946053escolar_
escolars1045343escolars
escorts9418403escorts
escot75320083esc_ot
escots84211743escots
escrow1135913escrow
escuage1035113escuage
escudo943373escudo
esker94412983esker_
eskers105312223eskers
esparto944233esparto
essay867623essa_y
essays965653essays
estate64719763estate
ester54727713ester_
esters64627733esters
estop74312103es_top
estral64716513estral
estray95713333estray
estuary1034683estuary
euchre11137663euchre
excerpt1845943excerpt
exocarps1953473exocarps
gelcap1136213gelca_p
harp96134283__harp
keycard1743663keycard
lascar868573lascar_
lascars979013lascars
mascara1138023mascara
mescal104113483mesca_l
mescals112911553mescals
mesocarps1543103mesocarps
osar46820953os_ar_
oxcart1539523oxcart
peccary1636283peccary
pericarp1446123pericarp
pessary1246873pessary
picara10311903picara
picaro10311323picaro
piscary1437423piscary
procarp1346823procarp
recap95718023reca_p
redcap1158493redca_p
rescale93215473rescale
rescore95616193rescore
restamp1146483restamp
restart7320033restart
sacra74516993_sacra
salp64534093_s_alp
samp85733593_s_amp
sap56463233_s_a_p
sard55344243_s_ard
sari45444043_s_ari
sark84938973_s_ark
scab85926713_sca_b
scabs94818643_scabs
scad75725763_sca_d
scads85419953_scads
scag76626893_sca_g
scags85520973_scags
scald84818123_scald
scale74629143_scale
scall74420373_scall
scalps104315233_scalps
scaly104718723_scaly
scam85932353_sca_m
scampi12469103_scampi
scamps125014173_scamps
scams94423973_scams
scan65530453_sca_n
scans74625103_scans
scant79735073_scant
scape96921843_scape
scarab10310063_scarab
scarce104013633_scarce
scared95227293_scared
scarer84524603_scarer
scares85033003_scares
scarey115016983_scarey
scarfs114714683_scarfs
scarped124314393_scarped
scarper114814823_scarper
scarphs14437413_scarphs
scarry116311183_scarry
scarts85321493_scarts
scat65848373_sca_t
scats75930603_scats
scatt76030093_scatt
scaups105411933_scaups
scaur75814903_scaur
scaurs85512043_scaurs
scoop95617163_scoop
scop85925523_sc_op
score75526733_score
scorn75817443_scorn
scrag85916173_scrag
scram910621613_scram
scrape105917573_scrape
scraps106017243_scraps
scrip96619193_scrip
scry96017763_sc_ry
sculp95314843_sculp
scup84822383_sc_up
scurf104719323_scurf
sear47353843_sear_
sears54744913_sears
secant84023293secant
secern81010223secern
secpar1037923secpar_
secpars1138413secpars
sectary1238273sectary
secure8513533secure
senary93716073senary
sewar85421093sewar_
sewars94018623sewars
shard96125963_shard
share86437083_share
shark126225023_shark
sharn84823703_sharn
sharps115516083_sharps
sharpy145211033_sharpy
slap66434043_sla_p
slurp74014983_slurp
smarm95517603_smarm
smart75834093_smart
snap65727033_sna_p
snare54429983_snare
snarf86525423_snarf
snark95419943_snark
snarl54921083_snarl
soap65831133_soa_p
soar46838673_soar_
soars54732513_soars
spar65433303_spar_
spare75135563_spare
spark114920893_spark
spars75431543_spars
stamp95217363_stamp
star48037763_star_
stare54440263_stare
stark95425623_stark
stars55836573_stars
start55642313_start
stirp76815503_stirp
strap77925263_strap
swamp125015323_swamp
swap95925433_swa_p
sward94221463_sward
sware85828213_sware
swarf115324653_swarf
swarm106218833_swarm
swart86234643_swart
syncarp1444533syncarp
tarp66936413__tarp
teacart91113193teacart
tsar47819803ts_ar_
tsars56717103ts_ars
uncap9312283unca_p
unsharp1235543unsharp
usurp7106903us_urp
vicar10513863vicar_
vicars11712263vicars
warp95635003__warp

Search took 8 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162616.97016171.6
3Display Results2612610.1731508.7
 (SQL Overall)1786912617.28324535.4
 
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.