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

166 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
shielding143455(None) 
shieling123512401shiel_ing
bielding12237472_bielding
childing15288502chi_lding
fielding13206862_fielding
hilding123713532_hi_lding
shedding14278112sh_edding
shelling123515212sh_elling
shelving15278172sh_elving
shending132511252sh_ending
shielings13237122shiel_ings
shilling123315382shi_lling
shredding1544512shredding
spieling113212522spiel_ing
wielding13286862_wielding
yielding13205032_yielding
building1237503bui_lding
chiding143911593chi__ding
chilling143512183chi_lling
chiseling1536403chisel_ing
chiselling1644683chiselling
chitling142910663chitl_ing
friending1495553friending
gelding103911793__gelding
gilding103813003_gi_lding
heading122919113_h_eading
heeding123515063_h_eeding
heeling113618513_heel_ing
heiling113616363_heil_ing
helling114623223_h_elling
helming133712003_h_elming
helping133512223_h_elping
helving144011133_h_elving
herding122915123_h_erding
hiding114319333_hi__ding
hieing104216623_hie__ing
hildings13347503_hi_ldings
hilling113821773_hi_lling
hilloing12158303_hilloing
hilting113316893_hi_lting
hireling121210993_hirel_ing
holding123514283_h_olding
melding113414273__melding
milding113615453_mi_lding
misfielding1842723misfielding
rewelding1436913rewelding
sailing83927373sai_l_ing
scalding12339393s_calding
scending122610583s_cending
schilling15286393schi_lling
scolding12278913s_colding
screeding1336323screeding
seceding12288563sece_ding
seeding93719483s__eeding
seedling102610953s_eedling
seeling83522003s_eel_ing
selfing112911623s__elfing
selling83225833s__elling
sending94221373s__ending
shading123115563sh__ading
shauling1249393shaul_ing
shaveling1646843shavel_ing
shawling1558223shawl_ing
sheafing15329483sh_eafing
shealing123415463sh_ealing
shearing123915903sh_earing
sheaving154110253sh_eaving
sheening123010803sh_eening
sheering123715103sh_eering
sheeting122712833sh_eeting
shelvings16283823sh_elvings
shewing143812193sh_e_wing
shield106212973shield___
shielded1334393shield_ed
shielder1235183shield_er
shielders1334763shielders
shields11538043shield__s
shifting152910383shi_fting
shilingi1233843shi_l_ingi
shillings13348093shi_llings
shimming16278253shi_mming
shimmying2042533shimmying
shindig12244243shi_ndi_g
shingling14136973shingling
shining113816523shi__ning
shinning123211023shi_nning
shinnying16193723shinnying
shipping163611253shi_pping
shirking163210473shi_rking
shirring122910443shi_rring
shirting123213613shi_rting
shitting123212663shi_tting
shivering1637333shivering
shlepping1733393shlepping
shoaling123111753shoal_ing
shoeing113211883shoe__ing
shooling123012563shool_ing
shoveling1635553shovel_ing
shovelling1744063shovelling
shrewing15228093shre_wing
shrieking1734583shrie_king
shrieving1633973shrie_ving
shrilling13307693shrilling
shriveling1743253shrivel_ing
shrivelling1842213shrivelling
shrouding1434753shrouding
sibling10814423s_ibl_ing
sideling101012183sidel_ing
siding83822133s_i__ding
sidling9915423s_idl_ing
sieging92613203s_ie_ging
sieving112311233s_ie_ving
silking123715593s_i_lking
siloing83215503s_i_loing
silting83320483s_i_lting
skelping1535973s_kelping
skidding1535463ski_dding
skilling132911333ski_lling
skirling13249063skirl_ing
sledding11248503s_ledding
sliding93114553sli__ding
smelling113712723s_melling
smelting11339713s_melting
smiling103915443smi_l_ing
snedding11246953s_nedding
snelling93913563s_nelling
sniveling1336033snivel_ing
snivelling1444293snivelling
soiling83422323soi_l_ing
speeding122810933s_peeding
speeling112713123speel_ing
speiling113612973speil_ing
spelling113315233s_pelling
spending122712433s_pending
spiering112713353spie_ring
spiling102919703spi_l_ing
spilling113113943spi_lling
spindling13136273spindling
spreading1339653spreading
steading103613593s_teading
steeling93615143steel_ing
stifling122110913stifl_ing
stilling93415323sti_lling
stilting93312403sti_lting
sueding92613753s_ue_ding
suiciding1345453suiciding
swelling123212753s_welling
swilling123511933swi_lling
swindling14135833swindling
swirling12249143swirl_ing
swiveling1634573swivel_ing
swivelling1743413swivelling
thieving1535143thie_ving
thirling12248583thirl_ing
threading14107593threading
unyielding1542473unyielding
welding123213253__welding
wheedling1733073wheedling
wheeling15318593wheel_ing
whelming17304923wh_elming
whelping17245333wh_elping
whidding1734573whi_dding
whiling143511743whi_l_ing
whingding1833203whingding
whirling15237163whirl_ing
wilding123814293_wi_lding

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411666.31323545.2
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.79626293.6
 
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.