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

239 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
escarps1139737(None) 
escarp10449001escarp_
escars83913131escar_s
scarps104718601_scarps
ascaris93613322ascaris
carps96932252__carps
encamps1335422encamps
epicarps1444782epicarps
escalops1244672escalops
escape103811662esca_pe
escapes113811672escapes
escar74011992escar__
escarped1355162escarped
eschars1237172eschar_s
escorts9418402escorts
eskars10357592eskar_s
exocarps1953472exocarps
mesocarps1543102mesocarps
scalps104315232_scalps
scamps125014172_scamps
scares85033002_scares
scarfs114714682_scarfs
scarp95724102_scarp_
scarph13429602_scarph
scarphs14437412_scarphs
scars75433532_scar_s
scarts85321492_scarts
scaups105411932_scaups
scraps106017242_scraps
sharps115516082_sharps
acarus8312193_acarus
apocarps1474423apocarps
ascared10399523ascared
ascarid103910723ascarid
ascarids11438503ascarids
ascocarps1542423ascocarps
becaps123811403beca_ps
beswarms1544323beswarms
bicarbs1336013bicarbs
camps116330263__camps
caps87147893__ca_ps
carbs96031463__carbs
cards85137933__cards
cares77369183__cares
carks115534213__carks
carls77037423__carls
carns75937563__carns
carp85139813__carp_
carpi94319393__carpi
carpus105514303__carpus
carrs75730853__carrs
cars67364763__car_s
carts78946293__carts
cascaras1237703cascaras
corps95927043__corps
craps95328643__craps
decamps1435643decamps
decares102818533decares
descants112910143descants
discards1238913discards
earls56127513e__arls
earns55927563e__arns
ears46356593e__ar_s
ecarte84313503e_carte
ecartes94212563e_cartes
echards1337963echards
ecrus75113863e_c_rus
eggars8398973eggar_s
embarks15337353embarks
embars103812883embar_s
encages103313783encages
encamp1235943encamp_
encases93116053encases
enclasps1245133enclasps
encores9315213encores
endocarps1443613endocarps
ensnares856893ensnares
ensnarls873393ensnarls
entraps9109763entraps
enwraps1284833enwraps
epicarp1376073epicarp_
escallops1343193escallops
escalop1144783escalop
escalope1244523escalope
escalopes1344773escalopes
escaped12388853escaped
escapee113310463escapee
escapees12336333escapees
escaper11368843escaper
escapers12337413escapers
escapism1444453escapism
escapist1246213escapist
escargot1183863escargot
escargots1262263escargots
escarole1045743escarole
escaroles1145273escaroles
escarping1435203escarping
eschar1136523eschar__
eschews1534553eschews
escolars1045343escolar_s
escort84616483escor_t
escots84211743esc_ots
escrow1135913esc_row
escrows1235803escrows
escuages1145163escuages
escudos1043493escudos
eskar9457453eskar__
eskers105312223esker_s
esparto944233esparto
espartos1044333espartos
essays965653essa_ys
estates74520183estates
esters64627733ester_s
estops84011223es_tops
estrays10529403estrays
estrus61912113es_trus
eucharis1347443eucharis
euchres1288663euchres
excerpt1845943excerpt
excerpts1943743excerpts
exocarp1843853exocarp_
gelcaps1235203gelca_ps
harps105926873__harps
keycards1843063keycards
lascars979013lascar_s
mascaras1237693mascaras
mescals112911553mesca_ls
mesocarp1443983mesocarp_
oxcarts1634313oxcarts
pericarps1544473pericarps
picaras11311283picaras
picaros11310893picaros
procarps1445973procarps
recaps103615733reca_ps
redcaps1247073redca_ps
rescales103414573rescales
rescores105415693rescores
restamps1234703restamps
restarts8310873restarts
salps74423243_s_alps
samps96124673_s_amps
saps65346373_s_a_ps
sards64736183_s_ards
saris54544953_s_aris
sarks96632463_s_arks
saros55238063_s_aros
scabs94818643_sca_bs
scads85419963_sca_ds
scags85520973_sca_gs
scalds94813693_scalds
scales84529313_scales
scalls84218203_scalls
scalp95217983_scalp_
scamp115717313_scamp_
scampi12469103_scampi
scams94423973_sca_ms
scans74625103_sca_ns
scants85219723_scants
scape96921843_sca_pe
scapes105122263_scapes
scar66434203_scar__
scarab10310063_scarab
scarabs1137293_scarabs
scarce104013633_scarce
scare75334463_scar_e
scared95227293_scared
scarer84524613_scarer
scarers94618513_scarers
scarey115016983_scarey
scarf105427143_scar_f
scarped124314403_scarped
scarper114814823_scarper
scarpers124712513_scarpers
scarry116311183_scarry
scart76139773_scar_t
scarves124511623_scarves
scary105222593_scar_y
scats75930603_sca_ts
scatts85914663_scatts
scaup95515993_scaup_
scaurs85512053_scaurs
scoops105414363_scoops
scops95820193_sc_ops
scores84725923_scores
scorns85713023_scorns
scrags95713803_scrags
scrams105216623_scrams
scrap97120403_scrap_
scrape105917573_scrape
scrapes116217663_scrapes
scrips105316033_scrips
sculps104611753_sculps
scups95316653_sc_ups
scurfs113210813_scurfs
sears54744913_sear_s
secants93413893secants
secerns987733secerns
secpars1138413secpar_s
secures9613163secures
sewars94018633sewar_s
shards104319173_shards
shares95236413_shares
sharks135019723_sharks
sharns95516983_sharns
sharp104922533_sharp_
sharpy145211033_sharpy
slaps76025713_sla_ps
slurps84410003_slurps
smarms105712533_smarms
smarts86218003_smarts
snaps74719563_sna_ps
snares65329033_snares
snarfs95113423_snarfs
snarks104815733_snarks
snarls64016873_snarls
soaps75120713_soa_ps
soars54732513_soar_s
spares84834553_spares
sparks124616363_sparks
spars75431543_spar_s
stamps105614023_stamps
stares66038753_stares
stars55836573_star_s
starts65423123_starts
stirps85011823_stirps
straps87721783_straps
swamps135910263_swamps
swaps104819203_swa_ps
swards105415133_swards
swarfs125612063_swarfs
swarms116112173_swarms
syncarps1543903syncarps
tarps76527113__tarps
teacarts10116073teacarts
tsars56717113ts_ar_s
uncaps1039813unca_ps
usurps8105073us_urps
vicars11712263vicar_s
warps107126423__warps

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340272395.90622693.4
3Display Results2392390.0763144.7
 (SQL Overall)1786912396.40527898.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.