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

149 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
conceding155934(None) 
canceling14310162canceling
coinciding1644622coinciding
concaving1737352concaving
concealing1549302concealing
conceiting15311772conceiting
conceiving1846772conceiving
concerning1548902concerning
concerting15313892concerting
concluding1644912concluding
concreting1539872concreting
confiding1638332confiding
congeeing1337902congeeing
contending1449122contending
convening15311192convening
conveying1838322conveying
noncoding1347672noncoding
acceding1446093_acceding
bonding113318433bon__ding
bonneting1236173bonneting
cancelling1547213cancelling
cankering162110793cankering
canoeing11310213canoe_ing
cantering122417373cantering
cascading1545673cascading
ceding104014803___ceding
centering122915143centering
cinching163310223cinc_hing
cindering13311223cindering
coaching164011963coac_hing
coacting133412703coac_ting
coannexing2083163coannexing
cockering1839693cockering
cocking163619983co_c_king
cockling172310393co_ckling
codding124014693co__dding
coding104024793co___ding
coffering1838043coffering
coheading1636623coheading
cohering142413833co_hering
coinhering1647313coinhering
coleading1338523coleading
colleting12311053colleting
colliding1338583colliding
colluding1335903colluding
commending1846633commending
compering163414163compering
competing163712463competing
concede12310103conced__e
conceded1438293conced_ed
conceder1338743conced_er
conceders1437953conceders
concedes13311063conced_es
conceit113218073conce_i_t
conceits122813613conce_its
conceive1539233conce_ive
concent114422513conce__nt
concern113011963conce_rn_
concerns122710833conce_rns
concertina14410613concertina
concertino14910843concertino
concocting1448413concocting
concubine1545753concubine
concurring1546603concurring
concussing1546143concussing
condemning1665743condemning
condensing1447743condensing
condign1147733con__dign
condoling13510373condoling
condoning1339783condoning
conducing1537693conducing
confecting18310553confecting
conferring1648743conferring
confessing1647183confessing
confining1539993confining
confusing1537333confusing
confuting1539093confuting
congaing1239823con_gaing
congealing1447633congealing
congesting14410113congesting
coning94331823con___ing
conjuring1937913conjuring
conking143618453con__king
connecting15310383connecting
conning103718753con__ning
conniving1537093conniving
connoting12310023connoting
conquering2246273conquering
consenting13313223consenting
conserving1639763conserving
consoling12310873consoling
consuming1437913consuming
contemning1577063contemning
contenting13313323contenting
contesting13312213contesting
contusing1239143contusing
convecting18310433convecting
conventing16311543conventing
converging1758093converging
conversing16310543conversing
converting16313133converting
convoking1935743convoking
convoying1835983convoying
cooeeing1137453co_oeeing
cooeying1438143co_oeying
coopering142611323coopering
coppering162810893coppering
corbeling1439033corbeling
cording113620823co__rding
cornering12311893cornering
corrading1338203corrading
corroding1337943corroding
corseting12312173corseting
coshering15510023coshering
cosseting1239543cosseting
couching163213263couc_hing
counseling1345463counseling
countering13314473countering
covering142215723co_vering
coveting141912303co_veting
cowering142514033co_wering
cowhiding1943843cowhiding
cozening20188303co_zening
encoding1239043_encoding
fonding123815423fon__ding
honchoing1844873honchoing
honeying1537673hon_eying
jonesing1636633jon_esing
longeing10177593longe_ing
mongering13310353mongering
monkeying1944473monkeying
needing93214423__needing
nonbeing1137053nonbe_ing
noncaking1646683noncaking
noncling11310763nonc_ling
noncoking1646813noncoking
nonending1138003nonending
nonfading1445873nonfading
nonreading1246883nonreading
oncoming1338353_oncoming
poncing122913583ponc__ing
pondering132411333pondering
ponding114317083pon__ding
preceding15129363preceding
receding122713763_receding
sconcing1338263sconc__ing
seceding12288563_seceding
sonneting1037003sonneting
wondering142110463wondering

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411497.07621006.4
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.57523589.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.