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

514 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
haggle11351198(None) 
daggle93711901daggle
gaggle93412621gaggle
haggled13359281haggled
haggler12328931haggler
haggles123312481haggles
higgle113811741higgle
raggle83712881raggle
waggle113612301waggle
aggie73415012_aggie
agile65122262_agile
angle64528872_angle
argle65421562_argle
baggie102912192baggie
bangle94018952bangle
boggle104511942boggle
daggled11329462daggled
daggles103611912daggles
dangle84119302dangle
draggle1056102draggle
eagle64219482ea_gle
gaggled11359912gaggled
gaggles103512592gaggles
gargle84215462gargle
giggle94313512giggle
goggle94511572goggle
guggle94110432guggle
habile11515202habile
hackle154916812hackle
hagged124317702hagged
haggis11209512haggis
hagglers13326622hagglers
hale76052832ha__le
handle104219292handle
hantle94318202hantle
haole84820082ha_ole
hassle93711592hassle
higgled13339072higgled
higgler12369802higgler
higgles123911802higgles
jangle144416292jangle
jiggle153811992jiggle
joggle154010352joggle
juggle154310282juggle
mangle93921322mangle
miggle104012112miggle
niggle83612822niggle
raggee84217602raggee
raggles93813282raggles
tangle74019952tangle
toggle83810872toggle
vagile10310542vagile
waggled13389362waggled
waggles123812002waggles
waggly14347292waggly
wangle103817502wangle
wiggle113713012wiggle
abele76323253_abele
able66340533_a_ble
addle74318353_addle
agape85614843_agape
agate66525143_agate
agave95314033_agave
agaze156113663_agaze
age47154333_a_g_e
agee56241493_a_gee
agene65621583_agene
agger76420893_agger
aggies83515513_aggies
aggro738003_aggro
aglee65728493_aglee
aglet65534143_a_glet
agley96917333_a_gley
agly86821803_a_gly
agone65924553_agone
agree65226033_agree
ague55725923_a_gue
aiglet74224193_aiglet
aisle55223193_aisle
ale36572343_a__le
algae65319623_algae
amble95924633_amble
amole75724593_amole
ample94720303_ample
anele55628833_anele
angel65019563_angel
angled84219073_angled
angler74017863_angler
angles74426703_angles
anglo65215363_anglo
anile54634463_anile
ankle95220253_ankle
anole55330373_anole
apple94517673_apple
argled85314543_argled
argles75218483_argles
argue64818443_argue
argyle1066063argyle
axile126020513_axile
axle116424603_a_xle
azole145118033_azole
babble94017113babble
badge94819683badg_e
baffle14399873baffle
bagel85116793bagel_
bagels95712313bagels
baggage1235633baggage
bagged114519903bagged
bagger104619203bagger
baggier113611643baggier
baggies113814853baggies
baggily1436043baggily
baggy125615683bagg_y
bale66353843ba__le
bangles103617413bangles
barge85631023barg_e
bargee94624443bargee
battle85217863battle
bauble103813213bauble
beagle93612593beagle
biggie103810933biggie
boggled12409003boggled
boggler113910083boggler
boggles113411823boggles
bogle85821683_bogle
bugle84721943_bugle
bungle97116113bungle
burgle94815863burgle
cable95329913ca_ble
cackle143416923cackle
cadge94018783cadg_e
cage75339063ca_g_e
cagily12411563cagily
cajole154011183cajole
candle94321483candle
cangue91012443cangue
cantle84522153cantle
carle74535703ca_rle
castle84918963castle
cattle85118903cattle
caudle93912913caudle
change124116753chang_e
charge125114213charg_e
dabble114515193dabble
daddle94214283daddle
dagga839543dagg_a
daggas937973daggas
dagger95017293dagger
dale55643983da__le
dandle84218093dandle
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
dangly114212263dangly
dapple1138853dapple
darkle113813943darkle
dartle73714833dartle
dawdle11399503dawdle
dazzle1536853dazzle
dingle84317073dingle
doggie93910893doggie
dongle83612493dongle
draggled1254673draggled
draggles1145963draggles
eagled82914043ea_gled
eagles73819163ea_gles
eaglet73722583ea_glet
eagre64315323ea_gre
fable105824753fa_ble
facile112514883facile
fadge104816993fadg_e
fagged124717703fagged
faggier12309843faggier
faggot1139043faggot
faggy136514373fagg_y
faille93414743faille
farle86929243fa_rle
fragile1147843fragile
fugle94915543_fugle
gabble113815723gabble
gable85325523ga_ble
gage65936103ga_g_e
gagged104817153gagged
gagger95016513gagger
gale56347323__gale
gamble115417183gamble
gangly113911583gangly
gangue81310573gangue
garble94118453garble
gargled104210673gargled
gargler93710263gargler
gargles94214893gargles
gauge76117903gaug_e
giggled114010073giggled
giggler101029883giggler
giggles103312933giggles
giggly12518703giggly
goggled11348953goggled
goggler10379323goggler
goggles103510793goggles
goggly12337053goggly
guggled11338563guggled
guggles103410543guggles
gurgle83912473gurgle
hackee154921833hackee
hackie154615623hackie
hackled173312483hackled
hackler163512353hackler
hackles162917063hackles
hackly18298733hackly
hadal95518123hadal_
hade85440193ha__de
hadjee174111823hadjee
hae67364003ha___e
hag77255743ha_g__
hagbut1278913hagbut
hagdon1188283hagdon
haggada1353623haggada
haggard13377183haggard
hagging133114683hagging
haggises1335883haggises
haggish15207473haggish
haggling14227273haggling
hagride1237553hagride
hagrode1236443hagrode
hags86740843ha_g_s
hail74839063ha_il_
hailed104122743ha_iled
hailer94720343ha_iler
hails85231643ha_ils
hake115637843ha__ke
halal85623593halal_
halala94715093halala
halals95018313halals
haled95335823ha__led
haler85033523ha__ler
hales85449843ha__les
half106238453ha__lf
halide103417993halide
halite93624233halite
hall75741163ha__ll
hallel93514093ha_llel
hallo85127553ha_llo
halls85633783ha_lls
halm95834973ha__lm
halo76437323ha__lo
halt76056303ha__lt
halve114818923ha_lve
hamal104623103hamal_
hamals114816813hamals
hamate113319823hamate
hame97043133ha__me
hamlet113722793ha_mlet
hamuli1137053hamuli
hance105424153ha_nce
handled124114533handled
handler113516163handler
handles114020653handles
hang85535543hang__
hangable1438203hangable
hangar104114503hangar
hanged114222393hanged
hanger104023253hanger
hangmen1337373hangmen
hangs95726723hang_s
hangul1049213hangul
hangup1277293hangup
hankie133915713hankie
hanse85722793ha_nse
hansel95214373hansel
hantles104117513hantles
haoles94919803ha_oles
haply135915063ha_ply
hardly135112833hardly
hare76255733ha__re
harl75740003ha_rl_
harls85634503ha_rls
harslet10315653harslet
haslet93222713ha_slet
hassel95614213hassel
hassled11358303hassled
hassles103411693hassles
haste85927863ha_ste
hatable121713963hatable
hate78450173ha__te
haugh125114053haug_h
haughs13408563haughs
haul75530453ha_ul_
hauled104415213ha_uled
hauler95015123ha_uler
haulm104415413ha_ulm
hauls86123733ha_uls
haute89521613ha_ute
have106137073ha__ve
hawala12368913hawala
hawkie163810093hawkie
hawse116015123ha_wse
haze164833393ha__ze
hazel176414813hazel_
hazels185710083hazels
hazily2179063hazily
heckle153112093heckle
heddle114211163heddle
hedge105317333hedg_e
henge94819823heng_e
higglers13297223higglers
highly1636823highly
hinge95323443hing_e
hirple11158973hirple
hirsle9159573hirsle
hoagie102310003hoagie
hobble133913433hobble
hogg96617533hogg__
hogged125817773hogged
hogger114615083hogger
hogget114715763hogget
hoggs107212463hogg_s
hogtie102711763hogtie
hole77553393h__ole
hondle103914523hondle
hopple132910483hopple
hoyle11314413h_oyle
huckle153913073huckle
huddle113712993huddle
huge86321653h_ug_e
hugely1336803hugely
huggable1543333huggable
hugged124113643hugged
hugger114713123hugger
humble133615053humble
hurdle103712793hurdle
hurtle93512943hurtle
hustle93113993hustle
ingle64120433_ingle
jagg136115313jagg__
jagged164115353jagged
jagger154016003jagger
jaggier16339183jaggier
jaggies163311083jaggies
jaggs148111493jagg_s
jaggy175913143jagg_y
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
jangly174310603jangly
jaygee1759463jaygee
jiggled17358843jiggled
jiggles164111433jiggles
jiggly18378713jiggly
jingle143815223jingle
joggled17398433joggled
joggler16398833joggler
joggles164410413joggles
juggled17348653juggled
juggler16418873juggler
juggles164510843juggles
jungle144012653jungle
kale86533753ka__le
labile8315213labile
ladle66320443la_dle
lagged95520133lagged
lagger85919833lagger
lagune7158633lagune
langley1147443langley
langue71012173langue
large65325463larg_e
ligule74010833ligule
loggie84011993loggie
luggie8318903luggie
mackle143716433mackle
macle96127003ma_cle
macule104115273macule
mage75739123ma_g_e
maggot10311703maggot
magilp1137613magilp
maglev1237023ma_glev
magpie1139093magpie
maigre9309163maigre
maile75232213ma_ile
male66052293ma__le
malgre9299303malgre
mange84930183mang_e
mangel94017533mangel
mangled113615253mangled
mangler103215643mangler
mangles104021463mangles
mantle84420923mantle
maple95521143ma_ple
marble104219103marble
marge85328333marg_e
maugre9308973maugre
miggles113512033miggles
mingle93518783mingle
moggie103210103moggie
muggee103612833muggee
nagged93916053nagged
nagger84016123nagger
naggier9309153naggier
naggy106612823nagg_y
nargile847653nargile
niggled10319203niggled
niggler93610293niggler
niggles93512203niggles
niggly11418913niggly
ogle56325053__ogle
paddle104615143paddle
padle84522343pa_dle
page76036103pa_g_e
pale66055013pa__le
papule102212133papule
parge85831853parg_e
parle75836163pa_rle
parole84425253parole
phage115113673pha_g_e
piggie103210773piggie
pungle94413573pungle
rabble103818243rabble
rackle123917293rackle
raddle84816173raddle
raffle123910703raffle
rage55742353ra_g_e
ragee65432663ra_gee
ragg65622693ragg__
ragged94620263ragged
raggees93710913raggees
raggies93214733raggies
raggs75216473ragg_s
raggy106116573ragg_y
rale45050563ra__le
ramble104519973ramble
range64728413rang_e
rankle103414883rankle
rassle63813203rassle
rattle64717613rattle
regale74821453regale
reggae858953reggae
sable74732163sa_ble
saddle83915493saddle
sage55044593sa_g_e
sagely102811383sagely
saggar84010853saggar
sagged94120003sagged
sagger84321073sagger
saggier92912063saggier
saggy105917463sagg_y
sale44959703sa__le
sample104215013sample
sarge65531133sarg_e
shackle16409543shackle
shagged134210123shagged
shaggier13116053shaggier
shaggily1643773shaggily
shaggy14478043shagg_y
shale85332833sha__le
shamble14149263shamble
shingle117711273shingle
single74520603single
smuggle11265013smuggle
sniggle9316833sniggle
snuggle9275713snuggle
spangle1038403spangle
staggie9138463staggie
straggle10359133straggle
swaggie12135783swaggie
table75429603ta_ble
tackle123815733tackle
tagged93418123tagged
tagger84017693tagger
taille63116923taille
tale46154163ta__le
tamale83717393tamale
tangled94214633tangled
tangler83515073tangler
tangles83920043tangles
tangly104413913tangly
targe65227093targ_e
tattle64115653tattle
thuggee1245263thuggee
tingle74319053tingle
toggled10428653toggled
toggler9399193toggler
toggles93710973toggles
twangle1145803twangle
unagile838283unagile
vagal94613633vagal_
vague96513113va_gue
vale74937343va__le
veggie1136303veggie
wabble133714843wabble
waddle114715303waddle
waffle15369183waffle
wage84834083wa_g_e
wagged124616123wagged
wagger113616013wagger
wagglier1344323wagglier
waggon1136393waggon
wale74546433wa__le
wamble134415753wamble
wandle105316663wandle
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles
warble113516603warble
warsle93112923warsle
wattle94314213wattle
whale115517433wha__le
whangee14268613whangee
wiggled13299603wiggled
wiggler123110763wiggler
wiggles123312463wiggles
wiggly14559683wiggly
wrangle1137383wrangle
wriggle12316213wriggle
zagged183612513zagged

Search took 6 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 Limit1127165145.57620214.5
3Display Results5145140.1732971.1
 (SQL Overall)1786915145.89230327.7
 
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.