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

130 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
confesses143862(None) 
confessed1546051confessed
concusses1346342concusses
condenses12710132condenses
conferees14610622conferees
confess12399902confe_s_s
confessor1444342confessor
confessors1544832confessors
confuses13310362conf_uses
congresses1348022congresses
contessas1145022contessas
converses14311162converses
countesses1248842countesses
coynesses1437572coynesses
boninesses121111453boninesses
canonesses1238423canonesses
canvasses14286043canvasses
caresses10314063c_aresses
centeses1079443cente_ses
cesses84221363c___esses
chesses124112633c__hesses
coalesces1346043coalesces
codfishes1845643codfishes
coffees15329573coffe__es
coiffeuses1851683coiffeuses
coldnesses1338423coldnesses
colessee1098793co_lessee
colessees11146053co_lessees
coleuses1039723co_leuses
comfinesses1846913comfinesses
compasses1547393compasses
compresses1647773compresses
concedes13311063conce_des
conceives1639233conceives
concussed1444753concussed
condense1179613condense_
condensed1387113condensed
condenser1287413condenser
condensers1386373condensers
conenoses1188903conenoses
confected1739073confected
confects153110873confe_cts
conferee13613733confe_ree
conferred1537753conferred
conferree1447793conferree
conferrees1546103conferrees
conferrer1447063conferrer
conferrers1546453conferrers
confers124120093confe__rs
confervas1744823confervas
confessedly2052153confessedly
confessing1647183confessing
confession15126503confession
confessions16136633confessions
confides14310573conf_ides
confines13315653conf_ines
conflates14311133conflates
confluxes2143833confluxes
confreres1448033confreres
confuse1238853conf_use_
confused1437033conf_used
confutes1339843conf_utes
congees103517923conge__es
congeries12316403congeries
congested1338673congested
congests113510383conge_sts
congressed1445463congressed
conioses10313323con_ioses
consensus1144923consensus
consensuses1353133consensuses
conserves14311193conserves
contessa1044583contess_a
contested12310703contested
contester11311193contester
contesters12410193contesters
contests103413383conte_sts
contuses10413453con_tuses
convenes132916913conve_nes
converges1538383converges
converse13310263converse_
conversed1538683conversed
converser1438093converser
conversers1547353conversers
conversos1446893conversos
convexes20278273conve_xes
convulses1445503convulses
coolnesses1237193coolnesses
cordlesses1346303cordlesses
corninesses13410603corninesses
cosinesses121012823cosinesses
coulisses1145633coulisses
cowfishes2045723cowfishes
cozinesses21179503cozinesses
cresses94219813c__resses
cypresses1645853cypresses
donenesses11310563donenesses
dunnesses1037703dunnesses
fesses94820253___fesses
finesses111912343fin_esses
fondnesses1437703fondnesses
goddesses1243453goddesses
gonenesses11310253gonenesses
hostesses1247173hostesses
hotnesses1238903hotnesses
icinesses11310073icin_esses
ironnesses1047833ironnesses
joneses1438963jon_e_ses
lionesses939433lion_esses
loesses7310033lo__esses
lonenesses10311343lonenesses
longnesses1138503longnesses
lornnesses1037823lornnesses
lownesses1236983lownesses
nesses64718323__n_esses
noblesses1146003noblesses
nonsenses948343nonsenses
nownesses1236893nownesses
obsesses1036223_obsesses
offenses1443833_offenses
ogresses938473_ogresses
onenesses9311823_onenesses
oyesses1037333_o_yesses
poetesses1137233poetesses
possesses1046323possesses
professes1437873professes
unconfessed1762833unconfessed
votresses1236503votresses
wannesses1239233wannesses
woenesses1239133woenesses
wornnesses1337133wornnesses

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.420425454.8
2DLD Change Limit1486411306.83021763.0
3Display Results1301300.0632063.5
 (SQL Overall)1786911307.31324434.7
 
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.