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

120 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
choring13361766(None) 
charing133721321charing
choiring14279791choiring
choking173911941choking
chording15410151chording
chorine123218361chorine
chowing164412771chowing
coring94433961c_oring
shoring112820071shoring
whoring142910291whoring
adoring9412522adoring
anchoring1548322anchoring
boring94724872_boring
caring95137992c_aring
cering94522532c_ering
chafing163911492chafing
chairing143110772chairing
charging152910772charging
charking183512612charking
charming163012032charming
charring142913162charring
charting142614192charting
chasing133715892chasing
chawing164813032chawing
cheering143612702cheering
chefing16359032chefing
chewing163911142chewing
chiding143911592chiding
chiming153311832chiming
chining133316842chining
chirking18339382chirking
chirming16318642chirming
chirping16278862chirping
chirring142610172chirring
chlorin123113002chlorin_
chlorine133013302chlorine
chlorins132612882chlorins
chocking204011012chocking
choline122915382choline
chomping18339882chomping
choosing142010132choosing
chopin132712192chopin_
chopine143512262chopine
chopins142312242chopins
chopping183710262chopping
chorial124214142chorial
choric133515902chori_c
chorines132917252chorines
chorion12311772chorion
chorions13310662chorions
chorizo2136322chorizo
chortling1535562chortling
chorusing15246112chorusing
chousing14259422chousing
chowsing17217342chowsing
chroming163410722chroming
churning14237172churning
churring14298652churring
chuting132910732chuting
cloning103215472cloning
closing103114842closing
clouring112811272clouring
cloying133511752cloying
coding104024792c_oding
cohering142413842cohering
coking134523882c_oking
coloring11414842coloring
coming114225452c_oming
coning94331832c_oning
cooing94024922c_ooing
cooking143818972cooking
cooling103422572cooling
cooping123918932cooping
coping113927662c_oping
cording113620822c_ording
corking143018822c_orking
corning103720132c_orning
coting94629252c_oting
coving124321522c_oving
cowing124526322c_owing
coxing164218862c_oxing
coying124021482c_oying
crowing133814762crowing
curing94824782c_uring
curring103616842curring
echoing1358612echo_ing
goring84119572_goring
haring104233002_haring
hiring104421602_hiring
hoeing104117022_hoeing
hoking144419512_hoking
holing104025072_holing
homing123718382_homing
honing103421502_honing
hoping123719742_hoping
hording123517052_hording
horning113015002_horning
horsing113215582_horsing
hosing103421102_hosing
mooring102514442mooring
ochering14219392ochering
ochring13156672och_ring
phoning13312052phoning
poring94227272_poring
scoring103117212scoring
sharing113723242sharing
shoeing113211882shoeing
shooing112112912shooing
shorings12269482shorings
shorting122514802shorting
shoving142910642shoving
showing143814662showing
showring1548322showring
snoring83917202snoring
soring74731882_soring
sporing104319412sporing
storing83921122storing
tholing112812332tholing
thorning1237512thorning
thouing11258602thouing

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 Limit1076711202.93636672.7
3Display Results1201200.0304000.0
 (SQL Overall)1786911203.34253468.3
 
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.