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

194 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
courtly125692(None) 
curtly1149281c_urtly
costly114012332co_stly
country12388042country
county114313322count_y
court75532772court__
courted103514922courted
courter94516482courter
courtesy1364972courtesy
courts84216172court_s
covertly1655762covertly
curly105321232c_ur_ly
curtsy1156642c_urtsy
dourly103210432dour_ly
fourthly1742522fourthly
hourly12369622hour_ly
portly114713402po_rtly
sourly93612212sour_ly
adultly1143753adultly
alertly1046793alertly
auntly95211063_auntly
bluntly1235223bluntly
borty105522833bo_rt_y
bounty113411073bount_y
burbly134311153_burbly
burly104922833_bur_ly
charily15310283charily
cherty144612473chert_y
chortle124210443chortle
churchly2142973churchly
churchy2044183churchy
churl105913883chur_l_
churls115411073chur_ls
clerkly1643573clerkly
cloudily1444283cloudily
coaly105521593co__aly
coarsely1335533coarsely
cockily1838493cockily
cogently1446323cogently
coldly12459953co_ldly
colly104926773co__lly
coly96940533co___ly
comely134213733co_mely
comity13312713comit_y
comply152810383co_mply
coolly114811393co_olly
cooly105525423co__oly
copurify1843053copurify
coquetry2243563coquetry
coral76033453co_ral_
corals85325143co_rals
corby125018533co_r_by
corky145221153co_r_ky
cornily12410853cornily
corny106023273co_r_ny
corody12149703co_rody
corral83616253corral_
corrals93713853corrals
correctly1644963correctly
corrody13136143corrody
corruptly1643093corruptly
cortex15311473co_rtex
cortin82423153co_rtin
cory96941513co_r__y
cosily113613853co_sily
could86517713cou__ld
coulter94115603coulter
count74932053count__
countably1646283countably
counted103815803counted
counter94220153counter
counts84618273count_s
couple104415963cou_ple
courage10310993courage
courant9317973courant
courier93617893courier
courlan9117763courlan
course85117783cour_se
coursed104113603coursed
courser94114803courser
courses94218893courses
courters103015373courters
courtier1059333courtier
courting112514573courting
courtlier1154463courtlier
cousinly1345933cousinly
couter84930223cou_ter
couth106122493cou_t_h
couths115715413cou_ths
cowardly1744093cowardly
cowedly1635703cowedly
cowry135512483cowr__y
coyly135614893co__yly
cozily20349703co_zily
croupily1544743croupily
crousely1346563crousely
crudely1336273crudely
cruelly1236563cruelly
cruelty1234113cruelty
crumbly16347523crumbly
crumply16336093crumply
crural8610633crural_
crusily12199093crusily
crustily13328173crustily
crusty114911343crust_y
cuddly13388413c_uddly
cully105520463c_u_lly
curably142010773c_urably
curacy1339593c_uracy
curdle95514313c_urdle
curdy115916523c_ur_dy
curl66035053c_ur_l_
curlily1238383c_urlily
curls74927103c_ur_ls
curry105920343c_ur_ry
curt67051713c_urt__
curtal83914543c_urtal
curtals93111623c_urtals
curter85320083c_urter
curtesy1265833c_urtesy
curtsey1255013c_urtsey
curule83614123c_urule
curvey144111843c_urvey
curvy136013373c_ur_vy
cutely115312803c_utely
cutey105819793c_u_tey
cuttle84113893c_uttle
cutty105417223c_u_tty
dorty96220813do_rt_y
doubly12328963dou_bly
doucely1344883doucely
forty114824273fo_rt_y
foully1239013fou_lly
fourth12357443fourt_h
fourths13374953fourths
gauntly1135333gauntly
gorily10612503go_rily
goutily1137933goutily
gouty95217363gou_t_y
hoarily1338973hoarily
hostly124210863ho_stly
hotly115815483ho__tly
hurly115819293_hur_ly
hurtle93512943_hurtle
inertly1038543inertly
jointly1735483jointly
journey1734873journey
justly16307253_justly
knurly13405533knur_ly
lordly1038753lo_rdly
loudly1037783lou_dly
loury85716753lour__y
lousily1038333lousily
moistly1236613moistly
mostly113110943mo_stly
mousily1239393mousily
mouthy14409063mou_thy
murkly15368303_murkly
occultly1562483occultly
outby10411533_ou_tby
outfly1238273_outfly
outlay92711793_ou_tlay
overtly13268983overtly
partly116315473_partly
peartly1267453peartly
pertly115312543_pertly
poorly1137893poor_ly
poultry1235383poultry
pouty107018813pou_t_y
purely114013623_purely
purply13369043_purply
purty105019403_purt_y
robustly1342763robustly
roughly14507293roughly
roundly1136723roundly
roupily1246653roupily
shortly13387573shortly
smartly12497433smartly
softly12457763so_ftly
sorely94618013so_rely
sorrily1039833sorrily
soundly1136683soundly
spurtle937453spurtle
squatly1946433squatly
stoutly1035833stou_tly
subtly11249263_subtly
surely93816463_surely
surly85124433_sur_ly
tartly96014023_tartly
tautly9499503tau_tly
toughly14487433toughly
tourney1036273tourney
turtle63213573_turtle
worthy15598803wo_rthy

Search took 8 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.1561145455.1
2DLD Change Limit1340271947.06318975.9
3Display Results1941940.0633079.4
 (SQL Overall)1786911947.28224538.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.