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

101 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
consuming143791(None) 
censuring1237602censuring
censusing1244812censusing
coassuming1542652coassuming
coinsuring1345372coinsuring
conducing1537692conducing
confusing1537332confusing
confuting1539092confuting
conjuring1937912conjuring
consoling12310872consoling
consulting1349082consulting
contusing1239142contusing
costuming1445282costuming
tonsuring1046502tonsuring
assuming1135143_assuming
bosoming1336643bo_soming
capsuling1444533capsuling
censing104215263cens__ing
censoring1238783censoring
closuring1255173closuring
coaming123818323co__aming
coasting113615513coas_ting
coenduring1444233coenduring
cohousing1535283cohousing
colluding1335903colluding
colouring1258733colouring
coming114225453co___ming
communing16207863communing
commuting16288443commuting
computing16309853computing
concaving1737353concaving
conceding1559343conceding
concluding1644913concluding
concubine1545753concubine
concurring1546603concurring
concussing1546143concussing
condemning1665743condemning
condoling13510373condoling
condoning1339783condoning
conducting1648833conducting
confiding1638333confiding
confining1539993confining
confirming1845903confirming
conforming1847373conforming
congaing1239823con_gaing
congeeing1337903congeeing
coning94331823con___ing
conking143618453con__king
conning103718753con__ning
conniving1537093conniving
connoting12310023connoting
conquering2246273conquering
consenting13313223consenting
conserving1639763conserving
consign1038773cons__ign
consigning1446783consigning
consisting1349523consisting
consorting13410743consorting
conspiring1546553conspiring
constringe1345853constringe
construing1347443construing
consume11510133consum__e
consumed1337923consum_ed
consumer1238503consum_er
consumers1337203consumers
consumes12310413consum_es
consummating1953663consummating
contemning1577063contemning
contouring1347013contouring
convening15311193convening
conveying1838323conveying
convoking1935743convoking
convoying1835983convoying
convulsing1645383convulsing
corseting12312173corseting
coshing134316433co_s_hing
cosseting1239543cosseting
costing104323023co_s_ting
cosying134513133co_s_ying
counseling1345463counseling
couping124317023co__uping
ensuing8239543_ensu_ing
ensuring9310173_ensuring
fondueing1443093fondueing
fonduing13245893fondu_ing
honouring1336883honouring
inhuming1435853_inhuming
insuring9311153_insuring
nonbuying1543953nonbuying
nonconsuming1753213nonconsuming
nonjuring1756053nonjuring
nonruling1046433nonruling
nonsuiting1147273nonsuiting
nonusing939233non_using
oncoming1338353_oncoming
presuming1437663presuming
ransoming1256513ransoming
resuming11310083_resuming
subsuming1444273subsuming
tonguing1046263tongu_ing
voluming1435043vo_luming

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.406440125.6
2DLD Change Limit1486411016.36023371.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.81226231.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.