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

242 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
chortens1330879(None) 
chorten122811301chorten_
shortens11288991shortens
charters134115592charters
chastens13429182chastens
choreas124414202chor_eas
chores114828022chor_e_s
chorines132917252chorines
chorions13310662chorions
chortlers14305662chortlers
chortles133611322chortles
cortins92421332c_ortins
shorten103511412shorten_
aborters1038573aborters
boreens9310403_boreens
careens94514703c_areens
carotene1039143carotene
carotenes11410213carotenes
carotins102315583carotins
cartels94618123c_artels
carters95327263c_arters
cartes86239473c_arte_s
cartons94122473c_artons
cavorters1434973cavorters
certes84623083c_erte_s
chanters134016743chanters
chanteys16387493chanteys
chapters154012133chapters
chares115631803char_e_s
chargers144011323chargers
charges134615983charge_s
charleys1695633charleys
charmers154211333charmers
charnels13328173charnels
charted135116853charte_d
charter123918303charte_r
charting142614193charting
chartless1435703chartless
charts115823093chart__s
chasten124312403chasten_
chattels13286793chattels
chatters134213953chatters
chazzens21253943chazzens
cheapens15305943cheapens
cheaters133613513cheaters
cherts115617233chert__s
chickens19267433chickens
chirpers15358133chirpers
chirren12388743chirren_
chirres123812253chirre_s
chitins122713793ch_itins
chitons122611913ch_itons
chitters133711173chitters
chlorates142512273chlorate_s
chlordans1544893chlordans
chlorines142512353chlorines
chlorins132612883chlor_ins
chlorites142311963chlorite_s
choices142010613choice_s
chokers164311523cho_kers
chokes154917383cho_ke_s
cholates132414763cholate_s
cholent12313253cho_lent
cholents1337623cho_lents
cholers124215203cho_lers
cholines132214493cholines
chompers17369593chompers
choosers134810883choosers
chooses125717433choose_s
chopines152711733chopines
chopins142312243cho_pins
choppers174110463choppers
choragus1474303choragus
chorales133712883chorales
chorals124614113chor_als
chordates1547683chordate_s
chorded144710553chorde_d
chording15410153chording
chords125214633chor__ds
chore105126763chor_e__
chorea115216093chor_e_a
choreal124412223chor_eal
chored125321883chor_e_d
choregi1344563chor_egi
choregus1484213choregus
choreic1438703chor_eic
choremen1597603choremen_
chorine123218363chor_ine
choring133617663chor_ing
chorion12311773chorion_
choristers1586113choristers
chorizos2245493chorizos
choroids1438703choroids
chortle124210443chort_le
chortled14326613chortled
chortler13336843chortler
chortling1535563chortling
chorus115014773chor__us
choruses1339983choruses
chosen116014133cho_sen_
choses115825133cho_se_s
chotts113610993cho_t_ts
chousers134610203chousers
chouses125117813chouse_s
chowders17387543chowders
chowses155611283chowse_s
christens14125423christens
chromes142914933chrome_s
chronons1347353chronons
chunters133910903chunters
churners13316893churners
churns114910233chur__ns
chutes114615773ch_ute_s
clouters10399803clouters
coarsens10348123coarsens
coatees93816553c_oatees
coaters93525793c_oaters
codens94821013c_o_dens
cohorts123411103cohort__s
cohostess1443463cohostess
colters93522443c_olters
comtes106222813c_omte_s
contemns1237403c_ontemns
contend103511893c_ontend
contends112810573c_ontends
content94326153c_ontent
contents104018213c_ontents
contes84432913c_onte_s
cooters94525733c_ooters
copens106119963c_o_pens
copters113621283c_opters
corbans11313173c_orbans
corbels113813593c_orbels
corders104520883c_orders
cordons104415763c_ordons
corers85231073c_or_ers
cores76361853c_or_e_s
corkers134118853c_orkers
cormels113813373c_ormels
corneas94717003c_orneas
cornels94716663c_ornels
corners94723313c_orners
cornets94820573c_ornets
corns76034763c_or__ns
corses84433463c_orse_s
corsets94819803c_orsets
cortege1098953c_ortege
corteges1198823c_orteges
cortex15311473c_orte_x
cortexes1797613c_ortexes
cortin82423153c_ortin_
cortina91915973c_ortina
cortinas102212453c_ortinas
corvees124613793c_orvees
corves115122523c_orve_s
corvets124715023c_orvets
costers94128343c_osters
cotans81317923c_o_tans
cotes76347843c_o_te_s
cotters94323453c_otters
cottons9312193c_ottons
courters103015373courters
couters93827303c_outers
covens114919263c_o_vens
cozens176314933c_o_zens
crofters13358913crofters
crores86121163cror_e_s
crotons93714373cro_tons
croutes94815653croute_s
croutons1036753croutons
exhorters1944713exhorters
fortes95327183_forte_s
gorhens1137183_gorhens
haptens124511343_haptens
hardens113815023_hardens
harkens144112863_harkens
hastens106214813_hastens
heartens113010153heartens
hoarsens11306033_hoarsens
hoddens12378803_hoddens
hoidens11329083_hoidens
hooters104520483_hooters
hordeins1238323_hordeins
hordes104921633_horde_s
hornets104113553_hornets
horns86125333_hor__ns
horrent10313553_horrent
horses94729353_horse_s
horstes104516113_horste_s
hostels103712323_hostels
hostess103210243_hostess
hotels94515523_ho_tels
hoydens14347403_hoydens
hurters103413653_hurters
martens93714953_martens
moorhens1344853moorhens
moreens939963_moreens
morgens10310463_morgens
phorates13413043phorate_s
photons123814433pho_tons
portend103411193_portend
portends11358963_portends
portent93619643_portent
portents103512823_portents
porters93722703_porters
sharpens13377813sharpens
shooters112811583shooters
shorans102812413shor_ans
shores94830413shor_e_s
shorted113614403shorte_d
shortened1345663shortened
shortener1245773shortener
shorteners1345083shorteners
shorter103515503shorte_r
shortest11310783shortest
shortias1148093shortias
shorties11414583shorties
shorting122514803shorting
shortness1236733shortness
shorts95321743short__s
shotes95321913sho_te_s
shotten10288463shotten_
shouters113510623shouters
smartens10286663smartens
snorters83410583snorters
softens10347623_softens
sorters74221133_sorters
sporters103714063sporters
stoutens8255273stoutens
thirteens1243013thirteens
thorites11312393thorite_s
thorns95314103thor__ns
thorons104511913thor_ons
thorpes125010353thorpe_s
torten65314353_torten_
tortes64826053_torte_s
wheatens1454663wheatens
whitens13428733wh_itens
whores125617103whor_e_s
whortles14306743whortles
whorts125111433whort__s
worsens104610263_worsens

Search took 9 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 Filter1786911461620.470380193.6
2DLD Change Limit1461622427.76318828.0
3Display Results2422420.0932602.2
 (SQL Overall)1786912428.32621461.8
 
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.