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 “discounters” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

161 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
discounters144576(None) 
discounter1347021discounter_
discounted1447842discounte_d
discounts1287822discount__s
discoursers1443592discoursers
viscountess1662382viscountess
counters103320193___counters
descanters1345013desc_anters
discerners1345703discern_ers
disconcert1548263disco_ncert
disconcerts1655243disco_ncerts
discontent13410253disco_ntent
discontents1447563disco_ntents
discount11811313discount___
discounting1547443discounting
discouragers1652323discouragers
discourser1344763discourser_
discourses1346503discourse_s
discourteous1552313discourteous
discourtesy1753193discourtesy
discoverers1773463discoverers
discovers1538153disco__vers
discussers13235193disc_ussers
disinters1039713dis__inters
dismounted1445413dismounte_d
dismounts1275283dismount__s
disputers1236613dis_pu_ters
disrupters1343933dis_rupters
dissenters1197733dis_senters
distorters1147183disto_rters
disuniters11104733dis__uniters
encounters1244553_encounters
miscounted1546063miscounte_d
miscounts1386413miscount__s
recounters1246213_recounters
rencounters1343303rencounters
scouters103411323__scou_ters
viscometers1854943viscometers
viscounties1653633viscounties
viscounts1484583viscount__s
absconders1542374absco_nders
accouters1344864_accou_ters
chunters133910904___chunters
cointers103616424___cointers
coulters103614314___coulters
counter94220154___counter_
countess103710054___countess
courters103015374___courters
couters93827304___cou_ters
daunters9329854d___aunters
decanters12229224d_ec_anters
decenters122410374d_ec_enters
decouplers1573084d_ecouplers
denouncers1343404d_enouncers
descanter1246444desc_anter_
descenders1445454desc_enders
desolaters1146044des_olaters
diaconates1346704diaconate_s
diluters9288114di__lu_ters
diopters1137694di__o_pters
disasters1039154dis__asters
disbursers1373864dis_bursers
discanted1339334disc_ante_d
discants112912024disc_ant__s
discarders1445044disc_arders
discerner1246944discern_er_
dischargers1873064dischargers
disclaimers1653134disclaimers
disclosers1375194disc_losers
discolors1246594disco__lors
discolours1343824disco_lours
disconfirm1853164disco_nfirm
disconfirms1952924disco_nfirms
disconnect1555874disco_nnect
disconnects1654114disconnects
discountable1753854discountable
discourager1553084discourager_
discourages1554384discourages
discourse1246864discou___rse
discoursed1445794discourse_d
discourtesies1672264discourtesies
discover1439564disco__ver_
discoverer1674814discoverer_
discovert1548794disco__vert
discovery1845274disco__very
discreeter1344734discreeter_
discuses113112864disc_u_se_s
discusser12246184disc_usser_
discusses12268254disc_usse_s
disenchanters1961684disenchanters
disgruntles1352274disgruntles
disguisers1244034dis_guisers
dishonorers1552494dishonorers
dishonors1345424disho_n_ors
dishwaters1744024dis_hwaters
disinter9310674dis__inter_
disjointed1944834disjointe_d
disjoints1745474disjoint__s
dislocates13108324dislocate_s
dismount1188224dismount___
dismounting1545084dismounting
disobeyers1642384dis_obeyers
disorders1146964dis_o_rders
dispensers13146744dis_pensers
disposers1238374dispo__sers
disputer1137974dis_pu_ter_
disputes1139654dis_pu_te_s
disrobers1246384disro__bers
disrupter1244724dis_rupter_
disruptors1343084dis_ruptors
dissenter1059134dis_senter_
dissipaters1453474dissipaters
dissolvers1444644disso_lvers
dissuaders1273834dis_suaders
distenders12166744dis_tenders
distorter1048404disto_rter_
disturbers13164164dis_turbers
disuniter1086204dis__uniter_
disunites1088674dis__unite_s
doubters11257394d___oubters
encounter1145184_encounter_
impounders1542984_impounders
incenters112510304_inc_enters
miscount1299474miscount___
miscounting1646054miscounting
misenters1139544mis__enters
mishanters1544984mis_hanters
misinters1138184mis__inters
misjoinders2152344misjoinders
misquoters2142634mis_quoters
misroutes1148314misrou_te_s
mounters103712504___mounters
picometers1648284pi_cometers
recounter1137944_recounter_
rediscounted1651984rediscounte_d
rediscounts1452294rediscount__s
reencounters1451724reencounters
rencounter1244294rencounter_
saunters82911754__s_aunters
scooters103511034__sco_oters
scorners10228494__scorn_ers
scoters93313814__sco__ters
scourers10348534__scou_rers
scourgers1234384__scourgers
scouter93313324__scou_ter_
scouthers1445994__scouthers
scroungers1343194__scroungers
scunners10357304__sc_unners
scutters103311024__sc_utters
shouters113510624__shou_ters
shunters113210754__s_hunters
sounders93214114__s_ounders
souters74422604__s_ou_ters
spouters104011164__spou_ters
viscometer1745304viscometer_
viscount1396784viscount___
viscountcies1962084viscountcies
viscountcy2091954viscount_cy
viscountesses1851804viscountesses
viscounty1793404viscount__y
viscousness1655534viscousness

Search took 9 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 Filter1786911488190.436409841.7
2DLD Change Limit1488191618.29617938.6
3Display Results1611610.0802012.5
 (SQL Overall)1786911618.81220278.1
 
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.