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

259 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
coercers123765(None) 
coercer1138381coercer_
coerces11311941coerce_s
amercers1256132amercers
coerce10310402coerce__
coerced1238582coerce_d
coerects1258542coerects
coherers132310732coher_ers
corders104520882co_rders
corers85231072co_r_ers
corkers134118852co_rkers
corners94723312co_rners
couriers103213172couriers
coursers104412302coursers
courters103015372courters
coverers132712122cover_ers
forcers124215712fo_rcers
mercers114412772_mercers
piercers12316722piercers
amercer1146373amercer_
amerces1149853amerce_s
averters11249513averters
boarders11408623boarders
borders104317533bo_rders
borers85122683bo_r_ers
bouncers12309353bouncers
cancers114018583c_ancers
caperers122611723caper_ers
carcels114516063c_arcels
carders104820353c_arders
careers95218783c_areers
carers85133963c_ar_ers
carpers114521253c_arpers
carriers103614203carriers
carters95327253c_arters
carvers124817533c_arvers
caterers102814403cater_ers
ceders93817673c_e_ders
ceilers93912533c_eilers
censers94313903c_ensers
centers94420603c_enters
cercis104614493c_erc_is
cercus105013153c_erc_us
ceres75540013c_er_e_s
cereus85215523c_er_eus
cermets1139713c_ermets
certes84623083c_erte_s
chancers154313493chancers
chargers144011323chargers
charmers154211333charmers
charters134115583charters
cheaters133613513cheaters
checkers19317843checkers
cheders134512393che_ders
cheepers15329013cheepers
cheerers13319543cheerers
cheers114518913che__ers
chequers2234103chequers
chewers154111133che_wers
chirpers15358133chirpers
churners13316893churners
circlers1235353c_irclers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
clenchers16276553clenchers
coachers154312303coachers
coalers94419353co_alers
coarsens10348123coarsens
coarser93211203coarser_
coasters104317333coasters
coaters93525793co_aters
coaxers164311083co_axers
cobbers134114753co_bbers
cobblers14359593cobblers
cockers153618333co_ckers
codders114114453co_dders
coddlers12359173coddlers
coders95426983co__ders
codgers115113933co_dgers
codices12512583codice_s
codrivers1544863codrivers
coenures1048683coenures
coercing1349003coercing
coercion1246573coercion
coercions1346203coercions
coercive1545873coercive
coerect11913353coer_ect
coexert16312363coe_xert
coexerts1734883coe_xerts
coffers154112693co_ffers
coherer122912783coher_er_
coheres122917693coher_e_s
coilers93619903co_ilers
coiners93620753co_iners
coinfers13349503coinfers
cointers103616413cointers
coleaders1237823coleaders
colliers103613583colliers
colorers10312183colorers
colters93522443co_lters
comakers16339173comakers
combers134516623co_mbers
comembers1744223comembers
comers105328083co__mers
comethers1637443comethers
commencers18156373commencers
commerces17147233commerce_s
compeers143410013compeers
concern113011963co_ncern
concerns122710833co_ncerns
concert113325223co_ncert
concerts123016063co_ncerts
concurs11311473co_ncurs
conducers14136563conducers
conferrers1546453conferrers
confers124120093co_nfers
congers104223233co_ngers
conifers133611703conifers
conkers133721043co_nkers
conners94023113co_nners
conquers1938223conquers
conservers1547683conservers
conversers1547353conversers
converters1539633converters
cooers84324563co__oers
cookers134619463co_okers
coolers93522493co_olers
coopers114019483co_opers
cooters94525723co_oters
copers104629843co__pers
copiers114215963co_piers
coppers133519753co_ppers
copters113621283co_pters
corbels113813593co_rbels
corder94322883co_rder_
coreless103013833coreless
corer75538873co_r_er_
cores76361853co_r_e_s
corker124720853co_rker_
cormels113813373co_rmels
corneas94717003co_rneas
cornels94716663co_rnels
corner84625623co_rner_
cornets94820573co_rnets
coroners104016223coroners
corrects1259573corrects
corries94026793corrie_s
corses84433463co_rse_s
corsets94819803co_rsets
corulers1039773corulers
corvees124613793co_rvees
corves115122523co_rve_s
corvets124715023co_rvets
coshers123618183co_shers
costers94128333co_sters
coteries10422703coterie_s
cotters94323443co_tters
cottiers10399153cottiers
couchers153513863couchers
coughers14399963coughers
coulters103614313coulters
counters103320193counters
couplers123311323couplers
courier93617893courier_
courser94114803courser_
courses94218893course_s
courter94516483courter_
courtiers1146693courtiers
couters93827303co_uters
coverer123113523cover_er_
coverless1436803coverless
coverlets1437053coverlets
covers114627963co__vers
coveters132411083coveters
cowers114625533co__wers
coworkers1854363coworkers
cowries124218013cowrie_s
cowriters14317283cowriters
cozeners19297783cozeners
creamers124111303creamers
creasers103612823creasers
creepers12318623creepers
criers83918583c__riers
curbers115514383c_urbers
curers84923193c_ur_ers
curlers94218073c_urlers
curriers103410753curriers
cursers94317163c_ursers
deicers103612733_deicers
dormers104313923do_rmers
dorpers104113173do_rpers
dorsers83516303do_rsers
farcers124713443_farcers
fencers123810623_fencers
fiercer12356953fiercer_
fleecers13325933fleecers
forceps14466983fo_rceps
forcer114917343fo_rcer_
forces114422133fo_rce_s
forevers1438173forevers
forgers115218183fo_rgers
forkers144615783fo_rkers
formers128217953fo_rmers
gorgers94813643go_rgers
herders113914123_herders
hoarders12307433hoarders
hoverers14289023hover_ers
jeerers14328923jeer_ers
jerkers18287083_jerkers
mercer105214203_mercer_
mercery14397623_mercery
merces105720743_merce_s
mergers103813423_mergers
mourners1036913mourners
noticers1035693noticers
orders74315993_o_rders
ormers84316143_o_rmers
perchers153611523_perchers
piecers114112253pie_cers
piercer11337773piercer_
pierces113411193pierce_s
policers12259993policers
porkers134314933po_rkers
porters93722703po_rters
pouncers12349203pouncers
pourers93513673pour_ers
queriers1736963queriers
reorders9198833reorders
roarers73812743roar_ers
scorchers16145513sco_rchers
scorers94115313sco_r_ers
scorners10228493sco_rners
scourers10348533scour_ers
scourgers1234383scourgers
sergers83815633_sergers
servers103214833_servers
soarers74118093soar_ers
soccers1138393so_ccers
solacers10268893solacers
sorcery1237033so_rcery
sorners73416873so_rners
sorters74221133so_rters
sources9312173source_s
spencers12269193spencers
swervers1455213swervers
tercels94110363_tercels
terces83921413_terce_s
tercets93512443_tercets
termers95414503_termers
tiercels10344733tiercels
tierces93710453tierce_s
tourers73512743tour_ers
vergers114412633_vergers
versers103813523_versers
voicers12348993vo_icers
workers144612693wo_rkers
wormers124012573wo_rmers
worriers11257813worriers

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622598.14017956.0
3Display Results2592590.0932784.9
 (SQL Overall)1786912598.38921300.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.