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

213 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
armpit1081109(None) 
armpits1157131armpits
admit8319492adm_it
ambit94223712a_mbit
armet76739452arm_et
armlet84118192armlet
crampit1338862crampit
abrupt1039943abrup_t
acmic11312333acm_ic
acquit17610323acquit
adapt81218553adap_t
adept81219643adep_t
adipic1137263adipic
adit56443653a__dit
admits9411413adm_its
admix1557733adm_ix
admixt1637333admixt
adopt81219743adop_t
adroit7518793adroit
afrit8323173a_frit
airmail946213airmail
ait38093903a___it
albeit8314343albeit
alit46155693a__lit
almost81014433almost
amain74922913a_main
ambits103713413a_mbits
ament76036543a_ment
ami56646813a_m_i_
amia66836903a_m_ia
amid77036353a_m_id
amie66339853a_m_ie
amin66042253a_m_in
amir65129753a_m_ir
amis66445323a_m_is
amity10416093a_m_ity
amnia75918643a_mnia
amnic95516243a_mnic
amnio75218053a_mnio
amort75832203a_mort
amp77541023a_mp__
amped104820513a_mped
amping114317573a_mping
ample94720303a_mple
amply125012913a_mply
amps86230343a_mp_s
ampul91110853a_mpul
amrita8411133a_mrita
anopia83412393anopia
apt57352543a__p_t
arabic10312733arabic
aramid93315613aramid
archil11611573archil
arctic10313513arctic
ardent73022613ardent
areic73219393ar_eic
arenite71017713arenite
arepa75615563arep_a
arepas85515703arepas
argent74023663argent
argil65116883ar_gil
argot67728653ar_got
arhat8327093ar_hat
aria46245423ar__ia
arid57642713ar__id
aridity11510113aridity
aright103817663aright
aril45843023ar__il
arm58449623arm___
armada938783armada
armed86324433arm_ed
armer76924443arm_er
armers85520273armers
armets84918353armets
armful1167163armful
armies85123693armies
arming94719803arming
armlets94610063armlets
armlike1348553armlike
armoire938133armoire
armor75118053arm_or
armors85017813armors
armory114211473armory
armour84411853armour
armrest9310163armrest
arms66137493arm__s
armure8710133armure
army96624183arm__y
aroid65428343ar_oid
aroint6328153aroint
aroynt9312893aroynt
arpen74418043ar_pen
arpent84822093arpent
arrant6623253arrant
arrest63722633arrest
arris56824683ar_ris
arshin9312173arshin
arsis55722423ar_sis
art38679143ar___t
artist64125543artist
aspic95114733a_spic
aspis74618143a_spis
atopic103514143atopic
atropin9311583atropin
attrit6315753attrit
atypic13337653atypic
audit62527883a_udit
await85524493a_wait
barefit1249723barefit
barmaid1238203barmaid
barmie103816393barm_ie
brit66350153br__it
bruit76126723br_uit
campi116217783campi_
carpet104530093car_pet
carpi94319393car_pi_
comfit133112423comfit
commit124016703commit
compt116328223comp_t
crampits1436273crampits
credit9315193credit
crept95125893crep_t
crit65743713cr__it
crumpet133711063crumpet
crypt123715233cryp_t
dammit11311133dammit
demit84832303dem_it
dimwit1237953dimwit
dript86923873drip_t
droit65127123dr_oit
dropt86924433drop_t
emit65438423_em_it
erupt74220063erup_t
frit77044473fr__it
fruit85122223fr_uit
gambit114714213gambit
garment10315233garment
gript85126173grip_t
grit55247243gr__it
harmin113117393harm_in
harpin113614383har_pin
harpist12312363har_pist
hempie132410563hempie
hermit11519443herm_it
impi85415793_impi_
impis96213853_impis
karmic1438113karm_ic
kempt134318463kemp_t
krait94726773kr_ait
limit73126343lim_it
limpet103518633limpet
limpid11389753limpid
marmite112413993marm_ite
marmot10318743marm_ot
omit65337373_om_it
orbit73622063or_bit
orpin73415533or_pin
parapet11317643parapet
parfait12312053parfait
permit10321683perm_it
pipit95224873_pipit
pit56471923___pit
probit103218353probit
profit113016273profit
prompt12313013promp_t
prosit85124593prosit
pulpit10310933pulpit
rabbit102914563rabbit
ramet75743143ram_et
rami66034093ram_i_
ramie75027823ram_ie
ramjet15311543ramjet
ramp85934003ramp__
rampant11312173rampant
rampart11311993rampart
ramped114617903ramped
rampike1536603rampike
ramping123316873ramping
rampion11298583rampion
ramps96224633ramp_s
ramtil8311033ramtil
rapid86422033_rapid
rapist82520673_rapist
rapt67245313_rap_t
rarebit948423rarebit
recit75235103_recit
refit84230063_refit
relit55340683_relit
remit75737223_remit
repin75324703_repin
repot75132623_repot
resit54241043_resit
sandpit1049633sandpit
sarment9318763sarment
scrimpit1444183scrimpit
smit65138413_sm_it
spit65545083__spit
summit10311543summit
tempi94912203tempi_
tempt95124843temp_t
tomtit8413853tomtit
trait56940843tr_ait
trapt76433393trap_t
trepid9310083trepid
tropic103014193tropic
tropin83316753tropin
trumpet113810723trumpet
varment12313243varment
varmint12311683varmint
vomit102622573vom_it
warmest123113033warmest
wrapt105123183wrap_t
writ75537913wr__it

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.406440125.6
2DLD Change Limit1127162136.92016288.4
3Display Results2132130.220968.2
 (SQL Overall)1786912137.54623680.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.