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

441 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
happens1435917(None) 
happen134812191happen_
haptens124511341haptens
appels104312792_appels
append1138272_append
appends1236392_appends
arpens84814822_arpens
aspens85013352_aspens
cappers134419402cappers
dampens12348562dampens
hampers143616952hampers
hapless123311332hapless
happed144820102happe_d
happened1635652happened
happing153817232happing
hapten115312982hapten_
haptene123810932haptene
haptenes133810822haptenes
hardens113815022hardens
harkens144112862harkens
harpers124916202harpers
harpins123615702harpins
hastens106214812hastens
hatpins123410642hatpins
hausens1077632hausens
havens124514042ha_vens
hoppers143115142hoppers
hyphens1836042hyphens
lappers113717462lappers
lappets11329122lappets
lippens11328532lippens
mappers133313782mappers
nappers114214862nappers
nappes104515622nappe_s
rappees113611452rappees
rappels11448802rappels
rappen103512712rappen_
rappers113618442rappers
sapiens9310172sapiens
sappers113518902sappers
sharpens13377812sharpens
shippens15316802shippens
tappers113416542tappers
tappets113610012tappets
whappers18276742whappers
yappers144012252yappers
zappers203911632zappers
aliens65619213_aliens
amens75624843_a_mens
apers76629133_a_pers
apes66047433_a_pe_s
apneas83211383_apneas
appals104812943_appals
appeal103911613_appeal
appeals11378673_appeals
appear10379343_appear
appears11308953_appears
appease1137913_appease
appel94615893_appe_l
apples104315763_apples
applets115710063_applets
apps86319693_app__s
apres75426403_apre_s
aprons8316993_aprons
apses76823913_apse_s
arpen74418043_arpen_
arpent84822093_arpent
arpents93613083_arpents
aspen75216093_aspen_
aspers86220313_aspers
avens86419333_a_vens
baleens938473baleens
barrens94414323barrens
battens95313263battens
boppers133911923boppers
campers134220293campers
capers105428143ca_pers
capes95441923ca_pe_s
capless114312763capless
caplets114914523caplets
caplins113515993caplins
capons104119503ca_pons
capped134721853cappe_d
capper124421983cappe_r
capping143819673capping
cappings15369493cappings
captans111612053captans
careens94514703careens
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
champers173311623champers
chapels14429153cha_pels
chapes135421873cha_pe_s
chaplets1556883chaplets
chapmen1637283chapmen_
chapped172711443chappe_d
chappies172610093chappies
chapping183710723chapping
chapters154012133chapters
chastens13429183chastens
chazzens21253943chazzens
cheapens15305943cheapens
chippers173510883chippers
choppers174110463choppers
clappers143310833clappers
copens106119963_copens
coppers133519753coppers
crappers144011023crappers
cuppers133712213cuppers
dampen114310593dampen_
dampers123915693dampers
daphnes13327683daphnes
dapped124516763dappe_d
dapper114016633dappe_r
dapping133714793dapping
dapples1238993dapples
darkens12409873darkens
davens104612913da_vens
deepens10307813deepens
dippers123615183dippers
fastens105511753fastens
fattens105111713fattens
flappers15388383flappers
frappes14328383frappe_s
gapers94520473ga_pers
gapes86030823ga_pe_s
gapless10349993gapless
gapped124217123gappe_d
gapping134214783gapping
gardens93312093gardens
gaspers105014133gaspers
gawpers13448313gawpers
gippers123212083gippers
gyppers15235503gyppers
haceks15447863ha_ceks
hackees165014103hackees
hackers164619043hackers
hades96035113ha_de_s
hadjees18356383hadjees
hadjes175210403hadje_s
hadrons113314303hadrons
haemins122811403haemins
haems105517013ha__ems
haen76229453ha__en_
haeres94017033haere_s
haes77651023ha__e_s
haets86525123ha__ets
haffets1636053haffets
hafters134614333hafters
hagdons1258523hagdons
hailers104017263hailers
hairpins1365433hairpins
hajes155420943ha_je_s
hajjes15485243hajje_s
hakeems16394803hakeems
hakes126034303ha_ke_s
halers94926913ha_lers
hales85449843ha_le_s
hallels103310133hallels
haloes94623863haloe_s
halogens1237363halogens
halons95720713ha_lons
halters104619803halters
halvers133311423halvers
halves124717093halve_s
hames106138703ha_me_s
hamlets123211403hamlets
hammers144216063hammers
hamper134518653hampe_r
hanapers1346963hanapers
hances115621283hance_s
handers114224333handers
hangers113120813hangers
hankers144218133hankers
hansels104011653hansels
hanses95022633hanse_s
haoles94919803haole_s
hapaxes1936593hapaxes
haplont12412563haplont
haplonts1345773haplonts
happening1735593happening
happenings1842623happenings
happier143312033happier
happiest152411673happiest
happily1745763happily
happiness1635993happiness
happy155813533happ__y
haps96443463ha_p__s
haptenic1545763haptenic
harden105718533harden_
hardpans1436453hardpans
hareems12428203hareems
harems115513823ha_rems
hares86255543ha_re_s
harken135116343harken_
harmers124116593harmers
harmins123716723harmins
harness102413933harness
harped124418403harpe_d
harper115018403harpe_r
harpies123818313harpies
harpin113614383harpin_
harping134118383harping
harpings14379773harpings
harpoons1337483harpoons
harps105926873harp__s
harshens1437603harshens
hashes125024803hashe_s
haslets102510863haslets
hasped125014443haspe_d
hasping134414903hasping
hasps105114643hasp__s
hassels104311013hassels
hasten95718563hasten_
hastes95727073haste_s
haters94930403ha_ters
hates86742573ha_te_s
hatless103813443hatless
hatpin112610613hatpin_
hatreds11307813hatreds
hatters104221523hatters
haulers104012443haulers
hausen9610383hausen_
haven114718533ha_ven_
havers124721483ha_vers
haves116034873ha_ve_s
hawkers174210333hawkers
hawkeys20414703hawkeys
hawsers13409483hawsers
hawses125113993hawse_s
hayers124415943ha_yers
hazans183411653ha_zans
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_ze_s
hazzans18215783hazzans
headpins1436103headpins
heapers123616673heapers
hearkens15336693hearkens
heartens113010153heartens
heathens143210153heathens
heavens13439303heavens
helpers123311853helpers
hempen1338963hempen_
hens75642573h___ens
hepper133412663heppe_r
heppest14228143heppest
herpes115517323herpe_s
hipless12399923hipless
hipness12277383hipness
hipped144317693hippe_d
hipper133818023hippe_r
hippest14219753hippest
hippies142813743hippies
hipping153915103hipping
hippos13408433hipp_os
hoarsens11306023hoarsens
hoddens12378803hoddens
hoidens11329083hoidens
holpen11299413holpen_
hoopers123616483hoopers
hopers114222973h_opers
hopes105835643h_ope_s
hopped144318113hoppe_d
hopper134218483hoppe_r
hopping154115273hopping
hoppings16306523hoppings
hopples142810713hopples
hoydens14347403hoydens
humpers142713523humpers
huppahs1743333huppahs
hymens1437993h_ymens
hypers144811913h_ypers
hypes135818673h_ype_s
hyphen1736393hyphen_
japans1539823ja_pans
japers154616173ja_pers
japes146322823ja_pe_s
jaspers164310463jaspers
kappas144410363kapp_as
keppen14346573keppen_
khazens2332663kha_zens
kippen14299013kippen_
kippers153211433kippers
knappers16315643knappers
ladens74516233la_dens
lampers113817333lampers
lapels83712043la_pels
lapins84520683la_pins
lapped114320033lappe_d
lapper104319953lappe_r
lappet103817723lappe_t
lapping124117023lapping
lapsers93911053lapsers
lapses85217693lapse_s
lateens74210553lateens
latens64620213la_tens
lattens75014673lattens
lippen103911403lippen_
lippers113416443lippers
loppers113014103loppers
lumpens11298263lumpens
maddens11359753maddens
maidens10349663maidens
maples104819423maple_s
mapped134015883mappe_d
mapper124516093mappe_r
mapping143413993mapping
mappings15296413mappings
martens93714953martens
mavens114312973ma_vens
mispens11311073mispens
moppers133412463moppers
moppets13307163moppets
napes74828463na_pe_s
napkins1336673napkins
napless93110283napless
nappas105511613napp_as
nappe96114993nappe__
napped114218163nappe_d
napper103718283nappe_r
nappies114613393nappies
napping123514183napping
nippers113012623nippers
opens76118553__opens
pampeans1444703pampeans
pampers133615933pampers
pangens103112063pangens
papains11312363papains
papers105125323pa_pers
pappies103214823pappies
pappous1057463pappous
pappus9408373papp_us
patens84820863pa_tens
pattens95414923pattens
paupers114311073paupers
peens76428193__peens
pens65649643___pens
peppers103311443peppers
pigpens1235503pigpens
pippins10319753pippins
playpens1534073playpens
poppers103414863poppers
poppets10338853poppets
puppets10317013puppets
rapers84327183ra_pers
rapes75740723ra_pe_s
raphes115117453raphe_s
rapiers95012873rapiers
rapines95120863rapines
rapped114122683rappe_d
rappee103618673rappe_e
rappel104211953rappe_l
rapper104621573rappe_r
rapping123619103rapping
rappini11347573rappini
raspers94415923raspers
rattens74213403rattens
ravens93916883ra_vens
reopens939373reopens
rhaphes1534703rhaphe_s
ripens85012173_ripens
rippers114115033rippers
saddens9309603saddens
sampans112411003sampans
saphena1235863saphena
saphenas1345713saphenas
sapient9415333sapient
sapients1037423sapients
sapless93313443sapless
sapped114422013sappe_d
sapper103822353sappe_r
sapping123519313sapping
sarsens7311393sarsens
sateens73710753sateens
schappes1736033schappe_s
shapen114414653sha_pen_
shapers124016893sha_pers
shapes115124943sha_pe_s
sharpen12389723sharpen_
sharpers133810943sharpers
shippen14298863shippen_
shippers153012313shippers
shippons15255663shippons
shoppers153010763shoppers
shoppes143411393shoppe_s
sippers113117753sippers
sippets113310183sippets
slappers123710943slappers
snappers123510173snappers
suppers113314703suppers
swappers15358083swappers
taipans9269553taipans
tampans113310983tampans
tampers113516743tampers
tampons112711563tampons
tapers84025813ta_pers
tapes75838603ta_pe_s
tapped113820053tappe_d
tapper104419613tappe_r
tappet103820113tappe_t
tapping123317133tapping
tappings13267713tappings
tarpans92513533tarpans
tarpons92612213tarpons
taupes8212673taupe_s
tautens7317843tautens
tippers113414353tippers
tippets11339373tippets
toppers113914603toppers
trappers123711043trappers
unpens82511013_unpens
uppers102912293_uppers
vampers143111623vampers
wakens135012043wa_kens
wapped144416473wappe_d
wapping153514603wapping
wardens113711903wardens
warpers123413583warpers
warrens103810893warrens
whapped18367573whappe_d
whapper17348273whappe_r
whapping19317113whapping
whippers18329043whippers
whippets18255253whippets
whoppers18297533whoppers
wrappers15306933wrappers
yamens114010823ya_mens
yapons114411773ya_pons
yapped144415143yappe_d
yapper133714513yappe_r
yapping153412613yapping
yaupers12337663yaupers
yaupons12345683yaupons
yawpers15346853yawpers
zapped204213523zappe_d
zapper193414023zappe_r
zapping213211473zapping
zazens1435833za_zens
zippers203310383zippers

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.423422437.4
2DLD Change Limit1340274417.07618941.1
3Display Results4414410.1732549.1
 (SQL Overall)1786914417.67223291.3
 
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.