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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
concentered164501(None) 
concenter13312212concenter__
concenters14410592concenter_s
carpentered1652493carpentered
centered112513523___centered
conceited14310423conceit__ed
concentering1755443concentering
concentrated17116733concentrated
concentric1346133concent_ric
concerted14312113concert__ed
concertized25146363concertized
conjectured23153273conjectured
consented12311943consent__ed
consenter11312493consenter__
consenters12410843consenter_s
contented12313043content__ed
convented15410753convent__ed
countered12313003co__untered
decentered1445323_decentered
unentered1037573_un_entered
ancestored1343654_ancestored
calendered1443394c_alendered
cancered132411554canc___ered
cantered113415984___cantered
centred103411684___cent_red
chuntered1536664c__huntered
cinctured1444274cinc__tured
cockered17710214co_c__kered
cocultured1543964co_cultured
coelentera1243644coelenter_a
coelenteron1382024coelenteron
coendured1344094co__endured
cofeatured1642714co_featured
coinhered1536594co__inhered
cointerred1346564co__interred
coinvented1643994coinvent__ed
commentated1886214commentated
commented16129614comment__ed
commenter151410694commenter__
commenters16139484commenter_s
compeered1646304compe__ered
concealed1458134conce__aled
concealer1368224concealer__
concealers1476914concealer_s
conceded1438294conc___eded
conceder1338744conce_der__
conceders1437954conce_der_s
conceitedly1953784conceitedly
conceived1746714conce__ived
conceiver1657414conceiver__
conceivers1746314conceiver_s
concent114422514concent____
concentrate15118354concentrate
concentrates16118214concentrates
concents122516604concent___s
conceptive1949514conceptive_
conceptuses1774514conceptuses
concerned1438644conce__rned
concertedly1954774concertedly
concertgoer1672664concertgoer
concertize23169354concertize_
concertizes24158584concertizes
concocted1346774concoct__ed
concocter1247634concocter__
concocters1346764concocter_s
concreted1439414conc__reted
concretized25174674concretized
concurred1445674conc__urred
condensed1387114conden__sed
condenser1287414condenser__
condensers1386374condenser_s
confected1739074confect__ed
conferred1537754confe__rred
congener112412204congen_er__
congeneric1554674congen_eric
congeners122511134congen_er_s
congested1338674congest__ed
conjecture21134744conjecture_
conjecturer22153194conjecturer
conjectures22134894conjectures
connected1438754connect__ed
connecter1349054connecter__
connecters1448024connecter_s
conquered2145464con__quered
considered1444284con_sidered
contended1339274conten__ded
contender1239564contender__
contenders1348624contender_s
contentedly1754914contentedly
contested12310704contest__ed
contester11311194contester__
contesters12410194contester_s
contexture1943934contexture_
contextures2054124contextures
convected1738784convect__ed
convened143412224conven___ed
convener132913164conven_er__
conveners142911444conven_er_s
converted15311564convert__ed
converter14311014converter__
converters1539634converter_s
copartnered1651374copartnered
cornered11311134co__rn_ered
cottered112511744co___ttered
decentred13236234_decent_red
donnered10307754don__n_ered
encountered1452754_encountered
enfettered1442484_enfettered
engendered1342824_engendered
entered82718884____entered
incented112412544_incent__ed
incenter102212094_incenter__
incenters112510304_incenter_s
indentured1243124_indentured
misentered1345914_misentered
neutered937424__n_eutered
noncentral1248014noncent_ral
nontenured1143134nonten_ured
reentered1038574__reentered
rencountered1552214rencountered
sceptered1444724__sceptered
tentered96412104___tentered
uncatered1237404_unc_atered
uncensored1354254_uncensored
uncensured1344004_uncensured
unfettered1443654_unfettered
unlettered1143954_unlettered

Search took 11 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.423422437.4
2DLD Change Limit14881912710.42314277.9
3Display Results1271270.0632015.9
 (SQL Overall)17869112710.90916380.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.