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

537 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
hansels10401166(None) 
handsels12317251handsels
hansel95214371hansel_
hanses95022631hanse_s
hassels104311021hassels
angels74416172_angels
cancels114113312cancels
cannels93413362cannels
chancels15439092chancels
channels13388502channels
damsels10126712damsels
easels65914552ea_sels
gunsels8338132gunsels
hallels103310132hallels
hances115621282hance_s
handers114224332handers
handles114020652handles
handsel11308722handsel_
handsets12258342handsets
hangers113120812hangers
hankers144218132hankers
hansas94616042hans_as
hanse85722792hanse__
hanseled1237712hanseled
hansoms12238522hansoms
hantles104117512hantles
hassel95614212hassel_
hassles103411692hassles
hausens1077632hausens
hawsers13409482hawsers
hawses125113992hawse_s
hazels185710082ha_zels
hirsels10128352hirsels
hosels94218612h_osels
housels105312142housels
mangels103614492mangels
manses84225512manse_s
mantels94515042mantels
panels84716522pan_els
passels93913022passels
sanseis73011602sanseis
tassels74510852tassels
tinsels738372tinsels
abseils935973_abseils
ainsell796393ainsell
ainsells895403ainsells
aisles64721143_aisles
anele55628833_an_ele
aneles64626293_an_eles
anes45255933_an_e_s
angel65019573_angel_
angelus8418463_angelus
angers75222543_angers
angles74426703_angles
anils56326723_an_ils
anises64826693_anise_s
ankles104818383_ankles
annals66415923_annals
anneals7449953_anneals
annuls64711733_annuls
anoles64827433_anoles
answers1037043_answers
antes56334323_ante_s
anuses66218773_anuse_s
anvils9219713_anvils
appels104312793_appels
apses76823913_apse_s
ariels65119373_ariels
arses55733873_arse_s
artels66216233_artels
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
axels126313633_a_xels
baases85218013baase_s
babels105216723ba_bels
bagels95712313ba_gels
banders104324563banders
banes74945583ban_e_s
bangers104020353bangers
bangles103617413bangles
bankers133919093bankers
banners94018713banners
bannets94013843bannets
banshees13127863banshees
banters94623123banters
barbels114514433barbels
barrels94514363barrels
basely114412313ba_sely
bases75644353ba_se_s
basils85717473ba_sils
basses85428303basse_s
bassets96414823bassets
camels105217083ca_mels
canals84421673can_als
cancel105316683cancel_
cancers114018583cancers
candela1089743candela
candelas1139533candelas
candles104422343candles
caners84629203can_ers
canes75350373can_e_s
canfuls1248423canfuls
canistels11205393canistels
cankers134418753cankers
cannel84216403cannel_
canners93822663canners
canoers94318373canoers
canoes84725883canoe_s
cansos84915383cans_os
cantals93919573cantals
canters94827733canters
cantles94721413cantles
carcels114516063carcels
carpels115315463carpels
carrels95117303carrels
carses85233653carse_s
cartels94618123cartels
carvels124914593carvels
cases75048383ca_se_s
causals91411183causals
causers94014793causers
causes88026473cause_s
causeys12387223causeys
censers94313903censers
censes83721803cense_s
chaises124317493chaise_s
chancel144011783chancel_
chancers154313493chancers
chances145218093chance_s
changers144313203changers
changes134517583change_s
channel123910493channel_
chansons1337473chansons
chanters134016743chanters
chanteys16387493chanteys
chaoses124715123chaose_s
chapels14429153cha_pels
charnels13328173charnels
chasers123714923cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chattels13286793chattels
chisels12219103chisels
chunnels13304563chunnels
consols92914073consols
consuls92412323consuls
counsels1037583counsels
daises74318983daise_s
damosels11195243damosels
damsel9148033damsel_
dancers103413093dancers
dances95120653dance_s
danders93921183danders
dandles94218533dandles
dangers94818213dangers
dangles93618423dangles
danseur833663danseur
danseurs933433danseurs
danseuse942893danseuse
darnels83710433darnels
densely1146713densely
diesels8429143diesels
donzels1735393donzels
dorsels84412583dorsels
dossels85511613dossels
dynels10536813dyn_els
easel54521113ea_sel_
eases56041613ea_se_s
enamels9128163enamels
evangels1243733evangels
falsely1336013falsely
fanes84639893fan_e_s
fanjets1734803fanjets
fanners103914653fanners
fardels11389893fardels
farfels13348213farfels
fennels10387903fennels
flannels1134843flannels
funnels10348173funnels
fusels94412453_fusels
ganders93521703ganders
ganefs10489203gan_efs
ganevs10456913gan_evs
gangers94418603gangers
gangrels1094973gangrels
gannets83811443gannets
gases65633993ga_se_s
gassers84714633gassers
gasses75724783gasse_s
gavels105911093ga_vels
gunnels8358563gunnels
gunsel7339853gunsel_
haceks15447863ha_ceks
hackees165014103hackees
hackers164619043hackers
hackles162917063hackles
hades96035113ha_de_s
hadjees18356383hadjees
hadjes175210403hadje_s
haems105517013ha__ems
haeres94017033haere_s
haes77651023ha__e_s
haets86525123ha__ets
haffets1636053haffets
hafters134614333hafters
haggles123312483haggles
hailers104017263hailers
hails85231643ha__ils
hajes155420943ha_je_s
hajjes15485243hajje_s
hakeems16394803hakeems
hakes126034303ha_ke_s
halals95018313ha_lals
halers94926913ha_lers
hales85449843ha_le_s
hallel93514093hallel_
halls85633783ha__lls
haloes94623863haloe_s
halters104619803halters
halvers133311423halvers
halves124717093halve_s
hamals114816833ha_mals
hamauls12387823hamauls
hames106138703ha_me_s
hamlets123211403hamlets
hammals14409233hammals
hammers144216063hammers
hampers143616953hampers
hamsters13710423hamsters
hanapers1346963hanapers
hance105424153hance__
handbell14114523handbell
handbells1594363handbells
handed114919983hande_d
hander104526433hande_r
handfuls15115753handfuls
handheld1644463handheld
handhelds1743763handhelds
handily143610873handily
handle104219293han_dle
handled124114533handled
handler113516163handler
handlers124014143handlers
handless123512063handless
hands95327383han__ds
handsaws1545873handsaws
handseled1444403handseled
handset113016823handse_t
handsewn1543623handsewn
hangars114313493hangars
hanged114222403hange_d
hanger104023263hange_r
hangs95726733han__gs
hangul1049223hangul_
hangups1364823hangups
hanked144220603hanke_d
hanker134622093hanke_r
hankies143617763hankies
hanks126226863han__ks
hansa85416783hans__a
hanseling1338063hanseling
hanselled1345483hanselled
hansom11219153hans_om
hanted104124313hante_d
hantle94318203han_tle
hants86335403han__ts
haoles94919803haole_s
hapless123311333hapless
happens14359173happens
haptens124511343haptens
hardens113815023hardens
hareems12428203hareems
harems115513823ha_rems
hares86255543ha_re_s
harkens144112863harkens
harls85634503ha__rls
harmers124116593harmers
harness102413933harness
harpers124916203harpers
harshens1437603harshens
harshly1636273harshly
harslet10315653harslet
harslets1137833harslets
hartals10313023hartals
hashes125024803ha_shes
haslet93222713ha_slet
haslets102510863haslets
hasps105114643ha_s_ps
hassle93711593ha_ssle
hassled11358303hassled
hastens106214813hastens
hastes95727073ha_stes
hatchels16368673hatchels
haters94930403ha_ters
hates86742573ha_te_s
hatfuls1386023hatfuls
hatless103813443hatless
hatreds11307813hatreds
hatters104221523hatters
haulers104012443haulers
hauls86123733ha__uls
haunters11329543haunters
hausen9610383hause_n
havens124514043ha_vens
haverels14325753haverels
havers124721483ha_vers
haves116034873ha_ve_s
hawkers174210333hawkers
hawkeys20414703hawkeys
hawse116015123hawse__
hawser125910843hawse_r
hayers124415943ha_yers
hayseed1435633hayseed
hayseeds1543283hayseeds
hazel176414813ha_zel_
hazers184615953ha_zers
hazes174928323ha_ze_s
headsets1236053headsets
hearses104414543hearse_s
heels85625533h__eels
henges104516463henge_s
henleys1334843henleys
herself1337623herself
himself1544293himself
hinders113718503hinders
hingers113420213hingers
hinges105121033hinge_s
hinters103719583hinters
hirsel9138683hirsel_
hirsles101510073hirsles
hisself1335913hisself
hissers104112313hissers
hisses94719353hisse_s
hoarsely1444373hoarsely
hoarsens11306033hoarsens
hoises94823683hoise_s
hondles113614523hondles
honers94324973hon_ers
hones88144493hon_e_s
honeys124016083hon_eys
honkers143315233honkers
honkeys17439513honkeys
hornfels1443793hornfels
horses94729353horse_s
hosel86024823h_osel_
hosers95223973h_osers
hoses85443183h_ose_s
hoseys124614013h_oseys
hostels103712323hostels
hotels94515523h_otels
housel95217053housel_
housers104717823housers
houses96032283house_s
hovels125413343h_ovels
hungers114013303hungers
hunkers143314333hunkers
hunkeys17386193hunkeys
hunters103915733hunters
insets64016133_insets
janes124928123jan_e_s
jangles154015683jangles
kaisers11369273kaisers
kanes95529373kan_e_s
kantele1138253kantele
kanteles1238123kanteles
kennels11387193kennels
knawels14344683knawels
kneels10408933_kneels
labels84515683la_bels
lancers93616643lancers
lances84824103lance_s
lancets93411163lancets
landers84026213landers
lanely93914483lan_ely
lanes54946793lan_e_s
langrels9106173langrels
lanners73618333lanners
lapels83712043la_pels
lapsers93911053lapsers
lapses85217693lapse_s
lasers64925703la_sers
lases54944763la_se_s
lasses64827593lasse_s
laurels746663laurels
lenses64620893lense_s
linseys1035083linseys
lintels73311163lintels
losels64714593_losels
mandrels1137313mandrels
manes76648963man_e_s
mangel94017543mangel_
mangers103521263mangers
manges94628953mange_s
mangles104021463mangles
manless93012933manless
manners93417833manners
manse75528233manse__
mantel84317973mantel_
mantes84430783mante_s
mantles94820703mantles
manuals9311223manuals
marcels113212373marcels
marses84827113marse_s
marvels123810093marvels
masers84623453ma_sers
masses85028713masse_s
menses84222453mense_s
missels94614813missels
morsels94112663morsels
mussels9419843mussels
nances83618643nance_s
nasals63312463na_sals
nauseas735993nauseas
navels95712693na_vels
noels56418703__noels
nonself1078513nonself
oases55330983oa_se_s
onsets64013543_onsets
ousels64815283_ousels
panders103423733panders
panel76023623pan_el_
panes76148693pan_e_s
panfuls1237173panfuls
pangens103112063pangens
paniers94717333paniers
panners93621273panners
pannes85522853panne_s
pansies94521983pansies
panzers184012013panzers
parcels113712663parcels
parrels94713493parrels
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
paseos88015813pa_seos
pases75346503pa_se_s
passel85117003passel_
passers94717753passers
passes86030473passe_s
pastels95215183pastels
pausers94113223pausers
pauses84621473pause_s
pencels113610063pencels
pensees9311203pensees
pensils92811593pensils
phases114618403pha_se_s
raisers73617393raisers
raises64826543raise_s
rances84625443rance_s
ranees64623963ran_ees
rangers83621043rangers
ranges73826933range_s
rankers113217463rankers
rankles113114543rankles
ransoms92410163ransoms
ranters73323643ranters
rappels11448803rappels
rasers64526783ra_sers
rases55447213ra_se_s
rassles73513923rassles
ratels64518213ra_tels
ravels94717073ra_vels
rinsers73815743rinsers
rinses64720383rinse_s
rondels82510053rondels
ronnels7318623ronnels
runnels7329163runnels
samiels939763samiels
sandals82715203sandals
sanders84025943sanders
sanely93114613san_ely
sanes55649073san_e_s
sangers84421943sangers
sanies63031953sanie_s
sansars73313913sansars
sansei63411903sanse_i
santols73513323santols
sarsens7311393sarsens
sasses64124393sasse_s
saurels749303saurels
sels46345983___sels
senseis73310643senseis
senses63923943sense_s
shanteys14395513shanteys
spancels1245273spancels
spaniels1045963spaniels
sunsets72911573sunsets
taels56822073ta__els
tahsils1035053tahsils
tandems1037633tandems
tangelo837043tangelo
tangelos935743tangelos
tangles83920053tangles
tankers113416913tankers
tanners74018393tanners
tanrecs934823tanrecs
tansies74521243tansies
tarsals72512603tarsals
tassel66014773tassel_
tasses64826763tasse_s
tassets75012773tassets
tawses94913193tawse_s
teasels74311313teasels
tensely1037363tensely
tenses64722553tense_s
thanes94918983than_e_s
thankers15297833thankers
tinsel639443tinsel_
tonsils7310183tonsils
tunnels7328723tunnels
unseals73212583_unseals
unsell63512543_unsell
unsells73210773_unsells
unsets64116163_unsets
unsews9379363_unsews
vakeels14113733vakeels
valses94514613valse_s
vandals113211663vandals
vanes85130973van_e_s
vanners103612843vanners
vases84626263va_se_s
vassals1057953vassals
vessels1035933vessels
wadmels1334303wadmels
wadsets1136443wadsets
wanders114221333wanders
wanes85040883wan_e_s
wangles113416933wangles
wankers144514713wankers
wanness102610683wanness
wanters104420093wanters
warsles103413643warsles
weasels10468503weasels
whangees15275063whangees
zanders173015793zanders
zanies153219673zanie_s

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 Limit1340275376.75019855.9
3Display Results5375370.2032645.3
 (SQL Overall)1786915377.35924282.0
 
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.