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

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

91 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
hatchelling205262(None) 
hatcheling1943691hatche_ling
hatchling1844952hatch__ling
atheling1249203_at_he_ling
cancelling1547213canc_elling
catcalling1545123catc_alling
handselling1642823handselling
hanselling1445623ha_nselling
hatchelled1943013hatchell_ed
hatching173312213hatch___ing
hatchlings1943033hatch__lings
marcelling1545593marc_elling
parcelling1546173parc_elling
ratcheting1643783ratche_ting
athelings1345114_at_he_lings
barrelling1345454ba_rrelling
batching163712094batch___ing
bushelling1644064_bushelling
butchering1844504butche_ring
cacheting1737154ca_che_ting
canceling14310164canc_e_ling
cartwheeling2151014cartwheeling
catching163712774catch___ing
cathecting1844834cat_hecting
celling103921264___c_elling
chandelling1844454cha_ndelling
channelling1743994cha_nnelling
chilling143512184___chilling
excelling1935644_exc_elling
farewelling1842624farewelling
fathering161010094fat_he_ring
gathering1499464gat_he_ring
gavelling14286874ga__velling
hachuring1845124ha_ch_uring
hackling183310164ha_c__kling
handseling1544324handse_ling
hanseling1338064ha_nse_ling
harshening1744174harshe_ning
hatchel153510754hatche_l___
hatcheled1844224hatche_l_ed
hatchels16368674hatche_l__s
hatcheries1846524hatche_ries
hatchings18225674hatch___ings
helling114623224____helling
hirselling1444834h_irselling
hitchhiking2351374hitchhiking
hitching173310524hitch___ing
hostelling1446164h_ostelling
hotching17309314hotch___ing
houselling1445754h_ouselling
hovelling1636164h__ovelling
hutching17318644hutch___ing
labelling1238084la__belling
latching143712024latch___ing
latchstring17101964latchstring
lateralling1244634lateralling
lathering13912254lat_he_ring
laurelling1144464la_urelling
marshalling1753214marshalling
marvelling1645364ma_rvelling
matching163512394match___ing
matchmaking2552974matchmaking
nickelling1743644_nickelling
outcheating1744874outcheating
outduelling1342974outduelling
outselling1188024out_selling
outsmelling1453564outsmelling
outspelling1444144outspelling
outtelling11107134out_telling
outyelling14116144out_yelling
panelling1239074pa__nelling
parceling1438444parc_e_ling
patching163212754patch___ing
patrolling1345694pat_rolling
pitchpoling2151654pitchpoling
prechilling1943744prechilling
racheting1537794ra_che_ting
rappelling1544364ra_ppelling
ravelling13269244ra__velling
retelling102112494ret__elling
schilling15286394__schilling
shelling123515214___shelling
spancelling1643344spanc_elling
tasselling1145234ta_sselling
telling83321084__t__elling
thatching1835144thatch___ing
towelling1366254__towelling
unshelling1445594_unshelling
vetchling1843594vetch__ling
watching173011174watch___ing
watchmaking2652464watchmaking

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 Filter1786911488190.1731032896.0
2DLD Change Limit148819918.48317543.2
3Display Results91910.0461978.3
 (SQL Overall)178691918.70220534.5
 
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.