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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
coarse8481390(None) 
carse74934331c_arse
coarsen93210321coarsen
coarser93211201coarser
corse75036181co_rse
course85117781course
hoarse94411321hoarse
arse46539272__arse
boars75229602boars_
bourse84414332bourse
care66968372c_ar_e
cares77369182c_ares
carle74535702c_arle
cars67364762c_ars_
carses85233652c_arses
carte75940422c_arte
carve106227752c_arve
case65848082c_a_se
cause75225352c_ause
cease75227652cea_se
chaise114916412chaise
chare105231982char_e
chares115631802chares
charge125114212charge
chars105936642chars_
chase105127122cha_se
chasse115114602chasse
clause84311502clause
coals76129602coals_
coarsely1335532coarsely
coarsens10348122coarsens
coarsest1039162coarsest
coast75236272coa_st
coatee84327222coatee
coats75635002coats_
coaxes154715632coaxes
coerce10310402coerce
coirs75221052coirs_
comose105016842comose
copse95623922co_pse
core67263112co_r_e
cores76361852co_res
corpse104013402corpse
corrie83621222corrie
cors66656442co_rs_
corses84433462co_rses
corset85636222co_rset
coursed104113602coursed
courser94114802courser
courses94218892courses
cowrie113814282cowrie
curse75829142c_urse
czars164812912czars_
gorse65926812go_rse
hearse94114272hearse
hoars85925552hoars_
hoarsen10367992hoarsen
hoarser10388392hoarser
horse86132652ho_rse
marse76231152_marse
morse76032702mo_rse
oars46846032_oars_
parse75236992_parse
roars55622242roars_
soars54732512soars_
sparse84516342sparse
torse55833332to_rse
worse86525262wo_rse

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 Filter178691825510.686260482.5
2DLD Change Limit82551685.22015814.4
3Display Results68680.0302266.7
 (SQL Overall)178691685.93630102.9
 
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.