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

132 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
thatching183514(None) 
hatching173312211_hatching
thatchings1942481thatchings
batching163712092_batching
catching163712772_catching
dethatching2142242dethatching
hatchings18225672_hatchings
hatchling1844952_hatchling
hitching173310522_hitching
hotching17309312_hotching
hutching17318642_hutching
latching143712022_latching
matching163512392_matching
patching163212752_patching
snatching1536362snatching
teaching143612602tea_ching
thacking183110042tha_cking
thatchier1743982thatchier
twitching1834242twitching
watching173011172_watching
aching126521973__a_ching
arching136216693__arching
attaching1545433atta_ching
baching156017753_ba_ching
bathing134816243_bat_hing
beaching164114143bea_ching
bitching163610623_bitching
blanching17297093blanching
blotching1734963blotching
botching16359703_botching
branching17289263branching
caching156317503_ca_ching
chancing162810283chanc_ing
chatting142810143chat_ting
churching2055083churching
clutching17154823clutching
coaching164011963coa_ching
cranching17278733cranching
crutching17216073crutching
detaching1637263detaching
ditching15349943_ditching
etching134511843__etching
fetching17298413_fetching
fletching18256143fletching
flitching18265343flitching
grutching16224373grutching
hacking173720613_ha_cking
hashing145020163_ha_shing
hatcheling1943693_hatcheling
hatchlings1943033_hatchlings
hating104929713_hat__ing
hatting113920233_hat_ting
hunching17309113_hunching
inarching1546343inarching
itching134011683__itching
katchina1745333_katchina
kvetching2242903kvetching
lathing114315693_lat_hing
leaching143012833lea_ching
letching143810263_letching
loathing1247673loat_hing
marching164312193_marching
notching14288583_notching
outcatching1943113outcatching
outmatching1943333outmatching
outwatching2043013outwatching
parching164313053_parching
peaching163613643pea_ching
pitching163411113_pitching
poaching163510833poa_ching
potlatching1952113potlatching
ranching141712043_ranching
reaching143317203rea_ching
rematching1844913rematching
repatching1844993repatching
retching143412173_retching
roaching143210433roa_ching
scathing14269703scat_hing
scotching1735653scotching
scratching1844533scratching
scutching1735223scutching
searching1538343searching
shacking184014083sha_cking
sheathing1636873sheat_hing
sketching1935083sketching
smutching1734853smutching
snitching1535913snitching
stanching1538083stanching
starching1538593starching
stitching1547103stitching
stretching1645813stretching
swathing15248713swat_hing
switching1835703switching
tacking144421483t_a_cking
talcing103111633t_alc_ing
talcking1567083t_alcking
tatting84019523t_at_ting
tattling9259473t_attling
teachings15296553tea_chings
teething1237163teet_hing
thanking16409523tha_nking
thatch1435613thatch___
thatched1735433thatch_ed
thatcher1635663thatch_er
thatchers1744583thatchers
thatches1637513thatch_es
thatchiest1844163thatchiest
thatchy1833303thatch__y
thawing14378683tha__wing
thrashing1635683thrashing
threshing1645663threshing
thwacking2253193thwacking
tithing113513893t_it_hing
toothing12278863toot_hing
torching142510083t_orching
touching143211343t_ouching
trachling1537823tra_chling
tracing103720153tra_c_ing
tracking153715463tra_cking
trancing112812023tranc_ing
trashing122613223tra_shing
trauchling1643473trauchling
trenching15227653trenching
trithing122811773trit_hing
trothing122410843trot_hing
twattling1332693twattling
tything14316573t_yt_hing
unhitching1942843unhitching
unlatching1643153unlatching
whacking21377483wha_cking
witching173410633_witching
wrathing15248923wrat_hing

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.423422437.4
2DLD Change Limit1486411326.43623095.2
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.90525878.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.