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

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

81 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
administers145290(None) 
administer1343271administer_
administered1661902administered
admonishers1752342admonishers
ministers1139622__ministers
administering1762193administering
admitters1244553adm__itters
admonisher1652723admonisher_
admonishes1643493admonishe_s
admonitors1342973admoni_tors
maladministers197913maladministers
minister10410363__minister_
minsters103813923__min_sters
reminiscers1552973reminiscers
subministers1651873subministers
accipiters16162814accipi_ters
adjusters1744164ad__justers
administrant1562484administrant
administrants1662064administrants
administrate1562534administrate
administrates1662394administrates
administrators1761714administrators
admirers1134714adm__i_rers
admittees1243274adm__ittees
admitter1135114adm__itter_
admonished1743034admonishe_d
admonitor1243124admoni_tor_
admonitory1652414admoni_tory
adonises92611434ad_onis_e_s
advisers12135004ad__vis_ers
agonistes10266264a_goniste_s
alpinists1195794alpinist__s
aminities11312914a_mini_ties
ammoniates1444794ammoniate_s
ammonites1348144ammoni_te_s
amniotes1036604a_m_niote_s
anointers937004anoin__ters
arrivistes1342304arriviste_s
assisters936354a__ssisters
banisters11189474__banisters
bannisters1244324_bannisters
canisters112310194__canisters
cannisters1245014_cannisters
demisters1249204_d_emisters
diasters92913184_d_i_asters
diesters92513604_d_i_esters
digesters11257884_d_igesters
diminishes1644974diminishe_s
disasters1039154_d_isasters
disinters1039714_d_isinters
dominickers2051954dominickers
feminises14229754feminis_e_s
feminists14227624feminist__s
filisters1237004__filisters
finishers1545354__finishers
ganisters10248314__ganisters
gannisters1153844_gannisters
insisters997654___insisters
lamisters1157124lam__isters
luminists1147174luminist__s
magisters1235804__magisters
maladminister186974maladminister_
meisters103313844__m_eisters
minishes13310584__minishe_s
ministered1344964__ministered
ministry1385794__minist_ry
minivers1337484__mini_vers
minster93914324__min_ster_
minters93822474__min__ters
misinters1138184__misinters
misters93927514__m__isters
monsters103314554__mon_sters
munsters104010554__mun_sters
palmisters1444674palm__isters
pinasters1136824__pinasters
refinishers1752624refinishers
reminiscer1443704reminiscer_
reminisces1445254reminisce_s
sinister838584__sinister_
spinsters1136614_spin_sters
subminister1552374subminister_

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 Filter1786911488190.410435831.7
2DLD Change Limit148819818.79616918.9
3Display Results81810.0461760.9
 (SQL Overall)178691819.25219313.8
 
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.