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

223 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
entraps910976(None) 
entrap8710561entrap_
enwraps1284831enwraps
cantraps12319112cantraps
centrals102712032centrals
engrams1038072engrams
enrapt8313012en_rapt
enthrals11278902enthrals
entrails8310162entrails
entrain7313072entrain
entrains8312962entrains
entrant7318872entrant
entrants8311752entrants
entreats839772entreats
entrees71813772entrees
entries71523162entries
entropy1247352entropy
enwrap1185212enwrap_
estrays10529402estrays
extras13310222extra_s
inwraps12105252inwraps
mantraps12298062mantraps
satraps95011642satraps
straps87721782_straps
traps75727482__traps
unstraps1045982unstraps
unwraps1255512unwraps
ventrals112910002ventrals
amtracs1198883amtracs
anoraks1137603anoraks
antas55432033ant_a_s
antiars7314623antiars
antirape10410113antirape
antra56521923antra__
antral65719413antra_l
antres65021003antr_es
antrums969173antrums
anurans73810553anurans
astrals75515243astrals
ataps76414833_at_aps
bentgrass1242963bentgrass
betrays12127823betrays
bewraps14135403bewraps
bitmaps1344253bitmaps
caltraps12327253caltraps
cantraips13255273cantraips
cantrap113310283cantrap_
cantrips12318933cantrips
catnaps1197033catnaps
centals94317053cent_als
centares102913893centares
centas85020703cent_a_s
centra84113883centra__
central93114473centra_l
centres93817123centr_es
centrums1236913centrums
citrals91111673citrals
contras93015623contra_s
craps95328643__craps
dentals83915393dent_als
dextrans1695983dextrans
earlaps936393earlaps
encamps1335423encamps
enclasp1145843enclasp
enclasps1245133enclasps
encrypt1445323encrypt
encrypts1542983encrypts
endears83710053endears
endrins8312163endrins
endways1444443endways
enemas8812003enema_s
enframe1247363enframe
enframes1357453enframes
engraft11118613engraft
engrafts1294703engrafts
engrail846263engrail
engrails945383engrails
engrain838353engrain
engrains937583engrains
engram9310653engra_m
engrave1137133engrave
engraves1237233engraves
engross837123engross
enneads834733enneads
enrage72715073en_rage
enrages83114853en_rages
enrols61213383en_rols
entail61114343ent_ail
entails7912823entails
entases72816273entases
entasis73012573entasis
entera64216833entera__
enteral73516443entera_l
enterers82214153enterers
enterics10312853enterics
enterons8314153enterons
enters64425643ent_ers
enthalpy1642563enthalpy
enthral103410933enthra_l
enthrall11266833enthrall
enthralls12256133enthralls
entia5318203entia__
entices91616333entices
entires71517783entires
entoils7810733entoils
entombs1135613entombs
entrance10311323entrance
entrances11310953entrances
entrapped1484873entrapped
entrapper1344853entrapper
entrappers1444183entrappers
entreat7315263entreat
entreaty1146173entreaty
entree61817883entr_ee
entrepot1046193entrepot
entrepots1144253entrepots
entropic1249683entropic
entropies11411023entropies
entrust7410883entrust
entrusts847113entrusts
entry82414263entr__y
entryways1851473entryways
enures63919713enur_es
eras45441503e__ra_s
escarps11397373escarps
estops84011223est_ops
estral64716513estra_l
estray95713333estra_y
estreats839423estreats
estrins7315853estrins
estrous7712533estrous
estrums9208603estrums
estrus61912113estr_us
etape74413703e_t_ape
etapes85415293e_t_apes
etas46432273e_t_a_s
etnas54713933e_tna_s
extra1239003extra__
extract16311013extract
extracts1747623extracts
extrados1645343extrados
eyras84715923e_yra_s
flytraps1642963flytraps
fraps105620553__fraps
generals9109333generals
genipaps1342163genipaps
gentians937563gentians
gentries91315263gentries
interlaps1148233interlaps
inthrals11258503inthrals
intrados946563intrados
intrant7318753intrant
intrants8312863intrants
intreats8311543intreats
introns73515023introns
intros64215773intr_os
inwrap11115903inwrap_
knaps115511173kn__aps
mantrams12288963mantrams
mantrap11379823mantrap_
mantras93815863mantra_s
matrass939403matrass
menorahs1346543menorahs
naps66238583_n__aps
neaps75618323_n_eaps
netops839213net_ops
neutrals846283neutrals
pentads1039523pent_ads
petnaps1145033petnaps
peytrals1355493peytrals
raps66247733___raps
rattraps1044823rattraps
rentals74017473rent_als
rewraps12136563rewraps
ripraps1134943ripraps
satrap86212553satrap_
satrapy12497933satrapy
scraps106017243_scraps
senoras72714953senora_s
sentries81318053sentries
snaps74719563sn__aps
sneaps84510863sn_eaps
strap77925263_strap_
strass67117223_strass
straws98718673_straws
strays96417933_strays
streps86218063_streps
strips85719653_strips
strops86220383_strops
sutras64818593sutra_s
tantras73112093tantra_s
taps66050673__t_aps
tarps76527113__tarps
tetrads82910193tetrads
tetras63017623tetra_s
tramps105114453__tramps
trams75327673__trams
trans54933043__trans
trap67532803__trap_
trapes85024463__trapes
trapt76433393__trapt
trass56226473__trass
trays85623433__trays
trips74923363__trips
ultras6310193ultra_s
uncaps1039813un_caps
undrape1049333undrape
undrapes1138603undrapes
undraws1136893undraws
unrips8199453un_rips
unsnaps935423unsnaps
unstrap946783unstrap_
untrack1338703untrack
untracks1437523untracks
untreads936223untreads
untrims938613untrims
untruss736553untruss
unwrap11126323unwrap_
ventral103612173ventra_l
wataps11248683wat_aps
wraps105617153__wraps
yantras10259003yantra_s
yentas94614213yent_a_s

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.406440125.6
2DLD Change Limit1340272236.42320866.7
3Display Results2232230.0762934.2
 (SQL Overall)1786912236.90525878.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.