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

248 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
blarney1217476(None) 
barney115314451b_arney
blarneys13183191blarneys
baloney1237482baloney
barley115116762b_arley
barned95623582b_arned
barneys12569562b_arneys
barny105821732b_arn_y
blare75826232blar_e_
blared95018242blar_ed
blares85021632blar_es
blarneyed1542152blarneyed
carney115315702_carney
alane56135613ala_ne_
alarmed1037743alarmed
alary86123443alar__y
bailey115015673b_ailey
bairnly1234503bairnly
baloneys1334663baloneys
bandy114824183b_a_ndy
bane65250433b_a_ne_
baned85436353b_a_ned
banes74945583b_a_nes
banned94721343b_anned
banner84421503b_anner
bannet84925333b_annet
banty106624003b_a_nty
barbe95328283b_arbe_
barbed115121313b_arbed
barbel104317073b_arbel
barber104419323b_arber
barbes104526233b_arbes
barbet104427883b_arbet
barde85330773b_arde_
barded105426423b_arded
bardes95026933b_ardes
bare65460523b_ar_e_
bared85144483b_ar_ed
barely114716793b_arely
barer74535803b_ar_er
bares75457133b_ar_es
barfed125416383b_arfed
barfly14339653b_arfly
barge85631023b_arge_
barged105822643b_arged
bargee94624443b_argee
barges94528253b_arges
barked135027313b_arked
barker124822863b_arker
barky145721613b_ar_ky
barleys125011843b_arleys
barmen105418533b_armen
barmy125218763b_ar_my
barn66444643b_arn__
barnier93213673b_arnier
barns76335143b_arn_s
baronet91022203b_aronet
barony115915303b_arony
barre75929543b_arre_
barred95725793b_arred
barrel84517873b_arrel
barren85317613b_arren
barres84427543b_arres
barret84930483b_arret
barter85525373b_arter
barye105021493b_arye_
baryes116218503b_aryes
beaned95621473bea_ned
beanery1237563bea_nery
bearded114212133bearded
bearer85323913bear_er
blabbed11357813blabbed
blabber10418923blabber
blabby1234813bla_bby
blacked163613373blacked
blacken15439793blacken
blacker154513513blacker
blackly1835253blackly
bladder11429153bladder
bladdery15344583bladdery
blade85923333bla_de_
bladed104717763bla_ded
blader93618583bla_der
blades95221253bla_des
blae66134643bla__e_
blain75421793blain__
blains84516373blain_s
blame95625493bla_me_
blamed116017953bla_med
blamer104417143bla_mer
blames105121863bla_mes
blanch133410853bla_nch
bland85320453bla_n_d
blander103715163blander
blandly1336043blandly
blank115418553bla_n_k
blanked144011223blanked
blanker134612023blanker
blanket134313093blanket
blankly1634263blankly
blanks124112893bla_nks
blaring104317113blaring
blarneying1641943blarneying
blase75524233bla_se_
blasted104213473blasted
blaster94017303blaster
blasty115611053bla_sty
blatancy1543573blatancy
blate75933783bla_te_
blather125314213blather
blatted104812713blatted
blatter94415653blatter
blawed124713893bla_wed
blawn106813703blawn__
blaze165520833bla_ze_
blazed184314713bla_zed
blazer174414023bla_zer
blazes174817353bla_zes
blazoned2044313blazoned
blazoner1944133blazoner
blazonry2242163blazonry
bleared104211253blear_ed
blearier1037333blearier
blearily1365953blearily
bleary115112553blear__y
blenny1156203bl_enny
blimey13468453bl_imey
blooey115110793bl_ooey
bluey104817053bl__uey
blurbed12337613blurbed
blurred10427803blurred
blurry11437673blur_ry
blurted10399783blurted
blurter9419833blurter
boarded113910503boarded
boarder103910323boarder
boloney1247763boloney
boney105227313b__oney
borane84620213borane_
boranes93720403boranes
borne77926793b_orne_
bourne83714093bourne_
bournes93615023bournes
brained103816103brained
brainy114815643brain_y
brandy124712063bra_ndy
branned104311693branned
branner94212373branner
branny115111833bra_nny
brawny144710603brawn_y
burley114715753b_urley
burned95818963b_urned
burner83819203b_urner
burnet84326173b_urnet
carnet84732873_carnet
carneys124310543_carneys
carny105822923_carn_y
charley15118273charley
charnel124010053charnel
clanky15469073cla_nky
claret84026573clar_et
claries93422203claries
clarify1536093clarify
clarinet10317293clarinet
clarity12310913clarity
claroes93113733claroes
clary105719613clar__y
clayey14407663cla_yey
darkey145212423_darkey
darned85018483_darned
darnel74312183_darnel
darner74017303_darner
earned74818333_earned
earner63617223_earner
flakey164410513fla_key
flanes94522423fla_nes
flannel1035423flannel
flare84823633flar_e_
flared105317603flar_ed
flares94521703flar_es
flaunty1354413flaunty
garner73917003_garner
garnet73928413_garnet
garvey13127873_garvey
glare65222963glar_e_
glared84715203glar_ed
glares75518873glar_es
glarier84112213glarier
glary96018543glar__y
gurney10429413_gurney
jarvey19135403_jarvey
journey1734873journey
lacey105820913_la_cey
lackey154813353_lackey
lane45153333_la_ne_
lanely93914483_la_nely
lanes54946793_la_nes
lanky125517483_la_nky
lanner64920603_lanner
larceny1234853_larceny
larded84319093_larded
larder73720973_larder
lardy96119273_lar_dy
laree56036293_lar_ee
larees65323113_larees
lares54852633_lar_es
large65325463_large_
largely1136703_largely
larger74417513_larger
larges74824233_larges
larine63927043_larine_
larked114519473_larked
larker104519243_larker
larky125218873_lar_ky
lawny115912013_lawn_y
learned8329303learned
learner7319383learner
liney87029633_l_iney
looney94712413_looney
malarkey1743413malarkey
parley116718363_parley
plaguey13335943plaguey
plained103812233plained
plainer93811983plainer
plainly1236473plainly
plane74929143pla_ne_
planed94420913pla_ned
planer84122653pla_ner
planes85028083pla_nes
planet84228353pla_net
planned103810153planned
planner93511623planner
sawney12387603_sawney
scarey115016983scar_ey
sharny124711833sharn_y
slangy105411393sla_ngy
slanty95114843sla_nty
slatey95417063sla_tey
slavey124011803sla_vey
tawney12338233_tawney
tourney1036273tourney
waney115120323_wa_ney
warned104018913_warned
warner93717223_warner
yarned105514023_yarned
yarner93313063_yarner
yearned11327373yearned
yearner10336873yearner

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 Limit1340272485.94022563.5
3Display Results2482480.0763263.2
 (SQL Overall)1786912486.42227824.8
 
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.