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

118 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
courtesy136497(None) 
curtesy1265831c_urtesy
countess103710052countess
courses94218892courses_
courted103514922courte_d
courter94516482courte_r
courters103015372courters
courtesan1144172courtesan
courtly1256922court_ly
courts84216172court_s_
curtest9713962c_urtest
curtsey1255012c_urtsey
curtsy1156642c_urt_sy
cutesy114810732c_u_tesy
bournes93615023bournes_
bourses94014303bourses_
cartes86239473c_artes_
cautery12349593cau_tery
certes84623083c_ertes_
chutes114615773chu_tes_
clustery13317113clustery
cluttery13346323cluttery
coarsely1335533coarsely
coarsest1039163coarsest
coattest1038863coattest
coerces11311943coerces_
colures9315143colur_es_
comates114123643comates_
comtes106222813co_mtes_
contes84432913co_ntes_
contest93523233co_ntest
cores76361853co_r_es_
corries94026793corries_
corses84433463co_rses_
cortege1098953co_rtege
cortex15311473co_rte_x
corves115122523co_rves_
cotes76347843co__tes_
couches144020473couches_
couldest1148353couldest
coulees9315513coulees_
coulter94115603coulte_r
coulters103614313coulters
counted103815803counte_d
counter94220153counte_r
counters103320193counters
counterspy1744663counterspy
counties10316283counties_
countless1146373countless
country12388043count_ry
counts84618273count_s_
county114313323count__y
coupes105022523cou_pes_
couples115317053couples_
courages11311393courages_
courantes1148883courantes_
courier93617893courie_r
couriers103213173couriers
course85117783cour__se
coursed104113603course_d
courser94114803course_r
coursers104412303coursers
court75532773court___
courteous1145813courteous
courteously16104433courteously
courtesans1244253courtesans
courtesied1344043courtesied
courtesies1246453courtesies
courtesying1743123courtesying
courtezan2042983courtezan
courtier1059333courtier
courtiers1146693courtiers
courting112514573courting
courtliest1244903courtliest
couteau938833cou_teau
couter84930223cou_te_r
couters93827303cou_ters
couthest13312083couthest
couths115715413cou_ths_
cowries124218013cowries_
cowrites133011593cowrites_
coyotes12410703coyotes_
croutes94815653crou_tes_
curates95323833c_urates_
cures75645433c_ur_es_
curets84922343c_urets_
curies84934023c_uries_
curites93919863c_urites_
curses85328273c_urses_
curter85320083c_urte_r
curtly1149283c_urt_ly
curtness1037263c_urtness
curtseys1342743c_urtseys
curves114619283c_urves_
curvey144111843c_urve_y
cutely115312803c_u_tely
cutes79438323c_u_tes_
cutest85820143c_u_test
cutey105819793c_u_te_y
cuteys11569983c_u_teys
discourtesy1753193discourtesy
dourest8312943dour_est
dourness947683dourness
fortes95327183fo_rtes_
fourteen1144503fourteen
fourthly1742523fourthly
fourths13374953fourths_
gourdes9109383gourdes_
journey1734873journe_y
journeys1843203journeys
routes66129313rou_tes_
scourges1136533scourges_
sources9312173sources_
sourest7515713sour_est
sourness839543sourness
tortes64826053to_rtes_
tourney1036273tourne_y
tourneys1134013tourneys

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621187.08020644.4
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.54623680.2
 
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.