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

173 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
courtiers114669(None) 
couriers103213171cour_iers
courters103015371court_ers
courtier1059331courtier_
cottiers10399152co_ttiers
coulters103614312coult_ers
counters103320192count_ers
counties10316282countie_s
courier93617892cour_ier_
coursers104412302cour_sers
courter94516482court_er_
courtlier1154462courtlier_
couters93827302cou_t_ers
cowriters14317282cowriters
curriers103410752c_urriers
blurters10348373blurt_ers
bounties10311403bountie_s
bourtrees11154013bourtrees
bouviers1375003bou_viers
buriers94017193_bur_iers
bustiers103810053_bustiers
carriers103614203c_arriers
carters95327253c_art_ers
charters134115583chart_ers
chertier1387873chertier_
chortlers14305663chortlers
chunters133910903chunt_ers
churners13316893chur_ners
clouters10399803clou_t_ers
clusters102912403clust_ers
clutters103210353clu_tters
coasters104317333coast_ers
coaters93525793co_at_ers
codifiers1555343codifiers
codrivers1544863codrivers
coercers1237653coer_cers
cointers103616413coint_ers
colliers103613583co_lliers
colters93522443co_lt_ers
comethers1637443comethers
comities12317793comitie_s
compliers1538293compliers
contrivers1547253contrivers
coonties10513803coontie_s
cooters94525723co_ot_ers
cooties93725733co_otie_s
copartners1443573copartners
copiers114215963co__piers
copters113621283co_pt_ers
corbies113520123co_rbie_s
corders104520883co_r_ders
corers85231073co_r__ers
corkers134118853co_r_kers
corkier133114303co_rkier_
corners94723313co_r_ners
cornier93017093co_rnier_
coroners104016223co_roners
corries94026793co_rrie_s
cortices12615013co_rtices
cortinas102212443co_rtinas
cortins92421333co_rti_ns
corulers1039773co_rulers
costers94128333co_st_ers
cotters94323443co__tters
cottier93814173co_ttier_
couchers153513863cou_chers
coughers14399963cou_ghers
couloirs1045993couloi_rs
coulter94115603coult_er_
counter94220153count_er_
countess103710053count_ess
countians1147333countians
countless1146373countless
countries11313613countrie_s
couplers123311323cou_plers
courages11311393courage_s
courser94114803cour_ser_
courses94218893cour_se_s
coursings12235873coursings
courted103514923court_e_d
courteous1145813courteous
courtesies1246453courtesie_s
courtesy1364973court_esy
courting112514573courti_ng
courtliest1244903courtliest
courtliness1343903courtliness
courts84216173court___s
courtsides1343583courtsides
courtyard1542193courtyard
courtyards1651903courtyards
couter84930223cou_t_er_
couther123914633cou_ther_
couthier13218913couthier_
coutures10311993cou_tures
couturiers1243853couturiers
coveters132411083covet_ers
cowries124218013cowr_ie_s
cowriter13238883cowriter_
cowrites133011593cowrite_s
criers83918583c__r_iers
croupiers1334653crou_piers
crustier10259533crustier_
curbers115514383c_ur_bers
curdier103312623c_urdier_
curdlers11368493c_urdlers
curers84923193c_ur__ers
curies84934023c_ur_ie_s
curites93919863c_urite_s
curlers94218073c_ur_lers
curlier93314183c_urlier_
currier93316703c_urrier_
curriery13326163c_urriery
curries93723163c_urrie_s
cursers94317163c_ur_sers
curtailers1243403c_urtailers
curter85320083c_urt_er_
curtness1037263c_urtness
curtseys1342743c_urtseys
curtsies1038733c_urtsie_s
curvier123110663c_urvier_
cuties84927363c_u_tie_s
cutlers94217003c_u_tlers
cutters94218963c_u_tters
cutties93118843c_uttie_s
doubters11257393doubt_ers
forties104323863fo_rtie_s
fourteens1243343fourteens
furriers11369493_furriers
furthers1436493_furthers
goutier82612353gou_tier_
hourlies1138343hourlie_s
hurriers11358893_hurriers
hurters103413643_hurt_ers
jousters153210423joust_ers
mortisers1186163mo_rtisers
moulters103510783moult_ers
mounters103712503mount_ers
mourners1036913mour_ners
mouthers133811303mou_thers
murthers1336543_murthers
northers1139333no_rthers
ousters74122793_oust_ers
outers64230173_ou_t_ers
outliers82610673_outliers
outriders10237223_outriders
partiers103514243_partiers
porters93722703po_rt_ers
portiere1038773po_rtiere
portieres1138213po_rtieres
poulters103911053poult_ers
pourers93513673pour__ers
pouters94221873pou_t_ers
poutier93215323pou_tier_
purtier93214093_purtier_
puttiers10288013_puttiers
quartiers1845183quartiers
roturiers944553rotur_iers
rousters84315683roust_ers
routers74822873rou_t_ers
scourers10348533scour__ers
scourgers1234383scour_gers
scouters103411323scou_t_ers
scouthers1445993scou_thers
sorters74221133so_rt_ers
sorties74126403so_rtie_s
souters74422603sou_t_ers
southers114214453sou_thers
spurriers11245063spurriers
spurters103311703spurt_ers
tourers73512743tour__ers
touters74018353tou_t_ers
turtlers8258203_turtlers
worriers11257813wo_rriers

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 Filter1786911486410.483369960.7
2DLD Change Limit1486411736.81321817.3
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.37624226.0
 
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.