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 “submaxillaries” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
submaxillaries25779(None) 
maxillaries2053103___maxillaries
premaxillaries257903premaxillaries
submaxillary2661003submaxillar__y
axillaries1744874____axillaries
auxiliaries1852735au___xiliaries
capillaries1554455___capillaries
subfamilies1852485subfami_l__ies
subsidiaries1552415sub__sidiaries
summabilities1975645summabi_lities
vexillaries2152875___vexillaries
ancillaries1354576___ancillaries
axillars15235996____axillar__s
balladries1345196__b_a__lladries
fritillaries1552006__fritillaries
imaginaries1453726__imagi_naries
luminaries1246596lu_m__i_naries
maxillae17256726___maxilla__e_
maxillary2143446___maxillar__y
maxillas17227706___maxilla___s
milliaries1248246___m__illiaries
premaxillae2261226premaxilla__e_
premaxillary266946premaxillar__y
premaxillas2251396premaxilla___s
railleries1046646___ra_illeries
sabadillas1352586sab_adilla___s
sagittaries1252996s___agittaries
salaries8319586s___a___laries
sanitaries1049916s___ani_taries
semasiologies1652996s_emasiologies
seminaries12410006s_em__i_naries
smallages1245296s__ma__lla_ges
suabilities13610816su__abi_lities
subcategories18101546subca_tegories
subcavities1854486subcavi___ties
subcellars1452856sub__cellar__s
subcontraries1772136sub_contraries
submandibulars217736submandibular__s
submariners1553226submari_ner__s
submarines1446916submari____nes
submaximal2351966submaxi_ma___l
subsatellites1561176subsatell_ites
subsecretaries187936subsecretaries
subtilities1347856sub__ti_lities
subtilties1246116sub__ti_l_ties
subvarieties1751996subvari__eties
suitabilities1548106suitabi_lities
sulfanilamides207926sulfani_lamides
summaries13118186su_m____maries
summitries1444646su_m_mi__tries
surveillances186956su_rveillances

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit124790519.36013332.3
3Display Results51510.0301700.0
 (SQL Overall)178691519.78018271.1
 
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.