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

107 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
axillar1424756(None) 
axilla13289571axilla_
axillae14248231axillae
axillars15235991axillars
axillary18235101axillary
axillas14278961axillas
bacillar1276532bacillar
maxilla16248192maxilla_
maxillae17256722maxillae
maxillary2143442maxillary
maxillas17227702maxillas
papillar1296712papillar
pillar8314022_pillar
vexillar1843462vexillar
abolla8410193abolla_
abollae936943abollae
acicular12218663acicular
acinar8310483aci_nar
alar46340073a___lar
allay85620393a__llay
altar55520643a__ltar
alular6311353a_lular
ampullar1253133ampullar
ancilla948603ancilla_
ancillae1047653ancillae
ancillary1444373ancillary
ancillas1048043ancillas
angular838533angular
annular737693annular
areolar779223areolar
arillate8412993arillate
armilla936993armilla_
armillae1045563armillae
armillary1443913armillary
armillas1046663armillas
ashlar9338193a_shlar
astylar10265063astylar
auxiliary1952063auxiliary
avellan1037293avellan
avicular13237273avicular
axial124515193axi__al
axially1737233axially
axil116424453axi_l__
axile126020513axi_l_e
axillaries1744873axillaries
axils127217503axi_l_s
bacillary1673973bacillary
barilla9310323barilla_
barillas10310193barillas
basilar937303basi_lar
biller84923483_biller
capillary16134263capillary
caviller1337063caviller
cellar84514983_cellar
chiller124112183chiller
collar83816173_collar
dollar74110983_dollar
driller84311883driller
eviller1056673eviller
exiler134712183exi_ler
exilian1446963exilian
familiar1365953familiar
filar84819293_fi_lar
filler94623623_filler
friller104111743friller
giller74519733_giller
griller84513353griller
hilar85418143_hi_lar
hiller94421633_hiller
iller54821293__iller
killer104917953_killer
lamellar1096493lamellar
latilla737953latilla_
latillas847363latillas
manilla93012473manilla_
manillas102611163manillas
miller84625413_miller
ocellar936533ocellar
paillard1146263paillard
papilla11127913papilla_
papillae12137023papillae
papillary1694403papillary
patellar1046863patellar
pilar75221503_pi_lar
pillars9313493_pillars
pilular938203_pilular
quillai1644993quillai
railcar945483railcar
scilla8310943scilla_
scillas9310473scillas
siller64026063_siller
spiller92914333spiller
stellar72610433stellar
stiller73414303stiller
swiller103211663swiller
tiller64222543_tiller
triller74215893triller
vanilla10238743vanilla_
vanillas11228123vanillas
variolar1176343variolar
vexilla1744663vexilla_
vexillary2242443vexillary
villa85321233_villa_
villae95615383_villae
villas96117263_villas
willer94021063_willer
zillah1836563_zillah

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 Limit1340271076.15321782.4
3Display Results1071070.0502140.0
 (SQL Overall)1786911076.60927037.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.