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 “cherts” 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
cherts11561723(None) 
charts115823091charts
cheats114519541cheats
chert105232101chert_
cherty144612471cherty
chests114916261chests
alerts64418222alerts
averts95715242averts
carets85330772carets
carts78946292c_arts
celts75325782c_elts
cents74730332c_ents
ceres75540012c_eres
ceros74726072c_eros
certes84623082c_ertes
chants115020392chants
charas114223612charas
chards125119732chards
chares115631802chares
charks155219702charks
charms135218842charms
charrs115219192charrs
chars105936642char_s
chart105038282chart_
chats105730092ch_ats
cheaps134613682cheaps
cheat105732452cheat_
checks174912702checks
cheeks154712782cheeks
cheeps135312912cheeps
cheeros123711632cheeros
cheers114518912cheers
chefs136214662che_fs
chelas113817202chelas
chemos13311722chemos
cherish15310462cherish
cheroots1348192cheroots
cherry144810762cherry
cherub1337262cherub
cherubs1434552cherubs
chess105016922che_ss
chest104926142chest_
chesty144610502chesty
cheth135013822che_th
cheths14389822cheths
chevres15379792chevres
chevrets16255322chevrets
chews135418512che_ws
chints115117832chints
chirks155414842chirks
chirms135113982chirms
chiros114617772chiros
chirps135414002chirps
chirrs114514982chirrs
chirus114615692chirus
chits105424572ch_its
chords125214632chords
chores114828022chores
chorus115014772chorus
chotts113610992chotts
churls115411072churls
churns114910232churns
churrs115111512churrs
cleats84919312cleats
clefts114610162clefts
clerks12458842clerks
coheres122917692coheres
cohorts123411102cohorts
courts84216172courts
coverts124813812coverts
crests85218702crests
curets84922342curets
everts94514892everts
exerts133712292exerts
harts88441592_harts
hearts96218942_hearts
heats85838402_heats
hefts116218152_hefts
hents87330742_hents
herbs105520502_herbs
herds96424682_herds
heres86245902_heres
herls85226432_herls
herms105626432_herms
herns84825582_herns
heros84930862_heros
hers75844872_her_s
hertz174919042_hertz
hests85829932_hests
hets75547202_he_ts
hurts86922822_hurts
inerts64517022inerts
khets124913432khe_ts
nerts55924982_nerts
ochers113915302ocher_s
sheets93918502sheets
sherds105614722sherds
shirts94918342shirts
shorts95321742shorts
thefts12387922thefts
theres96525472theres
therms115914872therms
verts85724732_verts
wheats125013222wheats
wheres125917432wheres
whets115019612whe_ts
whorts125111432whorts

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.346516448.0
2DLD Change Limit825511072.53032628.9
3Display Results1071070.0303566.7
 (SQL Overall)1786911072.90661490.4
 
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.