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

390 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
khaphs1839432(None) 
kaphs144911501k_aphs
khaph17395961khaph_
caphs124515372_caphs
chapes135421872chapes
chaps125326062chap_s
graphs124510152graphs
hahs108333362_ha_hs
haps96443462_hap_s
kapas116021732k_apas
kaph135815752k_aph_
khadis1446912khadis
khafs15648842kha_fs
khakis1265852khakis
khans124615172kha_ns
khats125316012kha_ts
kheths16495972kheths
knaps115511172knap_s
kophs145010932k_ophs
rhaphe1433422rhaphe
rhaphes1534702rhaphes
shahs115919512sha_hs
shapes115124942shapes
staphs114411032staphs
whaps135115162whap_s
aahs716428563__aahs
adapts9107813adapts
agapes95212413agapes
ahs68644823__a_hs
alephs1136533alephs
amahs107819063ama_hs
apes66047433__apes
aphis105917133__aphis
apos65433823__apos
apps86319693__apps
ataps76414833atap_s
ayahs116813523aya_hs
baps86040843_bap_s
baths105922923_baths
bhangs12449663bhangs
blahs105616513bla_hs
brachs134415753brachs
bumphs15467103bumphs
capes95441923_capes
caph116623293_caph_
capos94826073_capos
caps87147893_cap_s
chads116122233cha_ds
chafes145017913chafes
chaffs17459613chaffs
chains114819703chains
chairs114916183chairs
chais107530313cha_is
chalahs15289883chalahs
chalehs15268803chalehs
chalks155412143chalks
champs154915683champs
chams126028503cha_ms
changs125215373changs
chants115020393chants
chaos105622863cha_os
chap114928493chap__
chape125221143chap_e
chapel134911373chapel
chapels14429153chapels
chapt125827643chap_t
charas114223613charas
chards125119733chards
chares115631803chares
charks155219703charks
charms135218843charms
charrs115219193charrs
chars105936643cha_rs
charts115823093charts
chases115128233chases
chasms135513143chasms
chats105730093cha_ts
chaws135022463cha_ws
chays135319743cha_ys
cheapos14418513cheapos
cheaps134613683cheap_s
cheths14389823cheths
chips125721253chip_s
chops125019873chop_s
clachs133511323clachs
claps95626183clap_s
coapts104614013coapts
crapes104727693crapes
craps95328643crap_s
dahs88231813_da_hs
daps77239163_dap_s
deaths105914443deaths
dhaks13479703dha_ks
dhals95415443dha_ls
drapes95419653drapes
ephahs1435503epha_hs
etapes85415293etapes
flaps105621383flap_s
fraps105620553frap_s
gapes86030823_gapes
gaps76042973_gap_s
ghats95818613gha_ts
ghauts10447783ghauts
ghazis1935203ghazis
glyphs1534303glyphs
grapes95123123grapes
graph115315613graph_
haafs115711163_haafs
haars85620473_haars
habus106317143_habus
hacks144928713_hacks
hades96035113_hades
haems105517013_haems
haes77651023_ha_es
haets86525123_haets
hafts116219463_hafts
hags86740843_ha_gs
hah910655223_ha_h_
haha107821063_ha_ha
hahas117118443_hahas
haiks125120933_haiks
hails85231643_hails
hairs86225173_hairs
hajes155420943_hajes
hajis156716283_hajis
hakes126034303_hakes
hakus125114113_hakus
hales85449843_hales
halls85633783_halls
halms105225213_halms
halos85230253_halos
halts85230103_halts
hames106138703_hames
hams96446133_ha_ms
hands95327383_hands
hangs95726723_hangs
hanks126226863_hanks
hants86335403_hants
hap87360053_hap__
hapax1739323_hapax
haply135915063_haply
happy155813533_happy
hards96435653_hards
hares86255543_hares
harks126333433_harks
harls85634503_harls
harms106829013_harms
harps105926873_harps
harsh116418053_harsh
harts88441593_harts
has67372653_ha__s
hash106936503_hash_
hashes125024803_hashes
hasps105114643_hasps
hates86742573_hates
hath105933913_hath_
hats76858253_ha_ts
haughs13408563_haughs
hauls86123733_hauls
haves116034873_haves
hawks155415703_hawks
haws106439443_ha_ws
hays106138073_ha_ys
hazes174928323_hazes
heaps105223223heap_s
heaths126316383heaths
hehs106723963_h_ehs
heths116317783_heths
highs125412523_highs
hips96433703_hip_s
hopes105835643_hopes
hops97942633_hop_s
humphs16528163humphs
hypes135818673_hypes
hypha1637383_hypha
hypos1312014743_hypos
hyps125418413_hyp_s
japes146322823_japes
kaas86531843k_a_as
kabs107130843k_a_bs
kadis105921063k_adis
kaes85734063k_a_es
kafs116423743k_a_fs
kagus105812033k_agus
kaifs125715643k_aifs
kails95525213k_ails
kains96125643k_ains
kakapos1243673kakapos
kakas85117343k_akas
kakis86116843k_akis
kales95730983k_ales
kaliphs1634293kaliphs
kalpas124112943kalpas
kames115024693k_ames
kanas95326913k_anas
kanes95529373k_anes
kaons95014853k_aons
kapa106021293k_ap_a
kapok10448783k_apok
kapoks11347263k_apoks
kappa13469743k_appa
kappas144410363kappas
kaput11717063k_aput
karns96624143k_arns
karts97630113k_arts
kas77058583k_a__s
kasha124710723k_asha
kashas133311903k_ashas
katas95922093k_atas
kats85944333k_a_ts
kavas125919953k_avas
kayos127714703k_ayos
kays116032193k_a_ys
kbars114612603kba_rs
keas86337093kea__s
keeps116020283keep_s
kelps115116423kelp_s
kemps135012523kemp_s
kepis115313363k_epis
keps106027303k_ep_s
khadi1367603kha_di
khaf145319603kha__f
khaki1157643kha_ki
khalif1657833khalif
khalifs1754073khalifs
khan115819143kha__n
khat116730723kha__t
khazen2233773khazen
khazens2332663khazens
khedahs1852953khedahs
khedas1446313khedas
kheth15509753kheth_
khets124913433kh_ets
khis117017983kh__is
khoums1594013khoums
kiangs11378363kiangs
kiaughs1542283kiaughs
kips106430523k_ip_s
kiths125814973k_iths
klepht1535043klepht
klephts1642183klephts
knacks11428543knacks
knap105815403knap__
knars94416113kna_rs
knaurs10466963knaurs
knaves13439523knaves
knawes13328393knawes
knops115911813knop_s
koalas104011663koalas
koans95818623koa_ns
koas85635093koa__s
koph135816543k_oph_
koppas14407603koppas
kops107031293k_op_s
kraals10378433kraals
krafts13438853krafts
kraits104912203kraits
krauts10418513krauts
kvas117015943kva__s
kvases13467103kvases
kvass12507273kva_ss
kwacha1832983kwacha
kwachas1943063kwachas
kyacks14416063kyacks
kyaks11459163kya_ks
kyars124813963kya_rs
kyats125012443kya_ts
lakhs125210343_lakhs
lapis76223153_lapis
laps66848873_lap_s
laths86022403_laths
leaps75522933leap_s
lymphs1635053lymphs
machs125722563_machs
maps86141053_map_s
maths105624023_maths
morphs13149433morphs
napas75924353_napas
napes74828463_napes
naps66238583_nap_s
neaps75618323neap_s
nymphs1633503nymphs
oaths86117313_oaths
odahs95610083oda_hs
okapis1235393okapis
oomphs1344723oomphs
opahs105411983opa_hs
ouphs104311273_ouphs
papas94927493_papas
paps86443453_pap_s
paraphs1439313paraphs
paths105521383_paths
phages125213513phages
pharos11312063pharos
phases114618403phases
phasis114614923phasis
phpht1538063ph_pht
qophs19507813_qophs
ralphs1135373ralphs
rapes75740723_rapes
raphe104916423_raphe
raphes115117453_raphes
raphis114014323_raphis
raps66247733_rap_s
reaps75626193reap_s
rhachis1555693rhachis
rhaphae1543193rhaphae
saps65346373_sap_s
scapes105122263scapes
scarphs14437413scarphs
seraphs12408093seraphs
shacks154817563shacks
shades105924533shades
shads95124483sha_ds
shafts125411443shafts
shags95123863sha_gs
shah105627783sha_h_
shakes135024593shakes
shakos134912193shakos
shales94731253shales
shamas113717943shamas
shames114726223shames
shamos114216983shamos
shams105829413sha_ms
shamus114112813shamus
shanks135315583shanks
shape105125113shap_e
shaped125020103shaped
shapen114414653shapen
shaper114119933shaper
shapers124016893shapers
shards104319173shards
shares95236413shares
sharks135019723sharks
sharns95516983sharns
sharps115516083sharps
shaughs14245283shaughs
shauls94913113shauls
shaves125224933shaves
shawls125411973shawls
shawms14579563shawms
shaws116226263sha_ws
shays116021433sha_ys
sheaths1358753sheaths
ships105123773ship_s
shnapps1463343shnapps
shnaps1148083shnap_s
shops104222903shop_s
slaps76025713slap_s
snaps74719563snap_s
snaths95112913snaths
soaps75120713soap_s
sophs104916023_sophs
stapes85028733stapes
staph104314653staph_
swaps104819203swap_s
swaths125312643swaths
sylphs1435543sylphs
syphs13519453_syphs
tachs105820933_tachs
tapas74627713_tapas
tapes75838603_tapes
tapis75028863_tapis
taps66050673_tap_s
thacks154311923thacks
thanes94918983thanes
thanks134313133thanks
tharms115712243tharms
thaws116515463tha_ws
thighs1346633thighs
tophs105220053_tophs
trapes85024463trapes
traps75727483trap_s
waps96642083_wap_s
whacks184610483whacks
whales124716943whales
whams135515643wha_ms
whangs13439723whangs
whap125119643whap__
wharfs1546373wharfs
whats117718993wha_ts
whaups14405753whaups
whips134917083whip_s
whops135013933whop_s
whups134210003whup_s
wraps105617153wrap_s
wraths123810083wraths
yaps95933523_yap_s
yeahs115214553yea_hs
zaps156826893_zap_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 Filter1786911127160.390458182.1
2DLD Change Limit1127163906.58017130.1
3Display Results3903900.1103545.5
 (SQL Overall)1786913907.08025238.8
 
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.