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

251 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
hapaxes193659(None) 
apexes1539132_apexes
galaxes1538882galaxes
hamates122917682hamates
handaxes1938402handaxes
hapax1739322hapax__
hoaxes163611692h_oaxes
hyraxes2045702hyraxes
paxes144928422__paxes
abases85720773_abases
abates85825033_abates
adages8412953_adages
addaxes1634573addaxes
agapes95212413_agapes
agates76121343_agates
agaves104611513_agaves
alates64833973_alates
amazes175613473_amazes
apace94718383_apace_
apaches143411843_apaches
apes66047433_ap__es
apices104916263_apices
apples104315763_apples
apres75426403_ap_res
apses76823913_ap_ses
arames84622573_arames
ataxies142410013_ataxies
awakes135012473_awakes
axes117337853___axes
baases85218013ba_ases
balases93815433balases
banjaxes2443393banjaxes
boraxes163511633boraxes
calxes154113033ca_lxes
calyxes19426233calyxes
camases114216343camases
canapes111213083canapes
capes95441923cap__es
capiases1239253capiases
capizes20410373capizes
capotes11314643capotes
carafes125015703carafes
carapaxes2044833carapaxes
carates95630613carates
chamades16138653chamades
chapatis15127943chapatis
chapes135421873chap__es
chappies172610103chappies
charades141310853charades
charases131312763charases
coaxes154715633_coaxes
damages11511283damages
daphnes13327683daphnes
dapples1238993dapples
dewaxes18297843dewaxes
earwaxes1844703earwaxes
empales112411433empales
facades1339033facades
faxes155726653__faxes
flaxes165015353_flaxes
galaxies1637173galaxies
gapes86030823gap__es
garages9314113garages
gavages1237683gavages
haafs115711163ha_a_fs
haars85620473ha_a_rs
hackees165014103hackees
hackies163418243hackies
hackles162917063hackles
hades96035113h__ades
hadjees18356383hadjees
hadjes175210403ha_djes
haeres94017033ha_eres
haes77651023h__a_es
hafizes2235983hafizes
haggles123312483haggles
hahas117118443haha__s
hajes155420943h__ajes
hajjes15485243ha_jjes
hakes126034303h__akes
halalas104214083halalas
halals95018313hala_ls
hales85449843h__ales
halides113416663halides
halites103221193halites
halloes104021523halloes
haloes94623863ha_loes
halves124717093ha_lves
hamadas1339673hamadas
hamals114816833hama_ls
hamate113319833hamate_
hamauls12387823hamauls
hames106138703h__ames
hanaper1237133hanaper
hanapers1346963hanapers
hances115621283ha_nces
handles114020653handles
hankies143617763hankies
hanses95022633ha_nses
hantles104117513hantles
haoles94919803ha_oles
hapless123311333hapless
haplites1339993haplites
haploses1338853haploses
happed144820103hap_ped
happen134812193hap_pen
happens14359173happens
happier143312043happier
happiest152411683happiest
haps96443463hap___s
hapten115312983hap_ten
haptenes133810823haptenes
haptens124511343haptens
harass9313943hara_ss
harasses11311033harasses
hardies114923233hardies
hares86255543h__ares
harpies123818323harpies
harries103525493harries
hashes125024803ha_shes
hassles103411693hassles
hastes95727073ha_stes
hatboxes2055003hatboxes
hatches153420273hatches
hates86742573h__ates
haulages1236623haulages
haves116034873h__aves
hawalas13348353hawalas
hawkies173311243hawkies
hawses125113993ha_wses
haylages1536013haylages
hazans183411653haza_ns
hazards2037463hazards
hazes174928323h__azes
heaves124120303h_eaves
helixes1739133helixes
heptanes1339003heptanes
hexades18378703hexades
hexanes17319463hexanes
hexes155123043h__exes
hippies142813753hippies
hoaxed17378873h_oaxed
hoaxer16348563h_oaxer
hoaxers17327133h_oaxers
homages131011593homages
hopes105835643hop__es
hopples142810713hopples
humates122813193humates
hypes135818673hyp__es
hypotaxes2445323hypotaxes
hyraces1537913hyraces
impales113311763impales
jacales16310323jacales
japans1539823japa_ns
japes146322823jap__es
kapas116021733kapa__s
karates115617473karates
khanates1535733khanates
lampases1267293lampases
lapides103012043lapides
lapises93513463lapises
lapses85217693lap_ses
latexes1438313latexes
lavages1138603lavages
laxes125430093__laxes
lipases9209483lipases
madames12310063madames
malates93522613malates
manages103418963manages
maples104819423map_les
maxes145629533__maxes
maxixes1535253maxixes
naiades838213naiades
napalms1144033napalms
napas75924353napa__s
napes74828463nap__es
nappes104515623nap_pes
nappies114613403nappies
nopales93812523nopales
paces96741113__paces
pages85235073__pages
palaces114216463palaces
palates93624943palates
pales75753803__pales
palpates122613063palpates
panes76148693__panes
papacies1439483papacies
papains11312363papains
papas94927493papa__s
papaws13419113papa_ws
papayas1437273papayas
pappies103214833pappies
papules112411573papules
parades104121463parades
pares77164483__pares
pases75346503__pases
pates76047893__pates
pavanes123612653pavanes
paves104833923__paves
paxwaxes1942053paxwaxes
phalanxes2153913phalanxes
pipages1289423pipages
pixes144323173__pixes
poxes145325723__poxes
praxes156215183_praxes
pupates113311433pupates
pyxes175911403__pyxes
radixes15259343radixes
rampages1336673rampages
rapes75740723rap__es
raphes115117453rap_hes
rapines95120863rapines
rappees113611453rappees
ravages1139403ravages
raxes124729393__raxes
relaxes143215323relaxes
repaves123513653repaves
retaxes143615093retaxes
rewaxes173911333rewaxes
rhaphes1534703rhap_hes
sapotes9313943sapotes
sarapes94617753sarapes
savages1139973savages
savates10312953savates
saxes125229343__saxes
shapes115124953shap__es
spaces104722633_spaces
spades94222583_spades
spaes76029973_spa_es
spales84728103_spales
spares84834553_spares
spates85028173_spates
takahes1436173takahes
tamales93216153tamales
tapalos938813tapalos
tapas74627713tapa__s
tapes75838603tap__es
tapises92914013tapises
taxes124730823__taxes
thanages12107623thanages
thoraxes1896363thoraxes
topazes1857313topazes
upases84112903_upases
vacates12312833vacates
wakames1635283wakames
warpages1437053warpages
watapes12228383watapes
waxes155825503__waxes
zapateo1844593zapateo
zapateos1943113zapateos
zaxes215113823__zaxes

Search took 7 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 Limit1340272516.06322105.7
3Display Results2512510.0932698.9
 (SQL Overall)1786912516.56227231.2
 
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.