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

189 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
axillas1427896(None) 
axilla13289571axilla_
axillae14248231axillae
axillar14247561axillar
axillars15235991axillars
maxillas17227701maxillas
ancillas1048042ancillas
armillas1046662armillas
axillary18235102axillary
axils127217502axi_l_s
barillas10310192barillas
latillas847362latillas
manillas102611162manillas
maxilla16248192maxilla_
maxillae17256722maxillae
scillas9310472scillas
vanillas11228122vanillas
villas96117262_villas
abelias93213563abelias
abolla8410193abolla_
abollae936943abollae
abulias93210693abulias
achilleas1443263achilleas
aciculas12228563aciculas
agitas7310593agi_tas
ahimsas1234783ahimsas
ails45654713a_i_l_s
aiolis6316843a_iolis
aisles64721143a_isles
ajivas1655133aji_vas
akelas10311193a_kelas
alas46358123a___las
albas75925393a__lbas
alfas87219043a__lfas
algas65624933a__lgas
alias55834603a__lias
aliyas93911803ali_yas
allay85620393a__llay
allays94313743a__llays
alls46740923a__ll_s
almas76629773a__lmas
amias75831473ami__as
amigas95912173ami_gas
ancilla948603ancilla_
ancillae1047653ancillae
anilins7416793anilins
anils56326723ani_l_s
animals94111703animals
animas84418723ani_mas
anlas55626933a__nlas
apicals1159923apicals
apollos946793apollos
areolas71013863areolas
argalas84011093argalas
arias55438023ari__as
ariels65119373ariel_s
arillate8412993arillate
arils58732203ari_l_s
aristas7413523aristas
armilla936993armilla_
armillae1045563armillae
atlas55821583a__tlas
atolls65511353atoll_s
avellan1037293avellan
axels126313633ax_el_s
axial124515193axi__al
axially1737233axially
axil116424453axi_l__
axile126020513axi_l_e
axillaries1744873axillaries
axioms15408053axi_oms
axions134713483axi_ons
axis116127913axi___s
axises134413993axi_ses
axites134913833axi_tes
axles125219473ax__les
axoplasm1943733axoplasm
azaleas1636993azaleas
bacillar1276533bacillar
bacillus1245153bacillus
barilla9310323barilla_
bills75632863_bill_s
brillos9369183brillos
brills84916293brill_s
cabrillas1345603cabrillas
callas84526753_callas
canellas10310563canellas
cavallas1366843cavallas
cedillas1145743cedillas
challas124414123challas
chillis124411603chillis
chills114717703chill_s
chimlas1437453chimlas
chollas123811353chollas
dills65530973_dill_s
drills74414203drill_s
exilers14419733exilers
exiles134816403exi_les
exilian1446963exilian
failles102914133failles
favellas1446163favellas
fellas95116963_fellas
filles94224523_filles
fillos94415083_fillos
fills84632373_fill_s
frills94414223frill_s
gills64728193_gill_s
gorillas946373gorillas
grilles83715023grilles
grills74314803grill_s
hilloas104413553_hilloas
hillos94618893_hillos
hills85431353_hill_s
hollas94616903_hollas
ills47030423__ill_s
ixias12488373ixi__as
jills125122823_jill_s
kiblas1239323_kiblas
kills94526173_kill_s
krills104211283krill_s
lamellas1098163lamellas
lapillus1043933lapillus
latilla737953latilla_
maills84215283maill_s
manilas93915873mani_las
manilla93012473manilla_
manilles102312603manilles
mantillas1147043mantillas
matildas1145023matildas
maxillary2143443maxillary
maximals19325223maximals
megillas1145893megillas
milles84526563_milles
mills75435053_mill_s
milpas101710273_milpas
mullas84215933_mullas
nills54926673_nill_s
ollas54218283__ollas
paellas9411413paellas
papilla11127913papilla_
papillae12137023papillae
papillar1296713papillar
patellas1039103patellas
perillas10310823perillas
pillar8314023_pillar
pillars9313493_pillars
pills74130973_pill_s
prills84015613prill_s
psyllas1244883psyllas
quillai1644993quillai
quillais1745003quillais
quills153811853quill_s
ramtillas1174193ramtillas
rilles64725503_rilles
rills55032713_rill_s
salsillas943853salsillas
scilla8310943scilla_
shills94519613shill_s
sills55135993_sill_s
silvas92912183_silvas
skills104313923skill_s
spills84717463spill_s
squillas1745333squillas
stellas72813043stellas
stills64118573still_s
swills94213363swill_s
tailles72516473tailles
thills95515383thill_s
tills54631713_till_s
trills64319853trill_s
tuilles72411923tuilles
twills9489793twill_s
vanilla10238743vanilla_
variolas1168533variolas
vexilla1744663vexilla_
vexillar1843463vexillar
villa85321233_villa_
villae95615383_villae
vills86429323_vill_s
villus93611223_villus
violas93713523_violas
wallas95719393_wallas
waxbills2042783waxbill_s
wills84528963_will_s
yills83921553_yill_s
zillah1836563_zillah
zillahs1935383_zillahs
zills144020783_zill_s
zorillas1745483zorillas

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 Limit1340271897.17018692.7
3Display Results1891890.0633000.0
 (SQL Overall)1786911897.65623340.0
 
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.