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

111 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
crowing13381476(None) 
chowing164412771chowing
cowing124526321c_owing
crewing133212631crewing
crowding15247931crowding
crowning143510031crowning
growing123512471growing
rowing103623301_rowing
trowing113413701trowing
arrowing1237942arrowing
avowing1466602avowing
blowing133813052blowing
bowing124723062_bowing
brewing133411152brewing
broking143514822broking
browning14299642browning
browsing14319352browsing
caroling113317002caroling
caroming133312962caroming
cawing124322612c_awing
chawing164813032chawing
chewing163911142chewing
choking173911942choking
choring133617662choring
chowsing17217342chowsing
chroming163410722chroming
clawing133812672clawing
clewing13359582clewing
cloning103215472cloning
closing103114842closing
clowning14307252clowning
cloying133511752cloying
coding104024792c_oding
coking134523882c_oking
coming114225452c_oming
coning94331822c_oning
cooing94024922c_ooing
cooking143818972cooking
cooling103422572cooling
cooping123918932cooping
coping113927662c_oping
cording113620822cording
coring94433962c_oring
corking143018822corking
corning103720122corning
coting94629252c_oting
coving124321522c_oving
cowling134017422c_owling
coxing164218862c_oxing
coying124021482c_oying
craning103620302craning
craping124018712craping
crating103725202crating
craving134015732craving
crawling143110512crawling
crazing193914582crazing
creping122913652creping
croaking153712162croaking
crocine11314152crocine
crocking174313442crocking
crooking153611342crooking
crooning113112112crooning
cropping153210882cropping
crossing112612682crossing
crown105620082crow_n_
crowns115615112crow_ns
crying123612282cr_ying
dowing114221512_dowing
drawing123812052drawing
droning93013722droning
droving12379682droving
drowning13298362drowning
drowsing13287772drowsing
eroding9314272eroding
escrowing1544812escrowing
flowing143411762flowing
frowning15307832frowning
glowing123211792glowing
groping113313102groping
growling1348162growling
ironing82414012ironing
jowing174216042_jowing
knowing15287682knowing
lowing104623272_lowing
meowing1368592meowing
mowing124119092_mowing
owing96222722__owing
plowing133111722plowing
probing123314442probing
prosing103319382prosing
proving134214072proving
prowling1449992prowling
robing93618002_robing
roping94023022_roping
rosing73925592_rosing
roving103618742_roving
rowings113710362_rowings
scowing133812092scowing
screwing14288232screwing
showing143814662showing
slowing112814742slowing
snowing113913452snowing
sowing104222912_sowing
stowing113315132stowing
strowing122310562strowing
throwing1536722throwing
towing103823192_towing
troking123514102troking
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.390458182.1
2DLD Change Limit1076711113.12334476.8
3Display Results1111110.0462413.0
 (SQL Overall)1786911113.55950208.2
 
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.