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

109 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
choking17391194(None) 
chocking204011011chocking
choring133617661choring
chowing164412771chowing
coking134523881c_oking
cooking143818971cooking
hoking144419511_hoking
booking143618382booking
broking143514822broking
caking134624672c_aking
calking144617782calking
carking144322852carking
casking144317352casking
chafing163911492chafing
chalking183310062chalking
charing133721322charing
charking183512612charking
chasing133715892chasing
chawing164813032chawing
checking20379202checking
cheeking18349082cheeking
chefing16359032chefing
chewing163911142chewing
chiding143911592chiding
chiming153311832chiming
chining133316842chining
chinking183210892chinking
chirking18339382chirking
choiring14279792choiring
chokier1638042chokier
chokingly2243982chokingly
choline122915382choline
chomping18339882chomping
choosing142010132choosing
chopin132712192chopin_
chopine143512262chopine
chopins142312242chopins
chopping183710262chopping
chording15410152chording
chorine123218362chorine
chousing14259422chousing
chowsing17217342chowsing
chroming163410722chroming
chucking20379502chucking
chunking18328052chunking
chuting132910732chuting
cloaking15299712cloaking
clocking174312412clocking
cloning103215472cloning
clonking153810152clonking
closing103114842closing
cloying133511752cloying
cocking163619982cocking
coding104024792c_oding
coming114225452c_oming
coning94331822c_oning
conking143618452conking
cooing94024922c_ooing
cookings15358602cookings
cooling103422572cooling
cooping123918932cooping
coping113927662c_oping
coring94433962c_oring
corking143018822corking
coting94629252c_oting
coving124321522c_oving
cowing124526322c_owing
coxing164218862c_oxing
coying124021482c_oying
croaking153712162croaking
crocking174313442crocking
crooking153611342crooking
crowing133814762crowing
echoing1358612echo_ing
evoking1536412evoking
hiking143617102_hiking
hocking173417242_hocking
hoeing104117022_hoeing
holing104025072_holing
holking153512312_holking
homing123718382_homing
honing103421502_honing
honking153414792_honking
hooking153716692hooking
hoping123719742_hoping
hosing103421102_hosing
howking183610312_howking
joking184113022_joking
looking123415042looking
phoning13312052phoning
poking133819302_poking
rooking123517362rooking
shaking153317252shaking
shocking184311542shocking
shoeing113211882shoeing
shooing112112912shooing
shoring112820072shoring
shoving142910642shoving
showing143814662showing
smoking143210522smoking
spoking143212222spoking
stoking123615592stoking
tholing112812332tholing
thouing11258602thouing
toking114420722_toking
troking123514102troking
unchoking1935702unchoking
whoring142910292whoring
yoking143912282_yoking

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 Limit1076711092.89037256.4
3Display Results1091090.0502180.0
 (SQL Overall)1786911093.31353936.3
 
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.