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

107 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
chowing16441277(None) 
chawing164813031chawing
chewing163911141chewing
choking173911941choking
choring133617661choring
chowsing17217341chowsing
cowing124526321c_owing
crowing133814761crowing
showing143814661showing
avowing1466602avowing
blowing133813052blowing
bowing124723062_bowing
cawing124322612c_awing
chafing163911492chafing
charing133721322charing
chasing133715892chasing
chefing16359032chefing
chewink19315112chewink
chiding143911592chiding
chiming153311832chiming
chining133316842chining
chocking204011012chocking
choiring14279792choiring
choline122915382choline
chomping18339882chomping
choosing142010132choosing
chopin132712192chopin_
chopine143512262chopine
chopins142312242chopins
chopping183710262chopping
chording15410152chording
chorine123218362chorine
chousing14259422chousing
chroming163410722chroming
chuting132910732chuting
clawing133812672clawing
clewing13359582clewing
cloning103215472cloning
closing103114842closing
clowning14307252clowning
cloying133511752cloying
coding104024792c_oding
coking134523882c_oking
coming114225452c_oming
coning94331832c_oning
cooing94024922c_ooing
cooking143818972cooking
cooling103422572cooling
cooping123918932cooping
coping113927662c_oping
coring94433962c_oring
coting94629252c_oting
coving124321522c_oving
cowling134017422c_owling
coxing164218862c_oxing
coying124021482c_oying
crewing133212632crewing
crowding15247932crowding
crowning143510032crowning
dowing114221512_dowing
echoing1358612echo_ing
flowing143411762flowing
glowing123211792glowing
growing123512472growing
hawing134322352_hawing
hewing134514242_hewing
hoeing104117022_hoeing
hoking144419512_hoking
holing104025072_holing
homing123718382_homing
honing103421502_honing
hoping123719742_hoping
hosing103421102_hosing
howking183610312_howking
howling143413162_howling
jowing174216042_jowing
knowing15287682knowing
lowing104623272_lowing
meowing1368592meowing
mowing124119092_mowing
owing96222722__owing
phoning13312052phoning
plowing133111722plowing
rowing103623302_rowing
scowing133812092scowing
shawing143514882shawing
shewing143812192shewing
shoeing113211882shoeing
shooing112112912shooing
shoring112820072shoring
shoving142910642shoving
showings15246882showings
showring1548322showring
slowing112814742slowing
snowing113913452snowing
sowing104222912_sowing
stowing113315132stowing
thawing14378682thawing
tholing112812332tholing
thouing11258602thouing
throwing1536722throwing
towing103823192_towing
trowing113413702trowing
vowing133715272_vowing
whoring142910292whoring
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.373479064.3
2DLD Change Limit1076711073.34332207.9
3Display Results1071070.0333242.4
 (SQL Overall)1786911073.74947663.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.