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

124 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
chokes15491738(None) 
choke145118021choke_
choked164914791choked
choker154314371choker
chokers164311521chokers
chokey184811711chokey
chores114828021chores
choses115825131choses
cokes115537191c_okes
hokes126231641_hokes
blokes123813882blokes
cakes116037672c_akes
chafes145017912chafes
chaoses124715122chaoses
chapes135421872chapes
chares115631802chares
chases115128232chases
cheeks154712782cheeks
chides124620472chides
chiles115425302chiles
chimes134922572chimes
chines115029172chines
chives144317592chives
chocked194411612chocked
chocks174815312chocks
choices142010612choices
choirs114911882choirs
chokier1638042chokier
chokiest1738722chokiest
choky175711222chok_y
cholas114818002cholas
choler113717152choler
cholers124215202cholers
cholos114716852cholos
chomps155112222chomps
chooks155312792chooks
choose115116142choose
chooses125717432chooses
chops125019872cho_ps
chords125214632chords
chore105126762chore_
chorea115216092chorea
choreas124414202choreas
chored125321882chored
chorus115014772chorus
chose105925402chose_
chosen116014132chosen
chotts113610992chotts
chouse116017562chouse
chouses125117812chouses
chowed154914652chowed
chows135618202cho_ws
chowse144711752chowse
chowses155611282chowses
chromes142914932chromes
chutes114615772chutes
chyles144813282chyles
chymes165912152chymes
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codes86247292c_odes
coke107038382c_oke_
coked124730692c_oked
coles76055062c_oles
comes97246992c_omes
cones76457422c_ones
cooees85621892cooees
cooked135921362cooked
cooker124722452cooker
cookers134619462cookers
cookey155414332cookey
cookeys16478502cookeys
cookies133719272cookies
cooks115429142cook_s
copes97747102c_opes
cores76361852c_ores
coses76949492c_oses
cotes76347842c_otes
coves105539172c_oves
coxes145430862c_oxes
cozes166033242c_ozes
crakes124921812crakes
crones84729242crones
crores86121162crores
crozes174417662crozes
cukes115422092c_ukes
dholes104914792dholes
echoes114715522echo_es
evokes13459682evokes
hakes126034302_hakes
hikes125426982_hikes
hoes75755732_ho_es
hoke115935932_hoke_
hoked135326992_hoked
hokey155422182_hokey
holes84748652_holes
homes106938822_homes
hones88144492_hones
hopes105835642_hopes
hoses85443182_hoses
howes114730262_howes
jokes165423332_jokes
mokes114631032_mokes
okes84936342__okes
phones114121212phones
pokes116133012_pokes
shakes135024592shakes
shoes85429662sho_es
shores94830412shores
shotes95321912shotes
shoves124919422shoves
smokes124814342smokes
sokes95031422_sokes
spokes124417212spokes
stokes104821792stokes
tholes94919782tholes
tokes95234972_tokes
trokes104019262trokes
unchokes17227272unchokes
wholes124616772wholes
whores125617102whores
yokes125223022_yokes

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511242.26636430.3
3Display Results1241240.0304133.3
 (SQL Overall)1786911242.63967711.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.