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 “trowing” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
trowing11341370(None) 
crowing133814761crowing
growing123512471growing
rowing103623301_rowing
strowing122310561strowing
throwing1536721throwing
towing103823191t_owing
troking123514101troking
arrowing1237942arrowing
avowing1466602avowing
blowing133813052blowing
bowing124723062_bowing
brewing133411152brewing
broking143514822broking
browning14299642browning
browsing14319352browsing
chowing164412772chowing
cowing124526322_cowing
crewing133212632crewing
crowding15247932crowding
crowning143510032crowning
dowing114221512_dowing
drawing123812052drawing
droning93013722droning
droving12379682droving
drowning13298362drowning
drowsing13287772drowsing
eroding9314272eroding
flowing143411762flowing
frowning15307832frowning
glowing123211792glowing
groping113313102groping
growling1348162growling
ironing82414012ironing
jowing174216042_jowing
knowing15287682knowing
lowing104623272_lowing
meowing1368592meowing
mowing124119092_mowing
outrowing1339032outrowing
owing96222722__owing
plowing133111722plowing
probing123314442probing
prosing103319382prosing
proving134214072proving
prowling1449992prowling
robing93618002_robing
roping94023022_roping
rosing73925592_rosing
roving103618742_roving
rowings113710362_rowings
scowing133812092scowing
showing143814662showing
slowing112814742slowing
snowing113913452snowing
sowing104222912_sowing
stowing113315132stowing
strawing122411622strawing
strewing12289852strewing
stroking132610942stroking
stroying122410592stroying
tawing104521552t_awing
tewing103914822t_ewing
thawing14378682thawing
tholing112812332tholing
thouing11258602thouing
thrawing1535962thrawing
throning1238862throning
toeing74418472t_oeing
toking114420722t_oking
toling73926122t_oling
toning74025792t_oning
tooling82918312tooling
tooting83019422tooting
toping94122992t_oping
toting74123792t_oting
toying105017302t_oying
tracing103720152tracing
trading93517972trading
trawling122710782trawling
treeing83414302treeing
tricing103417352tricing
trining82919212trining
troaking133310972troaking
trocking153612422trocking
trolling93212492trolling
tromping13319602tromping
trooping112710282trooping
tropin83316752tropin_
tropine93116652tropine
tropins93116312tropins
trothing122410842trothing
trotting92510912trotting
trouping11249502trouping
troweling1376362troweling
trucing103211842trucing
trueing83410182trueing
truing73913932tr_uing
trying104214072tr_ying
vowing133715272_vowing
wowing133915392_wowing
yowing133715542_yowing

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711022.92336835.8
3Display Results1021020.0303400.0
 (SQL Overall)1786911023.32953677.1
 
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.