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

98 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
concenters1441058(None) 
concenter13312211concenter_
consenters12410841consenters
commenters16139482commenters
concealers1476912concealers
conceders1437952conce_ders
conceivers1746312conceivers
concentered1645002concentered
concents122516602concent__s
concocters1346752concocters
condensers1386372condensers
congeners122511132congen_ers
connecters1448012connecters
consenter11312492consenter_
contenders1348622contenders
contesters12410182contesters
conveners142911442conven_ers
converters1539632converters
incenters112510302_incenters
cancelers13247863cance_lers
cancellers1445363cancellers
carpenters1445843carpenters
cementers1338313c_ementers
centers94420603___centers
coelentera1243643coelentera
cointers103616413co__inters
coinventors1652943coinventors
commencers18156373commencers
commenders17137143commenders
commenter151410693commenter_
concealer1368223concealer_
conceder1338743conce_der_
concedes13311063conce_de_s
conceited14310423conceite_d
conceits122813613conceit__s
conceiver1657413conceiver_
conceives1639233conceive_s
concent114422513concent___
concentering1755433concentering
concentric1346133concentric
concepts143110303concept__s
conceptus15295873concept_us
concerted14312113concerte_d
concertgoers1752583concertgoers
concertos132711133concert_os
concerts123016063concert__s
concluders1543493concluders
concocter1247623concocter_
concoctors1346403concoctors
concretes13411473concrete_s
condemners1546023condemners
condenser1287413condenser_
condenses12710133condense_s
condoners122811513condon_ers
conferrers1546453conferrers
confiners1439953confin_ers
confronters1643833confronters
confuters1437793con_futers
congealers1365673congealers
congener112412203congen_er_
connecter1349053connecter_
connectors1448183connectors
conners94023113con__n_ers
consented12311943consente_d
consents102715893consent__s
conservers1547683conservers
consulters1297213consulters
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
counters103320193co__unters
coveters132411083co_ve_ters
cozeners19297783co_zen_ers
decenters122410373_decenters
epicenters14114463epicenters
fomenters1437853fo_menters
incenter102212093_incenter_
indenters102710033_indenters
inventers12269533_inventers
monoesters1245993monoesters
nonhunters1344733nonhunters
orienters937613_orienters
subcenters1446163subcenters
tormenters1245823tormenters

Search took 7 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.406440125.6
2DLD Change Limit140603985.98323500.4
3Display Results98980.0462130.4
 (SQL Overall)178691986.43527768.6
 
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.