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

170 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
conceder133874(None) 
concede12310101concede_
conceded1438291conceded
conceders1437951conceders
concedes13311061concedes
canceler12238912canceler
concealer1368222concealer
conceiver1657412conceiver
concenter13312212concenter
conciser12310242conciser
concluder1444182concluder
confider1438122confider
congener112412202congener
consider11310392consider
contender1239562contender
convener132913162convener
conveyer16278142conveyer
acceder1235373_acceder
bonder95324783bon__der
boneyer1237403bon_eyer
canceled13279403canceled
cancelers13247863cancelers
canceller1366683canceller
cancer104220923canc__er
cancered132411553cancered
candider1237343candider
ceder85322243___ceder
cheder125113493c__heder
cinder94119123cin__der
coacher143714123coac_her
cocker144320393co_c_ker
cockier154013623co_ckier
codder104416343co__dder
coder86134223co___der
coherer122912783co_herer
coholder1436073coholder
coincide1346493coincide_
coincided1544023coincided
coincides1446433coincides
colander1139033colander
colder95121853co__lder
coleader1139183coleader
colleger11227933colleger
collider113410423collider
colluder11276873colluder
commender16167923commender
compeer133811553compe_er
concave1439373concave_
concaved1636223concaved
concaves1538913concaves
conceal113313023conce_al
concealed1458133concealed
concealers1476913concealers
conceals123111033conceals
concededly1952813concededly
conceding1559343conceding
conceit113218073conce_it
conceited14310423conceited
conceits122813613conceits
conceive1539233conceive
conceived1746713conceived
conceivers1746313conceivers
conceives1639233conceives
concent114422513conce_nt
concenters14410593concenters
concents122516603concents
concept133314443conce_pt
concepti14328273concepti
concepts143110303concepts
concern113011963conce_rn
concerned1438643concerned
concerns122710833concerns
concert113325223conce_rt
concerted14312113concerted
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
conchae143911643conchae_
conches144019813conc_hes
conchie143312683conchie_
conchies153214853conchies
concise11314473concise_
conclude1344673conclude_
concluded1544033concluded
concluders1543493concluders
concludes1445143concludes
concocter1247633concocter
concrete12411083concrete_
concreted1439413concreted
concretes13411473concretes
concur10411103conc__ur
condemner1445763condemner
condenser1287413condenser
condoler113412123condoler
condoner112913413condoner
condor94616973con__dor
conducer13127373conducer
coned86040053con_ed__
confederal1653923confederal
confer114018683con__fer
conferee13613733conferee
conferrer1447063conferrer
confide13310203confide_
confided1537453confided
confiders1537483confiders
confides14310573confides
confiner13311193confiner
confuter1338513confuter
congealer1256703congealer
congee96024473conge_e_
congeed113212313conge_ed
congees103517923conge_es
congeners122511133congeners
conger95024273con__ger
conifer123212643con_ifer
conjurer17117683conjurer
conked135019113conked__
conker124721553con__ker
connecter1349053connecter
conned95119703conned__
conner84423963con__ner
conniver1337493conniver
conquer1838623con_quer
conquerer2044723conquerer
consenter11312493consenter
conserver1448723conserver
considers1238933considers
consoler102812613consoler
consumer1238503consumer
contemner1347183contemner
contended1339273contended
contenders1348623contenders
contester11311193contester
convene123314323convene_
convened143412223convened
conveners142911443conveners
convenes132916913convenes
convenor13307613convenor
converser1438093converser
converter14311013converter
convexes20278273convexes
conveyed17247923conveyed
conveyers17267203conveyers
conveyor16245293conveyor
convoker17226903convoker
corder94322883co__rder
coucher144515853couc_her
coverer123113523co_verer
coveter122912063co_veter
cozener18328953co_zener
crookeder1642823crookeder
curseder1145343curseder
encoder1038633_encoder
fonder104120063fon__der
moneyer1237903mon_eyer
needer73614953__needer
nonreader1045913nonreader
ponced114314813ponced__
ponder94521703pon__der
ponderer112410193ponderer
sconced12359173sconced__
seceder10329573_seceder
sincerer1037203sincerer
sonder73623523son__der
sorcerer1036433sorcerer
unceded11410563_unceded
vocoder1334693vo_coder
wonder103617813won__der
wonderer12249183wonderer
yonder103214133yon__der

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621706.73321708.3
3Display Results1701700.0802125.0
 (SQL Overall)1786911707.21924752.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.