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

197 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
dewlap126484(None) 
dewlaps1334661dewlaps
bewrap13157052bewrap
declaw1266702declaw
delay94820632de_lay
dewan95718042dew_an
dewar95817732dew_ar
dewax165510852dew_ax
dewclaw1651792dewclaw
rewrap11127532rewrap
becap114315053be_cap
beclasp1335263beclasp
bedlam1149273bedlam
bedlamp1464513bedlamp
beflag1265883beflag
beglad10138463beglad
belay105021523be_lay
beleap10410283beleap
beweep13147253beweep
bewraps14135403bewraps
bewrapt14147133bewrapt
bewray14147733bewray
burlap1098353burlap
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
clap86429043__clap
cowflap1742503cowflap
dap66652453d___ap
dead65434243de__ad
deaf85838403de__af
deal56347413de__al
dealate83617843dealate
dealer74122143dealer
deals65435343deal_s
dealt65234283deal_t
dean56039483de__an
dear55343603de__ar
debag94212303de_bag
debar85517863de_bar
debeak1336763debeak
decaf114919443de_caf
decal85523233de_cal
decals93717713decals
decamp1338453decamp
decay114718483de_cay
declaim1247363declaim
declare10411233declare
declass1038733declass
declaws1336253declaws
dedal75719023de_dal
deejay1734523deejay
deep76031883de__ep
deewan10267553deewan
defat95426693de_fat
defeat103817163defeat
deflate113613943deflate
deflea1037443deflea
defleas1147223defleas
defoam1238563defoam
defrag1136463defrag
defray1337643defray
degas75119163de_gas
deglaze1835583deglaze
deil56231623deil__
deils65722863deil_s
del46752753de_l__
delate73827753de_late
delays104014053de_lays
dele56843083de_l_e
delead84112343delead
deled75326543de_led
deles65139253de_les
delf85436573de_l_f
delfs94918673de_lfs
delft95623323de_lft
deli55631293de_l_i
delis64928543de_lis
dell56938203de_l_l
dells66630943de_lls
delly96023873de_lly
dels56745473de_l_s
delt57855273de_l_t
delta66117773de_lta
deltas74414823deltas
delts65731793de_lts
delve96018263de_lve
demean9510563demean
denar65223293de_nar
denial74720513denial
dental74319173dental
deodar837713deodar
deplane10311413deplane
deploy1237583deploy
derat65044083de_rat
deray95024183de_ray
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desalt7518313desalt
desman9311693desman
deva85720983de_va_
devas96218883de_vas
develop13145033develop
dew77139923dew___
dewans105215143dewans
dewars105117073dewars
dewclaws1751873dewclaws
dewdrop1442813dewdrop
dewed105020303dew_ed
dewfall1453763dewfall
dewier104013463dewier
dewily1338343dewily
dewing114115703dewing
dewlapped1841953dewlapped
dewless1137473dewless
dewool1047403dewool
deworm1249533deworm
dews86230603dew__s
dewy115419023dew__y
diwan95712553diw_an
dobla84913643dobla_
doblas93812293doblas
dognap1035343dognap
dollar74110983dollar
dollop9259363dollop
doula65717773doula_
doulas75114993doulas
dwell9519853dwel_l
dwells10417713dwells
dwelt94316523dwel_t
earlap837183earlap
eclat7523603_eclat
elan46734243_e_lan
enwrap1185213enwrap
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
flap96128703__flap
gelcap1136213gelcap
gewgaw1441783gewgaw
heap96432893he__ap
heeltap1243733heeltap
help95328923he_l_p
inwrap11115903inwrap
jalap143612473_jalap
jetlag1434523jetlag
keblah1545313keblah
kelep116014563ke_lep
kelp105322813ke_l_p
lap58565273___lap
leap66032683le__ap
medlar93010463medlar
mewl95618323mewl__
mewled123710053mewled
mewler113510233mewler
mewls105813233mewl_s
neap66927013ne__ap
newly114610203newl_y
overlap12239833overlap
pedlar93311273pedlar
pepla9312863pepla_
petnap1037423petnap
prewrap14104973prewrap
reap65934743re__ap
recap95718023re_cap
reclad9311873reclad
reclasp1136643reclasp
redcap1158493redcap
reflag1098083reflag
relax124817803re_lax
relay84424673re_lay
remap95418103re_map
replan83215823replan
replay113412923replay
rewan85623663rew_an
rewax155713923rew_ax
rewear93012003rewear
rewraps12136563rewraps
rewrapt12138113rewrapt
selah8319613se_lah
sewan85921293sew_an
sewar85421103sew_ar
slap66434043__slap
swap95925433_sw_ap
tela45532973te_la_
telae54323293te_lae
tesla55612603tesla_
teslas64212173teslas
underlap11146423underlap
unwrap11126323unwrap
vela75725543ve_la_
velar85817633ve_lar
wap86553373__w_ap
whap125119643__whap
wrap96821973__wrap
yelp95621353ye_l_p

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 Filter1786911127160.393454684.5
2DLD Change Limit1127161976.37317686.5
3Display Results1971970.0633127.0
 (SQL Overall)1786911976.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.