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

167 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
armpits115713(None) 
armpit10811091armpit_
admits9411412adm_its
ambits103713412a_mbits
armets84918352arm_ets
armies85123692arm_ies
armlets94610062armlets
crampits1436272crampits
acquits1857293acquits
adapts9107813adap_ts
adepts9117103adep_ts
adits66523713a__dits
admit8319493adm_it_
adopts998083adop_ts
afrits9311903a_frits
airmails1045273airmails
aits46355533a___its
ambit94223713a_mbit_
aments85219803a_ments
amias75831473a_m_ias
amids85627513a_m_ids
amies76837693a_m_ies
amins75534323a_m_ins
amirs75924923a_m_irs
amis66445323a_m_i_s
amiss75823073a_m_iss
amity10416093a_m_ity
amnios84912523a_mnios
amping114317573a_mping
amps86230343a_mp__s
ampuls1098893a_mpuls
amrita8411133a_mrita
amritas939093a_mritas
anopias92412483anopias
aramids102810513aramids
archils12510533archils
arctics1138953arctics
arenite71017713arenite
arenites8917103arenites
arepas85515703arep_as
argents84014853argents
argils75213623ar_gils
argots74116033ar_gots
arhats9312973ar_hats
arias55438023ar__ias
aridity11510113aridity
arils58732203ar__ils
armadas1038173armadas
armers85520273arm_ers
armet76739453arm_et_
armfuls1275013armfuls
arming94719803arm_ing
armings103811503armings
armless9369943armless
armlet84118193armlet_
armlike1348553armlike
armoire938133armoire
armoires1057623armoires
armories10313653armories
armors85017813arm_ors
armours9389853armours
armrest9310163armrest
armrests1055383armrests
arms66137493arm___s
armures9510273armures
aroids75118223ar_oids
aroints7313133aroints
aroynts1036633aroynts
arpens84814823ar_pens
arpents93613083arpents
arrests73312683arrests
arris56824683ar_ri_s
arshins10312573arshins
arsis55722423ar_si_s
artist64125543ar_tist
artists74215593artists
arts49650263ar___ts
aspics104211563a_spics
aspis74618143a_spi_s
atopies92816433atopies
atropins10410493atropins
attrits7310613attrits
audits72814113a_udits
awaits96411953a_waits
barmaids1345943barmaids
brits76433083br__its
bruits85714453br_uits
carpets113915333car_pets
comfits14328743comfits
commits133812383commits
compts125216653comp_ts
crampit1338863crampit_
credits1039973credits
crits75527573cr__its
crumpets14335943crumpets
crypts13397743cryp_ts
demits94918073dem_its
dimwits1344513dimwits
droits74314313dr_oits
emits75421473_em_its
erupts8348903erup_ts
frits86129103fr__its
fruits94512493fr_uits
gambits12399723gambits
garments1139963garments
grits65529583gr__its
harmins123716723harm_ins
harpies123818313har_pies
harpins123615703har_pins
harpist12312353har_pist
harpists1338103har_pists
hermits12312143herm_its
impis96213853_impi_s
kraits104912203kr_aits
limits82514143lim_its
limpets11329783limpets
marmite112413993marm_ite
marmites122212793marm_ites
marmots11311513marm_ots
omits75018263_om_its
orbits84211443or_bits
orpins83614163or_pins
parapets1239763parapets
parfaits1346913parfaits
permits11314003perm_its
pipits104713063_pipits
pits66348743___pits
probits112712573probits
profits122911243profits
prompts1337473promp_ts
pulpits1137243pulpits
rabbits11299863rabbits
ramets83517393ram_ets
ramies84630463ram_ies
ramjets1635163ramjets
ramparts1245583ramparts
rampike1536603rampike
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
rampions12248023rampions
ramps96224633ramp__s
ramtils938413ramtils
rapids94913893_rapids
rapist82520673_rapist
rapists92510753_rapists
rarebits1045223rarebits
recits83621353_recits
refits94017653_refits
remits85622943_remits
repins84924313_repins
repots85621003_repots
resits64725563_resits
sandpits1146843sandpits
sarments10311963sarments
spits74429553__spits
summits1137983summits
tempts10439453temp_ts
tomtits937243tomtits
traits65121983tr_aits
tropics113610653tropics
tropins93116303tropins
trumpets12315573trumpets
varments1339063varments
varmints1335643varmints
vomits112610923vom_its
writs86624383wr__its

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271677.03319056.9
3Display Results1671670.0463630.4
 (SQL Overall)1786911677.21924752.9
 
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.