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

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

136 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
concenter1331221(None) 
concenters14410581concenters
consenter11312491consenter
commenter151410692commenter
concealer1368222concealer
conceder1338742conce_der
conceited14310422conceited
conceiver1657412conceiver
concent114422512concent__
concentered1645002concentered
concents122516602concent_s
concerted14312112concerted
concocter1247622concocter
condenser1287412condenser
congener112412202congen_er
connecter1349052connecter
consented12311942consented
consenters12410842consenters
contender1239562contender
contented12313042contented
contester11311182contester
convener132913162conven_er
convented15410752convented
converter14311012converter
incenter102212092_incenter
ancienter1145393_ancienter
canceler12238913cance_ler
canceller1366683canceller
carpenter1346503carpenter
cementer1239193c_ementer
center84421413___center
coelentera1243643coelentera
cointer93616723co__inter
coinvented1643993coinvented
coinventor1562973coinventor
commencer17147803commencer
commender16167923commender
commented16129613commented
commenters16139483commenters
concealed1458133concealed
concealers1476913concealers
concede12310103conce_de_
conceded1438293conce_ded
conceders1437953conce_ders
concedes13311063conce_des
conceit113218073conceit__
conceits122813613conceit_s
conceive1539233conceive_
conceived1746713conceived
conceivers1746313conceivers
conceives1639233conceives
concentering1755433concentering
concentric1346133concentric
concept133314443concept__
concepti14328273concept_i
concepts143110303concept_s
conceptus15295873conceptus
concerned1438643concerned
concert113325223concert__
concertgoer1672663concertgoer
concerti122912603concert_i
concerto123311613concert_o
concertos132711133concertos
concerts123016063concert_s
conciser12310243conc_iser
concluder1444183concluder
concocted1346763concocted
concocters1346753concocters
concoctor1246323concoctor
concrete12411083concrete_
concreted1439413concreted
concretes13411473concretes
condemner1445763condemner
condense1179613condense_
condensed1387113condensed
condensers1386373condensers
condenses12710133condenses
condoner112913413condon_er
confected1739073confected
conferrer1447063conferrer
confiner13311193confin_er
confronter1544363confronter
confuter1338513con_futer
congealer1256703congealer
congeners122511133congen_ers
congested1338673congested
connected1438753connected
connecters1448013connecters
connector1347923connector
conner84423963con__n_er
consent93723113consent__
consents102715893consent_s
conserver1448723conserver
consulter1198223consulter
contemner1347183contemner
contended1339273contended
contenders1348623contenders
content94326153content__
contents104018213content_s
contested12310693contested
contesters12410183contesters
continuer1148713continuer
convected1738783convected
convector1648083convector
convene123314323conven_e_
convened143412223conven_ed
conveners142911443conven_ers
convenes132916913conven_es
convenor13307613conven_or
convent123919413convent__
convents132614603convent_s
converser1438093converser
converted15311563converted
converters1539633converters
convertor1448783convertor
conveyer16278143conve_yer
convincer1645833convincer
correcter1348103correcter
counter94220153co__unter
coveter122912063co_ve_ter
cozener18328953co_zen_er
decenter112412163_decenter
epicenter1395503epicenter
fomenter1339263fo_menter
honester1139713hon_ester
incented112412543_incented
incenters112510303_incenters
indenter92311443_indenter
innocenter1252903innocenter
inventer112410843_inventer
monoester1146453monoester
nonhunter1245053nonhunter
orienter838313_orienter
recenter102715443_recenter
subcenter1347073subcenter
tormenter1146703tormenter

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411366.45323034.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.93625762.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.