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

185 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
countered1231300(None) 
chuntered1536661chuntered
cantered113415982c_antered
centered112513522c_entered
clustered12186612clustered
cluttered12185942cluttered
coinhered1536592coinhered
cointerred1346552cointerred
cornered11311132corn_ered
cottered112511732co_ttered
counseled1245052counseled
counted103815802count__ed
counter94220152counter__
counterbid1546082counterbid
countermen1449292countermen
counters103320192counter_s
countersued1447072countersued
encountered1452752encountered
foundered1435402foundered
sauntered1036282sauntered
accoutered1542783accou_tered
bantered113313633_bantered
blundered1335193blundered
blustered12157263blustered
bolstered1246093bolstered
bouldered1344483bouldered
bountied1136333bount_ied
bunkered15177183_bunkered
buttered112712623_buttered
cancered132411553c_ancered
cankered153010223c_ankered
catered103117773c__atered
centred103411683c_ent_red
chaptered17176793chaptered
chartered15158393chartered
chattered15197993chattered
chittered15166413chittered
chunter123911483chunter__
chunters133910903chunter_s
cindered1239793c_indered
clattered12178403clattered
clinkered1634773clinkered
cloistered1344513cloistered
coannexed1942953coannexed
cockered17710213co_ckered
cocultured1543963cocultured
coendured1344093coendured
coffered1737673co_ffered
cohered133514693co__hered
coinferred1643893coinferred
coinhere1337133coinhere_
coinheres1447633coinheres
coinsured1245513coinsured
cointer93616723cointer__
cointers103616413cointer_s
compeered1646303compeered
compered153414923co_mpered
conceded1438293co_nceded
concentered1645003concentered
concerned1438643co_ncerned
concerted14312113co_ncerted
conferee13613733co_nferee
conferred1537753co_nferred
congeed113212313co_nge_ed
conjured18117903co_njured
conquered2145463conquered
conserved1538853co_nserved
contemned1446793co_ntemned
contend103511893co_nte_nd
contended1339273co_ntended
contented12313043co_ntented
contested12310693co_ntested
contorted1239473co_ntorted
contoured1237303co_ntoured
contused1138443co_ntused
convened143412223co_nvened
converged1636973co_nverged
conversed1538683co_nversed
converted15311563co_nverted
conveyed17247923co_nveyed
coopered133310933co_opered
coppered153410543co_ppered
coshered14610293co_shered
coulter94115603coulter__
coulters103614313coulter_s
counselee1145593counselee
counselled1344533counselled
counteract1449603counteract
counteracted1747363counteracted
counterbids1646033counterbids
countercry1745093countercry
counterfeit1657733counterfeit
countering13314473countering
counterion1249533counterion
counterman1448553counterman
countermand1647123countermand
countermemo1754723countermemo
countermoved2054993countermoved
counterplea1547033counterplea
counterposed1756323counterposed
counterraid1446753counterraid
counterspy1744663counterspy
counterstep1547113counterstep
countersue1247743countersue
countersues1348533countersues
countertop1445843countertop
countertrend1575943countertrend
counterview19116683counterview
countess103710053counte_ss
countesses1248843countesses
counties10316283count_ies
countries11313613countries
country12388043count_r_y
courted103514923court__ed
courter94516483courter__
courters103015373courter_s
courtesied1344043courtesied
couter84930223cou_ter__
couters93827303cou_ter_s
couture9310623cou_ture_
coutures10311993cou_tures
covered133315293co__vered
cowered133214653co__wered
cratered1149683c_ratered
cultured1137233c_ultured
cumbered15157963c_umbered
daundered1294423daundered
donnered10307753do_nnered
entered82718883__entered
floundered1542423floundered
flustered13185883flustered
fluttered13185943fluttered
fostered122210453fo_stered
guttered10259163_guttered
holstered1345883holstered
hungered13217053_hungered
hunkered16186923_hunkered
jointured17133483jointured
laundered1185023laundered
lobstered1244643lobstered
loitered938183lo_itered
louvered1244993lou_vered
lustered92510603_lustered
maundered1394943maundered
mongered1238953mo_ngered
mouldered1343753mouldered
mounted103611533mount__ed
mounter93713173mounter__
mounters103712503mounter_s
mustered112511503_mustered
muttered112610793_muttered
neutered937423neu_tered
outbred10311263_ou_tbred
oystered1236923_oystered
plundered1344313plundered
pondered126411293po_ndered
portered112311543po_rtered
pottered112311663po_ttered
poulterer1145423poulterer
puttered112611143_puttered
reentered1038573reentered
rencountered1552213rencountered
reuttered1036073reuttered
roistered1037643roistered
roystered1344873roystered
saunterer945033saunterer
scouthered1643643scouthered
scunnered1243803scunnered
scuttered12166423scuttered
shuttered13156333shuttered
sintered92213903_sintered
sputtered12166323sputtered
stuttered10145763stuttered
sundered10312153_sundered
tentered96412103_tentered
thundered1444573thundered
tottered9208703to_ttered
unentered1037573unentered
untired82316383__untired
unuttered1065733unuttered
uttered82712433__uttered
volunteered1551323volunteered
vouchered1843853vouchered
wintered122111573_wintered
wondered13239943wo_ndered

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.453394461.4
2DLD Change Limit1486411856.96621338.1
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.49923828.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.