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

476 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
haptens12451134(None) 
happens14359171happens
hapten115312981hapten_
haptene123810931haptene
haptenes133810821haptenes
hastens106214811hastens
battens95313262battens
captans111612052captans
chapters154012112chapters
chastens13429182chastens
fastens105511752fastens
fattens105111712fattens
hafters134614332hafters
halters104619802halters
hapless123311332hapless
happen134812192happen_
haptenic1545762haptenic
hardens113815022hardens
harkens144112862harkens
hasten95718562hasten_
hastes95727072haste_s
haters94930392ha_ters
hates86742572ha_te_s
hatpins123410642hatpins
hatters104221522hatters
hausens1077632hausens
havens124514042ha_vens
heartens113010152heartens
hyphens1836042hyphens
latens64620212la_tens
lattens75014672lattens
martens93714952martens
patens84820862pa_tens
pattens95414922pattens
rattens74213402rattens
sapiens9310172sapiens
tautens7317842tautens
actins86321103_actins
adapters1136103adapters
afters94717073_afters
aliens65619213_aliens
alters64924223_alters
amens75624843_a_mens
antes56334323_ante_s
apers76629133_ap_ers
apes66047433_ap_e_s
apneas83211383_apneas
appels104312793_appels
append1138273_append
appends1236393_appends
apres75426403_apre_s
aprons8316993_aprons
apses76823913_apse_s
apter76120203_apte_r
aptest82917513_aptest
aptness9268573_aptness
arpens84814823_arpens
artels66216233_artels
aspens85013353_aspens
asters65631603_asters
ates45047923_a_te_s
attend7258973_attend
attends8257593_attends
attent62818323_attent
avens86419333_a_vens
baiters94619303baiters
baleens938473baleens
banteng1046363banteng
bantengs1134593bantengs
banters94623113banters
barrens94414323barrens
bartend1038753bartend
bartends1136793bartends
barters94223033barters
basters94930303basters
bastes85330383baste_s
bates75846343ba_te_s
batons85519423ba_tons
batten85217123batten_
batters94626013batters
caftans12179443caftans
canteens1038573canteens
canters94827723canters
cantons95221203cantons
capers105428133cap_ers
capes95441923cap_e_s
capless114312763capless
caplets114914523caplets
caplins113515993caplins
capons104119503cap_ons
capotes11314643capote_s
cappers134419403cappers
capstans1257243capstans
captains121810573captains
captan101613343captan_
captions123813213captions
captors113914983captors
careens94514703careens
cartels94618123cartels
carters95327243carters
cartes86239473carte_s
cartons94122473cartons
casters94729893casters
castes85631863caste_s
catena8312473ca_tena
catenas9313103ca_tenas
caters85336493ca_ters
cates75951873ca_te_s
chanters134016723chanters
chanteys16387493chanteys
chapels14429153chap_els
chapes135421873chap_e_s
chapiters1635193chapiters
chaplets1556883chaplets
chapmen1637283chapmen_
chapter144213853chapte_r
charters134115563charters
chasten124312403chasten_
chattels13286793chattels
chatters134213933chatters
chazzens21253943chazzens
cheapens15305943cheap_ens
chortens13308793chortens
copens106119963cop_ens
copters113621273copters
daltons8310403daltons
dampens12348563dampens
daphnes13327683daphnes
darkens12409873darkens
darters84017603darters
daters74827363da_ters
dates65639153da_te_s
davens104612913da_vens
easters75125683easters
eaten55323053ea_ten_
eaters65535943ea_ters
emptins1179403emptins
falters103916473falters
fasten95114893fasten_
fates85139233fa_te_s
fatten94314903fatten_
flattens11357483flattens
gaiters83516533gaiters
gapers94520463gap_ers
gapes86030823gap_e_s
gapless10349993gapless
gardens93312093gardens
garters84218223garters
gasters85624283gasters
gaters74728633ga_ters
gates65939503ga_te_s
glutens8437593glutens
habitans1346623habitans
haceks15447863ha_ceks
hackees165014103hackees
hackers164619043hackers
hades96035113ha_de_s
hadjees18356383hadjees
hadjes175210403hadje_s
hadrons113314303hadrons
haemins122811393haemins
haems105517013ha__ems
haen76229453ha__en_
haeres94017033haere_s
haes77651023ha__e_s
haets86525123ha__ets
haffets1636053haffets
hafted134713833hafte_d
hafter124815883hafte_r
hafting144014173hafting
hafts116219463haft__s
hagdons1258523hagdons
hailers104017263hailers
hajes155420943ha_je_s
hajjes15485243hajje_s
hakeems16394803hakeems
hakes126034303ha_ke_s
halers94926913ha_lers
hales85449843ha_le_s
halites103221193halite_s
hallels103310133hallels
haloes94623863haloe_s
halogens1237363halogens
halons95720713ha_lons
halted105019603halte_d
halter94420883halte_r
haltere103614703haltere
halteres113414593halteres
halting114419073halting
haltless11308443haltless
halts85230103halt__s
halvers133311423halvers
halves124717093halve_s
hamates122917673hamate_s
hames106138703ha_me_s
hamlets123211403hamlets
hammers144216053hammers
hampers143616943hampers
hamsters13710423hamsters
hances115621283hance_s
handers114224333handers
hangers113120813hangers
hankers144218133hankers
hansels104011653hansels
hanses95022633hanse_s
hanted104124313hante_d
hanting114124483hanting
hantles104117513hantles
hants86335403hant__s
haoles94919803haole_s
hapaxes1936593hapaxes
haplites1339993haplite_s
haplont12412563haplont
haplonts1345773haplonts
happed144820103happe_d
happened1635653happened
happing153817233happing
haps96443463hap___s
haptic13511883hapt_ic
harden105718533harden_
hareems12428203hareems
harems115513823ha_rems
hares86255543ha_re_s
harken135116343harken_
harmers124116593harmers
harmins123716713harmins
harness102413933harness
harpers124916203harpers
harpies123818313harpie_s
harpins123615703harpins
harpoons1337473harpoons
harshens1437603harshens
hartals10313023hartals
harts88441593hart__s
hashes125024803hashe_s
haslets102510863haslets
hassels104311013hassels
haste85927863haste__
hasted105125283haste_d
hastened12239103hastened
hastener11259133hastener
hasteners12267813hasteners
hasting114725193hasting
hate78450173ha_te__
hated95734023ha_te_d
hater85034753ha_te_r
hating104929713ha_ting
hatless103813443hatless
hatpin112610603hatpin_
hatreds11307813hatreds
hats76858253ha_t__s
hatted104921513hatte_d
hatter94724873hatte_r
hatting113920233hatting
haulers104012443haulers
haunters11329533haunters
hausen9610383hausen_
haute89521613haute__
hauteur1033893hauteur
hauteurs1133733hauteurs
haven114718533ha_ven_
havers124721483ha_vers
haves116034873ha_ve_s
hawkers174210333hawkers
hawkeys20414703hawkeys
hawsers13409483hawsers
hawses125113993hawse_s
hayers124415943ha_yers
hazans183411653ha_zans
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_ze_s
hazzans18215783hazzans
heapers123616673heap_ers
hearkens15336693hearkens
hearten102411753hearten_
heaters104225213heaters
heathens143210153heathens
heavens13439303heavens
hefters134312003hefters
hens75642573h___ens
heptads1335873heptads
heptane1238363heptane
heptanes1339003heptanes
hinters103719573hinters
hipless12399923hipless
hipness12277383hipness
hipsters13268783hipsters
hitters104717583hitters
hoarsens11306023hoarsens
hoddens12378803hoddens
hoidens11329083hoidens
hooters104520463hooters
hopers114222973hop_ers
hopes105835643hop_e_s
hoppers143115143hoppers
hostels103712313hostels
hostess103210233hostess
hotels94515503h_otels
hoydens14347403hoydens
hunters103915723hunters
hurters103413633hurters
hymens1437993h_ymens
hypers144811913hyp_ers
hypes135818673hyp_e_s
hyphen1736393hyphen_
japans1539823jap_ans
japers154616173jap_ers
japes146322823jap_e_s
kaftans14185353kaftans
khazens2332663kha_zens
kittens11347583kittens
ladens74516233la_dens
lanterns838303lanterns
lapels83712043lap_els
lapins84520683lap_ins
lappers113717463lappers
lappets11329123lappets
lapsers93911053lapsers
lapses85217693lapse_s
laptops1166603laptops
lasters75627693lasters
lateens74210553lateens
laten54328343la_ten_
latent64124303la_tent
latents75214313la_tents
latten65018203latten_
lattes65324203latte_s
lattins74115483lattins
leptins92412693leptins
leptons91910413leptons
lippens11328533lippens
listens74014133listens
maddens11359753maddens
maidens10349663maidens
malteds10377603malteds
mantels94515043mantels
mantes84430783mante_s
maples104819423maple_s
mappers133313773mappers
marten84518263marten_
martins93322063martins
masters94628923masters
maters85032383ma_ters
mates75251363ma_te_s
mateys115610943ma_teys
matins84527783ma_tins
matters94421753matters
mattes85624533matte_s
mattins93316143mattins
mavens114312973ma_vens
mittens9349883mittens
napes74828463nap_e_s
napkins1336673napkins
napless93110283napless
nappers114214863nappers
nappes104515623nappe_s
nates55238333na_te_s
natters73718063natters
neatens73310403neatens
oaten55222403oa_ten_
oaters65029783oa_ters
opens76118553_op_ens
palters94021683palters
pangens103112063pangens
papains11312363papains
papers105125323pap_ers
partans94418283partans
partons94620513partons
pastels95215183pastels
pasterns104112623pasterns
pasters94531733pasters
pastes85233913paste_s
paten74827343pa_ten_
patent84524923pa_tent
patents94815203pa_tents
paters84935823pa_ters
pates76047893pa_te_s
patins87528783pa_tins
patten84418193patten_
patterns10439943patterns
patters94825193patters
pectens11189203pectens
peens76428193__peens
pens65649643__p_ens
phaetons1345853phaetons
platens94213983platens
rafters103715633rafters
ranters73323643ranters
rapers84327183rap_ers
rapes75740723rap_e_s
raphes115117453raphe_s
rapiers95012873rapiers
rapines95120863rapines
rappees113611453rappees
rappels11448803rappels
rappen103512713rappen_
rappers113618443rappers
raptness1046733raptness
raptors94213353raptors
rasters74629023rasters
ratans63819373ra_tans
ratels64518213ra_tels
raters63936573ra_ters
rates55352013ra_te_s
rattans73411953rattans
ratteens8256053ratteens
ratten64217383ratten_
ratters74422473ratters
rattons73815323rattons
ravens93916883ra_vens
rhaphes1534703rhaphe_s
ripens85012173rip_ens
saddens9309603saddens
salterns8388893salterns
salters73622253salters
saphena1235863saphena
saphenas1345713saphenas
sapient9415333sapient
sapients1037423sapients
sapless93313443sapless
sapotes9313933sapote_s
sappers113518893sappers
sarsens7311393sarsens
sateens73710753sateens
sates54949323sa_te_s
satins64930483sa_tins
sautes63924913saute_s
septets998953septets
shaitans1136403shaitans
shanteys14395503shanteys
shapen114414653shap_en_
shapers124016893shap_ers
shapes115124943shap_e_s
sharpens13377813sharpens
shatters113313903shatters
shippens15316793shippens
shortens11288983shortens
smartens10286663smartens
softens10347623softens
spates85028173spate_s
tapers84025813tap_ers
tapes75838603tap_e_s
tappers113416543tappers
tappets113610013tappets
tapsters10318803tapsters
tartans72615823tartans
tasters74225643tasters
tastes64126423taste_s
taters64932193ta_ters
tates55444983ta_te_s
tatters74520483tatters
tauten64311893tauten_
tens45647413___tens
unpens82511013unp_ens
wafters134112813wafters
waiters104218623waiters
wakens135012043wa_kens
wanters104420093wanters
wantons103713013wantons
wardens113711903wardens
warrens103810893warrens
wasters104026593wasters
wastes96224883waste_s
waters95030623wa_ters
whappers18276743whappers
wheatens1454663wheatens
whitens13428733whitens
yamens114010823ya_mens
yapons114411773yap_ons
yappers144012253yappers
yatters103914623yatters
zapateos1943113zapateos
zappers203911633zappers
zaptiehs2241863zaptiehs
zazens1435833za_zens

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274767.84317088.7
3Display Results4764760.1563051.3
 (SQL Overall)1786914768.15521911.8
 
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.