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

373 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
comperes14321797(None) 
compares143816431compares
compeers143410011compeers
compere134616621compere_
compered153414921compered
competes144117241competes
amperes11313982_amperes
campers134220282camper_s
chompers17369572chomper_s
coheres122917692co_heres
combers134516612comber_s
comers105328082com_er_s
commerces17147232commerces
compadres16266412compadres
compare135814992compare_
compared153811822compared
comparer143611362comparer
comparers15319382comparers
comparts144210832comparts
compeer133811552compe_er
compeered1646302compeered
compels133210882compe_ls
compends15378252compends
compete134716552compete_
competed154113592competed
compiles14311982compiles
completes153212922completes
complexes22308092complexes
complies14314522complies
comports143411982comports
composes145017112composes
compotes144716512compotes
compress1439052compress
computes143914532computes
coopered133310932coopered
cooperies131113312cooperies
coopers114019482cooper_s
copers104629842co_per_s
copperas14308562copperas
coppered153410542coppered
coppers133519752copper_s
rompers113412242romper_s
abamperes1563023abamperes
ampere10514413_ampere_
bombers134512593bomber_s
boppers133911923bopper_s
bumpered1536003bumpered
bumpers133912053bumper_s
cambered15128993cambered
cambers134017433camber_s
cameras11313343cam_eras
camper124722213camper__
campfires1844123campfires
camphenes1846463camphenes
camphires1845783camphires
camporee1449343camporee
camporees1546103camporees
campuses1437773campuses
capered123014043c_apered
caperer113013403c_aperer
caperers122611723c_aperers
capers105428133c_aper_s
cappers134419403capper_s
carpers114521253carper_s
ceres75540013c___eres
champers173311613champer_s
chimeres153511303chimeres
chomper163810073chomper__
choppered1964883choppered
choppers174110453chopper_s
clampers143211883clamper_s
coalers94419333coaler_s
coatees93816533coate_es
coaters93525773coater_s
coaxers164311063coaxer_s
cobbers134114753cobber_s
cockered17710213cockered
cockerel16107113cockerel
cockerels1784673cockerels
cockers153618333cocker_s
cockeyes1967033cockeyes
codders114114443codder_s
coders95426973co_der_s
codgers115113923codger_s
codpieces1643803codpieces
coenures1048673coenures
coerces11311943co__erces
coexerts1734883coexerts
coffees15329573coffe_es
coffered1737673coffered
coffers154112693coffer_s
cohere112716993co_here_
cohered133514693co_hered
coherer122912783co_herer
coherers132310733co_herers
coilers93619903coiler_s
coiners93620753coiner_s
coinheres1447633coinheres
colleges112410513colleges
colters93522433colter_s
colures9315133co_lures
comakers16339163comaker_s
comakes154413643com_akes
comates114123633com_ates
comber125118503comber__
combes125321733com__bes
combines142814623combines
comedies13311833comedies
comedos12329073com_edos
comer95832693com_er__
comes97246993com___es
comets105823583com_e_ts
comforts15347323comforts
comfrey1734683com_frey
comfreys1843333comfreys
comities12317783comities
commences17139573commences
commends15308463commends
comments142913873comments
commerce16116323commerce
commerced18125463commerced
commies133718443com_mies
commixes2177343commixes
commodes1539093commodes
commoves1736963commoves
communes143411233communes
commutes143011873commutes
compacts16368903compacts
compadre15295883compadre_
companies15311793companies
compart134016003compar_t
comparted16338423comparted
compas125817063comp__as
compass13379563comp_ass
compasses1547393compasses
comped135919873comp__ed
compel124412893comp__el
compelled1646133compelled
compeller1546293compeller
compellers1645193compellers
compend144010303compe_nd
compering163414163compering
competent15411253competent
compile13312443compile_
compiled1537813compiled
compiler1438373compiler
compilers1537053compilers
complects1766413complects
complete143412053complete_
completed162810263completed
completer153310413completer
completers16298323completers
completest16297873completest
complex2037243comp_lex
complexed23295963complexed
complexer22316203complexer
complexest23265583complexest
complices1739253complices
complied1539673complied
complier14310253complier
compliers1538293compliers
complines15312833complines
complins14313103complins
complots1438163complots
compone136517193compone_
comport133616843compor_t
comported16319533comported
compos124818803comp__os
compose135716663compose_
composed154612063composed
composer145012953composer
composers153910613composers
composts144210913composts
composures1645123composures
compote135616463compote_
compresses1647773compresses
comprise14310813comp_rise
comprises15510943comprises
comprizes2468943comprizes
comps115526053comp___s
compted143813523comp_ted
compts125216653comp__ts
compute134513653compute_
computed154110943computed
computer144511503computer
computerese17183413computerese
computers15339733computers
comrades13149773comrades
comtes106222813com__tes
concedes13311053concedes
concerns122710833concerns
concerts123016063concerts
condores113315633condores
conferee13613723conferee
conferees14610623conferees
confers124120093confer_s
confreres1448033confreres
congees103517923conge_es
congeries12316403congeries
congers104223233conger_s
conjures17119903conjures
conkers133721043conker_s
conners94023113conner_s
conserves14311193conserves
conspires1358483conspires
convenes132916913convenes
converges1538373converges
converse13310263converse
converses14311163converses
converts133213553converts
convexes20278273convexes
cooees85621893co_oe_es
cooers84324563co_oer_s
cookeries151210633cookeries
cookers134619463cooker_s
coolers93522493cooler_s
cooper104221123cooper__
cooperages1565573cooperages
cooperates1469593cooperates
coopery143910273cooper_y
cooters94525713cooter_s
copecks1745873co_pecks
copens106119963co_pe_ns
coper95336093co_per__
copes97747103co_p__es
copiers114215963copier_s
copies104130303co_p_ies
copper124321893copper__
copperah17304903copperah
copperahs18323893copperahs
copperases1644893copperases
coppery16409393copper_y
coppices1638243coppices
coppras13327833co_ppras
copras103517153co_p_ras
copses104922473co_p_ses
copters113621273copter_s
corders104520873corder_s
corers85231073co_rer_s
cores76361853co___res
corkers134118853corker_s
cornered11311133cornered
corners94723313corner_s
corpses113913803corp_ses
corpuses12310063corpuses
corteges1198813corteges
cortexes1797613cortexes
corvees124613793corve_es
coshered14610293coshered
coshers123618173cosher_s
costers94128303coster_s
coteries10422703co_teries
cottered112511733cottered
cotters94323433cotter_s
coulees9315503coule_es
coupes105022523coup__es
couplers123311313coupler_s
couples115317053coup_les
couters93827283couter_s
coutures10311973coutures
covered133315293co_vered
coverer123113523co_verer
coverers132712123co_verers
covers114627963co_ver_s
coverts124813813co_verts
cowered133214643co_wered
cowers114625533co_wer_s
cowherbs1833543cowherbs
cowherds1735423cowherds
cowpeas1437273cowpe_as
cowpies143314283cowp_ies
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
crimpers14318933crimper_s
croppers143311483cropper_s
cumbered15157953cumbered
cumberer14266993cumberer
cumberers15175993cumberers
cumbers134515393cumber_s
cummers133713473cummer_s
cuppers133712193cupper_s
cymenes1477413cym_enes
cypres1338523c_yp_res
dampers123915693damper_s
dopers95522483do_per_s
dorpers104113163dorper_s
dumpers123412663dumper_s
ecospheres1795123ecospheres
ectomeres1346253ectom_eres
emperies12314563_emperies
empires1139853_empires
fopperies1666013fopperies
gomerel1036393gom_erel
gomerels1144563gom_erels
gomers94116883gom_er_s
hampered16239923hampered
hamperer15379093hamperer
hamperers16287523hamperers
hampers143616943hamper_s
hombres14369873hom_bres
homered133212713hom_ered
homers114821973hom_er_s
hoopers123616483hooper_s
hopers114222973ho_per_s
hoppers143115143hopper_s
humpers142713523humper_s
impedes124310093_impedes
jumpers18399843jumper_s
lampers113817333lamper_s
lamperses1345123lamperses
limpers113815223limper_s
loopers93914033looper_s
lopers84424143lo_per_s
loppered13326753loppered
loppers113014103lopper_s
lumpers113514483lumper_s
meres75143573__m_eres
momsers113810843momser_s
momzers20367133momzer_s
moperies12313873mo_peries
mopers104220373mo_per_s
moppers133412453mopper_s
mumpers133311363mumper_s
nowheres1437493nowheres
ombers104214393_omber_s
ombres103911133_om_bres
omers76923193_om_er_s
oosperms1243783oosperms
oospheres1456623oospheres
oospores1049523oospores
operas8312453_o_peras
pampered15229223pampered
pamperer14228333pamperer
pamperers15236863pamperers
pamperos14306693pamperos
pampers133615933pamper_s
peres76246643___peres
poperies12316793po_peries
poppers103414863popper_s
pumpers133113673pumper_s
romper104213683romper__
roperies10315763ro_peries
ropers84325903ro_per_s
scampered1635233scampered
scamperer1544623scamperer
scamperers1643473scamperers
scampers143611033scamper_s
scoopers124210193scooper_s
simpered1338253simpered
simperer1237173simperer
simperers1335933simperers
simpers113014113simper_s
soapers93715923soaper_s
stompers123610033stomper_s
tampered13279463tampered
tamperer12248893tamperer
tamperers13227313tamperers
tampers113516743tamper_s
temperas12278233temperas
tempered13248213tempered
temperer12227723temperer
temperers13247023temperers
tempers113513013temper_s
topees85519703to_pe_es
topers85025323to_per_s
toppers113914603topper_s
toupees938513toupe_es
umpires1137813_umpires
vampers143111623vamper_s
vampires15226033vampires
vomers115614943vom_er_s
womeras1287593wom_eras
wommeras15133773wommeras

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623736.51322441.6
3Display Results3733730.1602331.3
 (SQL Overall)1786913736.82926166.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.