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

241 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
thieving153514(None) 
achieving1843302achieving
grieving1385892grieving
hieing104216622_hie_ing
hiving134115522_hi_ving
shieling123512402shieling
shrieving1633972shrieving
sieving112311232_sieving
theming133610472th_eming
thievish1743262thievish
thinking16289862thinking
thinning12319092thinning
thirling12248582thirling
thriving15246352thriving
tieing73518762t_ie_ing
tiering8315252t_iering
aliening91510893aliening
atheling1249203ath_eling
believing1535283believing
briefing1436943briefing
cheeking18349083cheeking
cheeping16329553cheeping
cheering143612703cheering
cheesing14349413cheesing
chefing16359033ch_efing
chevying2034053ch_evying
chewing163911143ch_ewing
chiding143911593chi_ding
childing15288503childing
chilling143512183chilling
chiming153311833chi_ming
chining133316843chi_ning
chinking183210893chinking
chinning14329653chinning
chipping18389793chipping
chirking18339383chirking
chirming16318643chirming
chirping16278863chirping
chirring142610173chirring
chiseling1536403chiseling
chitling142910663chitling
chivvying2441713chivvying
chivying2034973chivying
dieing84018653_die_ing
dieting93616833_dieting
diving113717953_di_ving
driving123910713dri_ving
gieing83614853_gie_ing
giving114313883_gi_ving
haeing104118923_hae_ing
halving143511543_halving
having134220373_h_aving
heaving144114763_heaving
heeding123515063_heeding
heeling113618513_heeling
heezing20349873_heezing
heiling113616363_heiling
heiring113312903_heiring
helving144011133_helving
hewing134514243_h_ewing
hexing174210513_h_exing
hiding114319333_hi_ding
hiking143617103_hi_king
hilding123713533_hilding
hilling113821773_hilling
hilting113316893_hilting
hinging123917123_hinging
hinting113919223_hinting
hipping153915103_hipping
hireling121210993_hireling
hiring104421603_hi_ring
hissing114213143_hissing
histing113720373_histing
hitting113017273_hitting
hoeing104117023_hoe_ing
jiving173711603_ji_ving
living104318323_li_ving
outthieving1842453outthieving
peeving135112243_peeving
piecing12410453_piecing
pieing93917653_pie_ing
quieting18228463quieting
reeving113717663_reeving
reiving113316843rei_ving
relieving1336693relieving
retrieving1445293retrieving
riving104521423_ri_ving
scrieving1534133scrieving
shaving143414333sh_aving
sheaving154110253sheaving
sheening123010803sheening
sheering123715103sheering
sheeting122712833sheeting
shelving15278173shelving
shewing143812193sh_ewing
shielding1434553shielding
shielings13237123shielings
shifting152910383shifting
shilling123315383shilling
shimming16278253shimming
shining113816523shi_ning
shinning123211023shinning
shipping163611253shipping
shirking163210473shirking
shirring122910443shirring
shirting123213613shirting
shitting123212663shitting
shivering1637333shivering
shoeing113211883shoe_ing
shoving142910643sh_oving
shrewing15228083shrewing
shrieking1734583shrieking
shriving15268453shriving
sieging92613203_sieging
skiving15298373ski_ving
sleeving12359283sleeving
spieling113212523spieling
spiering112713353spiering
steeving12359653steeving
striving122611393stri_ving
swiving14358953swi_ving
tabering112211423tabering
tailing82923103tai_ling
tainting93613583tainting
tapering112112503tapering
teeing73916973t__eeing
teeming103513093t_eeming
telexing1646613telexing
tewing103914823t__ewing
thacking183110043thacking
thanking16409523thanking
thawing14378683th_awing
theelin1038003theelin_
theelins1137643theelins
thein85919023th_e_in_
theine94814923th_e_ine
theins95015423th_e_ins
thiamin1236933thiamin_
thiamine1346773thiamine
thiamins1346633thiamins
thiazin1945483thiazin_
thiazine2045253thiazine
thiazins2045313thiazins
thickening2043283thickening
thieve1235963thiev__e
thieved1434973thiev_ed
thievery1742563thievery
thieves1346903thiev_es
thing96622983th___ing
thinkings17255053thinkings
thionin1048673thionin_
thionine1187923thionine
thionins1177923thionins
thirsting1335283thirsting
tholing112812333th_oling
thorning1237513thorning
thouing11258603th_ouing
thrawing1535963thrawing
threading14107593threading
threaping15106113threaping
threating131010053threating
threeping15104803threeping
threshing1645663threshing
thrilling13276693thrilling
throning1238863throning
throwing1536723throwing
thudding1433983thudding
thumbing16245513thumbing
thumping16296713thumping
thunking16196953thunking
ticcing12308633t_iccing
ticking143218753t_icking
tiding83520093t_i_ding
tidying1238513t_idying
tiepin839343t_iepin_
tiepins939463t_iepins
tiffing14339383t_iffing
tiling73426553t_i_ling
tilling83522783t_illing
tilting83417103t_ilting
timing93619303t_i_ming
tinging93619463t_inging
tining74927543t_i_ning
tinning83117283t_inning
tinting84620603t_inting
tipping122814973t_ipping
tiring74023093t_i_ring
tirling83315733t_irling
tithing113513893t_ithing
titling83715793t_itling
toeing74418473t_oe_ing
toileting1036263toileting
toiling83219023toi_ling
toiting83217093toi_ting
tokening1336463tokening
toweling122910373toweling
towering122610873towering
treeing83414303t_reeing
triaging102610543triaging
tricing103417353tri_cing
tricking152714513tricking
trifling122411503trifling
trigging11299583trigging
trilling92815963trilling
trimming13318653trimming
trining82919213tri_ning
tripling112712553tripling
tripping133210923tripping
trithing122811773trithing
trueing83410183true_ing
tweeting12267033tweeting
tweezing21384113tweezing
twigging14305673twigging
twilling12268673twilling
twinging13278423twinging
twining113211443twi_ning
twinning12367043twinning
twirling12246243twirling
twisting12427813twisting
twitting12307223twitting
viewing1437073_viewing
waiving14329633wai_ving
wheeling15318593wheeling
wheeping17337103wheeping
wheezing24315383wheezing
whidding1734573whidding
whiffing2134703whiffing
whiling143511743whi_ling
whinging16247743whinging
whining143311673whi_ning
whipping19328173whipping
whirling15237163whirling
whirring15286283whirring
whishing18287183whishing
whisking19286613whisking
whisting15329543whisting
whitening1635103whitening
whitewing1943853whitewing
whiting143311303whi_ting
whizzing2333383whizzing
wiving133316603_wi_ving

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622416.80021494.4
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.04925349.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.