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

142 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
courlans1011761(None) 
courlan9117761courlan_
corbans11313172co_rbans
courant9317972cour_ant
courants10310802cour_ants
currans9310612c_urrans
anurans73810553anur_ans
bourbons1245343bourbons
bourdons1136433bourdons
bourns84114063bour__ns
boursins1037513boursins
burans85019303_bur_ans
burlaps1156253_burlaps
callans94518473c_allans
capelans1238013capelans
carlins93921923c_arlins
ceruleans1192923ceruleans
churls115411073churl__s
churns114910233chur__ns
clans75031013c___lans
cloudland1371953cloudland
cloudlands1471713cloudlands
coalas87418963co_ala_s
coarsens10348123coarsens
cobras104014193cobr_a_s
codlins104116243co_dlins
colas75436773co__la_s
colins85229043co__lins
collars93816573co_llars
collins93419833co_llins
colons86028683co__lons
complains1549193complains
complins14313113complins
coolant9316463co_olant
coolants1039943co_olants
cooncans1246273cooncans
coprahs14338153copr_ahs
copras103517153copr_a_s
copulas113811563copula_s
corals85325143co_r_als
corban10314693co_rban_
cordons104415763co_rdons
corns76034763co_r__ns
coronas93916913co_ronas
corrals93713853co_rrals
corsacs1139013co_rsacs
cortins92421333co_rtins
corulers1039773corulers
cotans81317923co__tans
couchant1549053couchant
cougars1038443cou_gars
coulees9315513cou_lees
coulis84018763cou_l_is
countians1147333countians
couplers123311323couplers
couples115317053coupl_es
couplets12389873couplets
coupling13310783coupling
couplings1435543couplings
coupons112710563cou_pons
courage10310993cour_age
courages11311393courages
courante1049953cour_ante
courantes1148883cour_antes
couranto1046903cour_anto
courantos1145793cour_antos
couriers103213173couriers
coursers104412303coursers
courses94218893cour_ses
coursing113112023coursing
coursings12235873coursings
courters103015373courters
courtesans1244253courtesans
courtezans2152873courtezans
courting112514573courting
courts84216173cour__ts
cousins9516003cou_sins
cowflaps1842293cowflaps
crucians1245293crucians
cullays12347703c_ullays
curlers94218073c_urlers
curlews12387393c_urlews
curling104320183c_urling
curlings114110383c_urlings
curls74927103c_url__s
curns74924283c_ur__ns
curran8312023c_urran_
currant9314173c_urrant
currants1037933c_urrants
curtains10259703c_urtains
curtals93111623c_urtals
cutlas8313103c_utla_s
cutlass938013c_utlass
cyprians1544213cyprians
doulas75114993dou_la_s
dourahs11487253dour_ahs
douras75016723dour_a_s
durians839573_durians
fourgons1234833fourgons
furans94515953_fur_ans
gourmand1243263gourmand
gourmands1343313gourmands
hourglass1341913hourglass
hourlies1138343hourlies
hourlong1242733hourlong
jordans1566833jo_rdans
journals1574353journals
kurgans12145653_kurgans
lorans65117603lo_r_ans
lurdans837073_lurdans
moorland1144683moorland
moorlands1244203moorlands
morgans10310123mo_rgans
morulas959713morula_s
mouflons13133653mouflons
moulins9312703mou_lins
mourns84111013mour__ns
norland837163no_rland
norlands936443no_rlands
oculars948363ocu_lars
organs7912913_o_rgans
orlons6411013_o_rlons
ourang73311063_our_ang
ourangs8318503_our_angs
outland81212343_outland
outlands988563_outlands
outlaws10249603_outlaws
outlays102610903_outlays
outmans92413283_outmans
outplans10259533_outplans
purlins93415423_purlins
saurians837763saurians
solans64122493so__lans
soudans8309353sou_dans
sovrans1036483sovr_ans
tolans64319273to__lans
torulas759853torula_s
toucans937583tou_cans
turbans939563_turbans
uhlans937573__uhlans
ulans54921303__u_lans
yulans958673_yu_lans

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.420425454.8
2DLD Change Limit1461621427.90618487.5
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.38921300.6
 
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.