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

404 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
compeer13381155(None) 
compeers143410011compeers
compere134616621compere
camper124722212camp_er
campier133313272campier
chomper163810072chomp_er
comaker153410602comaker
comber125118502com_ber
comer95832692com__er
comfier1439162comfier
compare135814992compare
comparer143611362comparer
comped135919872comp_ed
compeered1646302compeered
compel124412892comp_el
compeller1546292compeller
compels133210892compels
compend144010302compend
compered153414922compered
comperes143217972comperes
compete134716552compete
competed154113592competed
competes144117242competes
compiler1438372compiler
completer153310412completer
complex2037242complex
complexer22316212complexer
complier14310252complier
composer145012952composer
compted143813522compted
computer144511512computer
cooper104221122coop_er
coper95336092co_p_er
copier103722902co_pier
copper124321892co_pper
copter109822012co_pter
coupler114713012coupler
romper104213682romp_er
ambeer104511603_ambeer
ameer75618983_am_eer
ampere10514413_ampere
ampler104313303_ampler
bomber125014653bom_ber
bopeep1236763bo_peep
bopper123813833bo_pper
bumper123714343bump_er
bumpier13359203bumpier
camber124418483cam_ber
cameleer1246033cameleer
camped134720233camp_ed
campers134220293campers
camphor1636133camphor
caper94831623c_ap_er
caperer113013403c_aperer
capper124421983c_apper
career85822243c_areer
carper104923633carp_er
champer163813413champ_er
chapter144213853chapter
cheeper143610743cheeper
cheer105420383c__heer
chipper163912583chipper
chomped17329773chomp_ed
chompers17369593chompers
chopper163611893chopper
choppier17286653choppier
cipher133710263c_ipher
clamper134012993clamp_er
clapper134011863clapper
clipper133710323clipper
clomped14398973clomp_ed
clumpier1435583clumpier
coacher143714123coacher
coaler84121713co_aler
coalier93416183coalier
coappear1442893coappear
coapted123911503coapted
coarser93211203coarser
coaster94219043coaster
coatee84327223coatee_
coatees93816553coatees
coater84329573co_ater
coaxer153912793co_axer
cobber124116843co_bber
cobbier133410163cobbier
cobbler133311823cobbler
cocker144320393co_cker
cockier154013623cockier
codder104416343co_dder
coddler113710833coddler
coder86134223co__der
codger105814873co_dger
coempted1535333coempted
coercer1138383coercer
coffee144113743coffee_
coffees15329573coffees
coffer144112863co_ffer
coheir1137583co_heir
cohere112716993co_here
coherer122912783coherer
coiler84421593co_iler
coiner84323783co_iner
coinfer12419393coinfer
cointer93616723cointer
colder95121853co_lder
colleen939543colleen
colleger11227933colleger
collier93618153collier
colorer9312523colorer
colter84625093co_lter
comade114415323comade_
comae97128423com_ae_
comake144413423comake_
comakers16339173comakers
comakes154413643comakes
comate104124843comate_
comates114123643comates
combater1439383combater
combe116223543com_be_
combed135516543com_bed
combers134516623combers
combes125321733com_bes
combiner14259723combiner
come87547703com__e_
comedo11359603com_edo
comedy14378233com_edy
comelier12310653comelier
comely134213733com_ely
comember1644163comember
comers105328083com_ers
comes97246993com__es
comet95946073com__et
cometh134811683com_eth
comether1537253comether
comets105823583com_ets
comfrey1734683comfrey
commencer17147803commencer
commend144010183commend
commender16167923commender
comment1310317703comment
commenter151410693commenter
commie124215523commie_
commies133718453commies
commoner142710633commoner
communer14349303communer
commuter143010153commuter
comose105016853comose_
comp106731253comp___
compact153712213compact
compacter17257883compacter
compadre15295883compadre
company1619711143company
compared153811823compared
comparers15319393comparers
compares143816433compares
compart134016003compart
compas125817063comp_as
compass13379563compass
compeering1747053compeering
compelled1646133compelled
compellers1645193compellers
compends15378253compends
competent15411253competent
compile13312443compile
compiled1537813compiled
compilers1537053compilers
compiles14311983compiles
comping143518593comping
compleat14710153compleat
complect1659013complect
complete143412053complete
completed162810273completed
completers16298323completers
completes153212923completes
complexed23295983complexed
complexes22308113complexes
complied1539683complied
compliers1538293compliers
complies14314523complies
complin13312073complin
complot13310683complot
comply152810383comp_ly
compo115318573comp__o
compone136517193compone
compony1613011913compony
comport133616843comport
compos124818803comp_os
compose135716663compose
composed154612063composed
composers153910643composers
composes145017123composes
compost134515353compost
composter15369573composter
compote135616463compote
compotes144716513compotes
compress1439053compress
comps115526053comp__s
compt116328223comp__t
compts125216653comp_ts
compute134513663compute
computed154110953computed
computers15339753computers
computes143914553computes
comte96125473com_te_
comtes106222813com_tes
conceder1338743conceder
confer114018683co_nfer
congee96024473congee_
congeed113212313congeed
congees103517923congees
congener112412203congener
conger95024273co_nger
conifer123212643conifer
conker124721553co_nker
conner84423963co_nner
conquer1838623conquer
convener132913163convener
conveyer16278143conveyer
cooee74531023co_oee_
cooeed95917863co_oeed
cooees85621893co_oees
cooer74831013co__oer
cooker124722453co_oker
cooler84824713co_oler
cooped114821613coop_ed
coopered133310943coopered
coopers114019483coopers
coopery143910273coopery
coopted123710773coopted
cooter85128613co_oter
cope86847383co_p_e_
copeck1636943co_peck
coped105036853co_p_ed
copen94826433co_p_en
copens106119963co_pens
copers104629843co_pers
copes97747103co_p_es
copied114618573co_pied
copiers114215963co_piers
copies104130313co_pies
copped135221263co_pped
coppered153410543coppered
coppers133519753coppers
coppery16409393coppery
copse95623933co_pse_
copses104922483co_pses
copters113621283co_pters
corder94322883co_rder
corer75538873co__rer
corker124720853co_rker
corkier133114303corkier
corner84625623co_rner
cornier93017093cornier
coroner94218203coroner
corpse104013413corpse_
corpses113913813corpses
coruler9311713coruler
corvee114320093corvee_
corvees124613793corvees
cosher114819903co_sher
cosier84423763co_sier
coster84331293co_ster
cotter84926673co_tter
cottier93814173cottier
coucher144515853coucher
cougher133711733cougher
coulee8323513coulee_
coulees9315513coulees
coulter94115603coulter
counter94220153counter
coupe96023483coup_e_
couped115019313coup_ed
coupes105022523coup_es
couple104415963couple_
coupled124312673coupled
couplers123311323couplers
couples115317053couples
couplet114717943couplet
courier93617893courier
courser94114803courser
courter94516483courter
couter84930223co_uter
couther123914633couther
cover105430773co__ver
coverer123113523coverer
coveter122912063coveter
cower104531773co__wer
cowier113616163co_wier
cowpea1337643cowp_ea
cowpeas1437273cowpeas
cowpie133511513cowpie_
cowpies143314283cowpies
coyer105222843co__yer
cozener18328953cozener
cozier173315143co_zier
crampier14288903crampier
crapper133913193crapper
creeper11339983creeper
crepier1139753crepier
crimper136510423crimp_er
crimpier14287323crimpier
cropper133312973cropper
croupier1246893croupier
crupper13338563crupper
cumber124016703cum_ber
cumberer14266993cumberer
cummer124414593cum_mer
cupeler1177483c_upeler
cupper124313863c_upper
cuppier1368323cuppier
cypher16306593c_ypher
dampener1335533dampener
damper114117753damp_er
domineer1146273domineer
doper86128393do_p_er
dopier93515923do_pier
dorper94314573dorp_er
dumper114615213dump_er
dumpier12409653dumpier
emeer74815363_em_eer
gimpier12247943gimpier
gombeen1243733gombeen
gomer85220653gom__er
goopier103910573goopier
gopher1239183go_pher
gospeler1173963gospeler
hamper134518653hamp_er
hamperer15379093hamperer
hempier14319003hempier
homager13107853homager
homer105828453hom__er
homier116416993hom_ier
hooper114518313hoop_er
hoper105829143ho_p_er
hopper134218483ho_pper
hoppier143110703hoppier
humper134115883hump_er
humpier143110723humpier
impeder12438533_impeder
jimper17389863jimp_er
jumper173612373jump_er
jumpier18317943jumpier
limper104117853limp_er
looper83817113loop_er
loopier93711193loopier
loper75129233lo_p_er
lopper103717203lo_pper
loppier11369723loppier
lumper103816653lump_er
lumpier113410143lumpier
momser104011413mom_ser
momzer19327553mom_zer
moper94925923mo_p_er
mopier103914783mo_pier
mopper126215003mo_pper
mumper123513523mump_er
omber95316443_om_ber
omer67028393_om__er
opener83910993_o_pener
pamper124316663pamp_er
pamperer14228333pamperer
peer66238353___peer
pommee122813283pommee_
popper93615963po_pper
prompter1437983prompter
pumper124415553pump_er
romped114513653romp_ed
rompers113412243rompers
roper75431913ro_p_er
ropier84118813ro_pier
roupier9319493roupier
sampler113212013sampler
scamper134613163scamp_er
scamperer1544623scamperer
schmeer1475363schm_eer
scooper113812033scoop_er
simper103616293simp_er
simperer1237173simperer
simpler112910863simpler
soaper84517873soap_er
soapier93411713soapier
somber103714003som_ber
soppier112711583soppier
soupier93111753soupier
speer74623903__speer
stomper114111233stomp_er
sumpter1138873sumpter
tamper104618513tamp_er
tamperer12248893tamperer
temper103914093temp_er
temperer12227723temperer
tempter11358213tempter
topee76029953to_pee_
topees85519703to_pees
toper75231023to_p_er
topper103817603to_pper
toupee8316133toupee_
toupees938513toupees
vamper134212653vamp_er
vampier14308233vampier
vomer105517383vom__er
vomiter1237953vomiter
wimpier14248053wimpier
wombier1436543wombier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274046.95319276.1
3Display Results4044040.1562589.7
 (SQL Overall)1786914047.51523777.9
 
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.