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

457 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
hartals1031302(None) 
hartal9415471hartal_
argals75517702_argals
artal55525472_artal_
artels66216232_artels
bharals1236732bhar_als
cantals93919572cantals
carpals113414622carpals
cartels94618122cartels
curtals93111622curtals
farfals13268502farfals
gharials1245122gharials
halals95018312ha_lals
hamals114816812ha_mals
hammals14409212hammals
harass9313942har_ass
hardass1139752hardass
harls85634502har__ls
harts88441592hart__s
herbals122710602herbals
mortals93914002mortals
narwals1036982narwals
parrals94414572parrals
partans94418282partans
partials101911952partials
portals94015562portals
ratals64219582ra_tals
tarsals72512602tarsals
tartans72615822tartans
tartars73313402tartars
aals49941143_a__als
acetals93411353acetals
aerials74017553aerials
altars64518153_altars
annals66415923_annals
antas55432033_anta_s
aortal65217513aortal_
aortas65417783aorta_s
appals104812943_appals
araks94820883_ar_aks
areal55928733_areal_
areas55935773_area_s
argal65023383_argal_
argala74712663_argala
argalas84011083_argalas
argali75013743_argali
argalis84214183_argalis
argils75213623_argils
argols74514613_argols
arhats9312973_arhats
arias55438023_aria_s
ariels65119373_ariels
arils58732203_ar_ils
arras55626133_arra_s
arrays95311683_arrays
artel56122743_artel_
artily92814713_artily
arts49650263_art__s
arval86017013_arval_
aryls87015813_ar_yls
astrals75515243_astrals
ataps76414833_a_taps
atlas55821583_a_tlas
attars64515313_attars
baals76122703ba__als
bantams1149063bantams
barbal104016663barbal_
barbels114514433barbels
barbitals1345253barbitals
barcas101016603barca_s
barrels94514363barrels
barters94223033barters
barytas12378283baryta_s
bhaktas1633643bhakta_s
bharal1138893bhar_al_
borals86721913bor_als
borstals1037463borstals
burials93612083burials
buttals938503buttals
cabals104020153ca_bals
caftans12179443caftans
canals84421663ca_nals
cantal84122033cantal_
cantala94114673cantala
cantalas104013523cantalas
capitals12209443capitals
captans111612053captans
caracals12310743caracals
carates95630603carates
carats85929023car_ats
carcass11310513carcass
carcels114516063carcels
carfuls1249133carfuls
caritas93316943carita_s
carls77037423car__ls
carnal83919203carnal_
carols85124983car_ols
carpal103716253carpal_
carpale113414353carpale
carpels115315463carpels
carrels95117303carrels
cartable121314093cartable
cartage10312593cartage
cartages11313313cartages
cartel85022533cartel_
carters95327243carters
cartes86239473cart_es
cartons94122473cartons
carts78946293cart__s
carvels124914593carvels
casuals91410523casuals
catalo8314853ca_talo
catalos9414163ca_talos
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
causals91411183causals
centals94317053centals
cereals9313173cereals
chaetal1238283chaetal_
charas114223593char_a_s
charcoals16174673charcoals
charkas164810953charka_s
charnels13328173charnels
charpais1536923charpais
chartable1636833chartable
charters134115563charters
charts115823093chart__s
chattels13286793chattels
chorals124614103chor_als
citrals91111663citrals
corals85325143cor_als
corrals93713853corrals
craals84113303_craals
curtails10318243curtails
curtal83914543curtal_
dactyls1333913dactyls
darbars10510093darbars
darnels83710433darnels
darters84017603darters
dartle73714833dart_le
dartles84014133dartles
darts67635733dart__s
dentals83915393dentals
dharmas1356503dharma_s
dharnas1155373dharna_s
dorsals84110843dorsals
earfuls1036863earfuls
earlaps936393earlaps
earls56127513ear__ls
earthly13387383earthly
earths95014593eart_hs
facials123310743facials
fallals103310193fallals
fantails1139693fantails
farads104713273far_ads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113far__ls
farts88336843fart__s
fatal84819373fa_tal_
faucals12326563faucals
ferals94216643fer_als
formals123312893formals
fractals1346133fractals
garters84218223garters
garths104111503gart_hs
gavials1136603gavials
gayals1039513ga_yals
gharial1137343gharial_
gorals76917653gor_als
graals74112913_graals
haafs115711163ha__afs
haars85620473ha__ars
habitans1346623habitans
habitats1346733habitats
hadal95518123ha_dal_
haemal113811643haemal_
haets86525123haet__s
haftara13136093haftara
haftaras14136073haftaras
hafters134614333hafters
hafts116219463haft__s
hahas117118443ha_ha_s
hails85231643ha__ils
hairball1344633hairball
hairballs1443843hairballs
haircaps15144363haircaps
halal85623593ha_lal_
halala94715093ha_lala
halalas104214083ha_lalas
hallahs133912463hallahs
hallal94415563hallal_
hallels103310133hallels
halls85633783ha__lls
halmas117017893halma_s
halters104619803halters
halts85230103halt__s
halvahs16417533halvahs
halvas124714173halva_s
hamal104623103ha_mal_
hamates122917673hamates
hamauls12387803hamauls
hammal134512063hammal_
hammams13386433hammams
hamzahs24134373hamzahs
hamzas20119013hamza_s
hangars114313483hangars
hangtags1344153hangtags
hansas94616043hansa_s
hansels104011653hansels
hantle94318203hant_le
hantles104117513hantles
hants86335403hant__s
haptens124511343haptens
harbors12412413harbors
hardball14116303hardball
hardballs15115543hardballs
hardens113815023hardens
hardhats1546833hardhats
hardies114923233hardies
hardily143310273hardily
hardly135112833har_dly
hardpans1436453hardpans
hards96435653har__ds
hardtack1843993hardtack
hardtacks1943803hardtacks
hardtops1444843hardtops
hareems12428203hareems
harems115513823har_ems
hares86255543har__es
hariana10310243hariana
harianas1139163harianas
harijans1845723harijans
harkens144112863harkens
harks126333433har__ks
harl75740003har__l_
harlots103413293harlots
harmers124116593harmers
harmins123716713harmins
harms106829013har__ms
harness102413933harness
harpers124916203harpers
harpies123818313harpies
harpins123615703harpins
harps105926863har__ps
harries103525493harries
harrows132611033harrows
harshly1636273harshly
hart76865773hart___
hassels104311013hassels
hastate10313913hastate
hastens106214813hastens
hastes95727073hast_es
hastily133010663hastily
hatable121713963ha_table
haters94930393ha_ters
hates86742573ha_t_es
hatfuls1386023hatfuls
hatrack1638213hatrack
hatracks1737533hatracks
hatreds11307813hatreds
hats76858253ha_t__s
hatters104221523hatters
hauls86123733ha__uls
hawala12368913ha_wala
hawalas13348353ha_walas
hazans183411653ha_zans
hazels185710083ha_zels
hazmats2136603hazmats
hazzans18215783hazzans
heals85733453h__eals
hearsays1444513hearsays
heartens113010153heartens
hearths135311073heart_hs
hearties11315413hearties
heartily1436563heartily
hearts96218943heart__s
heptads1335873heptads
herald10311343her_ald
heralds1137703her_alds
herbal112513493herbal_
herls85226433her__ls
hertzes1938293hertzes
hiatal9310193hiatal_
hirsels10128343hirsels
horahs126313873hor_ahs
horal86328673hor_al_
horas86333093hor_a_s
horntails12124823horntails
hostas94515823hosta_s
hostels103712313hostels
hotels94515503h_otels
hurls86522713hur__ls
hurrahs13336773hurrahs
hurrays13386153hurrays
hurters103413633hurters
hurtle93512943hurt_le
hurtles103913753hurtles
hurts86922823hurt__s
hyetal1236543hyetal_
hymnals1543523hymnals
instals7611713instals
jacals1539873ja_cals
jackals2036893jackals
jarfuls1754773jarfuls
jarls126120963jar__ls
jarrahs1735453jarrahs
kaftans14185353kaftans
kantars11310033kantars
karates115617473karates
karats106420493kar_ats
karmas123013733karma_s
karts97630113kart__s
katas95922093ka_ta_s
kraals10378433_kraals
kurtas10349883kurta_s
labials9299873labials
lactams1136953lactams
lacteals1095663lacteals
lanitals837723lanitals
lariats7615053lariats
larval948503larval_
larvas9310233larva_s
maltols939403maltols
mammals10389273mammals
mantas85725363manta_s
mantels94515043mantels
manuals9311213manuals
maras75443283mar_a_s
marcels113212373marcels
margays1337493margays
marital92314183marital_
markas124717003marka_s
marls75535163mar__ls
marrams11310123marrams
marsala939583marsala
marsalas1038253marsalas
marshals1337783marshals
martens93714953martens
martial92415413martial_
martians103111613martians
martins93322063martins
marts77442233mart__s
martyrs1234893martyrs
marvels123810093marvels
matrass939393matrass
metals84520883_metals
morals85324633mor_als
mortal84616853mortal_
mortars93411523mortars
murals84016753mur_als
narial6317953narial_
narwal938943narwal_
narwhals1443613narwhals
nasals63312463na_sals
natal53921493na_tal_
normals92510903normals
orals55826483_or_als
palatals1037773palatals
paras76143043par_a_s
parcels113712663parcels
pardahs13289673pardahs
pariahs123812343pariahs
parians93519733parians
parietals1146863parietals
parkas125018023parka_s
parlays123910453parlays
parols84722613par_ols
parral85517533parral_
parrels94713493parrels
partake1339643partake
partakes1449923partakes
partan83820563parta_n
partial92616263partial_
parties93230863parties
partly116315473part_ly
partons94620513partons
parts77743373part__s
pascals11610013pascals
pastas85422873pasta_s
pastels95215183pastels
pastils94416173pastils
patrols93513513patrols
petals84719813_petals
portal84218463portal_
postals93716373postals
quartans1736283quartans
radials83614633radials
ragtags935373ragtags
raitas64417673raita_s
ramtils938413ramtils
rascals959663rascals
ratal55025113ra_tal_
ratans63819373ra_tans
ratels64518213ra_tels
rattails837133rattails
rattans73411953rattans
reals55038653__reals
rentals74017473rentals
rials55026673__rials
sabals84618863sa_bals
sacrals93311793sacrals
salals65120083sa_lals
sambals115213483sambals
sandals82715203sandals
santols73513323santols
sarans64224433sar_ans
sardars83112903sardars
sarsars73512143sarsars
sartors7314953sartors
satays94411683sa_tays
satraps95011643satraps
serials73919743serials
servals103410743servals
shaitans1136403shaitans
shariahs14206393shariahs
sharias102516003sharia_s
smartass1044273smartass
spitals93011593spitals
tamals84116623ta_mals
tantalus836373tantalus
tarmacs1138323tarmacs
tarnal63716503tarnal_
tarpans92513533tarpans
tarsal63315273tarsal_
tartan64217513tarta_n
tartana73010193tartana
tartanas8258893tartanas
tartar63214753tarta_r
tartare73012683tartare
tartily103511573tartily
tartly96014023tart_ly
tarts57242023tart__s
tarzans16329923tarzans
tatars64619793ta_tars
tertials8510073tertials
thermals13518513thermals
tortas64918253torta_s
totals63115163_totals
trials64319883_trials
urials64415193_urials
vandals113211663vandals
varas86028193var_a_s
varias95019903varia_s
varietals1244443varietals
varnas94212823varna_s
vassals1057953vassals
verbals121910733verbals
vestals104612333vestals
vitals94514303_vitals
wadmals1335513wadmals
wagtails1244443wagtails
warsaws1335763warsaws
warts814840403wart__s
wataps11248683wa_taps

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.1401276364.3
2DLD Change Limit1340274578.18616372.7
3Display Results4574570.1562929.5
 (SQL Overall)1786914578.48221067.1
 
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.