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 “apothem” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
apothem144464(None) 
apothegm1652121apothegm
apothems1544221apothems
another10289152another
anthem113410342a_nthem
apothece1543772apothece
apothegms1742092apothegms
pother113818852_pother
abohm1247973abo_h_m
aether94213673a_ether
ahem97225363a___hem
airthed11328303airthed
althea938193a_lthea
anathema1344583anathema
anthems12309423a_nthems
anther93715063a_nther
apache134210773apache_
apaches143411833apaches
apathies1339003apathies
apathy1437033apath_y
aphtha1444483aphth_a
aphthae1544703aphthae
apogee9312553apo_gee
apogees1037103apogees
apophthegm236863apophthegm
apostle937853apostle_
apostles1037753apostles
apotheces1644013apotheces
apothecia1644013apothecia
apothecium1952573apothecium
apter76120203ap_t_er
azote144416343azot_e_
azoted16388593azot_ed
azotes154312223azot_es
azoth17389903azoth__
azoths18366203azoth_s
bother115218063_bother
brothel12318193brothel
brother123311333brother
capote10315733capot_e_
capotes11314643capot_es
clothe114712993clothe_
clothed134010283clothed
clothes124513813clothes
epithet12312463epithet
frothed14288783frothed
frother133110153frother
hypothec2144293hypothec
isotherm1344283isotherm
mother113718643_mother
nother93815963_nother
other84219103__other
panther12611443panther
pithed124615613_pithed
poem86225773_po__em
poohed123912523_poohed
posher115018163_posher
poteen83514263_poteen
pothead133810393_pothead
potheen12257893_potheen
potherb14358683_potherb
pothers123818623_pothers
pothos114214693_pothos
potmen102713093_potmen
potted94624013_potted
potter83926983_potter
potzer174411213_potzer
sapote8314363sapot_e_
sapotes9313943sapot_es
smother123510213smother
soothe94214853soothe_
soothed113712743soothed
soother104215043soother
soothes103917113soothes
spathe115115693spathe_
spathed134013183spathed
spathes125116533spathes
spotted103713143spotted
spotter94514883spotter
them97427043___them
toothed113310243toothed
totem74819373_tot_em
tother94117143_tother
trothed114010973trothed

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.1531167915.0
2DLD Change Limit134027846.48620664.0
3Display Results84840.0302800.0
 (SQL Overall)178691846.66926794.3
 
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.