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

145 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
thrusting133501(None) 
trusting93411651t_rusting
crusting113612792_crusting
rusting83821262__rusting
thirsting1335282thirsting
thrashing1635682thrashing
threating131010052threating
threshing1645662threshing
throating1398402throating
thrumming1742902thrumming
trussing9268652t_russing
trysting12267052t_rysting
upthrusting1751402upthrusting
adjusting1843833adjusting
arresting1038633arresting
becrusting1544603becrusting
bruiting11259973_bruiting
brushing14359963_brushing
bruting102612993_bru_ting
bursting1138703bur_sting
busting104221793__busting
chaunting1555413chaunting
chorusing15246113chorus_ing
chorussing16193323chorussing
chousing14259423chous_ing
chuting132910733ch_u_ting
cresting114017043_cresting
crushing143010053_crushing
degusting1236163degusting
dusting93618993__dusting
encrusting13125293encrusting
entrusting11126183entrusting
eructing112110173_eructing
erupting11218443_erupting
exhausting2143153exhausting
foresting13311363foresting
frosting12311183_frosting
fruiting12229063_fruiting
ghosting1336463gh_osting
grunting10269583_grunting
gusting93917163__gusting
hasting114725193_h_asting
haunting123510053_haunting
heisting123411043_heisting
histing113720373_h_isting
hoisting123610903_hoisting
hosting114318383_h_osting
housing113316523_hous_ing
hunting114317123_h_unting
hurting113914033_h_urting
hushing144514473_h_ushing
husking154312053_h_usking
hustings12378683_h_ustings
hustling12228793_h_ustling
hutting113016033_h_utting
incrusting13126473incrusting
inrushing1365503inrushing
intrusting11128173intrusting
irrupting1243553irrupting
jousting16309353_jousting
justing153615163__justing
lusting83619323__lusting
musting103221073__musting
onrushing1364813onrushing
ousting84021353__ousting
outthrusting1651713outthrusting
perusing11811063perus_ing
phrasing1438013phras_ing
resting85031183__resting
rousting93913273_rousting
rushing113817703__rushing
rustling9249983__rustling
rutting82718043__rutting
shouting122711793shou_ting
shrugging1533703shrugging
shunting123610433sh_unting
shushing15317743sh_ushing
shuting113212053sh_u_ting
shutting12309693sh_utting
strunting1037873strunting
strutting1037003strutting
targeting1137303targeting
tarting84222653tar__ting
tasting84624213t__asting
taunting93510933t_aunting
tauting83316383t_au_ting
testing86021053t__esting
thouing11258603thou__ing
thralling13256833thralling
thrashings1742783thrashings
thrawing1535963thr_awing
threading14107593threading
threaping15106113threaping
threeping15104803threeping
thrilling13276693thrilling
thriving15246353thr_iving
throbbing1743533throbbing
thronging1435073thronging
throning1238863thr_oning
throttling1442793throttling
throwing1536723thr_owing
thrust91911893thrust___
thrusted1265223thrust_ed
thruster1135793thrust_er
thrusters1245333thrusters
thrustful1552273thrustful
thrustor1144123thrust_or
thrustors1244303thrustors
thrusts10226523thrust__s
thudding1433983th_udding
thumbing16245513th_umbing
thumping16296713th_umping
thunking16196953th_unking
thwarting1632763thwarting
toasting93410583t_oasting
tousing82916993t_ous_ing
tousling938793t_ousling
touting84118453t_ou_ting
trashing122613223t_rashing
treating92519613t_reating
trotting92510913t_rotting
truanting1035603t_ruanting
trucing103211843t_ru_cing
trucking153310163t_rucking
trudging11266443t_rudging
trueing83410183t_ru_eing
truing73913933t_ru__ing
trumping13308733t_rumping
trussings10224033t_russings
trusteeing1142893t_rusteeing
trustier8268683t_rustier
trusties82712853t_rusties
trustily11257103t_rustily
trustingly1444373t_rustingly
tufting11289873t__ufting
tushing114214013t__ushing
tusking124212063t__usking
tutting83515913t__utting
twisting12427813t_wisting
unresting10311133unresting
untrusting1186003untrusting
uprushing1544043uprushing
whisting15329543wh_isting
worsting1267683wor_sting
wresting123811833_wresting

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.406440125.6
2DLD Change Limit1486411456.82621775.7
3Display Results1451450.0801812.5
 (SQL Overall)1786911457.31224438.0
 
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.