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

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

100 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
consenters1241084(None) 
concenters14410581concenters
consenter11312491consenter_
commenters16139482commenters
concenter13312212concenter_
condensers1386372condensers
congeners122511132congen_ers
connecters1448012connecters
consented12311942consente_d
consents102715892consent__s
conservers1547682conservers
consulters1297212consulters
contenders1348622contenders
contesters12410182contesters
conveners142911442conven_ers
converters1539632converters
absenters1156173_absenters
assenters966993_assenters
bonesetters1352633bonesetters
carpenters1445843carpenters
cementers1338313c_ementers
centers94420603c___enters
coasters104317333coas__ters
coelentera1243643coelentera
cointers103616413co__inters
coinventors1652943coinventors
commencers18156373commencers
commenders17137143commenders
commenter151410693commenter_
concealers1476913concealers
conceders1437953conce_ders
conceivers1746313conceivers
concentered1645003concentered
concents122516603concent__s
concocters1346753concocters
condemners1546023condemners
condenser1287413condenser_
condenses12710133condense_s
condoners122811513condon_ers
conferrers1546453conferrers
confiners1439953confin_ers
confronters1643833confronters
confuters1437793con_futers
congealers1365673congealers
congener112412203congen_er_
connecter1349053connecter_
connectors1448183connectors
conners94023113con__n_ers
consensus1144923consen_sus
consent93723113consent___
consenting13313223consenting
conserver1448723conserver_
conserves14311193conserve_s
considers1238933cons_iders
consigners1346413consigners
consolers112510923cons_olers
conspirers1444573conspirers
construers1245873construers
consulter1198223consulter_
consultors1286403consultors
consumers1337203cons_umers
contemners1447073contemners
contender1239563contender_
contented12313043contente_d
contents104018213content__s
contester11311183contester_
continuers1247943continuers
convectors1768313convectors
convener132913163conven_er_
convenes132916913conven_e_s
convenors14277633conven_ors
convented15410753convente_d
convents132614603convent__s
conversers1547353conversers
converter14311013converter_
convertors1549133convertors
conveyers17267203conve_yers
convincers1745063convincers
costers94128333co_s__ters
counters103320193co__unters
coveters132411083co_ve_ters
cozeners19297783co_zen_ers
dissenters1197723dissenters
fomenters1437853fo_menters
incenters112510303_incenters
indenters102710033_indenters
inserters92210283_inserters
insetters9187133_insetters
inventers12269533_inventers
looseners945403loosen_ers
misenters1139533_misenters
monoesters1245993monoesters
monsters103314553mons__ters
nonhunters1344733nonhunters
nonsenses948343nonsense_s
nonskaters1444483nonskaters
orienters937613_orienters
pinsetters1244103pinsetters
presenters1239863presenters
tormenters1245823tormenters

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031006.87320457.3
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.34224338.2
 
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.