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

320 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
watape1120848(None) 
watap102111671watap_
watapes12228381watapes
wataps11248681wataps
wattape12135381wattape
agape85614842_agape
atap66722452_atap_
ataps76414832_ataps
canape10913512canape
etape74413702_etape
retape83917682retape
sarape84817572sarape
tape64538142__tape
waftage14115322waftage
wakame1535432wakame
wantage11119622wantage
wastage11109252wastage
wattage1186982wattage
wattapes1395252wattapes
wattle94314212wattle
abase76023483_abase
abate76627843_abate
adage7414053_adage
adapt81218553_adapt
agapae9388043_agapae
agapes95212413_agapes
agate66525143_agate
agave95314033_agave
agaze156113663_agaze
alae45643753_ala_e
alane56135613_alane
alate55340323_alate
amaze166016603_amaze
anatase738943anatase
antae56828293anta_e
apace94718383_apace
ape57251183___ape
arame75026623_arame
ataxy1537313_ataxy
ate37059243_at__e
atone56527983_atone
atop66124753_atop_
atopy106813393_atopy
awake125014783_awake
aware86420023_aware
bate66552423bat__e
bathe105822883bat_he
battle85217863battle
battue84311003battue
betake124512703betake
butane8313653butane
canapes111213083canapes
cape87242783__cape
carafe115416163carafe
carate84734003carate
cartage10312593cartage
catalo8314853catalo
catalpa1136503catalpa
cate66254593cat__e
catface1436763catface
catnap1098383catnap_
catnaper1294933catnaper
catnaps1197033catnaps
cattie85221013cattie
cattle85118903cattle
cetane8315283cetane
chape125221143_chape
cotype1346823cotype
crape96128443_crape
damage10410773damage
data56026653data__
datable101714233datable
datary10310243datary
date56443323dat__e
dative10311813dative
dotage82711613dotage
drape85319633_drape
eatable91717603eatable
ectype1334283ectype
escape103811663escape
estate64719763estate
etapes85415293_etapes
facade1238803facade
fatal84819373fata_l
fate75444283fat__e
gape75134513__gape
garage8314513garage
gate55746573gat__e
gavage1137193gavage
grape84824663_grape
hamate113319823hamate
hanaper1237133hanaper
hastate10313913hastate
hatable121713963hatable
hate78450173hat__e
intake10510863intake
jalap143612473jalap_
jalaps15299183jalaps
jape134923423__jape
kakapo1143853kakapo
karate105320923karate
kata85626023kata__
katas95922093kata_s
lactase937953lactase
lactate9312693lactate
lanate6421263lanate
late47560483lat__e
lathe85626713lat_he
latke94817093lat_ke
latte55426303lat_te
lavage1038263lavage
madame1139853madame
malate84624553malate
maltase938903maltase
manage93818903manage
mate65154213mat__e
matte75626843mat_te
mature8313463mature
metage93114453metage
metate82720533metate
metope10611123metope
mutase82811983mutase
mutate83017483mutate
nape65230803__nape
nappe96114993na_ppe
natal53921493nata_l
natant6318733natant
native9613013native
nature6311263nature
notate63217863notate
nutate63017373nutate
oatcake1345363oatcake
octane81411633octane
octave11157343octave
outage72017533outage
outate62923403outate
palace104516913palace
palapa10310673palapa
palate84226783palate
parade94720643parade
parae76335703para_e
parapet11317643parapet
paraph13311263paraph
partake1339643partake
pataca10311193pataca
pate65350463pat__e
patine85328123patine
pattee84323383pattee
pattie84020963pattie
pavane114113443pavane
platane93112303platane
potage92715903potage
pretape113511623pretape
ramate83921683ramate
rape65041633__rape
ratable91717553ratable
ratafee1047513ratafee
ratal55025113rata_l
ratals64219583ratals
ratan53722663rata_n
ratans63819373ratans
ratany93411873ratany
rate45458763rat__e
rathe85821923rat_he
ratine65131823ratine
ratite65022423ratite
rattle64717613rattle
ravage1039303ravage
retake104718533retake
retaped103814283retaped
retapes93917423retapes
retype11399143retype
rotate63320343rotate
salpae84614273salpae
sarapes94617743sarapes
satang75711563satang
satara6315533satara
satay84718463sata_y
satays94411683satays
sate45556103sat__e
satiate7315403satiate
satire63218003satire
satrap86212553satrap_
satraps95011643satraps
satrapy12497933satrapy
savage10410173savage
savate9313783savate
scape96921843_scape
scrape105917573scrape
serape84818413serape
setae56026223seta_e
shape105125113_shape
stade64825303_stade
stage65330193_stage
stake95927533_stake
stale55637103_stale
stane55933003_stane
stapes85028733_stapes
staph104314653_staph
staple84415823_staple
stare54440263_stare
state56237333_state
stave85324993_stave
stipe76523373_stipe
stope74727243_stope
stupe75217753_stupe
swathe125514113swat_he
tace65342513__tace
tae38267053__ta_e
takahe1335793takahe
take84739263__take
tale46154163__tale
tamale83717393tamale
tame66343663__tame
tap57663873__tap_
tapa65129143__tapa
taped85327423__taped
taper74829773__taper
tapes75838603__tapes
taps66050673__taps
tare45957623__tare
tartare73012683tartare
tatami839183tatami
tatar56122063tata_r
tatars64619793tatars
tate44748603__tate
tattie64817513tattie
tattle64115653tattle
taupe7314163ta_upe
tope65946383__tope
twattle1064273twattle
type96223743__type
untame82513603untame
uptake1236963uptake
vacate11314553vacate
vantage11109893vantage
vitae84217633vita_e
wabble133714843wabble
wacke145918623wa_cke
wadable13310233wadable
waddie114013323waddie
waddle114715303waddle
wade85237063w__ade
wae67556953w__a_e
waffie15338563waffie
waffle15369183waffle
waftages15105393waftages
wafture1334853wafture
wage84834083w__age
waggle113612303waggle
wagtail1145043wagtail
wahine123813013wahine
waive114214603wa_ive
wakames1635283wakames
wake114935703w__ake
wale74546433w__ale
wallie93216803wallie
wamble134415753wamble
wame95035483w__ame
wandle105316663wandle
wane76344713w__ane
wangle103817503wangle
wannabe1234533wannabe
wantages12109023wantages
wap86553373w__ap_
wapped144416473wa_pped
waps96642083w__aps
warble113516603warble
ware76254723w__are
warfare1336733warfare
warp95635003wa_rp_
warpage1336403warpage
warped124816413wa_rped
warper114015583wa_rper
warps107126423wa_rps
warsle93112923warsle
wartime1237743wartime
wasabi1154643wasabi
wasp95626853wa_sp_
wasps106714693wa_sps
waspy135410993wa_spy
wastable131410453wastable
wastages12109753wastages
waste86125053wa_ste
wastrie101210293wastrie
wat67378923wat___
watch135617063wat_ch
watched163012823watched
watcher153113403watcher
watches153017373watches
water84733313wat_er
waterage1248663waterage
watered113014953watered
waterer103314073waterer
waters95030623waters
watery123914493watery
wats77555883wat__s
watt75545413wat__t
wattages12106783wattages
watter93221983watter
wattled113610503wattled
wattles103814073wattles
watts86923093wat_ts
wave105234733w__ave
waxable1937673waxable
weave115218533w_eave
wetware1335793wetware
whale115517433w_hale
whap125119643w_hap_
whaps135115163w_haps
wickape1843723wickape
wipe94830283w__ipe
witan83816503wita_n
witans93412933witans
wite75443273wit__e
withe115220233wit_he
wrap96821973w_rap_
wraps105617153w_raps
wrapt105123183w_rapt
wyte106018643wyt__e

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.1431249587.4
2DLD Change Limit1127163205.87319192.2
3Display Results3203200.0933440.9
 (SQL Overall)1786913206.10929250.5
 
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.