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

175 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
courlan911776(None) 
courlans10117611courlans
corban10314692co_rban
courant9317972cour_ant
curran8312022c_urran
anuran64313243anur_an
bourbon1135813bourbon
bourdon1036423bourdon
bourn75518483bour__n
boursin938283boursin
buran75225303_bur_an
burlap1098353_burlap
callan83619603c_allan
capelan1139003capelan
carlin84421823c_arlin
carman103920743c_arman
cerulean1053773cerulean
churl105913883churl__
churls115411073churl_s
churn105113103chur__n
clan65633923c___lan
cloudland1371953cloudland
clubman1344023clubman
coala77521123co_ala_
coalas87418963co_alas
coarsen93210323coarsen
cobra95214403cobr_a_
cobras104014193cobr_as
codlin94516443co_dlin
cola66541393co__la_
colas75436773co__las
colin76231693co__lin
collar83816173co_llar
colon78630193co__lon
colorman1247893colorman
complain1448763complain
complin13312073complin
coolant9316463co_olant
cooncan1147233cooncan
copra98115463copr_a_
coprah133710603copr_ah
copras103517153copr_as
copula102812043copula_
copulae112810613copulae
copular113810603copular
copulas113811563copulas
coral76033453co_r_al
corals85325143co_rals
corbans11313173co_rbans
cordon95017293co_rdon
coria75828323co_ria_
corn69945813co_r__n
corona83817403co_rona
corral83616253co_rral
corrals93713853corrals
corsac10410173co_rsac
cortin82423153co_rtin
coruler9311713coruler
cotan71521783co__tan
couchant1549053couchant
cougar958783cou_gar
could86517713cou_l_d
coulee8323503cou_lee
coulis84018763cou_lis
countian1048123countian
couple104415963coupl_e
coupled124312673coupled
coupler114713013coupler
couples115317053couples
couplet114717943couplet
coupling13310783coupling
coupon102810993cou_pon
courage10310993courage
courante1049953cour_ante
couranto1046903cour_anto
courants10310803cour_ants
courier93617893courier
course85117783cour_se
coursed104113603coursed
courser94114803courser
courses94218893courses
coursing113112023coursing
court75532773cour__t
courted103514923courted
courter94516483courter
courtesan1144173courtesan
courtezan2042983courtezan
courting112514573courting
courtly1256923courtly
courts84216173cour_ts
cousin8517163cou_sin
couteau938833couteau
cowflap1742503cowflap
cowman13910373co_wman
crucian1146283crucian
crura7312583crur_a_
crural8610633crur_al
cullay113910173c_ullay
curia74523773c_uria_
curiae84518373c_uriae
curial84019153c_urial
curl66035053c_url__
curled95021653c_urled
curler85221323c_urler
curlew114010903c_urlew
curling104320183c_urling
curls74927103c_url_s
curly105321233c_url_y
curn66731883c_ur__n
currans9310613c_urrans
currant9314173c_urrant
curtain9319793c_urtain
curtal83914543c_urtal
cutlas8313103c_utlas
cyprian1445343cyprian
doorman1037063doorman
doula65717773dou_la_
doulas75114993dou_las
doura66518663dour_a_
dourah10479813dour_ah
douras75016723dour_as
dourly103210433dourl_y
durian7312003_durian
exurban1653503exurban
fourgon1134863fourgon
furan84320013_fur_an
gourmand1243263gourmand
hourlong1242733hourlong
hourly12369623hourl_y
jordan1468063jo_rdan
journal1484963journal
kurgan11126783_kurgan
loran55925093lo_r_an
lurdan738363_lurdan
moorland1144683moorland
morgan9311373mo_rgan
morula8710473morula_
morulae958963morulae
morular978223morular
morulas959713morulas
mouflon12104083mouflon
moulin8313283mou_lin
mourn77215013mour__n
nonurban1044853nonurban
norland837163no_rland
ocular8610133ocu_lar
organ6915393_o_rgan
orlon5415003_o_rlon
ourang73311063_our_ang
outlain71212613_outlain
outland81212343_outland
outlaw9279643_outlaw
outlay92711793_outlay
outman83115033_outman
outplan9249443_outplan
outran63218893_outran
purlin83615863_purlin
rurban849043_rurban
saurian739913saurian
slurban944863slurban
solan55328153so__lan
soudan73210353sou_dan
sourly93612213sourl_y
sovran937153sovr_an
tolan55124013to__lan
torula6610393torula_
torulae758553torulae
torulas759853torulas
toucan838193tou_can
turban8310483_turban
uhlan849113__uhlan
ulan46527393__u_lan
urban72013863__urban
yourn87512773your__n
yulan8411493_yu_lan

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 Limit1340271757.09618887.7
3Display Results1751750.0602916.7
 (SQL Overall)1786911757.31224438.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.