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

192 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
articles1031024(None) 
article9310921article_
articled1137061articled
particles1339801particles
artistes83213342artistes
auricles10138332auricles
canticles1339182canticles
cuticles1237892cuticles
particle1239532particle_
radicles11249702radicles
reticles103912482reticles
utricles1037222utricles
actives12311523acti_ves
advices13136933advic_es
aediles83413903aedi_les
affiches1945233affiches
airtimes1037503airti_mes
aisles64721143a__isles
aitches123014363ait_ches
amices105018013a_mic_es
anticked1538393anticked
anticks134612253antic_ks
anticlines1249363anticlines
anticly12410053anticl_y
antics84621453antic__s
anticults1159373anticults
antipoles11810473antipoles
antiques1738883antiques
apices104916263a_pic_es
arables91814973ar_ables
arbuscles1342813arbuscles
arches114822043ar__ches
arctics1138953arctic__s
areoles71016953ar_eoles
argils75213623argi_l_s
argles75218483ar__gles
argyles1136053ar_gyles
ariels65119373ar_iel_s
ariled75620323ar_i_led
arils58732203ar_i_l_s
arises65233803ar_i_ses
arles56735743ar___les
armholes1347383armholes
armies85123693armi__es
armillas1046663armillas
arnicas939543arnic_as
arrises71617583arri_ses
arrives101311513arri_ves
arsines73518813arsi_nes
artels66216233art_el_s
arteries8321483arteries
arterioles1045663arterioles
artichokes1953053artichokes
articling1247713articling
articular1179383articular
articulates1349043articulates
artier63419733arti__er
artiest73121993arti__est
artifices1446473artifices
artillery1243573artillery
artily92814713arti_l_y
artiness81615403artiness
artisans888523artisans
artiste73813693artiste_
artists74215593arti_sts
artless73712513art__less
astilbes1044733astilbes
attaches13137723attaches
atticizes2047663atticizes
attics84413283attic__s
attires72312953atti_res
audibles11215533audibles
audiles83112613audi_les
auricle9139813auricle_
auricled11135703auricled
barbicels15113513barbicels
barnacles1355333barnacles
bastiles10313353basti_les
bastilles1147353bastilles
bernicles1345403bernicles
brailles1039493brailles
brickles162810283br_ickles
bricoles122610303br_icoles
bridles104114473br_idles
britches15278683britches
brittles10178653brittles
calicles123811433calicles
canticle1239703canticle_
carices114220953car_ic_es
carioles10817073car_ioles
carrioles1169473carrioles
caruncles1345003caruncles
caulicles1344383caulicles
chicles143512503_chicles
cornicles1368243cornicles
cortices12615013cortic_es
cubicles1435883cubicles
curricles13105423curricles
cuticle1138233cuticle_
darioles9710693dar_ioles
dartles84014133dart__les
denticles1237753denticles
entices91616333entic_es
entitles8710663entitles
fascicles1664263fascicles
fetiales11319613fetiales
fetiches1636953fetiches
funicles13246833funicles
graciles112511613graciles
graticules13104363graticules
grilles83715023gr_illes
icicles1135943_icicles
intitles8710003intitles
latices9313763latic_es
lattices1038383lattic_es
mastiches1647333mastiches
matrices12312083matric_es
mortices12711563mortic_es
motiles93317433moti_les
nargiles976793nargi_les
notices9312283notic_es
oracles93212423or_acles
orioles7412993or_ioles
orrices9129363orric_es
ossicles1054183ossicles
ostioles839273ostioles
panicles121010113panicles
pantiles103617153panti_les
partials101911953partial_s
partible1238063partible_
participles1773263participles
parties93230863parti__es
pastiches1637453pastiches
pastilles1148703pastilles
pedicles1338683pedicles
petioles10311643petioles
porticoes1348253porticoes
potiches1539203potiches
prices104524543pr_ic_es
prickles162511093pr_ickles
quartiles1845603quarti_les
radicels11297183radicels
radices102314263radic_es
radicle103510713radicle_
ratables10159723ratables
ratches123620463rat_ches
ratholes11312413ratholes
raticides1248693raticides
ratifies11313513ratifies
ratines75328583rati_nes
ratites74920683rati_tes
rattles73217303rat_tles
reticle94112623reticle_
reticules1139013reticules
retiles74426993reti_les
retitles83612593retitles
rices75536153_r_ic_es
riches115022083_r_iches
rifles94217703_r_ifles
riles55343643_r_i_les
rilles64725503_r_illes
rutiles74315843ruti_les
sanicles10149943sanicles
silicles1037073silicles
stickles142512103_stickles
stifles103013393_stifles
stiles64328773_sti_les
strickles1567813strickles
surtitles945633surtitles
testicles1146773testicles
tickles133416853__tickles
tiles55542103__ti_les
titles63719923__titles
treacles1039703treacles
trices84826333tr_ic_es
trickles143013763tr_ickles
trifles103814823tr_ifles
triples94616873tr_iples
triticales1246263triticales
tunicles10217133tunicles
urticates1148893urticates
utricle937913utricle_
varices123313573var_ic_es
varioles11711123var_ioles
vehicles16204683vehicles
vernicles1446133vernicles
versicles1446353versicles
vertices13612283vertic_es
vesicles13127073vesicles
vortices1369123vortic_es
wartimes1336963warti_mes
wavicles1633783wavicles

Search took 8 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 Filter1786911461620.483369960.7
2DLD Change Limit1461621927.15620425.1
3Display Results1921920.0762526.3
 (SQL Overall)1786911927.71523161.5
 
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.