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

150 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
tempering143873(None) 
tampering1438451tampering
attempering1652122attempering
bumpering1636592bumpering
compering163414162compering
hampering1738862hampering
pampering1638382pampering
peppering1337082peppering
retempering1644302retempering
simpering1449292simpering
tapering112112502t_apering
teddering12256302teddering
teetering10239892teetering
telfering1336252telfering
telphering1644202telphering
tempesting1544452tempesting
temping122710692temp__ing
tempting1357342temp_ting
tendering112210812tendering
tentering102313202tentering
tethering1339132tethering
timbering14117722timbering
beavering1538703beavering
bemiring13239603bem_iring
bettering122212753bettering
cambering16109873cambering
capering132414963_capering
centering122915143centering
comparing162410583comparing
compeering1747053compeering
competing163712463competing
coopering142611323coopering
coppering162810893coppering
cumbering16108203cumbering
dampening1535463dampening
deepening1335613deepening
demerging1436643dem_erging
demurring1335253demurring
deperming1537113de_perming
diapering1339033diapering
distempering1852943distempering
emceeing1343573_emceeing
emerging1237893_em_erging
empaling1338363_empaling
emperies12314563_emperies
empowering1863253_empowering
emptying1634243_emptying
entering91920053_entering
experting1938053_experting
expiring1836253_expiring
festering132413173festering
fettering132310513fettering
fevering152510083fe_vering
gendering12249753gendering
gettering112310033gettering
hammering1737633hammering
homering141512073hom_ering
impeding1436563_impeding
jeering153513043je__ering
kippering18205443kippering
lappering14258843lappering
lechering1538443lechering
leering83417643le__ering
lettering102112073lettering
levering122212503le_vering
limbering1488793limbering
lippering14217883lippering
loppering14237283loppering
lumbering14117933lumbering
mammering1337333mammering
metering112915633me_tering
neutering1038963neutering
numbering14107003numbering
papering132213313_papering
paupering1437273paupering
peering103520353pe__ering
peltering122011673peltering
pestering122315663pestering
petering112516813pe_tering
premiering1547243premiering
remeeting12311433remeeting
remerging1358323rem_erging
rendering112213183rendering
reopening1248823reopening
repapering1547043repapering
reperking1638703re_perking
respiring12159903respiring
respring111614063resp_ring
revering122918073re_vering
scampering1745323scampering
severing122013853se_vering
sewering122411093se_wering
simmering1467823simmering
stammering1544523stammering
stampeding1642983stampeding
steamering1345443steamering
steepening1344043steepening
steering93916793ste__ering
stoppering1544613stoppering
summering1458753summering
supering11317683_supering
tabering112211423t_abering
tamping122815813tamp__ing
tamponing1445993tamponing
tattering102212323tattering
tearing84021493te__aring
teaseling1036913teaseling
teazeling1934543teazeling
teeing73916973te__e_ing
teeming103513093te__eming
telexing1646613te_lexing
telneting1035593telneting
temerity1346903tem_erity
temper103914093temper___
tempera11329043temper__a
temperance1644813temperance
temperas12278233temper_as
temperate1348513temperate
tempered13248223temper_ed
temperer12227723temper_er
temperers13247023temperers
tempers113513013temper__s
temporise1347403temporise
temporising1644963temporising
temporize2246873temporize
temporizing2545963temporizing
tenuring938863te_nuring
tepefying1843233te_pefying
texturing1735223texturing
tiering8315253t__iering
tillering1037883tillering
timberings15124093timberings
tinkering1437703tinkering
tittering102310313tittering
tochering1537153tochering
tottering10229613tottering
towering122610873t_owering
trapesing1247263trapesing
trumpeting1543573trumpeting
tuckering1635693tuckering
tumping123114243tump__ing
umbering1399433_umbering
umpiring1336093_umpiring
veering113213683ve__ering
veneering1337663veneering
weltering13219493weltering
westering132112643westering
whimpering2143853whimpering
yammering1735193yammering
zippering23215203zippering

Search took 9 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 Filter1786911486410.453394461.4
2DLD Change Limit1486411508.01618543.0
3Display Results1501500.0761973.7
 (SQL Overall)1786911508.54520911.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.