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

252 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
courant931797(None) 
courante1049951courante
couranto1046901couranto
courants10310801courants
colorant10414722colorant
coolant9316462coolant
coranto9311892co_ranto
couchant1549052couchant
count74932052cou__nt
courage10310992courage
courantes1148882courantes
courantos1145792courantos
courlan9117762courlan_
courlans10117612courlans
court75532772cour__t
currant9314172currant
jurant134216552_jurant
ourang73311062_ourang
accusant1246863accusant
anuran64313243anuran_
anurans73810553anurans
arrant6623253_arrant
borane84620213bo_rane
bouffant1643683bouffant
bourn75518483bour_n_
bourne83714093bour_ne
bourns84114063bour_ns
brant74742173__brant
buoyant1246263buoyant
buran75225303_buran_
burans85019303_burans
burnt75230323_bur_nt
callant94121223callant
cant66362033c___ant
carat75048793c_ara_t
cauterant1148533cauterant
chant105932693c__hant
churn105113103chur_n_
churns114910233chur_ns
clamant11312433clamant
clouring112811273clouring
coact96130583co__act
coagent10313983coagent
coagulant1245183coagulant
coapt96131533co__apt
coast75236273co__ast
coat67558353co__a_t
cobalt10317393co_balt
cobra95214403cobra__
cobras104014193cobra_s
cocoanut1246903cocoanut
coenact11311803coenact
coerect11913353coerect
cogent9321003co_gent
coherent13412473coherent
colorants1149863colorants
combat12316753comba_t
command14399213command
comment1310317703comment
compact153712213compact
company1619711143company
compart134016003compart
comrade12139213comrade
concent114422513concent
confront13411603confront
conjugant1944893conjugant
consent93723113consent
constant10515593constant
contact1144020683contact
content94326153content
contract122915633contract
contrast102614783contrast
convent123919413convent
coolants1039943coolants
coparent12412253coparent
copra98115463copra__
coprah133710603copra_h
coprahs14338153coprahs
copras103517153copra_s
coral76033453co_ra_l
corals85325143co_rals
corantos10310103co_rantos
corban10314693corban_
corbans11313173corbans
coring94433963co_ring
cormorant1348573cormorant
corn69945813co_r_n_
cornet84436733co_rnet
corns76034763co_r_ns
cornu75921323co_r_nu
corny106023273co_r_ny
corona83817403co_rona
coronet94227173co_ronet
corrade101111043corrade
corral83616253corra_l
corrals93713853corrals
correct11513983correct
corrupt1149103corrupt
corset85636223co_rset
coruscant13246043coruscant
corvet114626933co_rvet
corybant1547573corybant
cosecant12410683cosecant
cotan71521783co_tan_
cotans81317923co_tans
cotenant10511793cotenant
cougar958783couga_r
cougars1038443cougars
couldst1037043couldst
counts84618273cou__nts
county114313323cou__nty
couping124317023couping
couplet114717943couplet
coupon102810993coupon_
coupons112710563coupons
courages11311393courages
courantoes1244033courantoes
courier93617893courier
course85117783cour_se
coursed104113603coursed
courser94114803courser
courses94218893courses
coursing113112023coursing
courted103514923courted
courter94516483courter
courting112514573courting
courtly1256923courtly
courts84216173cour_ts
cousin8517163cousin_
cousins9516003cousins
couvade1335063couvade
covariant1447863covariant
covenant1349693covenant
cowbane1437673cowbane
cowhand1665933cowhand
cowman13910373cowman_
cowpat13312033cowpa_t
craft105327663c__raft
crane75331603c__rane
crank114819613c__rank
crura7312583crura__
crural8610633crura_l
cunt66243673c_u__nt
curacy1339593c_uracy
curagh1236553c_uragh
curara83712203c_urara
curare84916953c_urare
curari84414403c_urari
curate85226243c_urate
curet75447643c_ur_et
curing94824783c_uring
curn66731883c_ur_n_
curns74924273c_ur_ns
curran8312023curran_
currans9310613currans
currants1037933currants
current9313693current
curst74931023c_ur_st
curt67051713c_ur__t
curvet114720243c_urvet
dopant9316133do_pant
dormant102814373dormant
doura66518663doura__
dourah10479813doura_h
dourahs11487253dourahs
douras75016723doura_s
dourest8312943dourest
dourine8311453dourine
eluant6315093elu_ant
entrant7318873entrant
errant6618733_errant
figurant1246723figurant
fondant11311143fondant
forint9325023fo_rint
formant123416003formant
fount84727033fou__nt
furan84320013_furan_
furane94015493_furane
furans94515953_furans
gourami1083803gourami
gourmand1243263gourmand
gourmet1059203gourmet
grant64840023__grant
horrent10313553horrent
hydrant1489053hydrant
insurant8411413insurant
intrant7318753intrant
iterant7317783iterant
journal1484963journal
journo13135293jour_no
jurants14379213_jurants
jurat124829323_jura_t
korat94934433ko_ra_t
loran55925093lo_ran_
lorans65117603lo_rans
louring83916503louring
migrant10314313migrant
mordant10312403mordant
mount74128063mou__nt
mourn77215013mour_n_
mourns84111013mour_ns
mutant8317693_mutant
nougat74712653nouga_t
nutant6316383_nutant
occupant1444673occupant
octant81216553_octant
odorant8411393odorant
operant9317223operant
orang65119943_o_rang
ourangs8318503_ourangs
ourari63413543_ourari
outact8317203_outact
outran63218893_outran_
outrang83813953_outrang
outrank112611973_outrank
pouring103115863pouring
purana8712933_purana
quant143624813_qu_ant
rant45864683___rant
regrant8317323regrant
roborant1048383roborant
saturant8410643saturant
scouring112810853scouring
sonant6621953so_nant
sonorant8411703sonorant
soprani937403soprani
soprano937003soprano
soudan73210353soudan_
soudans8309353soudans
sourest7515713sourest
souring83219063souring
soutane7312063soutane
sovran937153sovran_
sovrans1036483sovrans
sovranty1443463sovranty
spirant9814293spirant
titrant7315193titrant
tolerant8411463tolerant
torrent7313413torrent
toucan838193toucan_
toucans937583toucans
touraco945363touraco
touring82915193touring
tourist7313203tourist
truant6315783tru_ant
tyrant9315333_tyrant
ululant747693ululant
vagrant11410663vagrant
vibrant12410393vibrant
volant9316323vo_lant
warrant10614243warrant
yourn87512773your_n_

Search took 10 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 Limit1340272528.90615049.1
3Display Results2522520.0763315.8
 (SQL Overall)1786912529.13819554.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.