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

543 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
abrade931305(None) 
abraded1138641abraded
abrader1038641abrader
abrades10312071abrades
abase76023482ab_ase
abate76627842ab_ate
abide86223702ab_ide
ablate82219212ablate
ablaze17239832ablaze
abode85518812ab_ode
abraders1137342abraders
abridge1135692abridge
abroad9310942abroad_
aerate64830552aerate
aggrade1035632aggrade
agrafe1038092agrafe
alcade91111512alcade
arame75026622a_rame
arcade91013642arcade
aubade939222aubade
aurae54128112aura_e
aurate64426472aurate
bade75140882_b_ade
barde85330772bar_de
blade85923332_blade
brace95629272_brace
brad75234342_brad_
brads85528292_brads
brae65639112_bra_e
brake116025342_brake
brave104925502_brave
braze165423452_braze
brede85520502_brede
bride86425532_bride
grade75126092_grade
irade65618152_irade
parade94720642parade
tirade7311692tirade
trade65026042_trade
aba512850953ab_a__
abaca95118043ab_aca
abaci94718843ab_aci
aback134816173ab_ack
abaft10318063ab_aft
abaka114313823ab_aka
abamp11310603ab_amp
abas68642083ab_a_s
abased96514993ab_ased
abaser86414343ab_aser
abases85720773ab_ases
abash106016513ab_ash
abated95918453ab_ated
abater85518123ab_ater
abates85825033ab_ates
abaya104413173ab_aya
abba810522643abba__
abbacy1536623abbacy
abbas95918643abba_s
abbe87627183ab__be
abduce1197193abduce
abeam9316533abea_m
abed79734133ab_ed_
abele76323253ab_ele
abfarad1344223abfarad_
abfarads1443163abfarads
abided105313313ab_ided
abider95314463ab_ider
abides94719893ab_ides
abjure1536733abjure
ablated102513443ablated
ablates92416903ablates
ablaut8313263ablaut
able66340533ab__le
abled86926833abled_
aboard9312613aboard
aboded104912513ab_oded
abodes94417513ab_odes
aboral8314373abora_l
aborted10310423aborted
above105414323ab_ove
abradable1495063abradable
abradant1147213abradant
abrading1239503abrading
abrasive1345753abrasive
abreact11310823abreact
abreast9311273abreast
abri65522213abr__i
abridged1343903abridged
abridger1243803abridger
abridges1245303abridges
abris75722603abr_is
abroach1446213abroach
abrogate11129603abrogate
abrupt1039943abrupt
abuse77119563ab_use
abused95614273abused
abwatt11410673abwatt
abye97921003ab__ye
accede1138293accede
acerate92818913acerate
acnode938193acnode
acre67330773acr__e
acreage1037833acreage
acred87126353acred_
acrid86920103acrid_
acrider1038623acrider
acuate8315633acuate
adage7414053a_dage
adnate72913483adnate
aerated85322373aerated
aerates74627483aerates
aerie54634603aer_ie
aeried74221863aeried
aerobe8412403aerobe
aflame1138723aflame
afraid1049713afraid
agape85614843a_gape
agate66525143a_gate
agave95314033a_gave
agaze156113663a_gaze
aggada955203aggada
aggraded1244183aggraded
aggrades1135853aggrades
aglare7312423aglare
agnate73314873agnate
agorae7511203agora_e
agrafes1137523agrafes
agraffe1443333agraffe
agree65226033agr_ee
agreed84712503agreed
ahead96817053ahead_
aide56044993a__ide
airdate8311323airdate
aired66032923aired_
airfare1047243airfare
airted74214503airted
airwave1344433airwave
alae45643753a_la_e
alane56135613a_lane
alate55340323a_late
alcades101011473alcades
alcaide1088453alcaide
alcalde10104953alcalde
alcayde13103723alcayde
algae65319623alga_e
alidade936993alidade
alkane104313323alkane
allude73910903allude
almude9399933almude
already1144263already
amaze166016603a_maze
ambage11510593ambage
ambsace1355963ambsace
amide86128473a_mide
amirate91115953amirate
anadem939183a_nadem
anlace82513923anlace
anlage72514223anlage
anode65021033a_node
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
aortae65115473aortae
apace94718383a_pace
apyrase1236363apyrase
aquae142212713aqua_e
arable81821003a_rable
arak86929573a_ra_k
araks94820883a_raks
arames84622573a_rames
arbute8311043arbute
arcaded1178973arcaded
arcades101113193arcades
arcane81216743arcane
arced88224163a_rced
ardeb8314523a_r_deb
are37874573a_r__e
areae55229743a_reae
arene55329413a_rene
arete56031353a_rete
argle65421563a_rgle
argue64818443a_rgue
arid57642713a_rid_
arider74717743a_rider
arise56436433a_rise
armada938783armada
armed86324433a_rmed
arose55832083a_rose
arrack121110253arrack
arrange838683arrange
arrant6623253arrant
arras55626133arra_s
arrased8149863arrased
arrases71214543arrases
array86317143arra_y
arrayed11117153arrayed
arrayer10136703arrayer
arrays95311683arrays
arrive91311793arrive
arse46539273a_r_se
aside65122083a_side
asrama839193asrama
astride8311973astride
aubades1038743aubades
audad71511383audad_
audads8167103audads
aura45836253aura__
aural54428963aura_l
aurar54420253aura_r
auras55932553aura_s
aurated83817793aurated
aureate72515283aureate
average1158853average
aviate9315203aviate
awake125014783a_wake
award97118043award_
awarded1236223awarded
awardee1137553awardee
awarder1135893awarder
awards107113453awards
aware86420023a_ware
azide155617163a_zide
baaed85218163_baaed
babe86835813_b_abe
bad67763153_b_ad_
badge94819683_b_adge
bads77048863_b_ads
bake105637513_b_ake
bale66353843_b_ale
ballade104012563ballade
bane65250423_b_ane
barbate11314543barbate
barbe95328283bar_be
barbed115121313barbed
barbie105018353barbie
bard75648863bar_d_
barded105426423bar_ded
bardes95026933bar_des
bards87139643bar_ds
bare65460523_b_are
bared85144483bared_
barege94713543barege
barfed125416383barfed
barge85631023bar_ge
barged105822643barged
bargee94624443bargee
barite84224813barite
barked135027313barked
barmie103816393barmie
barned95623583barned
barque17239553barque
barrage10710843barrage
barre75929543bar_re
barred95725793barred
barware12610703barware
barye105021493bar_ye
baryte115312883baryte
base64847023_b_ase
bate66552423_b_ate
bead75937923_bead_
beaded104922423_beaded
beader94623793_beader
beadle93314683_beadle
beads85429503_beads
beady114719923_beady
berake124216083berake
berate84729023berate
bide76041473_b_ide
bladed104717763_bladed
blader93618583_blader
blades95221253_blades
blae66134643_bla_e
blame95625493_blame
blare75826233_blare
blase75524233_blase
blate75933783_blate
blaze165520833_blaze
bode75838753_b_ode
borage93917013borage
borane84620213borane
borate85026153borate
boride9415903boride
bra56339463_bra__
braced115420603_braced
bracer104620583_bracer
braces108427773_braces
brach126123303_brach
bract96332723_bract
bradded12388713_bradded
braes75735053_braes
brag75229723_bra_g
brags85625103_brags
braid85822263_braid
braided114013213_braided
braider105112993_braider
braids95015683_braids
brail75525553_brail
brain76229383_brain
braise84318753_braise
braize174113113_braize
braked135318693_braked
brakes124923123_brakes
braky145015813_braky
bran65740383_bra_n
brand85124493_brand
branded114414103_branded
brander103915823_brander
brands95118943_brands
brandy124712063_brandy
brank115222283_brank
brans75437433_brans
brant74742173_brant
bras65746453_bra_s
brash106221563_brash
brass75428023_brass
brat66055543_bra_t
brats75336013_brats
brava106414793_brava
braved124817443_braved
braver114719043_braver
braves115524083_braves
bravi104715753_bravi
bravo105214343_bravo
braw94829563_bra_w
brawer114216333_brawer
brawl106217963_brawl
brawn106018563_brawn
braws106425193_braws
braxy175410893_braxy
bray95232903_bra_y
brayed124615783_brayed
brayer115315313_brayer
brays106723113_brays
braza165214253_braza
brazed184717083_brazed
brazen174812453_brazen
brazer174917533_brazer
brazes175522193_brazes
bread85523113_bread_
breaded115014063_breaded
breads95419203_breads
bready124511183_bready
bred75130973_bred_
bredes94818473_bredes
bree67241263_br_ee
breed85526693_breed
breve105317053_breve
bribe94820773_bribe
brides94423513_brides
bridge103711883_bridge
bridle94115463_bridle
brie65837903_br_ie
brigade1136493_brigade
brine75132273_brine
broad84817693_broad_
broaden10289143_broaden
broader103412603_broader
broads94515143_broads
brocade1238533_brocade
broke116019783_broke
brome94421973_brome
brose75227033_brose
brume95817983_brume
brute75321783_brute
cabbage1446983cabbage
cade76443913__cade
carafe115416163carafe
carate84734003carate
carbide126112493carbide
cascade12118603cascade
cerate84829463cerate
charade13129903charade
clade85821013_clade
comade114415323comade
comrade12139213comrade
corrade101111043corrade
cradle93313163_cradle
crake114823523_crake
crane75331603_crane
crape96128443_crape
crate76537403_crate
crave105626313_crave
craze165221463_craze
crude86018573_crude
curare84916953curare
curate85226243curate
debride1138593debride
decade104216163decade
degrade10229903degrade
derate74531233derate
deride84420033deride
dorado838813dorado
drake104918303_drake
drape85319633_drape
drave95219273_drave
embrace1388893embrace
enrage72715073enrage
erase54925493_erase
erode64520993_erode
evade938183_evade
facade1238803facade
fade85736343__fade
farad95720673farad_
farads104713273farads
forage104616993forage
forbade13259103forbade
frae75330473_fra_e
frame105821803_frame
furane94015493furane
gambade1336383gambade
garage8314513garage
garbage1138053garbage
glabrate1146033glabrate
glade75121963_glade
grace85124543_grace
grad66829863_grad_
graded94919553_graded
grader84919693_grader
grades84926313_grades
grads75625753_grads
grape84824663_grape
grate64932883_grate
grave94624873_grave
graze155820053_graze
gride75223583_gride
gyrase10508773gyrase
gyrate104912523gyrate
hade85440193__hade
hagride1237553hagride
hagrode1236443hagrode
hayride1437323hayride
hexade17438903hexade
horde94623053hor_de
invade10157853invade
irades74517393_irades
irate55627983_irate
jade125325443__jade
karate105320923karate
labiate91313573labiate
labra75415463labra__
labrador1143883labrador
lade56345983__lade
laurae64011663laura_e
librae84310173libra_e
librate93214233librate
lyrate94112103lyrate
macrame1338713macrame
made75440233__made
manmade1237963manmade
merde84320123mer_de
mirage92313653mirage
morae75831193mora_e
morale85220553morale
narrate7313493narrate
noyade1036423noyade
oblate82214743oblate
obtrude1044243obtrude
orad56031693_orad_
orate55133303_orate
paraded114014263paraded
parader103914863parader
parades104121463parades
parae76335703para_e
parbake1538353parbake
parkade1437583parkade
passade1039233passade
paygrade1543593paygrade
pervade1337023pervade
pesade9311103pesade
phrase11109903phrase
pirate82322883pirate
pomade113611333pomade
prase76128753_prase
prate75135983_prate
pride84724733_pride
prude84615973_prude
race66746263__race
rad47662003__rad_
rads56046603__rads
rage55742353__rage
rake84841573__rake
rale45050563__rale
rape65041633__rape
rare45348433__rare
rase46149983__rase
rate45458763__rate
rave75542093__rave
raze135235433__raze
rede55037663__rede
regrade92612033regrade
remade94316983remade
ride55945123__ride
rode55844303__rode
rude55632783__rude
sabra75317853sabra__
sabras85116363sabra_s
sabre74821503sabr__e
sabred95916533sabred_
saccade12107033saccade
sade55544473__sade
sarape84817573sarape
sarode75317513sarode
scrape105917573scrape
serape84818413serape
shade95125583_shade
spade84423323_spade
stade64825303_stade
strafe95215973strafe
strake104017393strake
stride75420963stride
strode75215973strode
subgrade1246053subgrade
subrace11313003subrace
tabard9313333tabard_
tabarded1234743tabarded
tabards10310383tabards
thrave126010273thrave
tirades8311723tirades
torsade837593torsade
trace75829613_trace
trad55630913_trad_
traded85717683_traded
trader75218753_trader
trades75724493_trades
trave85223033_trave
trode65322853_trode
tsade64311123_tsade
umbrae1038673umbra_e
umbrage1236723umbrage
unabraded1344893unabraded
unbrace111910483unbrace
unbrake13239123unbrake
unlade72714153unlade
unmade92911063unmade
upgrade11215823upgrade
uprate83916543uprate
urare56322553_urare
urase54624683_urase
urate55432163_urate
urbane82211383urbane
vambrace1743983vambrace
vibrate122811513vibrate
wade85237063__wade

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 Limit1127165436.89016359.4
3Display Results5435430.2032674.9
 (SQL Overall)1786915437.23324705.0
 
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.