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

211 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
article931092(None) 
articled1137061articled
articles10310241articles
particle1239531particle
anticly12410052anticly
artily92814712arti_ly
artiste73813692artiste
auricle9139812auricle
canticle1239702canticle
cuticle1138232cuticle
partible1238062partible
particles1339802particles
radicle103510712radicle
reticle94112622reticle
utricle937912utricle
actable11313473actable
active11313743acti_ve
addible11236063addible
advice12107883advic_e
aedile73716653aedi_le
affiche1844313affiche
agile65122263a_gi_le
airtime948063airti_me
aisle55223193a__isle
alible8311973a_lible
amice96122873a_mic_e
anile54634463a_ni_le
antiacne1048583antiacne
antic75728863antic__
anticar9312663anticar
antick124814583antic_k
anticked1538393anticked
anticks134612253anticks
anticline11410703anticline
anticold1147473anticold
antics84621453antic_s
anticult10411683anticult
antiflu1046683antiflu
antimale10312463antimale
antipole10910153antipole
antique1638883antique
aortic8316613aortic__
arable81821003ar_able
arbuscle1242883arbuscle
arctic10313513arctic__
arctics1138953arctic_s
areic73219393areic__
areole61017283ar_eole
argil65116883argi_l_
argils75213623argi_ls
argle65421563ar__gle
argyle1066063ar_gyle
aridly105513703ar_idly
ariel55228973ar_iel_
ariels65119373ar_iels
aril45843023ar_i_l_
ariled75620323ar_i_led
arils58732203ar_i_ls
ariose64818723ar_iose
arise56436433ar_i_se
armhole1236943armhole
armilla936993armilla
armillae1045563armillae
arnica8310443arnic_a
arnicas939543arnicas
arrive91311793arri_ve
arsine64021043arsi_ne
artal55525473art_al_
artel56122743art_el_
artels66216233art_els
arteriole945893arteriole
artful968273artful_
artichoke1852993artichoke
articling1247713articling
articular1179383articular
articulate12410243articulate
artier63419733arti_er
artiest73121993artiest
artifice1346403artifice
artillery1243573artillery
artisan759463artisan
artist64125543arti_st
artistes83213343artistes
artists74215593artists
astilbe945653astilbe
atilt54828473a_ti_lt
atingle848253a_tingle
atrial65418943atrial_
attache12106693attache
attic75618353attic__
atticize1948443atticize
attics84413283attic_s
attire62412383atti_re
audible10228243audible
audile73315303audi_le
auricled11135703auricled
auricles10138333auricles
avertible1495233avertible
awhile1257793awhi_le
axile126020513a_xi_le
barbicel14144963barbicel
barnacle1245943barnacle
bastile9313913basti_le
bastille1047993bastille
bernicle1245443bernicle
braille939713braille
brickle15279933br_ickle
bricole112810493br_icole
bridle94115463br_idle
brittle9168603brittle
calicle113111433calicle
canticles1339183canticles
cariole9818343car_iole
carriole1089863carriole
cartable121314093cartable
caruncle1244713caruncle
caulicle1245043caulicle
chicle134312543_chicle
cornicle1258783cornicle
cubicle1337003cubicle
curricle12145933curricle
cuticles1237893cuticles
dariole8711163dar_iole
dartle73714833dart__le
denticle1137773denticle
entice81316863entic_e
entitle7610293entitle
fascicle1554633fascicle
fertile10311733ferti_le
funicle12237483funicle
futile93914953futi_le
gracile102512603gracile
graticule1254573graticule
grille74315743gr_ille
icicle1036583_icicle
intitle7610583intitle
lattice938433lattic_e
martial92415413martial_
mastiche1547173mastiche
mortice11711493mortic_e
motile83818343moti_le
nargile847653nargi_le
notice8313443notic_e
oracle84313293or_acle
oriole6814293or_iole
orrice81410163orric_e
ossicle944483ossicle
ostiole739013ostiole
panicle11129983panicle
pantile93918483panti_le
partial92616263partial_
partials101911953partials
participle1683593participle
partite9317133parti_te
pastiche1546933pastiche
pastille1038943pastille
pedicle1238973pedicle
petiole9311303petiole
potiche1438043potiche
price93725413pr_ic_e
prickle153611013pr_ickle
quartile1747043quarti_le
radiale83813523radiale
radicel10278873radicel
radicles11249703radicles
ratable91717553ratable
rathole10312053rathole
raticide1148943raticide
ratine65131823rati_ne
ratite65022423rati_te
rattle64717613rat_tle
reticles103912483reticles
reticule1049303reticule
retile65929673reti_le
retitle73913093retitle
rice64942913_r_ic_e
rifle85518333_r_ifle
rile45650533_r_i_le
rille55728733_r_ille
rutile65217683ruti_le
sanicle91210263sanicle
silicle937753silicle
stickle132410973_stickle
stifle93611903_stifle
stile54931573_sti_le
strickle1467793strickle
surtitle845283surtitle
tactile9310613tacti_le
tartily103511573tarti_ly
testicle1037443testicle
tickle124616743__tickle
tile45451443__ti_le
title54721073__title
tortile7313193torti_le
treacle939973treacle
trice75127493tr_ic_e
trickle133613443tr_ickle
trifle94012883tr_ifle
triple84215923tr_iple
triticale1147513triticale
tunicle9308033tunicle
urticate1049863urticate
utile54718933_uti_le
utricles1037223utricles
variole10711593var_iole
vehicle15175253vehicle
vernicle1346433vernicle
versicle1366583versicle
vesicle12217923vesicle
wartime1237743warti_me
wavicle1534063wavicle

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 Limit1340272116.06322105.7
3Display Results2112110.0932268.8
 (SQL Overall)1786912116.56227231.2
 
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.