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

462 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
hatpin11261060(None) 
harpin113614381harpin
hatpins123410641hatpins
catkin123512372catkin
catlin83819072catlin
haemin113412662haemin
hairpin1245412hairpin
happen134812192happen
happing153817232happing
hapten115312982hapten
haptic13511882haptic
harmin113117392harmin
harping134118382harping
harpins123615702harpins
hasping134414902hasping
hating104929712hat_ing
hatting113920232hatting
headpin1336002headpin
hoatzin1943912hoatzin
lapin75222922la_pin
lattin64316222lattin
matin75132852mat_in
mattin84416632mattin
patin76832852pat_in
ratlin64116522ratlin
satin55935212sat_in
actin74922553_actin
again65218113_again
agin56132713_a_gin
ain37579093_a__in
akin86328033_a_kin
algin65718763_algin
aloin55227413_aloin
alpine84417373_alpine
amain74922883_amain
amin66042243_a_min
amping114317563_amping
apian75018333_a_pian
aping87327233_a_ping
arpen74418043_arpen
aspen75216093_aspen
aspic95114733_aspic
aspis74618143_aspis
atman75520143_atman
atopic103514143_atopic
atria56022333_atria
atrip75315743_atrip
atropin9311583_atropin
attain6311753attain
attic75618353_attic
atwain937813_atwain
atypic13337653_atypic
auxin121411913_auxin
ayin76331743_a_yin
basin75026923ba_sin
bathing134816243bathing
batik11614733bat_ik
bating95132253bat_ing
batman105214063batman
batmen104414303batmen
baton75822423bat_on
batten85217123batten
battik1238093battik
batting104422273batting
batwing13509813batwing
cabin94820933ca_bin
cain65643913ca__in
calkin123515493calkin
calpain11310413calpain
campi116217783campi_
camping143118973camping
campion133011413campion
capiz18514563ca_piz
caplin103216303caplin
capon95221873ca_pon
capping143819673capping
captain112111053captain
captan101613343captan
caption113513693caption
carlin84421823carlin
carpi94319393carpi_
carping123521083carping
casein83216453casein
cation83925503cation
catkins133012563catkins
catling104819793catling
catlins93818843catlins
catmint11314463catmint
catnip1097963catnip
cattie85221013cattie
catting103922643catting
chagrin1337883chagrin
chain105723673cha__in
champing183610933champing
champion17276353champion
chappie16298653chappie
chapping183710723chapping
chatting142810143chatting
chitin113114953chit_in
chitlin12269273chitlin
chopin132712183chopin
citrin82615403citrin
cutin75022773cut_in
dampen114310593dampen
damping133414003damping
dapping133714793dapping
dating85326483dat_ing
dauphin1344383dauphin
detain74617383detain
eaten55323053eat_en
eating75134403eat_ing
estrin6315923estrin
etamin81311853etamin
fadein1068843fadein
fagin9216573fa_gin
fain75840563fa__in
fating105328673fat_ing
fatling113815683fatling
fatten94314903fatten
fatting113818703fatting
gaijin1445973gaijin
gain56042163ga__in
gamin84422993ga_min
gaping105618923ga_ping
gapping134214783gapping
gaskin113610583gaskin
gasping113714363gasping
gastrin839823gastrin
gating84826953gat_ing
gawping14418463gawping
gittin72910553gittin
gratin74520583grat_in
habit103027013ha_bit
hackie154615623hackie
hacking173720613hacking
hading113922943ha_ding
hadji16839873hadji_
hadjis17439633hadjis
hadron102913753hadron
haeing104118923ha_eing
haemic133210083haemic
haemins122811393haemins
haen76229453ha__en
haffit1538533haffit
hafiz20611213ha_fiz
hafting144014173hafting
hagdon1188283hagdon
hagging133114683hagging
haggis11209513haggis
haik115526983ha__ik
hail74839063ha__il
hailing113820693hailing
haint85436323ha__int
hair76330143ha__ir
hairpins1365433hairpins
haji148520183ha_ji_
hajis156716273ha_jis
hajji14677453hajji_
hajjis15485883hajjis
hakim14311823ha_kim
halid94424973ha_lid
haling104229783ha_ling
haloid104317753haloid
haloing113814133haloing
halon86124863ha_lon
halting114419073halting
halving143511543halving
hamming153014093hamming
hamper134518653hamper
handing123518893handing
hanging123518703hanging
hankie133915713hankie
hanking154619103hanking
hanting114124483hanting
hap87360053ha_p__
hapax1739323ha_pax
haply135915063ha_ply
happed144820103happed
happens14359173happens
happier143312033happier
happily1745763happily
happy155813533ha_ppy
haps96443463ha_p_s
haptene123810933haptene
haptens124511343haptens
harden105718533harden
hardpan1336443hardpan
haring104233003ha_ring
harken135116343harken
harking154120943harking
harmine122816193harmine
harming133717933harming
harmins123716713harmins
harp96134283harp__
harped124418403harped
harper115018403harper
harpies123818313harpies
harpings14379773harpings
harpist12312353harpist
harpoon1238313harpoon
harps105926863harp_s
harpy136418203harp_y
hashing145020163hashing
hasp96627293hasp__
hasped125014443hasped
hasps105114643hasp_s
hasten95718563hasten
hasting114725193hasting
hat67289963hat___
hatband1346823hatband
hatbox1835133hatbox
hatch135719593hat_ch
hatching173312213hatching
hate78450173hat__e
hated95734023hat_ed
hater85034753hat_er
haters94930393haters
hates86742573hat_es
hatful12108743hatful
hath105933913hat__h
hatlike143311713hatlike
hatred104814333hatred
hats76858253hat__s
hatted104921513hatted
hatter94724873hatter
hauling113714433hauling
hausen9610383hausen
haven114718533ha_ven
having134220373ha_ving
hawing134322353ha_wing
hawkie163810093hawkie
hawking183711423hawking
haying134420613ha_ying
hazan173813613ha_zan
hazing194218553ha_zing
hazzan17236803hazzan
headpins1436103headpins
heaping133015853heaping
heathen133410893heathen
heating114024323heat_ing
helping133512223helping
hematein1387013hematein
hematin121516013hemat_in
hemin103620933h_emin
hempen1338963hempen
hempie132410563hempie
herein93717793herein
heroin94420593heroin
hetman112510603hetman
hin67559563h___in
hippie132811243hippie
hipping153915103hipping
hispid1238173hispid
hitman112710213hitman
hitmen11239193hitmen
hitting113017273hitting
hoactzin2241803hoactzin
hoatzins2043833hoatzins
hoddin11369933hoddin
holpen11299413holpen
hooping133615703hooping
hoping123719743h_oping
hopping154115273hopping
hotline10712343hotline
hotlink1476753hotlink
hottie92514363hottie
hotting113116513hotting
huipil1143773huipil
humping153213073humping
hutting113016033hutting
hyalin122210033hyalin
hyping15408483h_yping
iatric8312153iatric
isatin6412213isat_in
jalapin1645923jalapin
japan14411233ja_pan
japing165013573ja_ping
jasmin1538073jasmin
jauping17307193jauping
kain85334293ka__in
kamsin1238323kamsin
kaolin1039583kaolin
katcina1345153katcina
kation104315683kation
khamsin1643973khamsin
lain46146283la__in
lamping123116003lamping
lampion11278303lampion
lapins84520683la_pins
lapis76223153la_pis
lapping124117023lapping
lateen64014863lateen
laten54328343lat_en
lathi85417203lathi_
lathing114315693lathing
lathis95516173lathis
lati46438273lat_i_
latina65621143lat_ina
latino64120473lat_ino
latria62313583latria
latrine7715123latrine
latten65018203latten
lattins74115483lattins
layin84720333la_yin
leptin82512333leptin
lipin75518893_lipin
lupin75215843_lupin
lutein6311263lutein
magpie1139093magpie
main65345503ma__in
malkin122913143malkin
mapping143413993mapping
margin94016843margin
marlin84220903marlin
martin84122523martin
mating94832913mat_ing
matins84527783mat_ins
matrix1539833matrix
matron83918313matron
matting103620143matting
mattins93316143mattins
mavin105722953ma_vin
mayvin1436523mayvin
nandin7313033nandin
nankin1039673nankin
napkin1236903napkin
nappie104112263nappie
napping123514183napping
nation64322803nation
natron64116023natron
oaten55222403oat_en
obtain839183obtain
orpin73415533_orpin
outsin63617553outsin
pain65647243pa__in
palpi95414553palpi_
palping124112873palping
papain10313793papain
pappi84810893pappi_
paten74827343pat_en
patina86022193pat_ina
patine85328123pat_ine
patins87528783pat_ins
patio74426353pat_io
patois84319363patois
patron84018043patron
patten84418193patten
pattie84020963pattie
patting103722343patting
paulin8312983paulin
pavin105623203pa_vin
phatic133014403phat_ic
phytin14459003phyt_in
pin57066723___pin
pippin92810303pippin
potpie103412423potpie
rabbin103112293rabbin
rain46251733ra__in
raisin62716923raisin
ramping123316873ramping
rampion11298583rampion
rapid86422033ra_pid
rapine85023083ra_pine
raping94829853ra_ping
rapini84714683ra_pini
rappen103512713rappen
rapping123619103rapping
rappini11347573rappini
rasping104316253rasping
ratan53722663rat_an
ratfink1434943ratfink
ratine65131823rat_ine
rating74938703rat_ing
ratio55227583rat_io
ration64226013ration
ratline74517803ratline
ratlins73615583ratlins
ratoon64417373ratoon
rattan63613603rattan
ratten64217383ratten
ratting83822363ratting
ratton64116123ratton
ravin85624653ra_vin
rawin85521473ra_win
repin75324703_repin
retain64523283retain
rutin55421343rut_in
sabin74924943sa_bin
saimin8313663saimin
sain45551293sa__in
salpian938493salpian
salpid9510873salpid
salpinx1636093salpinx
saltpan935303saltpan
sampan102511893sampan
sapid84720933sa_pid
sapping123519313sapping
sarin55239253sa_rin
sasin54626573sa_sin
sateen63815013sateen
sati45539323sat_i_
sating74735453sat_ing
satins64930483sat_ins
satiny93817983sat_iny
satis55633673sat_is
savin84625083sa_vin
shapen114414653sha_pen
shaping133116183sha_ping
sharpen12389723sharpen
sharpie1238383sharpie
sharping143011373sharping
spin66231303__spin
stain55727933_stain
statin63921463statin
stein54620533_stein
tain45548073__tain
taipan82410663taipan
takin94921303ta_kin
tamein8313083tamein
tampan102512323tampan
tamping122815813tamping
tampion11298663tampion
tampon102911233tampon
tannin62613923tannin
taping94222393ta_ping
tapir75917063ta_pir
tapis75028863ta_pis
tapping123317133tapping
tarpan82814293tarpan
tarpon82812803tarpon
tattie64817513tattie
tatting84019523tatting
tawpie11339143tawpie
tenpin8310583tenpin
thin76732383__thin
tiepin839343tiepin
tin36362173__t_in
tropin83316753tropin
twin76023083__twin
tyin76424003__tyin
unpin72613243_unpin
vain75233003va__in
vamping152810233vamping
vapid115614283va_pid
vatic10316423vat_ic
vatting113614853vatting
wain75840193wa__in
wapping153514603wapping
warping133715183warping
whapping19317113whapping
whatsis1335243whatsis
whatsit1345813whatsit
within123611383within
xanthin1747043xanthin
yapon104613583ya_pon
yapping153412613yapping
yauping13357243yauping
yaupon11345493yaupon
yawping16357333yawping
zapping213211473zapping
zayin174512043za_yin
zeatin15412823zeat_in

Search took 6 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.1401276364.3
2DLD Change Limit1127164625.64019985.1
3Display Results4624620.1562961.5
 (SQL Overall)1786914625.93630102.9
 
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.