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

276 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
argyle106606(None) 
argle65421561arg_le
argyles1136051argyles
argyll1033641argyll
agile65122262a_gile
angle64528872ang_le
arable81821002arable
areole61017282areole
argal65023392argal_
argala74712672argala
argali75013752argali
argals75517712argals
argil65116882argil_
argils75213622argils
argled85314552arg_led
argles75218482arg_les
argol65317262argol_
argols74514612argols
argue64818442arg_ue
argylls1143462argylls
aryl75922342ar_yl_
aryls87015812ar_yls
gargle84215462garg_le
gargoyle1342502gargoyle
nargile847652nargile
raggle83712882raggle
abele76323253a_bele
able66340533a__ble
abye97921003a_by_e
acyl95314293a_cyl_
acyls104211523a_cyls
addle74318353a_ddle
aedile73716653aedile
agape85614843a_gape
agate66525153a_gate
agave95314033a_gave
agaze156113663a_gaze
age47154333a_g__e
agee56241493a_g_ee
agene65621583a_gene
aggie73415013a_ggie
aglee65728493a_glee
aglet65534143a_g_let
agley96917333a_g_ley
agly86821803a_g_ly
agone65924553a_gone
agrafe1038093agrafe
agree65226033a_gree
ague55725923a_g_ue
aiglet74224193aig_let
airhole1048273airhole
aisle55223193a_isle
ale36572343a___le
algae65319623alg_ae
algal66518223algal_
alible8311973alible
alkyl12518043alkyl_
alkyls13465723alkyls
alkyne13436863alkyne
allele64514563allele
allyl85310543allyl_
allyls9437273allyls
amble95924643a_mble
amole75724593a_mole
ample94720303a_mple
ampule10710613ampule
amyl95515103a_myl_
amyls104512693a_myls
anele55628833a_nele
angel65019563angel_
angeled93211513angeled
angels74416173angels
angled84219093ang_led
angler74017863ang_ler
angles74426703ang_les
anglo65215373ang_lo
anile54634463a_nile
ankle95220253a_nkle
anole55330383a_nole
apple94517673a_pple
arables91814973arables
arame75026623ar_ame
arbute8311043arbute
arcade91013643arcade
arcane81216743arcane
archly1437353archly
are37874573ar___e
areae55229743ar_eae
areal55928733areal_
arene55329413ar_ene
areola6813673areola
areolae7811733areolae
areoles71016953areoles
arete56031353ar_ete
argalas84011093argalas
argalis84214193argalis
argent74023663argent
argon65520593arg_on
argons75018203argons
argosy1036423argosy
argot67728653arg_ot
argots74116033argots
arguable1135903arguable
argued84311173argued
arguer74510543arguer
argues74516413argues
argufy1344093argufy
argus66716543arg_us
arguses84711743arguses
aridly105513703aridly
ariel55228973ariel_
ariels65119373ariels
aril45843023ar_il_
ariled75620323ar_iled
arils58732203ar_ils
ariose64818723ariose
arise56436433ar_ise
arkose104911343arkose
arles56735743ar__les
armhole1236943armhole
armlet84118193ar_mlet
armure8710133armure
army96624183army__
arose55832083ar_ose
arouse65019983arouse
aroynt9312893aroynt
arrive91311793arrive
arse46539273ar__se
arsine64021043arsine
artal55525473artal_
artel56122743artel_
artels66216233artels
article9310923article
artily92814713artily
arty77531313arty__
arugola844353arugola
arugula843913arugula
arval86017013arval_
asyla839333a_syla
audile73315303audile
augite7312613augite
aureole738693aureole
auricle9139813auricle
awhile1257793awhile
axile126020513a_xile
axle116424603a__xle
aye67151763a__y_e
azole145118033a_zole
bangle94018953bang_le
barbule1137943barbule
barge85631023barg__e
bargee94624443barg_ee
barye105021493bar_y_e
baryte115312883bar_yte
boggle104511943boggle
bogle85821683bog_le
bridle94115463bridle
bugle84721943bug_le
burgle94815863burg_le
cariole9818343cariole
carle74535703car__le
carpale113414353carpale
chyle134913483_chyle
cradle93313163cradle
creole8913733creole
daggle93711903daggle
dangle84119303dang_le
dariole8711163dariole
darkle113813943dar_kle
dartle73714833dar_tle
draggle1056103draggle
dryly12538453dr_yly
eagle64219483eag_le
ergate7315143ergate
farle86929243far__le
fragile1147843fragile
fugle94915543fug_le
gaggle93412623gaggle
gale56347323__gale
garble94118453gar_ble
gargled104210673garg_led
gargler93710263garg_ler
gargles94214893garg_les
gargoyled1541993gargoyled
gargoyles1442833gargoyles
giggle94313513giggle
goggle94511573goggle
grayly13287963grayly
greyly13316543greyly
grille74315743grille
groyne1037213groyne
guggle94110433guggle
gurgle83912473gurg_le
gybe105916243__gybe
gyre84722763__gyre
gyve116215083__gyve
haggle113511983haggle
higgle113811743higgle
hoyle11314413_hoyle
ingle64120433ing_le
jangle144416293jang_le
jiggle153811993jiggle
joggle154010353joggle
juggle154310283juggle
large65325463larg__e
largely1136703largely
ligule74010833ligule
mangle93921323mang_le
marble104219103mar_ble
marge85328333marg__e
miggle104012113miggle
narghile1244033narghile
nargileh1272433nargileh
nargiles976793nargiles
niggle83612823niggle
odyle9349593_odyle
ogle56325053_og_le
oracle84313293oracle
orgone71110913orgone
orgy85218003orgy__
oriole6814293oriole
orle45630463or__le
parable111819773parable
parge85831853parg__e
pargyline1544653pargyline
parle75836163par__le
parole84425253par_ole
phyle134111153_phyle
prole74527793pr_ole
protyle12229453protyle
rabble103818243rabble
rackle123917293rackle
raddle84816173raddle
raffle123910703raffle
rage55742353rag__e
ragee65432663rag_ee
raggee84217603raggee
raggles93813283raggles
rale45050563_r_ale
rallye95110163rallye
ramble104519973ramble
rankle103414883rankle
rassle63813203rassle
rattle64717613rattle
regale74821453regale
rhyme13479553_rhyme
rifle85518333_rifle
rile45650533_r_ile
rille55728733_rille
roble75223023_roble
role45851823_r_ole
ruble74521253_ruble
rule49938423_r_ule
rye66032543_r_y_e
ryke115616403_r_yke
sarge65531133sarg__e
style85519363_style
tangle74019953tang_le
targe65227093targ__e
toggle83810873toggle
treble8311663treble
trifle94012883trifle
triple84215923triple
urge54722413urg__e
vagile10310543vagile
variole10711593variole
virgule1144283virgule
waggle113612303waggle
wangle103817503wang_le
warble113516603war_ble
warsle93112923war_sle
warstle10328013warstle
wiggle113713013wiggle
wriggle12316213wriggle
wryly14356703wr_yly
wyle105519383__wyle

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.373479064.3
2DLD Change Limit1127162765.03322395.4
3Display Results2762760.0763631.6
 (SQL Overall)1786912765.48232596.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.