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

128 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
ciliary124792(None) 
biliary1238211biliary
miliary1249461miliary
calvary1537182calvary
cilia73016762cilia__
ciliate9514602ciliate
clary105719612c_l_ary
culinary1355852culinary
military1347232military
milliary1346852milliary
alary86123443_al_ary
ancillary1444373ancillary
apiary113910383_apiary
ariary94114203_ariary
auxiliary1952063auxiliary
aviary12338413_aviary
axillary18235103axillary
bacillary1673963bacillary
billiard1145873billiard
binary11312223bi_nary
bleary115112553_bleary
briary114912003_briary
calamary1545463calamary
calcar10312753calcar_
calcars11312653calcars
calibre1136603calibre
calory11312843cal_ory
canary11314693c_anary
capillary16134263capillary
caviar11310163caviar_
caviare1238373caviare
caviars1238623caviars
cavitary1664963cavitary
cedary12419603c_edary
celery1139623cel_ery
celiac101910433celia_c
celiacs11157893celiacs
celibacy1742643celibacy
cellar84514983cellar_
cellars93713693cellars
chary135023133c__hary
chiliad1337563chilia_d
chiliads1445853chiliads
chiliarch1952473chiliarch
chiliasm15134513chiliasm
chiliast13117933chiliast
cigar8911803ci_gar_
cigars9910723ci_gars
ciliated11510953ciliated
ciliately1443953ciliately
ciliates10413453ciliates
cilice103213353cili_ce
cilices113814023cilices
cilium104311373cili_um
cindery13429193cindery
cinerary1346433cinerary
cithara12166513cithara
citify1437443citi_fy
civilly1535483civilly
claro75018693c_l_aro
clay95927413c_l_a_y
clear76219053c_lear_
clearly1236663c_learly
clears84116563c_lears
cliffy17435243c_liffy
clingy12659063c_lingy
cliquy20324713c_liquy
colicky1835783colicky
collar83816173collar_
collard103712923collard
collars93816573collars
colliery13307363colliery
covary1438743c_ovary
cullay113910173culla_y
diary95016973__diary
dietary1158663dietary
filar84819293fil_ar_
filial93013253filia_l
filially1447003filially
filiate10414233filiate
foliar93210973foliar_
friary124010093_friary
glairy10448273_glairy
glary96018543_gl_ary
goliard936073goliard
hilar85418143hil_ar_
ilia46026823_ilia__
iliac75013493_ilia_c
iliad64613463_ilia_d
iliads7448673_iliads
ilial55317843_ilia_l
laniary1068013laniary
leary85927383__leary
liar47229683__liar_
liard65418593__liard
liars54723163__liars
library1245323library
limitary1344933limitary
milady1236613mil_ady
milia72719573milia__
miliaria1048783miliaria
milliard1147033milliard
milliare1039153milliare
mimicry1643493mimicry
nobiliary1443013nobiliary
oilier64417233oilier_
oilily93111723oili_ly
oilway1235743oilwa_y
olivary1345163olivary
ostiary1036463ostiary
palmary14338553palmary
pilar75221503pil_ar_
pillar8314023pillar_
pillars9313493pillars
pillory12247453pillory
piscary1437423piscary
retiary1038333retiary
salary9515213sal_ary
salivary1444733salivary
silvery13328093silvery
solidary1245103solidary
solitary1146503solitary
tilbury1242983tilbury
topiary1245813topiary
vilify1536773vili_fy
vivary1536983vi_vary
wilier93217073wilier_
wilily123310763wili_ly

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271287.37318178.1
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.84222786.4
 
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.