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

401 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
coteau831108(None) 
coteaux1643711coteaux
couteau938811couteau
bateau8810562bateau
chateau1236262chateau
cohead123811122cohead
colead94114642colead
cotan71521782cot_an
cote66648732cote__
coted85033852cote_d
cotes76347842cote_s
cotta75818572cotta_
cottae84615702cottae
cottar84613812cottar
cottas84615572cottas
couteaux1743192couteaux
gateau778102gateau
aboiteau1042713aboiteau
bateaux1693883bateaux
batteau936343batteau
beau66137273__beau
bohea105013733bohea_
boheas114013213boheas
boreal84817213boreal
boreas85421733boreas
bota66236503bot_a_
botas75328783bot_as
botel75121863bote_l
botels84815803botels
bureau8712523bureau
cate66254593cate__
catechu1444473catechu
catena8312473catena
catenae9311363catenae
catenas9313103catenas
cater74840703cate_r
cateran9313763cateran
caters85336493caters
cates75951873cate_s
cathead1338753cathead
catnap1098383catnap
caveat11417723caveat
cereal8315833cereal
cete64934783cete__
cetes75731103cete_s
chapeau1435523chapeau
chateaus1345983chateaus
chateaux2043073chateaux
cheap126915943c_heap
cheat105732453c_heat
chetah14399583chetah
chorea115216083chorea_
choreal124412223choreal
choreas124414203choreas
cite65640343cite__
cited84421953cite_d
citer74827323cite_r
citers85022973citers
cites74435583cite_s
citral81113883citral
clean75420413c_lean
clear76219053c_lear
cleat76335063c_leat
coaeval1245183coaeval
coal66939253co__al
coala77521123coala_
coalas87418963coalas
coat67558343co__at
coated94927033coate_d
coatee84327213coate_e
coatees93816533coatees
coater84329553coate_r
coaters93525773coaters
coax136922973co__ax
coaxal15387303coaxal
cobia94117513cobia_
cobias104014983cobias
cobra95214403cobra_
cobras104014193cobras
coca88030643co_ca_
cocas95926573co_cas
coccal9310223coccal
cocoa98517883cocoa_
cocoas104915743cocoas
coda77029343co_da_
codas84724243co_das
code77347733code__
codec107120343code_c
codecs115112933codecs
coded95433183code_d
codeia94112183codeia
codeias103911213codeias
codein94916713codein
coden86128543code_n
codens94821013codens
coder86134213code_r
coders95426973coders
codes86247293code_s
codex155817573code_x
coed77140543co_e_d
coeds85920163co_eds
coeval1138893coeval
cogent9321003cogent
cognac1157273cognac
cogway1566183cogway
coheads13289233coheads
coheir1137583coheir
cohere112716993cohere
cointreau1143023cointreau
coital84117053coital
coke107038383coke__
coked124730693coke_d
cokes115537193coke_s
cola66541393co_la_
colas75436773co_las
cole66956113cole__
coleads102911423coleads
coled85540753cole_d
coles76055063cole_s
coleus86818273coleus
collar83816173collar
colter84625093colte_r
colters93522433colters
colza165112983colza_
colzas174010503colzas
coma87134853co_ma_
comae97128423co_mae
comal95125133co_mal
comas95833003co_mas
combat12316753combat
come87547703come__
comedo11359603comedo
comedy14378233comedy
comely134213733comely
comer95832693come_r
comers105328083comers
comes97246993come_s
comet95946073come_t
cometh134811683cometh
comets105823583comets
comma114514793comma_
commas124814573commas
compas125817063compas
comte96125473comte__
comtes106222813comte_s
conceal113313013conceal
cone67256963cone__
coned86040053cone_d
cones76457423cone_s
coney105932883cone_y
coneys115218423coneys
confab1347063confab
conga85419873conga_
congas94417033congas
congeal104011683congeal
congou94313243congou
conte76633203conte__
contemn1137803contemn
contend103511893contend
content94326153content
contes84432913conte_s
contest93523233contest
context163913433context
contra83314693contra_
contras93015603contras
cooed84534343cooe_d
cooee74531023cooe_e
cooeed95917863cooeed
cooees85621893cooees
cooer74831013cooe_r
cooers84324563cooers
cooey105828223cooe_y
cooeys114914483cooeys
cooter85128613coote_r
cooters94525713cooters
copal95621783co_pal
copay126516313co_pay
cope86847383cope__
copeck1636943copeck
coped105036843cope_d
copen94826433cope_n
copens106119963copens
coper95336093cope_r
copers104629843copers
copes97747103cope_s
copra98115463copra_
coprah133710603coprah
copras103517153copras
copter109822013copte_r
copters113621273copters
coral76033453co_ral
corban10314693corban
core67263113core__
cored85044223core_d
corer75538873core_r
corers85231073corers
cores76361853core_s
coria75828303coria_
cornea84018923cornea_
corneal94414503corneal
corneas94716993corneas
cornu75921323co_rnu
cornua85411903cornua
corral83616253corral
corsac10410173corsac
cortege1098943cortege
cortex15311463corte_x
cosec96320183cose_c
cosecs105015213cosecs
coses76949493cose_s
coset75748843cose_t
cosets85824403cosets
cosey106226713cose_y
coseys115215813coseys
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
costed95623113coste_d
coster84331293coste_r
costers94128303costers
cot510483223cot___
cotans81317923cotans
cotenant10511793cotenant
coterie9417393coterie
cotidal1038453cotidal
coting94629253coting
cotquean1942273cotquean
cots68054843cot__s
cottage104210573cottage
cottars94412233cottars
cotter84926673cotter
cotters94323433cotters
cotton8312993cotton
cotype1346823cotype
cougar958783cougar
couter84930203coute_r
couters93827283couters
cove95837073cove__
coved115027373cove_d
coven106925043cove_n
covens114919263covens
cover105430773cove_r
covers114627963covers
covert114925503covert
coverup1434623coverup
coves105539173cove_s
covet105638943cove_t
covets114819643covets
covey136121783cove_y
coveys145413503coveys
cowed115637843cowe_d
cower104531773cowe_r
cowers114625533cowers
cowman13910373cowman
cowpat13312033cowpat
cowpea1337643cowpea_
cowpeas1437273cowpeas
coxa136922963co_xa_
coxae146115183co_xae
coxal146116673co_xal
coxed154322813coxe_d
coxes145430863coxe_s
coyed114623803coye_d
coyer105222843coye_r
coyest11316053coyest
coypou13268403coypou
coypu12349873co_ypu
cozen165019703coze_n
cozens176314923cozens
cozes166033243coze_s
cozey196718543coze_y
cozeys204610913cozeys
creak115418433c_reak
cream95721343c_ream
cuneal8611513cuneal
cute66440453cute__
cutely115312803cutely
cuter74728223cute_r
cutes79438313cute_s
cutest85820143cutest
cutesy114810733cutesy
cutey105819793cute_y
cuteys11569973cuteys
cutlas8313093cutlas
dogear838193dogear
dotal64919623dot_al
dote55442883dote__
doted75227073dote_d
doter65428623dote_r
doters74423913doters
dotes65836693dote_s
eau37450943___eau
foetal9311883foetal
fovea11310483fovea_
foveae1237563foveae
foveal1237703foveal
foveas1238623foveas
gateaus866323gateaus
gateaux1573123gateaux
hotel85520743hote_l
hotels94515503hotels
hothead14349293hothead
iota45127833iot_a_
iotas54821113iot_as
jota116423623jot_a_
jotas125717443jot_as
loreal63814313loreal
lota47233503lot_a_
lotah85315853lot_ah
lotas55926303lot_as
lutea54819073lutea_
luteal64411483luteal
manteau937863manteau
morceau1145573morceau
mote67048083mote__
motel76623243mote_l
motels83616893motels
motes75944003mote_s
motet75641193mote_t
motets84216193motets
motey105922953mote_y
nota46830773not_a_
notal55221353not_al
note46239963note__
noted65123843note_d
notepad1044123notepad
noter55025643note_r
noters64020993noters
notes55034583note_s
nouveau1043953nouveau
obeah1038993_obeah
ocean71212963_ocean
ocrea73311823ocrea_
ocreae83310273ocreae
octad81510653oct_ad
octal71214723oct_al
octan71313483oct_an
octet7324063octe_t
octets839403octets
odea56224573_odea_
olea46532723_olea_
oread64619603_oread
osteal6312953osteal
ottar54313993_ottar
outeat62824533outeat
plateau937403plateau
poleax1547993poleax
poteen83514263poteen
potent84223353potent
pothead133810393pothead
potman102813573potman
protea82214763protea_
protean92412193protean
proteas92015123proteas
reseau64216213reseau
reteam83214533reteam
retear63115483retear
rondeau846813rondeau
rota45834343rot_a_
rotas54827723rot_as
rote46249023rote__
rotes56143903rote_s
rouleau746823rouleau
scoter83815473scote_r
scoters93313793scoters
scotia8310783scotia_
scotias939733scotias
stead65520273_stead
steak95219803_steak
steal56125473_steal
steam76322923_steam
tau36856903__t_au
tea37353323__tea_
teak85930843__teak
teal45546503__teal
team66238653__team
tear45242883__tear
teas45851493__teas
teat45963633__teat
toea46732333to_ea_
toeas55726423to_eas
tonneau765913tonneau
total55321823tot_al
tote46643673tote__
toted64929483tote_d
totem74819363tote_m
totems86810763totems
toter55932133tote_r
toters65026363toters
totes55139683tote_s
uptear896783uptear
vote74728623vote__
voted93919143vote_d
voter85121053vote_r
voters95017443voters
votes84627083vote_s
zoea137118423zo_ea_
zoeae144412483zo_eae
zoeal144813783zo_eal
zoeas145815613zo_eas

Search took 7 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 Filter1786911127160.1731032896.0
2DLD Change Limit1127164015.70319764.3
3Display Results4014010.1233260.2
 (SQL Overall)1786914015.99929786.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.