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 “argle” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
argle6542156(None) 
angle64528871angle
argled85314551argled
argles75218481argles
argue64818441argue
argyle1066061argyle
gargle84215461gargle
abele76323252abele
able66340532a_ble
addle74318352addle
age47154332a_g_e
agee56241492a_gee
aggie73415012aggie
agile65122262agile
aglee65728492a_glee
aglet65534142a_glet
agley96917332a_gley
agly86821802a_gly
agree65226032agree
ague55725922a_gue
aiglet74224192aiglet
aisle55223192aisle
ale36572342a__le
algae65319622algae
amble95924642amble
amole75724592amole
ample94720302ample
anele55628832anele
angel65019562angel
angled84219092angled
angler74017862angler
angles74426702angles
anglo65215372anglo
anile54634462anile
ankle95220252ankle
anole55330382anole
apple94517672apple
arable81821002arable
arame75026622arame
are37874572ar__e
areae55229742areae
arene55329412arene
areole61017282areole
arete56031352arete
argal65023392argal
argala74712672argala
argali75013752argali
argals75517712argals
argil65116882argil
argils75213622argils
argol65317262argol
argols74514612argols
argon65520592argon
argot67728652argot
argued84311172argued
arguer74510542arguer
argues74516412argues
argus66716542argus
argyles1136052argyles
argyll1033642argyll
ariel55228972ariel
aril45843022aril_
ariled75620322ariled
arils58732202arils
arise56436432arise
arles56735742ar_les
armlet84118192armlet
arose55832082arose
arse46539272ar_se
artel56122742artel
aryl75922342aryl_
aryls87015812aryls
axile126020512axile
axle116424602a_xle
azole145118032azole
bangle94018952bangle
barge85631022barg_e
bargee94624442bargee
bogle85821682bogle
bugle84721942bugle
burgle94815862burgle
carle74535702car_le
daggle93711902daggle
dangle84119302dangle
darkle113813942darkle
dartle73714832dartle
eagle64219482eagle
farle86929242far_le
fugle94915542fugle
gaggle93412622gaggle
garble94118452garble
gargled104210672gargled
gargler93710262gargler
gargles94214892gargles
gurgle83912472gurgle
haggle113511982haggle
ingle64120432ingle
jangle144416292jangle
large65325462larg_e
mangle93921322mangle
marble104219102marble
marge85328332marg_e
nargile847652nargile
ogle56325052_ogle
orle45630462or_le
parge85831852parg_e
parle75836162par_le
parole84425252parole
prole74527792prole
rage55742352rag_e
ragee65432662ragee
raggle83712882raggle
rale45050562_rale
rile45650532_rile
role45851822_role
rule49938422_rule
sarge65531132sarg_e
tangle74019952tangle
targe65227092targ_e
urge54722422urg_e
waggle113612302waggle
wangle103817502wangle
warble113516602warble
warsle93112922warsle

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001241.47036598.6
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.79699493.9
 
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.