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

424 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
charley1511827(None) 
charleys1695631charleys
barley115116762_barley
carle74535702c_arle_
carles85435082c_arles
carney115315702c_arney
chaleh143711992cha_leh
chalet113825992cha_let
chalky18468772cha_lky
chally144314292cha_lly
chantey154112542chantey
chaplet14512252chaplet
chare105231982char_e_
chared125423692char_ed
chares115631802char_es
charge125114212charge_
charged144614022charged
charger133914062charger
charges134615982charges
charier124317902charier
charily15310282charily
charity15311022charity
charked174814012charked
charlady1743402charlady
charlie123011922charlie
charlies133414232charlies
charmed154714252charmed
charmer144913662charmer
charnel124010052charnel
charpoy1735712charpoy
charred134614482charred
charry145012112char_ry
charted135116852charted
charter123918302charter
chary135023132char__y
chimley1785162chimley
hurley125012522_hurley
parley116718352_parley
shaley123714992sha_ley
agley96917333__agley
alley85721673__alley
arles56735743__arles
bailey115015673_bailey
barely114716793_barely
barleys125011843_barleys
barney115314453_barney
blarney12174763blarney
burley114715753_burley
cable95329913c_able_
cabled114819873c_abled
cabler104519173c_abler
cables104527553c_ables
cablet104429463c_ablet
cagey115917823c_a_gey
cakey145517273c_a_key
called94126733c_alled
callee84327293c_allee
caller85125483c_aller
callet84536763c_allet
camlet104426583c_amlet
caplet104226813c_aplet
carboy134914183c_arboy
carcel105018673c_arcel
carded105424903c_arded
carder94524183c_arder
care66968373c_ar_e_
cared86050093c_ar_ed
careen84119493c_areen
career85822243c_areer
carer74942333c_ar_er
cares77369183c_ar_es
caret75360563c_ar_et
carex144822303c_ar_ex
caried94528693c_aried
caries85147623c_aries
carked134024823c_arked
carl65144783c_arl__
carless95118493c_arless
carlin84421823c_arlin
carls77037423c_arl_s
carmen104019343c_armen
carnet84732873c_arnet
carneys124310543c_arneys
carny105822923c_ar_ny
caroled103717693c_aroled
caroler93816753c_aroler
carped115923763c_arped
carpel105418473c_arpel
carper104923633c_arper
carpet104530093c_arpet
carrel84718633c_arrel
carry105823783c_ar_ry
carse74934333c_arse_
carses85233653c_arses
carte75940423c_arte_
carted98631443c_arted
cartel85022533c_artel
carter84932273c_arter
cartes86239473c_artes
carve106227753c_arve_
carved124320853c_arved
carvel114817573c_arvel
carven114716663c_arven
carver114420143c_arver
carves115128453c_arves
caules85927253c_aules
causey113513273c_ausey
chablis14368563chablis
chadless1436403chadless
chafe135117353cha_fe_
chafed154813913cha_fed
chafer144714573cha_fer
chafes145017913cha_fes
chaffed19387703chaffed
chaffer18389473chaffer
chaffy20456473cha_ffy
chaine115119223chaine_
chained133812693chained
chaines124518733chaines
chaired134211243chaired
chairmen15105473chairmen
chaise114916413chaise_
chaises124317493chaises
chalah143511663cha_lah
chalehs15268803cha_lehs
chalets122813473cha_lets
chalk144814603cha_l_k
chalked17449863chalked
chalks155412143cha_lks
challa114014193cha_lla
challah15458323challah
challas124414123challas
challie124012853challie
challies133915643challies
challis124613463challis
challot123613263challot
chalot113020133cha_lot
chamber164011063chamber
chamfer17399863chamfer
chammy18488953cha_mmy
champed174111483champed
champer163813413champer
champy18509613cha_mpy
chance134617093chance_
chanced154113213chanced
chancel144011773chancel
chancer144215633chancer
chancery18366653chancery
chances145218093chances
chancy164010863cha_ncy
chandler14358373chandler
chandlery18384423chandlery
change124116753change_
changed144214143changed
changer134215543changer
changes134517583changes
channel123910483channel
chanted134015953chanted
chanter123919733chanter
chanteys16387493chanteys
chantry15388223chantry
chanty145215823cha_nty
chaoses124715123chaoses
chape125221143cha_pe_
chapel134911373cha_pel
chapels14429153chapels
chapes135421873cha_pes
chaplets1556883chaplets
chapmen1637283chapmen
chapped172711443chapped
chapter144213853chapter
char95132153char___
charade13129913charade
charades141310853charades
charas114223613char_as
charases131312763charases
chard116124743char__d
chards125119733char_ds
chargers144011323chargers
chariest13315503chariest
charing133721323charing
chariot12316213chariot
charism14712203charism
chark144222713char__k
charka154011703char_ka
charkas164810963charkas
charkha19405153charkha
charks155219703char_ks
charlock1944393charlock
charm126124663char__m
charmers154211333charmers
charmless1633583charmless
charms135218843char_ms
charnels13328173charnels
charpai1436633charpai
charpoys1834533charpoys
charqui2144003charqui
charr104821783char__r
charrier1378683charrier
charro114212953char_ro
charros124312143charros
charrs115219193char_rs
chars105936643char__s
chart105038283char__t
charters134115583charters
chartless1435703chartless
charts115823093char_ts
chase105127123cha_se_
chased125019293cha_sed
chaser114918383cha_ser
chases115128233cha_ses
chasmed154710173chasmed
chasmy16468543cha_smy
chasse115114603chasse_
chassed134712133chassed
chasses124017503chasses
chaste114617393chaste_
chastely1635813chastely
chasten124312403chasten
chaster124718503chaster
chatted133411893chatted
chattel12388893chattel
chatter124416643chatter
chattery16357273chattery
chatty14419363cha_tty
chaufer15347943chaufer
chawed155214603cha_wed
chawer144314413cha_wer
chay124924873cha___y
chazzen20214783chazzen
cheaply1735023cheapl_y
cheerled14105703cheerled
cheerly15417603cheerl_y
cherry144810763cher_ry
cherty144612473cher_ty
chicle134312543chicle_
chicles143512503chicles
chicly16429203chicl_y
chile105626893ch_ile_
chiles115425303ch_iles
chilled133310933chilled
chiller124112183chiller
chilly144113223ch_illy
chimbley2063133chimbley
chimleys1883633chimleys
chimney1795483chimney
chirked173810333chirked
chirker16429323chirker
chirmed15379733chirmed
chirped15379783chirped
chirper14359963chirper
chirpy16498913chir_py
chirre114111853chirre_
chirred133612123chirred
chirren12388743chirren
chirres123812253chirres
chokey184811713ch_okey
choler113717153ch_oler
choosey15459233choosey
chorale124313353chorale_
chorales133712883chorales
chorally1638103chorally
chorded144710553chorded
chore105126763chor_e_
chorea115216083chor_ea
chored125321883chor_ed
chores114828023chor_es
chorten122811303chorten
chortle124210443chortle_
chortled14326613chortled
chortler13336843chortler
chortles133611323chortles
chromy16309903ch_romy
churchy2044183churchy
churl105913883churl__
churls115411073churl_s
churned13358373churned
churner12298343churner
churred13409173churred
chutney1533823chutney
chyle134913483ch_yle_
chyles144813283ch_yles
claret84026573clar_et
claries93422203claries
clarify1536093clarify
clarity12310913clarity
claroes93113733claroes
clary105719613clar__y
clayey14407663cla_yey
clearly1236663clearl_y
coaled95022713coa_led
coaler84121713coa_ler
coaly105521593coa_l_y
coarse84813903coarse_
coarsely1335533coarsely
coarsen93210323coarsen
coarser93211203coarser
craaled10339423craaled
cradle93313163cradle_
cradled113410813cradled
cradler102910513cradler
cradles103114133cradles
crawled133710403crawled
crawler123510453crawler
crawly144610763crawl_y
curled95021653c_urled
curler85221323c_urler
curlew114010903c_urlew
curly105321233c_url_y
curvey144111843c_urvey
darkey145212423_darkey
dearly104615323dearl_y
early85324123_earl_y
farle86929243_farle_
farles96025783_farles
galley104215453_galley
garvey13127873_garvey
gharry13546273ghar_ry
gnarled9287723gnarled
gnarly104610383gnarl_y
hailed104122743_hailed
hailer94720343_hailer
hale76052833_ha_le_
haled95335823_ha_led
haler85033523_ha_ler
hales85449843_ha_les
hallel93514093_hallel
hamlet113722793_hamlet
haole84820083_haole_
haoles94919803_haoles
haply135915063_hapl_y
harden105718533_harden
harder105022403_harder
hardly135112833_hardly
hardy125622063_har_dy
hare76255733_har_e_
hared95742183_har_ed
hareem114312063_hareem
harem104924453_har_em
hares86255543_har_es
harked145422553_harked
harken135116343_harken
harl75740003_harl__
harlot94422803_harlot
harls85634503_harl_s
harmed125218833_harmed
harmer114719553_harmer
harped124418403_harped
harper115018403_harper
harpy136418213_har_py
harry115322953_har_ry
harslet10315653_harslet
haslet93222713_haslet
hauled104415213_hauled
hauler95015123_hauler
haulmy14455553_haulmy
hawkey19507633_hawkey
hayey144812533_ha_yey
henley1237483_henley
holey115626903_h_oley
horsey125115403_horsey
hurled104617453_hurled
hurler94717223_hurler
hurleys13407333_hurleys
hurly115819293_hurl_y
jarvey19135403_jarvey
marled95523163_marled
marly106925613_marl_y
nearly94813733nearl_y
parlay113713993_parlay
parle75836163_parle_
parled94626283_parled
parles86334403_parles
parleys125212373_parleys
parsley1247793_parsley
pearled10411543pearled
pearler9310373pearler
pearly116414843pearl_y
rarely93513653_rarely
scarey115016983scar_ey
scarlet91516943scarlet
shale85332833sha_le_
shaled105023953sha_led
shales94731253sha_les
shaly114322863sha_l_y
shantey134210043shantey
shapely1536893shapely
share86437083shar_e_
shared105829063shar_ed
sharer95025483shar_er
shares95236413shar_es
sharked153613913sharked
sharker144313813sharker
sharny124711833shar_ny
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
sharply15406833sharply
sharpy145211033shar_py
shauled1148793shauled
shawled1437773shawled
snarled83612363snarled
snarler73610633snarler
snarly93815003snarl_y
sparely123410673sparely
starlet71620123starlet
thaler94613103tha_ler
thirled11328093thirled
trawley13317303trawley
valley124311603_valley
varlet9423503_varlet
whale115517433wha_le_
whaled134612033wha_led
whaler124611973wha_ler
whales124716943wha_les
wharfed1734413wharfed
wharve15456203wharve_
wharves16457133wharves
whirled14368043whirled
whirler13307603whirler
whirly15448863whirl_y
whorled14366903whorled
yarely122810303_yarely
yearly125210273yearl_y

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274247.09618887.7
3Display Results4244240.1403028.6
 (SQL Overall)1786914247.37624226.0
 
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.