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

119 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
thrashing163568(None) 
thrashings1742781thrashings
threshing1645661threshing
trashing122613221t_rashing
crashing143512632_crashing
hashing145020162_h_ashing
phrasing1438012phras_ing
thralling13256832thralling
thrawing1535962thra_wing
thrusting1335012thrusting
abashing1466623_abashing
ashing107824093___ashing
bashing135422583__bashing
brassing112612303_brassing
brushing14359963_brushing
cashing135022553__cashing
chasing133715893ch_as_ing
cherishing1944833cherishing
clashing143812193_clashing
crushing143010053_crushing
dashing125917893__dashing
deashing134210953_deashing
encashing1536443encashing
erasing8317963_eras_ing
fashing144918793__fashing
flashing153711553_flashing
freshing152611023_freshing
gashing125119233__gashing
gnashing1336423_gnashing
graphing1538533_graphing
grasping12348833_grasping
grassing103311973_grassing
harassing1346983harassing
hasping134414903_h_asping
hasting114725193_h_asting
hushing144514473_h_ushing
inrushing1365503inrushing
kurbashing2042253kurbashing
lashing114422893__lashing
leashing123310313_leashing
mashing134422243__mashing
onrushing1364813onrushing
pashing135120513__pashing
perishing1539533perishing
phasing133211673ph_as_ing
phrasings1544333phras_ings
plashing143311063_plashing
quashing2137093_quashing
rasing74330833__ras_ing
rasping104316253__rasping
rehashing1647113rehashing
rewashing1676903rewashing
rushing113817703__rushing
sashing114621473__sashing
sheathing1636873sheathing
shushing15317743sh_ushing
slashing123713413_slashing
smashing143310243_smashing
splashing1535703splashing
squashing2234703squashing
stashing123511583_stashing
swashing15369743_swashing
tarnishing1445153tarnishing
tasking124616323t__asking
tasting84624213t__asting
teaching143612603t_eaching
teasing83918513t_eas_ing
thacking183110043th_acking
thanking16409523th_anking
thatching1835143thatching
thawing14378683th_a_wing
thirsting1335283thirsting
thrash12258363thrash___
thrashed1555363thrash_ed
thrasher1455743thrash_er
thrashers1565313thrashers
thrashes1487653thrash_es
threading14107593threading
threaping15106113threaping
threating131010053threating
threeping15104803threeping
thrilling13276693thrilling
thriving15246353thr_iving
throating1398403throating
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throwing1536723thr_owing
thrumming1742903thrumming
thwacking2253193thwacking
thwarting1632763thwarting
toasting93410583t_oasting
torching142510083tor_ching
trachling1537823t_rachling
tracing103720153t_ra_cing
tracking153715463t_racking
trading93517973t_ra_ding
traiking132511973t_raiking
trailing92916093t_railing
training93015863t_raining
tramming13279343t_ramming
tramping132711273t_ramping
trancing112812023t_rancing
trapping132911393t_rapping
trashier113210103t_rashier
trashily1437323t_rashily
trawling122710783t_rawling
trithing122811773t_rithing
trothing122410843t_rothing
trussing9268653t_russing
trusting93411653t_rusting
trysting12267053t_rysting
tushing114214013t__ushing
unlashing1336493unlashing
uprushing1544043uprushing
washing145119283__washing
whishing18287183wh_ishing
whooshing1943213whooshing
wrathing15248923_wrathing

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411197.47019898.4
3Display Results1191190.0601983.3
 (SQL Overall)1786911197.95322468.4
 
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.