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 “cheroot” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
cheroot1241369(None) 
cheroots1348191cheroots
sheroot10414371sheroot
chariot12316212chariot
chert105232102cher__t
cheviot1546932cheviot
heriot9422342_heriot
sheroots1137862sheroots
beetroot1047253beetroot
bhoot104322103bh__oot
cahoot11416473c_ahoot
carrot8423123c_arrot
cermet10321153c_ermet
cero66329453c_er_o_
ceros74726073c_er_os
cerous85821203c_erous
challot123613263challot
chalot113020133ch_alot
chariots1339393chariots
charpoy1735713charpoy
charro114212953charro_
charros124312143charros
chart105038283char__t
chatroom1596263chatroom
cheapo134810083cheapo_
cheapos14418513cheapos
cheat105732453che__at
checkout1945593checkout
checkroom2253173checkroom
cheerio12379313cheerio_
cheerios13317583cheerios
cheero114712933cheero_
cheeros123711633cheeros
chefdom18134073chefdom
chegoe1237273che_goe
chegoes1337333chegoes
cheloid13310833cheloid
chemist143615003chemist
chemo12313633che_mo_
chemos13311723che_mos
chenopod1643943chenopod
cherish15310463cherish
cherry144810763cher_ry
cherts115617233cher_ts
cherty144612473cher_ty
cherub1337263cher_ub
cherubs1434553cherubs
chervil1534953chervil
chest104926143che__st
cheviots1643783cheviots
chevret153310633chevret
chevron1575783chevron
chevrons1665463chevrons
chinook1675103chinook
chiro105320343chir_o_
chiros114617773chir_os
chook146015043ch__ook
chorion12311773chorion
choroid13311803choroid
chott103923933ch__ott
chroma132912473ch_roma
chrome133214813ch_rome
chromo132811013ch_romo
chromos142610273ch_romos
chromy16309903ch_romy
chronon1237353ch_ronon
churro11448353churro_
churros12427583churros
cloot76127053c__loot
clubroot1244843clubroot
coerect11913353coerect
coherent13412473coherent
coot67860383c___oot
croft105622683c__roft
crook115217573c__rook
croon75522783c__roon
disroot8413563disroot
enroot6615993_enroot
ergot65422893__ergot
gherao1036753gherao_
harlot94422803_harlot
helot85332683_he_lot
hereat93527413_hereat
hereof123212373_hereof
hereon93914363_hereon
hereto9313693_hereto
heriots10312063_heriots
hermit11519443_hermit
hero74635783_her_o_
heroes94923823_heroes
heroic113516923_heroic
heroin94420593_heroin
heron85025503_her_on
herons94820543_herons
heros84930863_her_os
hoot75752103_h__oot
merlot83217603_merlot
ocherous1347013ocherous
outroot7516563outroot
overhot13411223overhot
pierrot948833pierrot
pokeroot1447703pokeroot
preriot9316413preriot
reboot84119333_reboot
redroot8312903redroot
reroof9315003_reroof
root45655923___root
roseroot859513roseroot
scherzo2153943scherzo_
scherzos2243703scherzos
sherbet12311383sherbet
shoot84235913sh__oot
taproot9412673taproot
thereat104315243thereat
thereof13168063thereof
thereon10199263thereon
thereto1038993thereto
thermit12312013thermit
thermos124610753thermos
theroid11313403theroid
theropod1445433theropod
throat94819753th_roat
unroot6315553_unroot
uproot8314123_uproot
whereat134311923whereat
whereof16185463whereof
whereon13196503whereon
whereto1346063whereto

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271285.86022871.5
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.31228309.7
 
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.